explain_planning_memory.out
application/octet-stream
Filename: explain_planning_memory.out
Type: application/octet-stream
Part: 0
QUERY PLAN
--------------------------------------------------------------------------
Hash Join (cost=28.84..47.08 rows=414 width=533)
Hash Cond: (c.reltype = t.oid)
-> Seq Scan on pg_class c (cost=0.00..17.14 rows=414 width=273)
-> Hash (cost=21.15..21.15 rows=615 width=260)
-> Seq Scan on pg_type t (cost=0.00..21.15 rows=615 width=260)
Planning Time: 8.001 ms
Planning Memory: used=80848 bytes allocated=90112 bytes
(7 rows)
QUERY PLAN
-----------------------------------------------
[ +
{ +
"Plan": { +
"Node Type": "Hash Join", +
"Parallel Aware": false, +
"Async Capable": false, +
"Join Type": "Inner", +
"Startup Cost": 28.84, +
"Total Cost": 47.08, +
"Plan Rows": 414, +
"Plan Width": 533, +
"Inner Unique": true, +
"Hash Cond": "(c.reltype = t.oid)", +
"Plans": [ +
{ +
"Node Type": "Seq Scan", +
"Parent Relationship": "Outer", +
"Parallel Aware": false, +
"Async Capable": false, +
"Relation Name": "pg_class", +
"Alias": "c", +
"Startup Cost": 0.00, +
"Total Cost": 17.14, +
"Plan Rows": 414, +
"Plan Width": 273 +
}, +
{ +
"Node Type": "Hash", +
"Parent Relationship": "Inner", +
"Parallel Aware": false, +
"Async Capable": false, +
"Startup Cost": 21.15, +
"Total Cost": 21.15, +
"Plan Rows": 615, +
"Plan Width": 260, +
"Plans": [ +
{ +
"Node Type": "Seq Scan", +
"Parent Relationship": "Outer",+
"Parallel Aware": false, +
"Async Capable": false, +
"Relation Name": "pg_type", +
"Alias": "t", +
"Startup Cost": 0.00, +
"Total Cost": 21.15, +
"Plan Rows": 615, +
"Plan Width": 260 +
} +
] +
} +
] +
}, +
"Planning Time": 1.289, +
"Planning Memory": { +
"Used": 80608, +
"Allocated": 90112 +
} +
} +
]
(1 row)
QUERY PLAN
----------------------------------------------------------------
<explain xmlns="http://www.postgresql.org/2009/explain"> +
<Query> +
<Plan> +
<Node-Type>Hash Join</Node-Type> +
<Parallel-Aware>false</Parallel-Aware> +
<Async-Capable>false</Async-Capable> +
<Join-Type>Inner</Join-Type> +
<Startup-Cost>28.84</Startup-Cost> +
<Total-Cost>47.08</Total-Cost> +
<Plan-Rows>414</Plan-Rows> +
<Plan-Width>533</Plan-Width> +
<Inner-Unique>true</Inner-Unique> +
<Hash-Cond>(c.reltype = t.oid)</Hash-Cond> +
<Plans> +
<Plan> +
<Node-Type>Seq Scan</Node-Type> +
<Parent-Relationship>Outer</Parent-Relationship> +
<Parallel-Aware>false</Parallel-Aware> +
<Async-Capable>false</Async-Capable> +
<Relation-Name>pg_class</Relation-Name> +
<Alias>c</Alias> +
<Startup-Cost>0.00</Startup-Cost> +
<Total-Cost>17.14</Total-Cost> +
<Plan-Rows>414</Plan-Rows> +
<Plan-Width>273</Plan-Width> +
</Plan> +
<Plan> +
<Node-Type>Hash</Node-Type> +
<Parent-Relationship>Inner</Parent-Relationship> +
<Parallel-Aware>false</Parallel-Aware> +
<Async-Capable>false</Async-Capable> +
<Startup-Cost>21.15</Startup-Cost> +
<Total-Cost>21.15</Total-Cost> +
<Plan-Rows>615</Plan-Rows> +
<Plan-Width>260</Plan-Width> +
<Plans> +
<Plan> +
<Node-Type>Seq Scan</Node-Type> +
<Parent-Relationship>Outer</Parent-Relationship>+
<Parallel-Aware>false</Parallel-Aware> +
<Async-Capable>false</Async-Capable> +
<Relation-Name>pg_type</Relation-Name> +
<Alias>t</Alias> +
<Startup-Cost>0.00</Startup-Cost> +
<Total-Cost>21.15</Total-Cost> +
<Plan-Rows>615</Plan-Rows> +
<Plan-Width>260</Plan-Width> +
</Plan> +
</Plans> +
</Plan> +
</Plans> +
</Plan> +
<Planning-Time>1.468</Planning-Time> +
<Planning-Memory> +
<Used>80608</Used> +
<Allocated>90112</Allocated> +
</Planning-Memory> +
</Query> +
</explain>
(1 row)
QUERY PLAN
------------------------------------------
- Plan: +
Node Type: "Hash Join" +
Parallel Aware: false +
Async Capable: false +
Join Type: "Inner" +
Startup Cost: 28.84 +
Total Cost: 47.08 +
Plan Rows: 414 +
Plan Width: 533 +
Inner Unique: true +
Hash Cond: "(c.reltype = t.oid)" +
Plans: +
- Node Type: "Seq Scan" +
Parent Relationship: "Outer" +
Parallel Aware: false +
Async Capable: false +
Relation Name: "pg_class" +
Alias: "c" +
Startup Cost: 0.00 +
Total Cost: 17.14 +
Plan Rows: 414 +
Plan Width: 273 +
- Node Type: "Hash" +
Parent Relationship: "Inner" +
Parallel Aware: false +
Async Capable: false +
Startup Cost: 21.15 +
Total Cost: 21.15 +
Plan Rows: 615 +
Plan Width: 260 +
Plans: +
- Node Type: "Seq Scan" +
Parent Relationship: "Outer"+
Parallel Aware: false +
Async Capable: false +
Relation Name: "pg_type" +
Alias: "t" +
Startup Cost: 0.00 +
Total Cost: 21.15 +
Plan Rows: 615 +
Plan Width: 260 +
Planning Time: 1.735 +
Planning Memory: +
Used: 80608 +
Allocated: 90112
(1 row)
QUERY PLAN
------------------------------------------
- Plan: +
Node Type: "Hash Join" +
Parallel Aware: false +
Async Capable: false +
Join Type: "Inner" +
Startup Cost: 28.84 +
Total Cost: 47.08 +
Plan Rows: 414 +
Plan Width: 533 +
Actual Startup Time: 1.899 +
Actual Total Time: 4.176 +
Actual Rows: 210 +
Actual Loops: 1 +
Inner Unique: true +
Hash Cond: "(c.reltype = t.oid)" +
Plans: +
- Node Type: "Seq Scan" +
Parent Relationship: "Outer" +
Parallel Aware: false +
Async Capable: false +
Relation Name: "pg_class" +
Alias: "c" +
Startup Cost: 0.00 +
Total Cost: 17.14 +
Plan Rows: 414 +
Plan Width: 273 +
Actual Startup Time: 0.026 +
Actual Total Time: 0.376 +
Actual Rows: 414 +
Actual Loops: 1 +
- Node Type: "Hash" +
Parent Relationship: "Inner" +
Parallel Aware: false +
Async Capable: false +
Startup Cost: 21.15 +
Total Cost: 21.15 +
Plan Rows: 615 +
Plan Width: 260 +
Actual Startup Time: 1.798 +
Actual Total Time: 1.800 +
Actual Rows: 615 +
Actual Loops: 1 +
Hash Buckets: 1024 +
Original Hash Buckets: 1024 +
Hash Batches: 1 +
Original Hash Batches: 1 +
Peak Memory Usage: 121 +
Plans: +
- Node Type: "Seq Scan" +
Parent Relationship: "Outer"+
Parallel Aware: false +
Async Capable: false +
Relation Name: "pg_type" +
Alias: "t" +
Startup Cost: 0.00 +
Total Cost: 21.15 +
Plan Rows: 615 +
Plan Width: 260 +
Actual Startup Time: 0.013 +
Actual Total Time: 0.852 +
Actual Rows: 615 +
Actual Loops: 1 +
Planning Time: 1.384 +
Planning Memory: +
Used: 80608 +
Allocated: 90112 +
Triggers: +
Execution Time: 4.504
(1 row)
QUERY PLAN
----------------------------------------------------------------
<explain xmlns="http://www.postgresql.org/2009/explain"> +
<Query> +
<Plan> +
<Node-Type>Hash Join</Node-Type> +
<Parallel-Aware>false</Parallel-Aware> +
<Async-Capable>false</Async-Capable> +
<Join-Type>Inner</Join-Type> +
<Startup-Cost>28.84</Startup-Cost> +
<Total-Cost>47.08</Total-Cost> +
<Plan-Rows>414</Plan-Rows> +
<Plan-Width>533</Plan-Width> +
<Actual-Startup-Time>1.429</Actual-Startup-Time> +
<Actual-Total-Time>4.142</Actual-Total-Time> +
<Actual-Rows>210</Actual-Rows> +
<Actual-Loops>1</Actual-Loops> +
<Inner-Unique>true</Inner-Unique> +
<Hash-Cond>(c.reltype = t.oid)</Hash-Cond> +
<Plans> +
<Plan> +
<Node-Type>Seq Scan</Node-Type> +
<Parent-Relationship>Outer</Parent-Relationship> +
<Parallel-Aware>false</Parallel-Aware> +
<Async-Capable>false</Async-Capable> +
<Relation-Name>pg_class</Relation-Name> +
<Alias>c</Alias> +
<Startup-Cost>0.00</Startup-Cost> +
<Total-Cost>17.14</Total-Cost> +
<Plan-Rows>414</Plan-Rows> +
<Plan-Width>273</Plan-Width> +
<Actual-Startup-Time>0.030</Actual-Startup-Time> +
<Actual-Total-Time>0.410</Actual-Total-Time> +
<Actual-Rows>414</Actual-Rows> +
<Actual-Loops>1</Actual-Loops> +
</Plan> +
<Plan> +
<Node-Type>Hash</Node-Type> +
<Parent-Relationship>Inner</Parent-Relationship> +
<Parallel-Aware>false</Parallel-Aware> +
<Async-Capable>false</Async-Capable> +
<Startup-Cost>21.15</Startup-Cost> +
<Total-Cost>21.15</Total-Cost> +
<Plan-Rows>615</Plan-Rows> +
<Plan-Width>260</Plan-Width> +
<Actual-Startup-Time>1.344</Actual-Startup-Time> +
<Actual-Total-Time>1.348</Actual-Total-Time> +
<Actual-Rows>615</Actual-Rows> +
<Actual-Loops>1</Actual-Loops> +
<Hash-Buckets>1024</Hash-Buckets> +
<Original-Hash-Buckets>1024</Original-Hash-Buckets> +
<Hash-Batches>1</Hash-Batches> +
<Original-Hash-Batches>1</Original-Hash-Batches> +
<Peak-Memory-Usage>121</Peak-Memory-Usage> +
<Plans> +
<Plan> +
<Node-Type>Seq Scan</Node-Type> +
<Parent-Relationship>Outer</Parent-Relationship>+
<Parallel-Aware>false</Parallel-Aware> +
<Async-Capable>false</Async-Capable> +
<Relation-Name>pg_type</Relation-Name> +
<Alias>t</Alias> +
<Startup-Cost>0.00</Startup-Cost> +
<Total-Cost>21.15</Total-Cost> +
<Plan-Rows>615</Plan-Rows> +
<Plan-Width>260</Plan-Width> +
<Actual-Startup-Time>0.014</Actual-Startup-Time>+
<Actual-Total-Time>0.483</Actual-Total-Time> +
<Actual-Rows>615</Actual-Rows> +
<Actual-Loops>1</Actual-Loops> +
</Plan> +
</Plans> +
</Plan> +
</Plans> +
</Plan> +
<Planning-Time>1.519</Planning-Time> +
<Planning-Memory> +
<Used>80608</Used> +
<Allocated>90112</Allocated> +
</Planning-Memory> +
<Triggers> +
</Triggers> +
<Execution-Time>4.546</Execution-Time> +
</Query> +
</explain>
(1 row)
QUERY PLAN
-----------------------------------------------
[ +
{ +
"Plan": { +
"Node Type": "Hash Join", +
"Parallel Aware": false, +
"Async Capable": false, +
"Join Type": "Inner", +
"Startup Cost": 28.84, +
"Total Cost": 47.08, +
"Plan Rows": 414, +
"Plan Width": 533, +
"Actual Startup Time": 1.420, +
"Actual Total Time": 4.024, +
"Actual Rows": 210, +
"Actual Loops": 1, +
"Inner Unique": true, +
"Hash Cond": "(c.reltype = t.oid)", +
"Plans": [ +
{ +
"Node Type": "Seq Scan", +
"Parent Relationship": "Outer", +
"Parallel Aware": false, +
"Async Capable": false, +
"Relation Name": "pg_class", +
"Alias": "c", +
"Startup Cost": 0.00, +
"Total Cost": 17.14, +
"Plan Rows": 414, +
"Plan Width": 273, +
"Actual Startup Time": 0.029, +
"Actual Total Time": 0.395, +
"Actual Rows": 414, +
"Actual Loops": 1 +
}, +
{ +
"Node Type": "Hash", +
"Parent Relationship": "Inner", +
"Parallel Aware": false, +
"Async Capable": false, +
"Startup Cost": 21.15, +
"Total Cost": 21.15, +
"Plan Rows": 615, +
"Plan Width": 260, +
"Actual Startup Time": 1.332, +
"Actual Total Time": 1.334, +
"Actual Rows": 615, +
"Actual Loops": 1, +
"Hash Buckets": 1024, +
"Original Hash Buckets": 1024, +
"Hash Batches": 1, +
"Original Hash Batches": 1, +
"Peak Memory Usage": 121, +
"Plans": [ +
{ +
"Node Type": "Seq Scan", +
"Parent Relationship": "Outer",+
"Parallel Aware": false, +
"Async Capable": false, +
"Relation Name": "pg_type", +
"Alias": "t", +
"Startup Cost": 0.00, +
"Total Cost": 21.15, +
"Plan Rows": 615, +
"Plan Width": 260, +
"Actual Startup Time": 0.013, +
"Actual Total Time": 0.482, +
"Actual Rows": 615, +
"Actual Loops": 1 +
} +
] +
} +
] +
}, +
"Planning Time": 1.462, +
"Planning Memory": { +
"Used": 80608, +
"Allocated": 90112 +
}, +
"Triggers": [ +
], +
"Execution Time": 4.405 +
} +
]
(1 row)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------
Hash Join (cost=28.84..47.08 rows=414 width=533) (actual time=1.657..4.623 rows=210 loops=1)
Hash Cond: (c.reltype = t.oid)
-> Seq Scan on pg_class c (cost=0.00..17.14 rows=414 width=273) (actual time=0.036..0.468 rows=414 loops=1)
-> Hash (cost=21.15..21.15 rows=615 width=260) (actual time=1.558..1.562 rows=615 loops=1)
Buckets: 1024 Batches: 1 Memory Usage: 121kB
-> Seq Scan on pg_type t (cost=0.00..21.15 rows=615 width=260) (actual time=0.017..0.580 rows=615 loops=1)
Planning Time: 1.937 ms
Planning Memory: used=80608 bytes allocated=90112 bytes
Execution Time: 5.032 ms
(9 rows)