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

DEPESZ / Pg-Explain-2.9 / t / 50-psql-frames.d / xml-2-aligned-unicode-double-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
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.039</Actual-Startup-Time>          ↵║
║       <Actual-Total-Time>1.976</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.013</Actual-Startup-Time>      ↵║
║           <Actual-Total-Time>0.077</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.025</Actual-Startup-Time>      ↵║
║           <Actual-Total-Time>1.898</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>1.985</Execution-Time>                      ↵║
║   </Query>                                                      ↵║
║ </explain>                                                       ║
╚══════════════════════════════════════════════════════════════════╝
(1 row)