explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4V2R : bans_interval

Settings
# exclusive inclusive rows x rows loops node
1. 0.333 6.993 ↑ 1.0 1,000 1

Limit (cost=1,000.30..3,106.79 rows=1,000 width=104) (actual time=1.509..6.993 rows=1,000 loops=1)

  • Buffers: shared hit=51 read=3
  • I/O Timings: read=0.036
2. 5.185 6.660 ↑ 5.1 1,000 1

Gather (cost=1,000.30..11,753.22 rows=5,129 width=104) (actual time=1.508..6.660 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=51 read=3
  • I/O Timings: read=0.036
3. 0.294 1.475 ↑ 638.2 335 3

Result (cost=0.30..10,240.32 rows=213,800 width=104) (actual time=0.056..1.475 rows=335 loops=3)

  • Buffers: shared hit=51 read=3
  • I/O Timings: read=0.036
4. 0.821 1.181 ↑ 638.2 335 3

ProjectSet (cost=0.30..5,964.32 rows=213,800 width=72) (actual time=0.050..1.181 rows=335 loops=3)

  • Buffers: shared hit=51 read=3
  • I/O Timings: read=0.036
5. 0.000 0.360 ↑ 6.0 355 3

Parallel Append (cost=0.30..4,873.94 rows=2,138 width=72) (actual time=0.034..0.360 rows=355 loops=3)

  • Buffers: shared hit=51 read=3
  • I/O Timings: read=0.036
6. 0.069 0.069 ↑ 75.7 29 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.069 rows=29 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=9
7. 0.318 0.318 ↑ 1.6 518 2

Parallel Index Scan using route_bans_1549231200_endtime_idx on bans_1549231200 b_2 (cost=0.30..1,318.27 rows=821 width=72) (actual time=0.024..0.318 rows=518 loops=2)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=42 read=3
  • I/O Timings: read=0.036
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.000..0.001 rows=0 loops=1)

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