explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gDgY

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 94.017 ↑ 1.0 1 1

Limit (cost=46,205.25..46,205.25 rows=1 width=55) (actual time=94.013..94.017 rows=1 loops=1)

  • Buffers: shared hit=2908
2. 41.009 94.011 ↑ 59,326.0 1 1

Sort (cost=46,205.25..46,353.56 rows=59,326 width=55) (actual time=94.011..94.011 rows=1 loops=1)

  • Sort Key: ((ip)::inet)
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=2908
3. 46.899 53.002 ↓ 1.4 84,642 1

Bitmap Heap Scan on conrepo_apnip ip (cost=760.32..45,908.62 rows=59,326 width=55) (actual time=6.521..53.002 rows=84,642 loops=1)

  • Recheck Cond: ((cidrid = ANY ('{33,35}'::bigint[])) AND (NOT reserved) AND (NOT allocated))
  • Heap Blocks: exact=2571
  • Buffers: shared hit=2903
4. 6.103 6.103 ↓ 1.4 84,675 1

Bitmap Index Scan on x_conrepo_apnip_cidridresall (cost=0.00..745.49 rows=59,326 width=0) (actual time=6.103..6.103 rows=84,675 loops=1)

  • Index Cond: (cidrid = ANY ('{33,35}'::bigint[]))
  • Buffers: shared hit=332