explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QRr9 : r_r

Settings
# exclusive inclusive rows x rows loops node
1. 0.405 1,979.058 ↑ 1.0 1,000 1

Limit (cost=1,000.43..4,440.64 rows=1,000 width=168) (actual time=64.570..1,979.058 rows=1,000 loops=1)

  • Buffers: shared hit=22 read=72
  • I/O Timings: read=974.716
2. 1,607.717 1,978.653 ↑ 70.4 1,000 1

Gather (cost=1,000.43..242,319.41 rows=70,351 width=168) (actual time=64.568..1,978.653 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=22 read=72
  • I/O Timings: read=974.716
3. 44.611 370.936 ↑ 8,776.3 334 3

Result (cost=0.43..234,284.31 rows=2,931,300 width=168) (actual time=34.374..370.936 rows=334 loops=3)

  • Buffers: shared hit=22 read=72
  • I/O Timings: read=974.716
4. 1.069 326.325 ↑ 8,776.3 334 3

ProjectSet (cost=0.43..87,719.31 rows=2,931,300 width=104) (actual time=25.638..326.325 rows=334 loops=3)

  • Buffers: shared hit=22 read=72
  • I/O Timings: read=974.716
5. 0.000 325.256 ↑ 250.5 117 3

Parallel Append (cost=0.43..72,769.68 rows=29,313 width=72) (actual time=25.604..325.256 rows=117 loops=3)

  • Buffers: shared hit=22 read=72
  • I/O Timings: read=974.716
6. 39.777 39.777 ↑ 29,128.0 1 1

Parallel Index Scan using route_routing_1549144800_endtime_idx on routing_1549144800 (cost=0.43..50,911.70 rows=29,128 width=72) (actual time=39.777..39.777 rows=1 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=4 read=4
  • I/O Timings: read=39.678
7. 467.920 467.920 ↑ 70.4 174 2

Parallel Index Scan using route_routing_1549231200_endtime_idx on routing_1549231200 (cost=0.43..21,418.29 rows=12,254 width=72) (actual time=18.514..467.920 rows=174 loops=2)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=18 read=68
  • I/O Timings: read=935.038
8. 0.001 0.001 ↓ 0.0 0 1

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

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