explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KICi : delivery_bare_query

Settings
# exclusive inclusive rows x rows loops node
1. 0.559 30.345 ↓ 1,000.0 1,000 1

Limit (cost=1,002.55..2,646.09 rows=1 width=544) (actual time=6.751..30.345 rows=1,000 loops=1)

  • Buffers: shared hit=156 read=123
  • I/O Timings: read=1.108
2. 13.382 29.786 ↓ 1,000.0 1,000 1

Gather (cost=1,002.55..2,646.09 rows=1 width=544) (actual time=6.749..29.786 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=156 read=123
  • I/O Timings: read=1.108
3. 3.809 16.404 ↓ 335.0 335 3

Parallel Hash Join (cost=2.55..1,645.99 rows=1 width=544) (actual time=0.513..16.404 rows=335 loops=3)

  • Hash Cond: (d_1.endtime = rundata_1549317600.endtime)
  • Buffers: shared hit=156 read=123
  • I/O Timings: read=1.108
4. 1.403 12.510 ↑ 43.3 335 3

Result (cost=0.00..1,638.59 rows=14,500 width=368) (actual time=0.179..12.510 rows=335 loops=3)

  • Buffers: shared hit=23 read=122
  • I/O Timings: read=1.083
5. 9.848 11.107 ↑ 43.3 335 3

ProjectSet (cost=0.00..152.34 rows=14,500 width=285) (actual time=0.164..11.107 rows=335 loops=3)

  • Buffers: shared hit=23 read=122
  • I/O Timings: read=1.083
6. 0.156 1.259 ↓ 1.7 242 3

Parallel Append (cost=0.00..70.42 rows=145 width=1,273) (actual time=0.070..1.259 rows=242 loops=3)

  • Buffers: shared hit=23 read=122
  • I/O Timings: read=1.083
7. 1.102 1.102 ↓ 1.2 242 3

Parallel Index Scan using route_delivery_1549317600_endtime_idx on delivery_1549317600 d_1 (cost=0.42..68.24 rows=204 width=1,276) (actual time=0.068..1.102 rows=242 loops=3)

  • Index Cond: ((endtime >= 1549362337) AND (endtime <= 1549364137))
  • Buffers: shared hit=23 read=122
  • I/O Timings: read=1.083
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.001..0.001 rows=0 loops=1)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
  • Buffers: shared hit=61 read=1
  • I/O Timings: read=0.026
10. 0.048 0.169 ↓ 30.0 60 1

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

  • Buffers: shared hit=61 read=1
  • I/O Timings: read=0.026
11. 0.120 0.120 ↓ 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.048..0.120 rows=60 loops=1)

  • Index Cond: ((endtime >= 1549362337) AND (endtime <= 1549364137))
  • Buffers: shared hit=61 read=1
  • I/O Timings: read=0.026
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))