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

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

              
                           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.040</Actual-Startup-Time>          ↵
      <Actual-Total-Time>2.061</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.026</Actual-Startup-Time>      ↵
          <Actual-Total-Time>1.982</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.045</Planning-Time>                        ↵
    <Triggers>                                                  ↵
    </Triggers>                                                 ↵
    <Execution-Time>2.071</Execution-Time>                      ↵
  </Query>                                                      ↵
</explain>
(1 row)