explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BNup : Optimization for: plan #Jeno

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.002 ↓ 0.0 0 1

Insert on conspecsensordata (cost=12.58..12.58 rows=0 width=0) (actual time=0.002..0.002 rows=0 loops=1)

2.          

CTE conspec_target_sensor

3. 0.000 0.026 ↑ 1.0 1 1

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

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

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

  • Join Filter: (nodeslogical.nl_np_id = nodesphysical.np_id)
5. 0.001 0.008 ↑ 1.0 1 1

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

  • Join Filter: (ports.p_nl_id = nodeslogical.nl_id)
6. 0.005 0.005 ↑ 1.0 1 1

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

  • Filter: ((p_pc_code = 'CONSPEC'::text) AND (p_nodeportindex = 1))
  • Rows Removed by Filter: 5
7. 0.002 0.002 ↑ 3.0 1 1

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

8. 0.004 0.014 ↑ 1.0 1 1

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

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

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

  • Index Cond: ((np_networkaddress)::text = '3C32'::text)
10. 0.002 0.002 ↑ 2.0 3 1

Seq Scan on conspecsensors (cost=0.00..1.06 rows=6 width=8) (actual time=0.001..0.002 rows=3 loops=1)

11.          

CTE update_calibration

12. 0.017 0.075 ↓ 0.0 0 1

Update on conspecsensors conspecsensors_1 (cost=0.03..1.13 rows=1 width=186) (actual time=0.075..0.075 rows=0 loops=1)

13. 0.013 0.058 ↑ 1.0 1 1

Hash Join (cost=0.03..1.13 rows=1 width=186) (actual time=0.057..0.058 rows=1 loops=1)

  • Hash Cond: (conspecsensors_1.cs_id = cts.cts_id)
14. 0.008 0.008 ↑ 1.0 6 1

Seq Scan on conspecsensors conspecsensors_1 (cost=0.00..1.06 rows=6 width=154) (actual time=0.006..0.008 rows=6 loops=1)

15. 0.003 0.037 ↑ 1.0 1 1

Hash (cost=0.02..0.02 rows=1 width=32) (actual time=0.037..0.037 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
16. 0.034 0.034 ↑ 1.0 1 1

CTE Scan on conspec_target_sensor cts (cost=0.00..0.02 rows=1 width=32) (actual time=0.033..0.034 rows=1 loops=1)

17. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=28) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
Planning time : 0.565 ms