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

DEPESZ / Pg-Explain-2.8 / t / 50-psql-frames.d / xml-2-aligned-unicode-single-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
61
62
63

              
┌──────────────────────────────────────────────────────────────────┐
│                            QUERY PLAN                            │
╞══════════════════════════════════════════════════════════════════╡
│ <explain xmlns="http://www.postgresql.org/2009/explain">        ↵│
│   <Query>                                                       ↵│
│     <Plan>                                                      ↵│
│       <Node-Type>Nested Loop</Node-Type>                        ↵│
│       <Parallel-Aware>false</Parallel-Aware>                    ↵│
│       <Join-Type>Inner</Join-Type>                              ↵│
│       <Startup-Cost>0.00</Startup-Cost>                         ↵│
│       <Total-Cost>2017.80</Total-Cost>                          ↵│
│       <Plan-Rows>15</Plan-Rows>                                 ↵│
│       <Plan-Width>133</Plan-Width>                              ↵│
│       <Actual-Startup-Time>0.045</Actual-Startup-Time>          ↵│
│       <Actual-Total-Time>2.098</Actual-Total-Time>              ↵│
│       <Actual-Rows>15</Actual-Rows>                             ↵│
│       <Actual-Loops>1</Actual-Loops>                            ↵│
│       <Inner-Unique>false</Inner-Unique>                        ↵│
│       <Plans>                                                   ↵│
│         <Plan>                                                  ↵│
│           <Node-Type>Seq Scan</Node-Type>                       ↵│
│           <Parent-Relationship>Outer</Parent-Relationship>      ↵│
│           <Parallel-Aware>false</Parallel-Aware>                ↵│
│           <Relation-Name>users</Relation-Name>                  ↵│
│           <Alias>u</Alias>                                      ↵│
│           <Startup-Cost>0.00</Startup-Cost>                     ↵│
│           <Total-Cost>41.40</Total-Cost>                        ↵│
│           <Plan-Rows>1</Plan-Rows>                              ↵│
│           <Plan-Width>129</Plan-Width>                          ↵│
│           <Actual-Startup-Time>0.014</Actual-Startup-Time>      ↵│
│           <Actual-Total-Time>0.080</Actual-Total-Time>          ↵│
│           <Actual-Rows>1</Actual-Rows>                          ↵│
│           <Actual-Loops>1</Actual-Loops>                        ↵│
│           <Filter>(username = 'depesz'::text)</Filter>          ↵│
│           <Rows-Removed-by-Filter>1231</Rows-Removed-by-Filter> ↵│
│         </Plan>                                                 ↵│
│         <Plan>                                                  ↵│
│           <Node-Type>Seq Scan</Node-Type>                       ↵│
│           <Parent-Relationship>Inner</Parent-Relationship>      ↵│
│           <Parallel-Aware>false</Parallel-Aware>                ↵│
│           <Relation-Name>part_0</Relation-Name>                 ↵│
│           <Alias>p</Alias>                                      ↵│
│           <Startup-Cost>0.00</Startup-Cost>                     ↵│
│           <Total-Cost>1976.25</Total-Cost>                      ↵│
│           <Plan-Rows>15</Plan-Rows>                             ↵│
│           <Plan-Width>17</Plan-Width>                           ↵│
│           <Actual-Startup-Time>0.030</Actual-Startup-Time>      ↵│
│           <Actual-Total-Time>2.015</Actual-Total-Time>          ↵│
│           <Actual-Rows>15</Actual-Rows>                         ↵│
│           <Actual-Loops>1</Actual-Loops>                        ↵│
│           <Filter>(added_by = 'depesz'::text)</Filter>          ↵│
│           <Rows-Removed-by-Filter>13205</Rows-Removed-by-Filter>↵│
│         </Plan>                                                 ↵│
│       </Plans>                                                  ↵│
│     </Plan>                                                     ↵│
│     <Planning-Time>0.041</Planning-Time>                        ↵│
│     <Triggers>                                                  ↵│
│     </Triggers>                                                 ↵│
│     <Execution-Time>2.107</Execution-Time>                      ↵│
│   </Query>                                                      ↵│
│ </explain>                                                       │
└──────────────────────────────────────────────────────────────────┘
(1 row)