explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N5mA : base_bans

Settings
# exclusive inclusive rows x rows loops node
1. 0.292 143.211 ↑ 1.0 1,000 1

Limit (cost=1,000.42..6,613.29 rows=1,000 width=368) (actual time=90.327..143.211 rows=1,000 loops=1)

  • Buffers: shared hit=45 read=13
  • I/O Timings: read=251.002
2. 33.358 142.919 ↑ 5.7 1,000 1

Gather (cost=1,000.42..33,061.12 rows=5,712 width=368) (actual time=90.324..142.919 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=45 read=13
  • I/O Timings: read=251.002
3. 1.216 109.561 ↑ 16.3 350 3

Subquery Scan on v (cost=0.42..31,489.92 rows=5,712 width=368) (actual time=77.839..109.561 rows=350 loops=3)

  • Filter: ((v.val ->> 4) <> ''::text)
  • Buffers: shared hit=45 read=13
  • I/O Timings: read=251.002
4. 0.778 108.345 ↑ 683.7 350 3

Result (cost=0.42..31,203.89 rows=239,300 width=384) (actual time=77.720..108.345 rows=350 loops=3)

  • Buffers: shared hit=45 read=13
  • I/O Timings: read=251.002
5. 1.063 107.567 ↑ 683.7 350 3

ProjectSet (cost=0.42..6,675.64 rows=239,300 width=112) (actual time=77.704..107.567 rows=350 loops=3)

  • Buffers: shared hit=45 read=13
  • I/O Timings: read=251.002
6. 0.000 106.504 ↑ 6.6 360 3

Parallel Append (cost=0.42..5,455.21 rows=2,393 width=80) (actual time=77.675..106.504 rows=360 loops=3)

  • Buffers: shared hit=45 read=13
  • I/O Timings: read=251.002
7. 75.631 75.631 ↑ 2.4 905 1

Parallel Index Scan using route_bans_1549144800_endtime_idx on bans_1549144800 (cost=0.42..3,523.60 rows=2,195 width=80) (actual time=74.748..75.631 rows=905 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=44 read=1
  • I/O Timings: read=74.667
8. 121.722 121.722 ↑ 13.4 88 2

Parallel Index Scan using route_bans_1549231200_endtime_idx on bans_1549231200 (cost=0.42..1,895.71 rows=1,181 width=80) (actual time=79.131..121.722 rows=88 loops=2)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=1 read=12
  • I/O Timings: read=176.335
9. 0.001 0.001 ↓ 0.0 0 1

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