explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i1My

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 75.679 ↑ 1.0 1 1

Limit (cost=79,830.90..79,830.90 rows=1 width=55) (actual time=75.676..75.679 rows=1 loops=1)

  • Buffers: shared hit=2964
2. 30.808 75.675 ↑ 498,422.0 1 1

Sort (cost=79,830.90..81,076.95 rows=498,422 width=55) (actual time=75.675..75.675 rows=1 loops=1)

  • Sort Key: ((ip)::inet)
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=2964
3. 41.275 44.867 ↑ 5.9 84,659 1

Bitmap Heap Scan on conrepo_apnip ip (cost=5,741.99..77,338.79 rows=498,422 width=55) (actual time=3.886..44.867 rows=84,659 loops=1)

  • Recheck Cond: ((cidrid = ANY ('{18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,35}'::bigint[])) AND (NOT reserved) AND (NOT allocated))
  • Heap Blocks: exact=2587
  • Buffers: shared hit=2964
4. 3.592 3.592 ↑ 5.9 84,692 1

Bitmap Index Scan on x_conrepo_apnip_cidridresall (cost=0.00..5,617.38 rows=498,422 width=0) (actual time=3.591..3.592 rows=84,692 loops=1)

  • Index Cond: (cidrid = ANY ('{18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,35}'::bigint[]))
  • Buffers: shared hit=377