tilemap |
piechart
|
#
|
node, ms
|
tree, ms
|
rows
|
|
||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 187′754.340 | 3′612′425 | |||||||||
| 0 | 168′845.485
| 187′754.340
| 3′612′425
| ▼ |
| |||||
| 1 | 4′216.992
| 8′210′240
|
| |||||||
| 2 | 13′827.236
| 14′691.863
| 3′612′425
|
| ||||||
| 3 | 864.627
| 3′612′425
|
| |||||||
10.739 |
| |||||||||
184.033 |
| |||||||||
187.112 | 187′941.452 |
|
Hash Right Join (cost=205′714.37..1′275′091.05 rows=10′321′111 width=32) (actual time=16′465.514..187′754.340 rows=3′612′425 loops=1) Hash Cond: (task.id = bp.parent_task_id) -> Seq Scan on dds__do_task_3 task (cost=0.00..765′518.61 rows=8′311′061 width=32) (actual time=0.042..4′216.992 rows=8′210′240 loops=1) -> Hash (cost=135′889.73..135′889.73 rows=3′611′091 width=32) (actual time=14′691.861..14′691.863 rows=3′612′425 loops=1) Buckets: 131′072 (originally 131′072) Batches: 524′288 (originally 64) Memory Usage: 63604kB -> Index Only Scan using "6b47db6c79341ca5aaa6ff7203ab391b" on dds__do_bp_full_3 bp (cost=0.43..135′889.73 rows=3′611′091 width=32) (actual time=1.646..864.627 rows=3′612′425 loops=1) Heap Fetches: 131 Planning Time: 10.739 ms JIT: Functions: 8 Options: Inlining true, Optimization true, Expressions true, Deforming true Timing: Generation 1.387 ms, Inlining 5.920 ms, Optimization 40.474 ms, Emission 136.252 ms, Total 184.033 ms Execution Time: 187′941.452 ms