explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xc4V

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

Limit (cost=96,169.52..96,169.64 rows=1 width=55) (actual time=706.066..707.880 rows=1 loops=1)

  • Buffers: shared hit=53651
2. 0.000 707.871 ↑ 421,922.0 1 1

Gather Merge (cost=96,169.52..145,397.19 rows=421,922 width=55) (actual time=706.064..707.871 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=53651
3. 146.271 2,083.236 ↑ 589.3 358 3

Sort (cost=95,169.50..95,696.90 rows=210,961 width=55) (actual time=694.307..694.412 rows=358 loops=3)

  • Sort Key: ((ip.ip)::inet)
  • Sort Method: quicksort Memory: 2719kB
  • Buffers: shared hit=53651
4. 787.236 1,936.965 ↑ 7.4 28,366 3

Hash Join (cost=3.11..71,361.07 rows=210,961 width=55) (actual time=106.622..645.655 rows=28,366 loops=3)

  • Hash Cond: (ip.cidrid = cidr.id)
  • Buffers: shared hit=53589
5. 1,149.567 1,149.567 ↑ 1.6 356,552 3

Parallel Seq Scan on conrepo_apnip ip (cost=0.00..66,099.45 rows=558,426 width=31) (actual time=0.158..383.189 rows=356,552 loops=3)

  • Filter: ((NOT reserved) AND (NOT allocated))
  • Rows Removed by Filter: 649069
  • Buffers: shared hit=53529
6. 0.036 0.162 ↑ 1.0 17 3

Hash (cost=2.90..2.90 rows=17 width=8) (actual time=0.054..0.054 rows=17 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=6
7. 0.036 0.126 ↑ 1.0 17 3

Nested Loop (cost=0.00..2.90 rows=17 width=8) (actual time=0.020..0.042 rows=17 loops=3)

  • Buffers: shared hit=6
8. 0.042 0.042 ↑ 1.0 1 3

Seq Scan on conrepo_apn apn (cost=0.00..1.16 rows=1 width=8) (actual time=0.012..0.014 rows=1 loops=3)

  • Filter: (enabled AND (id = 5))
  • Rows Removed by Filter: 12
  • Buffers: shared hit=3
9. 0.048 0.048 ↑ 1.0 17 3

Seq Scan on conrepo_apncidr cidr (cost=0.00..1.56 rows=17 width=16) (actual time=0.007..0.016 rows=17 loops=3)

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