explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rKpH : bans_interval

Settings
# exclusive inclusive rows x rows loops node
1. 0.501 8.573 ↑ 1.0 1,000 1

Limit (cost=1,000.42..3,106.76 rows=1,000 width=104) (actual time=1.524..8.573 rows=1,000 loops=1)

  • Buffers: shared hit=43 read=13
  • I/O Timings: read=0.116
2. 5.808 8.072 ↑ 5.7 1,000 1

Gather (cost=1,000.42..13,048.08 rows=5,747 width=104) (actual time=1.522..8.072 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=43 read=13
  • I/O Timings: read=0.116
3. 0.463 2.264 ↑ 717.1 334 3

Result (cost=0.42..11,473.38 rows=239,500 width=104) (actual time=0.072..2.264 rows=334 loops=3)

  • Buffers: shared hit=43 read=13
  • I/O Timings: read=0.116
4. 1.248 1.801 ↑ 717.1 334 3

ProjectSet (cost=0.42..6,683.38 rows=239,500 width=72) (actual time=0.065..1.801 rows=334 loops=3)

  • Buffers: shared hit=43 read=13
  • I/O Timings: read=0.116
5. 0.000 0.553 ↑ 6.8 351 3

Parallel Append (cost=0.42..5,461.93 rows=2,395 width=72) (actual time=0.049..0.553 rows=351 loops=3)

  • Buffers: shared hit=43 read=13
  • I/O Timings: read=0.116
6. 0.290 0.290 ↑ 5.9 371 1

Parallel Index Scan using route_bans_1549144800_endtime_idx on bans_1549144800 b_1 (cost=0.42..3,523.60 rows=2,195 width=72) (actual time=0.049..0.290 rows=371 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=24
7. 0.422 0.422 ↑ 3.5 341 2

Parallel Index Scan using route_bans_1549231200_endtime_idx on bans_1549231200 b_2 (cost=0.42..1,902.41 rows=1,185 width=72) (actual time=0.045..0.422 rows=341 loops=2)

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

Parallel Seq Scan on bans b (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))