explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qaE : test_bans1

Settings
# exclusive inclusive rows x rows loops node
1. 0.348 8.467 ↑ 1.0 1,000 1

Limit (cost=0.00..147.23 rows=1,000 width=368) (actual time=0.078..8.467 rows=1,000 loops=1)

  • Buffers: shared hit=45
2. 4.304 8.119 ↑ 578.0 1,000 1

Result (cost=0.00..85,099.53 rows=578,000 width=368) (actual time=0.077..8.119 rows=1,000 loops=1)

  • Buffers: shared hit=45
3. 2.703 3.815 ↑ 578.0 1,000 1

ProjectSet (cost=0.00..8,514.53 rows=578,000 width=112) (actual time=0.052..3.815 rows=1,000 loops=1)

  • Buffers: shared hit=45
4. 0.318 1.112 ↑ 5.7 1,007 1

Append (cost=0.00..5,566.73 rows=5,780 width=80) (actual time=0.040..1.112 rows=1,007 loops=1)

  • Buffers: shared hit=45
5. 0.015 0.015 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
6. 0.779 0.779 ↑ 3.7 1,007 1

Index Scan using route_bans_1549144800_endtime_idx on bans_1549144800 b_1 (cost=0.42..3,538.97 rows=3,732 width=80) (actual time=0.023..0.779 rows=1,007 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=45
7. 0.000 0.000 ↓ 0.0 0

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

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