explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b9eu

Settings
# exclusive inclusive rows x rows loops node
1. 2,925.538 7,302.493 ↑ 1.0 1 1

Aggregate (cost=67,204.99..67,205.01 rows=1 width=32) (actual time=7,302.486..7,302.493 rows=1 loops=1)

  • Buffers: shared hit=289,894
2. 0.005 4,186.141 ↑ 1.0 1 1

Nested Loop Left Join (cost=67,203.93..67,204.98 rows=1 width=32) (actual time=4,186.128..4,186.141 rows=1 loops=1)

  • Buffers: shared hit=289,894
3. 0.012 0.012 ↑ 1.0 1 1

Seq Scan on vendor (cost=0.00..1.01 rows=1 width=4) (actual time=0.007..0.012 rows=1 loops=1)

  • Filter: (id = 1)
  • Rows Removed by Filter: 3
  • Buffers: shared hit=1
4. 1,246.318 4,186.124 ↑ 1.0 1 1

Aggregate (cost=67,203.93..67,203.94 rows=1 width=32) (actual time=4,186.119..4,186.124 rows=1 loops=1)

  • Buffers: shared hit=289,893
5. 8.751 2,753.470 ↓ 4.0 4 1

Nested Loop Left Join (cost=67,201.67..67,203.92 rows=1 width=32) (actual time=11.995..2,753.470 rows=4 loops=1)

  • Buffers: shared hit=289,893
6. 0.019 0.019 ↓ 4.0 4 1

Index Scan using unique_node on node (cost=0.14..2.36 rows=1 width=4) (actual time=0.004..0.019 rows=4 loops=1)

  • Index Cond: (vendor_id = vendor.id)
  • Buffers: shared hit=2
7. 2,392.508 2,744.700 ↑ 1.0 1 4

Aggregate (cost=67,201.53..67,201.54 rows=1 width=32) (actual time=686.174..686.175 rows=1 loops=4)

  • Buffers: shared hit=289,891
8. 27.388 352.192 ↑ 1.8 70,380 4

Custom Scan (ChunkAppend) on pod_cost (cost=0.42..65,290.18 rows=127,423 width=220) (actual time=7.118..88.048 rows=70,380 loops=4)

  • Buffers: shared hit=289,891
9. 166.812 166.812 ↑ 2.0 37,974 4

Index Scan using "38_239_pod_cost_pkey" on _hyper_5_38_chunk (cost=0.42..26,143.33 rows=75,977 width=220) (actual time=3.036..41.703 rows=37,974 loops=4)

  • Index Cond: ((node_id = node.id) AND (end_time >= '2020-10-03 04:47:15'::timestamp without time zone))
  • Buffers: shared hit=142,397
10. 157.992 157.992 ↑ 1.6 32,406 4

Index Scan using "73_240_pod_cost_pkey" on _hyper_5_73_chunk (cost=0.42..39,146.85 rows=51,446 width=220) (actual time=5.055..39.498 rows=32,406 loops=4)

  • Index Cond: ((node_id = node.id) AND (end_time >= '2020-10-03 04:47:15'::timestamp without time zone))
  • Buffers: shared hit=147,494
11.          

SubPlan (for Aggregate)

12. 0.000 0.000 ↑ 1.0 1 281,518

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=281,518)

13.          

SubPlan (for Aggregate)

14. 186.336 186.336 ↑ 1.0 1 4

Result (cost=0.00..0.01 rows=1 width=32) (actual time=44.222..46.584 rows=1 loops=4)

15.          

SubPlan (for Aggregate)

16. 190.814 190.814 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=32) (actual time=181.398..190.814 rows=1 loops=1)

Planning time : 1.357 ms
Execution time : 7,390.138 ms