explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6LlwB : del_query

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.382 27.525 ↓ 1,000.0 1,000 1

Limit (cost=1,002.55..2,646.29 rows=1 width=180) (actual time=5.004..27.525 rows=1,000 loops=1)

  • Buffers: shared hit=147 read=131
  • I/O Timings: read=0.976
2. 11.404 27.143 ↓ 1,000.0 1,000 1

Gather (cost=1,002.55..2,646.29 rows=1 width=180) (actual time=5.002..27.143 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=147 read=131
  • I/O Timings: read=0.976
3. 5.785 15.739 ↓ 335.0 335 3

Parallel Hash Join (cost=2.55..1,646.19 rows=1 width=180) (actual time=0.549..15.739 rows=335 loops=3)

  • Hash Cond: (d_1.endtime = rundata_1549317600.endtime)
  • Buffers: shared hit=147 read=131
  • I/O Timings: read=0.976
4. 1.168 9.865 ↑ 43.3 335 3

Result (cost=0.00..1,638.57 rows=14,500 width=368) (actual time=0.151..9.865 rows=335 loops=3)

  • Buffers: shared hit=14 read=127
  • I/O Timings: read=0.925
5. 7.608 8.697 ↑ 43.3 335 3

ProjectSet (cost=0.00..152.32 rows=14,500 width=277) (actual time=0.135..8.697 rows=335 loops=3)

  • Buffers: shared hit=14 read=127
  • I/O Timings: read=0.925
6. 0.132 1.089 ↓ 1.6 233 3

Parallel Append (cost=0.00..70.40 rows=145 width=1,264) (actual time=0.056..1.089 rows=233 loops=3)

  • Buffers: shared hit=14 read=127
  • I/O Timings: read=0.925
7. 0.956 0.956 ↓ 1.1 233 3

Parallel Index Scan using route_delivery_1549317600_endtime_idx on delivery_1549317600 d_1 (cost=0.42..68.22 rows=204 width=1,268) (actual time=0.054..0.956 rows=233 loops=3)

  • Index Cond: ((endtime >= 1549362337) AND (endtime <= 1549364137))
  • Buffers: shared hit=14 read=127
  • I/O Timings: read=0.925
8. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549362337) AND (endtime <= 1549364137))
9. 0.000 0.089 ↓ 10.0 20 3

Parallel Hash (cost=2.52..2.52 rows=2 width=155) (actual time=0.089..0.089 rows=20 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
  • Buffers: shared hit=61 read=4
  • I/O Timings: read=0.051
10. 0.024 0.197 ↓ 30.0 60 1

Parallel Append (cost=0.00..2.52 rows=2 width=155) (actual time=0.076..0.197 rows=60 loops=1)

  • Buffers: shared hit=61 read=4
  • I/O Timings: read=0.051
11. 0.172 0.172 ↓ 60.0 60 1

Parallel Index Scan using route_rundata_1549317600_endtime_idx on rundata_1549317600 (cost=0.28..2.51 rows=1 width=212) (actual time=0.073..0.172 rows=60 loops=1)

  • Index Cond: ((endtime >= 1549362337) AND (endtime <= 1549364137))
  • Buffers: shared hit=61 read=4
  • I/O Timings: read=0.051
12. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549362337) AND (endtime <= 1549364137))