explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gxxz

Settings
# exclusive inclusive rows x rows loops node
1. 2,948.095 5,844.518 ↑ 1.0 1 1

Aggregate (cost=83,006.36..83,006.38 rows=1 width=32) (actual time=5,844.513..5,844.518 rows=1 loops=1)

  • Buffers: shared hit=154,681 read=3,544
2. 0.005 2,700.083 ↑ 1.0 1 1

Nested Loop Left Join (cost=83,005.30..83,006.35 rows=1 width=32) (actual time=2,700.072..2,700.083 rows=1 loops=1)

  • Buffers: shared hit=154,681 read=3,544
3. 0.016 0.016 ↑ 1.0 1 1

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

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

Aggregate (cost=83,005.30..83,005.31 rows=1 width=32) (actual time=2,700.059..2,700.062 rows=1 loops=1)

  • Buffers: shared hit=154,680 read=3,544
5. 26.193 301.532 ↓ 1.3 281,672 1

Custom Scan (ChunkAppend) on pod_cost (cost=0.00..79,749.00 rows=217,087 width=220) (actual time=0.319..301.532 rows=281,672 loops=1)

  • Chunks excluded during runtime: 0
  • Buffers: shared hit=154,680 read=3,544
6. 134.977 134.977 ↑ 1.0 151,894 1

Seq Scan on _hyper_5_38_chunk (cost=0.00..31,883.16 rows=151,953 width=220) (actual time=0.295..134.977 rows=151,894 loops=1)

  • Filter: ((end_time >= '2020-10-03 04:47:15'::timestamp without time zone) AND (vendor.id = vendor_id))
  • Rows Removed by Filter: 17,050
  • Buffers: shared hit=25,805 read=3,544
7. 140.362 140.362 ↓ 2.0 129,778 1

Index Scan using "73_240_pod_cost_pkey" on _hyper_5_73_chunk (cost=0.42..47,865.84 rows=65,134 width=220) (actual time=0.033..140.362 rows=129,778 loops=1)

  • Index Cond: ((vendor_id = vendor.id) AND (end_time >= '2020-10-03 04:47:15'::timestamp without time zone))
  • Buffers: shared hit=128,875
8.          

SubPlan (for Aggregate)

9. 0.000 0.000 ↑ 1.0 1 281,672

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

10.          

SubPlan (for Aggregate)

11. 196.340 196.340 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=32) (actual time=180.804..196.340 rows=1 loops=1)

Planning time : 4.221 ms
Execution time : 5,918.416 ms