explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rfZH : routing_esme_base

Settings
# exclusive inclusive rows x rows loops node
1. 5.813 394.035 ↑ 1.0 1,000 1

Limit (cost=1,000.43..1,347,414.57 rows=1,000 width=736) (actual time=169.271..394.035 rows=1,000 loops=1)

  • Buffers: shared hit=35 read=110
  • I/O Timings: read=548.913
2. 22.342 388.222 ↑ 87.5 1,000 1

Subquery Scan on v (cost=1,000.43..117,814,930.44 rows=87,502 width=736) (actual time=169.269..388.222 rows=1,000 loops=1)

  • Buffers: shared hit=6 read=26
  • I/O Timings: read=273.831
3. 136.668 365.880 ↑ 87.5 1,000 1

Gather (cost=1,000.43..117,772,054.46 rows=87,502 width=1,040) (actual time=169.144..365.880 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=35 read=110
  • I/O Timings: read=548.913
4. 33.201 229.212 ↑ 1,088,328.4 335 3

Result (cost=0.43..117,762,304.26 rows=364,590,000 width=1,040) (actual time=69.847..229.212 rows=335 loops=3)

  • Buffers: shared hit=35 read=110
  • I/O Timings: read=548.913
5. 0.934 196.011 ↑ 1,088,328.4 335 3

ProjectSet (cost=0.43..2,004,979.26 rows=364,590,000 width=144) (actual time=69.673..196.011 rows=335 loops=3)

  • Buffers: shared hit=35 read=110
  • I/O Timings: read=548.913
6. 1.408 195.077 ↑ 14,583.6 250 3

ProjectSet (cost=0.43..109,111.26 rows=3,645,900 width=112) (actual time=69.659..195.077 rows=250 loops=3)

  • Buffers: shared hit=35 read=110
  • I/O Timings: read=548.913
7. 0.000 193.669 ↑ 199.2 183 3

Parallel Append (cost=0.43..90,517.17 rows=36,459 width=80) (actual time=69.626..193.669 rows=183 loops=3)

  • Buffers: shared hit=35 read=110
  • I/O Timings: read=548.913
8. 169.644 169.644 ↑ 448.1 65 1

Parallel Index Scan using route_routing_1549144800_endtime_idx on routing_1549144800 (cost=0.43..50,916.10 rows=29,128 width=80) (actual time=41.540..169.644 rows=65 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=8 read=15
  • I/O Timings: read=169.348
9. 205.561 205.561 ↑ 92.3 242 2

Parallel Index Scan using route_routing_1549231200_endtime_idx on routing_1549231200 (cost=0.43..39,054.19 rows=22,343 width=80) (actual time=83.666..205.561 rows=242 loops=2)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=27 read=95
  • I/O Timings: read=379.565
10. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))