The Perl Toolchain Summit 2025 Needs You: You can help 🙏 Learn more

DEPESZ / Pg-Explain-2.8 / t / 55-planning-time.d / old-yaml.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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133

              
- Plan: 
    Node Type: "Sort"
    Parallel Aware: false
    Startup Cost: 31.39
    Total Cost: 31.49
    Plan Rows: 38
    Plan Width: 224
    Actual Startup Time: 0.692
    Actual Total Time: 0.694
    Actual Rows: 0
    Actual Loops: 1
    Sort Key: 
      - "n.nspname"
      - "c.relname"
    Sort Method: "quicksort"
    Sort Space Used: 25
    Sort Space Type: "Memory"
    Shared Hit Blocks: 14
    Shared Read Blocks: 0
    Shared Dirtied Blocks: 0
    Shared Written Blocks: 0
    Local Hit Blocks: 0
    Local Read Blocks: 0
    Local Dirtied Blocks: 0
    Local Written Blocks: 0
    Temp Read Blocks: 0
    Temp Written Blocks: 0
    Plans: 
      - Node Type: "Hash Join"
        Parent Relationship: "Outer"
        Parallel Aware: false
        Join Type: "Inner"
        Startup Cost: 1.25
        Total Cost: 30.39
        Plan Rows: 38
        Plan Width: 224
        Actual Startup Time: 0.684
        Actual Total Time: 0.686
        Actual Rows: 0
        Actual Loops: 1
        Inner Unique: true
        Hash Cond: "(c.relnamespace = n.oid)"
        Shared Hit Blocks: 14
        Shared Read Blocks: 0
        Shared Dirtied Blocks: 0
        Shared Written Blocks: 0
        Local Hit Blocks: 0
        Local Read Blocks: 0
        Local Dirtied Blocks: 0
        Local Written Blocks: 0
        Temp Read Blocks: 0
        Temp Written Blocks: 0
        Plans: 
          - Node Type: "Seq Scan"
            Parent Relationship: "Outer"
            Parallel Aware: false
            Relation Name: "pg_class"
            Alias: "c"
            Startup Cost: 0.00
            Total Cost: 27.96
            Plan Rows: 63
            Plan Width: 73
            Actual Startup Time: 0.015
            Actual Total Time: 0.405
            Actual Rows: 121
            Actual Loops: 1
            Filter: "((relkind = ANY ('{r,p,v,m,S,f,\"\"}'::\"char\"[])) AND pg_table_is_visible(oid))"
            Rows Removed by Filter: 221
            Shared Hit Blocks: 13
            Shared Read Blocks: 0
            Shared Dirtied Blocks: 0
            Shared Written Blocks: 0
            Local Hit Blocks: 0
            Local Read Blocks: 0
            Local Dirtied Blocks: 0
            Local Written Blocks: 0
            Temp Read Blocks: 0
            Temp Written Blocks: 0
          - Node Type: "Hash"
            Parent Relationship: "Inner"
            Parallel Aware: false
            Startup Cost: 1.18
            Total Cost: 1.18
            Plan Rows: 6
            Plan Width: 68
            Actual Startup Time: 0.062
            Actual Total Time: 0.064
            Actual Rows: 4
            Actual Loops: 1
            Hash Buckets: 1024
            Original Hash Buckets: 1024
            Hash Batches: 1
            Original Hash Batches: 1
            Peak Memory Usage: 9
            Shared Hit Blocks: 1
            Shared Read Blocks: 0
            Shared Dirtied Blocks: 0
            Shared Written Blocks: 0
            Local Hit Blocks: 0
            Local Read Blocks: 0
            Local Dirtied Blocks: 0
            Local Written Blocks: 0
            Temp Read Blocks: 0
            Temp Written Blocks: 0
            Plans: 
              - Node Type: "Seq Scan"
                Parent Relationship: "Outer"
                Parallel Aware: false
                Relation Name: "pg_namespace"
                Alias: "n"
                Startup Cost: 0.00
                Total Cost: 1.18
                Plan Rows: 6
                Plan Width: 68
                Actual Startup Time: 0.022
                Actual Total Time: 0.049
                Actual Rows: 4
                Actual Loops: 1
                Filter: "((nspname <> 'pg_catalog'::name) AND (nspname <> 'information_schema'::name) AND (nspname !~ '^pg_toast'::text))"
                Rows Removed by Filter: 6
                Shared Hit Blocks: 1
                Shared Read Blocks: 0
                Shared Dirtied Blocks: 0
                Shared Written Blocks: 0
                Local Hit Blocks: 0
                Local Read Blocks: 0
                Local Dirtied Blocks: 0
                Local Written Blocks: 0
                Temp Read Blocks: 0
                Temp Written Blocks: 0
  Planning Time: 0.331
  Triggers: 
  Execution Time: 0.762