explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jeno

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 0.044 ↑ 1.0 1 1

Nested Loop (cost=4.14..11.46 rows=1 width=4) (actual time=0.042..0.044 rows=1 loops=1)

  • Join Filter: (ports.p_id = conspecsensors.cs_p_id)
  • Rows Removed by Join Filter: 4
2. 0.002 0.036 ↑ 1.0 1 1

Nested Loop (cost=4.14..10.32 rows=1 width=4) (actual time=0.035..0.036 rows=1 loops=1)

  • Join Filter: (nodeslogical.nl_np_id = nodesphysical.np_id)
3. 0.002 0.014 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.16 rows=1 width=8) (actual time=0.013..0.014 rows=1 loops=1)

  • Join Filter: (ports.p_nl_id = nodeslogical.nl_id)
  • Rows Removed by Join Filter: 2
4. 0.009 0.009 ↑ 1.0 1 1

Seq Scan on ports (cost=0.00..1.09 rows=1 width=8) (actual time=0.008..0.009 rows=1 loops=1)

  • Filter: ((p_pc_code = 'CONSPEC'::text) AND (p_nodeportindex = 1))
  • Rows Removed by Filter: 5
5. 0.003 0.003 ↑ 1.0 3 1

Seq Scan on nodeslogical (cost=0.00..1.03 rows=3 width=8) (actual time=0.003..0.003 rows=3 loops=1)

6. 0.006 0.020 ↑ 1.0 1 1

Bitmap Heap Scan on nodesphysical (cost=4.14..8.15 rows=1 width=4) (actual time=0.020..0.020 rows=1 loops=1)

  • Recheck Cond: ((np_networkaddress)::text = '3C32'::text)
  • Heap Blocks: exact=2
7. 0.014 0.014 ↓ 2.0 2 1

Bitmap Index Scan on nodesphysical_np_networkaddress_key (cost=0.00..4.14 rows=1 width=0) (actual time=0.014..0.014 rows=2 loops=1)

  • Index Cond: ((np_networkaddress)::text = '3C32'::text)
8. 0.006 0.006 ↑ 1.2 5 1

Seq Scan on conspecsensors (cost=0.00..1.06 rows=6 width=8) (actual time=0.005..0.006 rows=5 loops=1)

Planning time : 0.542 ms