explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EoDI : plain_bans

Settings
# exclusive inclusive rows x rows loops node
1. 0.285 92.888 ↑ 1.0 1,000 1

Limit (cost=0.00..953.10 rows=1,000 width=80) (actual time=48.759..92.888 rows=1,000 loops=1)

  • Buffers: shared hit=7 read=38
  • I/O Timings: read=91.898
2. 0.292 92.603 ↑ 5.7 1,000 1

Append (cost=0.00..5,466.00 rows=5,735 width=80) (actual time=48.757..92.603 rows=1,000 loops=1)

  • Buffers: shared hit=7 read=38
  • I/O Timings: read=91.898
3. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on bans (cost=0.00..0.00 rows=1 width=80) (actual time=0.012..0.013 rows=0 loops=1)

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
4. 92.298 92.298 ↑ 3.7 1,000 1

Index Scan using route_bans_1549144800_endtime_idx on bans_1549144800 (cost=0.42..3,538.97 rows=3,732 width=80) (actual time=48.743..92.298 rows=1,000 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=7 read=38
  • I/O Timings: read=91.898
5. 0.000 0.000 ↓ 0.0 0

Index Scan using route_bans_1549231200_endtime_idx on bans_1549231200 (cost=0.42..1,898.36 rows=2,002 width=80) (never executed)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))