explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vxJ : bans1

Settings
# exclusive inclusive rows x rows loops node
1. 51.634 2,230.993 ↑ 104.1 11,229 1

Nested Loop (cost=0.01..138,160.99 rows=1,168,794 width=368) (actual time=126.148..2,230.993 rows=11,229 loops=1)

  • Buffers: shared hit=121 read=345
  • I/O Timings: read=2132.548
2. 3.778 2,144.181 ↑ 1.0 11,726 1

Append (cost=0.00..650.60 rows=11,806 width=181) (actual time=126.086..2,144.181 rows=11,726 loops=1)

  • Buffers: shared hit=121 read=345
  • I/O Timings: read=2132.548
3. 0.012 0.012 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549362337) AND (endtime <= 1549364137))
4. 2,140.391 2,140.391 ↑ 1.0 11,726 1

Index Scan using route_bans_1549317600_endtime_idx on bans_1549317600 b_1 (cost=0.42..591.57 rows=11,805 width=181) (actual time=126.072..2,140.391 rows=11,726 loops=1)

  • Index Cond: ((endtime >= 1549362337) AND (endtime <= 1549364137))
  • Buffers: shared hit=121 read=345
  • I/O Timings: read=2132.548
5. 35.178 35.178 ↑ 99.0 1 11,726

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

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