explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ai3c : bans_analytics

Settings
# exclusive inclusive rows x rows loops node
1. 0.359 8.662 ↑ 1.0 1,000 1

Limit (cost=0.01..127.28 rows=1,000 width=368) (actual time=0.070..8.662 rows=1,000 loops=1)

  • Buffers: shared hit=45
2. 4.324 8.303 ↑ 569.2 1,000 1

Nested Loop (cost=0.01..72,453.81 rows=569,250 width=368) (actual time=0.069..8.303 rows=1,000 loops=1)

  • Buffers: shared hit=45
3. 0.304 0.958 ↑ 5.7 1,007 1

Append (cost=0.00..5,480.68 rows=5,750 width=80) (actual time=0.031..0.958 rows=1,007 loops=1)

  • Buffers: shared hit=45
4. 0.013 0.013 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
5. 0.641 0.641 ↑ 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.017..0.641 rows=1,007 loops=1)

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

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

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
7. 3.021 3.021 ↑ 99.0 1 1,007

Function Scan on jsonb_each esme (cost=0.01..1.50 rows=99 width=64) (actual time=0.003..0.003 rows=1 loops=1,007)

  • Filter: ((value ->> 4) <> ''::text)