From Code to Community: Sponsoring The Perl and Raku Conference 2025 Learn more

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

              
┌───────────────────────────────────────────────┐
│                  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.038               ↵│
│     Actual Total Time: 2.220                 ↵│
│     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.013           ↵│
│         Actual Total Time: 0.079             ↵│
│         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.024           ↵│
│         Actual Total Time: 2.138             ↵│
│         Actual Rows: 15                      ↵│
│         Actual Loops: 1                      ↵│
│         Filter: "(added_by = 'depesz'::text)"↵│
│         Rows Removed by Filter: 13205        ↵│
│   Planning Time: 0.044                       ↵│
│   Triggers:                                  ↵│
│   Execution Time: 2.228                       │
└───────────────────────────────────────────────┘
(1 row)