explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dAuv : delivery_bare_query2

Settings
# exclusive inclusive rows x rows loops node
1. 0.344 16.781 ↓ 1,000.0 1,000 1

Limit (cost=1,002.55..2,656.95 rows=1 width=544) (actual time=3.273..16.781 rows=1,000 loops=1)

  • Buffers: shared hit=279 read=2
  • I/O Timings: read=0.036
2. 7.413 16.437 ↓ 1,000.0 1,000 1

Gather (cost=1,002.55..2,656.95 rows=1 width=544) (actual time=3.271..16.437 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=279 read=2
  • I/O Timings: read=0.036
3. 2.163 9.024 ↓ 335.0 335 3

Parallel Hash Join (cost=2.55..1,656.85 rows=1 width=544) (actual time=0.314..9.024 rows=335 loops=3)

  • Hash Cond: (d_1.endtime = rundata_1549317600.endtime)
  • Buffers: shared hit=279 read=2
  • I/O Timings: read=0.036
4. 0.778 6.807 ↑ 43.6 335 3

Result (cost=0.00..1,649.44 rows=14,600 width=368) (actual time=0.089..6.807 rows=335 loops=3)

  • Buffers: shared hit=145 read=2
  • I/O Timings: read=0.036
5. 5.446 6.029 ↑ 43.6 335 3

ProjectSet (cost=0.00..152.94 rows=14,600 width=285) (actual time=0.080..6.029 rows=335 loops=3)

  • Buffers: shared hit=145 read=2
  • I/O Timings: read=0.036
6. 0.107 0.583 ↓ 1.7 242 3

Parallel Append (cost=0.00..70.45 rows=146 width=1,273) (actual time=0.033..0.583 rows=242 loops=3)

  • Buffers: shared hit=145 read=2
  • I/O Timings: read=0.036
7. 0.475 0.475 ↓ 1.2 242 3

Parallel Index Scan using route_delivery_1549317600_endtime_idx on delivery_1549317600 d_1 (cost=0.42..68.26 rows=205 width=1,276) (actual time=0.021..0.475 rows=242 loops=3)

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
  • Buffers: shared hit=62
10. 0.031 0.079 ↓ 30.0 60 1

Parallel Append (cost=0.00..2.52 rows=2 width=179) (actual time=0.013..0.079 rows=60 loops=1)

  • Buffers: shared hit=62
11. 0.047 0.047 ↓ 60.0 60 1

Parallel Index Scan using route_rundata_1549317600_endtime_idx on rundata_1549317600 (cost=0.28..2.51 rows=1 width=228) (actual time=0.011..0.047 rows=60 loops=1)

  • Index Cond: ((endtime >= 1549362337) AND (endtime <= 1549364137))
  • Buffers: shared hit=62
12. 0.001 0.001 ↓ 0.0 0 1

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

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