The Perl and Raku Conference 2025: Greenville, South Carolina - June 27-29 Learn more

DEPESZ / Pg-Explain-2.8 / t / 50-psql-frames.d / json-0-unaligned-ascii-double-double-double.plan 

            

              
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60

              
QUERY PLAN
[
  {
    "Plan": {
      "Node Type": "Nested Loop",
      "Parallel Aware": false,
      "Join Type": "Inner",
      "Startup Cost": 0.00,
      "Total Cost": 2017.80,
      "Plan Rows": 15,
      "Plan Width": 133,
      "Actual Startup Time": 0.094,
      "Actual Total Time": 2.149,
      "Actual Rows": 15,
      "Actual Loops": 1,
      "Inner Unique": false,
      "Plans": [
        {
          "Node Type": "Seq Scan",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Relation Name": "users",
          "Alias": "u",
          "Startup Cost": 0.00,
          "Total Cost": 41.40,
          "Plan Rows": 1,
          "Plan Width": 129,
          "Actual Startup Time": 0.019,
          "Actual Total Time": 0.083,
          "Actual Rows": 1,
          "Actual Loops": 1,
          "Filter": "(username = 'depesz'::text)",
          "Rows Removed by Filter": 1231
        },
        {
          "Node Type": "Seq Scan",
          "Parent Relationship": "Inner",
          "Parallel Aware": false,
          "Relation Name": "part_0",
          "Alias": "p",
          "Startup Cost": 0.00,
          "Total Cost": 1976.25,
          "Plan Rows": 15,
          "Plan Width": 17,
          "Actual Startup Time": 0.074,
          "Actual Total Time": 2.063,
          "Actual Rows": 15,
          "Actual Loops": 1,
          "Filter": "(added_by = 'depesz'::text)",
          "Rows Removed by Filter": 13205
        }
      ]
    },
    "Planning Time": 0.057,
    "Triggers": [
    ],
    "Execution Time": 2.157
  }
]
(1 row)