explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wro4

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 631.293 ↑ 1.0 1 1

Limit (cost=92,162.93..92,162.94 rows=1 width=55) (actual time=631.285..631.293 rows=1 loops=1)

  • Buffers: shared hit=20492
2. 27.986 631.284 ↑ 506,299.0 1 1

Sort (cost=92,162.93..93,428.68 rows=506,299 width=55) (actual time=631.284..631.284 rows=1 loops=1)

  • Sort Key: ((ip.ip)::inet)
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=20492
3. 45.415 603.298 ↑ 5.9 85,093 1

Nested Loop (cost=11,255.39..89,631.44 rows=506,299 width=55) (actual time=41.371..603.298 rows=85,093 loops=1)

  • Buffers: shared hit=20492
4. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on conrepo_apn apn (cost=0.00..1.16 rows=1 width=8) (actual time=0.005..0.010 rows=1 loops=1)

  • Filter: (enabled AND (id = 5))
  • Rows Removed by Filter: 12
  • Buffers: shared hit=1
5. 275.107 557.873 ↑ 5.9 85,093 1

Hash Join (cost=11,255.39..82,035.79 rows=506,299 width=31) (actual time=41.355..557.873 rows=85,093 loops=1)

  • Hash Cond: (ip.cidrid = cidr.id)
  • Buffers: shared hit=20491
6. 245.258 282.742 ↑ 1.3 1,069,651 1

Bitmap Heap Scan on conrepo_apnip ip (cost=11,253.62..78,184.66 rows=1,340,204 width=31) (actual time=39.961..282.742 rows=1,069,651 loops=1)

  • Recheck Cond: ((NOT reserved) AND (NOT allocated))
  • Heap Blocks: exact=16389
  • Buffers: shared hit=20490
7. 37.484 37.484 ↑ 1.3 1,069,655 1

Bitmap Index Scan on x_conrepo_apnip_cidridresall (cost=0.00..10,918.57 rows=1,340,204 width=0) (actual time=37.484..37.484 rows=1,069,655 loops=1)

  • Buffers: shared hit=4101
8. 0.014 0.024 ↑ 1.0 17 1

Hash (cost=1.56..1.56 rows=17 width=16) (actual time=0.023..0.024 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
9. 0.010 0.010 ↑ 1.0 17 1

Seq Scan on conrepo_apncidr cidr (cost=0.00..1.56 rows=17 width=16) (actual time=0.004..0.010 rows=17 loops=1)

  • Filter: (enabled AND (apnid = 5))
  • Rows Removed by Filter: 28
  • Buffers: shared hit=1