explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tPx6

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.027 ↑ 1.0 17 1

Nested Loop (cost=0.00..2.90 rows=17 width=8) (actual time=0.014..0.027 rows=17 loops=1)

  • Buffers: shared hit=2
2. 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.008..0.010 rows=1 loops=1)

  • Filter: (enabled AND (id = 5))
  • Rows Removed by Filter: 12
  • Buffers: shared hit=1
3. 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