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

DEPESZ / Pg-Explain-2.8 / t / 50-psql-frames.d / yaml-0-aligned-unicode-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

              
                 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.037               ↵
    Actual Total Time: 1.898                 ↵
    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.014           ↵
        Actual Total Time: 0.077             ↵
        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.022           ↵
        Actual Total Time: 1.819             ↵
        Actual Rows: 15                      ↵
        Actual Loops: 1                      ↵
        Filter: "(added_by = 'depesz'::text)"↵
        Rows Removed by Filter: 13205        ↵
  Planning Time: 0.042                       ↵
  Triggers:                                  ↵
  Execution Time: 1.907
(1 row)