explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uJDc : routing_route_base

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 2.054 411.691 ↑ 1.0 1,000 1

Limit (cost=1,000.43..14,431.43 rows=1,000 width=868) (actual time=2.590..411.691 rows=1,000 loops=1)

  • Buffers: shared hit=105 read=2
  • I/O Timings: read=9.577
2. 21.081 409.637 ↑ 89.2 1,000 1

Subquery Scan on v (cost=1,000.43..1,199,488.76 rows=89,233 width=868) (actual time=2.588..409.637 rows=1,000 loops=1)

  • Buffers: shared hit=33 read=2
  • I/O Timings: read=9.577
3. 0.000 388.556 ↑ 89.2 1,000 1

Gather (cost=1,000.43..1,162,233.98 rows=89,233 width=976) (actual time=2.534..388.556 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=105 read=2
  • I/O Timings: read=9.577
4. 389.780 395.193 ↑ 11,131.7 334 3

Result (cost=0.43..1,152,310.68 rows=3,718,000 width=976) (actual time=1.094..395.193 rows=334 loops=3)

  • Buffers: shared hit=105 read=2
  • I/O Timings: read=9.577
5. 1.596 5.413 ↑ 11,131.7 334 3

ProjectSet (cost=0.43..111,270.68 rows=3,718,000 width=112) (actual time=0.071..5.413 rows=334 loops=3)

  • Buffers: shared hit=105 read=2
  • I/O Timings: read=9.577
6. 0.000 3.817 ↑ 295.1 126 3

Parallel Append (cost=0.43..92,308.88 rows=37,180 width=80) (actual time=0.046..3.817 rows=126 loops=3)

  • Buffers: shared hit=105 read=2
  • I/O Timings: read=9.577
7. 0.616 0.616 ↑ 246.8 118 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=0.068..0.616 rows=118 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=38
8. 5.309 5.309 ↑ 179.7 130 2

Parallel Index Scan using route_routing_1549231200_endtime_idx on routing_1549231200 (cost=0.43..40,835.08 rows=23,361 width=80) (actual time=0.032..5.309 rows=130 loops=2)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=67 read=2
  • I/O Timings: read=9.577
9. 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))