explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pv9f : Optimization for: delivery_warmed; plan #12Ir

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.289 14.894 ↑ 1.0 1 1

Aggregate (cost=4,644.29..4,644.30 rows=1 width=16) (actual time=14.894..14.894 rows=1 loops=1)

  • Buffers: shared hit=134 read=26
  • I/O Timings: read=0.214
2. 1.773 14.605 ↑ 1.0 1,000 1

Limit (cost=1,000.00..4,629.29 rows=1,000 width=8) (actual time=1.699..14.605 rows=1,000 loops=1)

  • Buffers: shared hit=134 read=26
  • I/O Timings: read=0.214
3. 0.000 12.832 ↑ 902.2 1,000 1

Subquery Scan on bml_vbase_delivery_analytics (cost=1,000.00..3,275,195.77 rows=902,158 width=8) (actual time=1.697..12.832 rows=1,000 loops=1)

  • Buffers: shared hit=88
4. 7.979 13.920 ↑ 902.2 1,000 1

Gather (cost=1,000.00..3,266,174.19 rows=902,158 width=368) (actual time=1.697..13.920 rows=1,000 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
  • Buffers: shared hit=134 read=26
  • I/O Timings: read=0.214
5. 0.522 5.941 ↑ 115,943.8 251 4

Result (cost=0.00..3,174,958.39 rows=29,101,900 width=368) (actual time=0.120..5.941 rows=251 loops=4)

  • Buffers: shared hit=134 read=26
  • I/O Timings: read=0.214
6. 4.913 5.419 ↑ 115,943.8 251 4

ProjectSet (cost=0.00..337,523.14 rows=29,101,900 width=264) (actual time=0.111..5.419 rows=251 loops=4)

  • Buffers: shared hit=134 read=26
  • I/O Timings: read=0.214
7. 0.000 0.506 ↑ 1,616.8 180 4

Parallel Append (cost=0.00..173,097.41 rows=291,019 width=1,252) (actual time=0.045..0.506 rows=180 loops=4)

  • Buffers: shared hit=134 read=26
  • I/O Timings: read=0.214
8. 0.485 0.485 ↑ 1,751.3 96 2

Parallel Index Scan using route_delivery_1549231200_endtime_idx on delivery_1549231200 d_1 (cost=0.42..97,292.63 rows=168,128 width=1,249) (actual time=0.056..0.485 rows=96 loops=2)

  • Index Cond: ((endtime >= 1549270503) AND (endtime <= 1549356903))
  • Buffers: shared hit=26 read=26
  • I/O Timings: read=0.214
9. 0.351 0.351 ↑ 462.0 266 2

Parallel Index Scan using route_delivery_1549317600_endtime_idx on delivery_1549317600 d_2 (cost=0.42..71,439.49 rows=122,890 width=1,255) (actual time=0.028..0.351 rows=266 loops=2)

  • Index Cond: ((endtime >= 1549270503) AND (endtime <= 1549356903))
  • Buffers: shared hit=108
10. 0.001 0.001 ↓ 0.0 0 1

Parallel Seq Scan on delivery d (cost=0.00..0.00 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((endtime >= 1549270503) AND (endtime <= 1549356903))