explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j1iH : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #boIY; plan #On9C; plan #Vhki; plan #IRtl; plan #u1Ze; plan #uvcn

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 2,258.606 3,102.117 ↓ 2.0 10,706,017 1

Hash Join (cost=33.15..285,113.15 rows=5,382,975 width=77) (actual time=0.244..3,102.117 rows=10,706,017 loops=1)

  • Hash Cond: (conspecsensordata.csd_cs_id = conspecsensors.cs_id)
2. 843.286 843.286 ↑ 1.0 10,958,118 1

Seq Scan on conspecsensordata (cost=0.00..190,157.00 rows=10,958,200 width=20) (actual time=0.012..843.286 rows=10,958,118 loops=1)

3. 0.007 0.225 ↑ 1.1 26 1

Hash (cost=32.80..32.80 rows=28 width=65) (actual time=0.225..0.225 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
4. 0.013 0.218 ↑ 1.1 26 1

Nested Loop (cost=4.40..32.80 rows=28 width=65) (actual time=0.106..0.218 rows=26 loops=1)

5. 0.003 0.177 ↑ 1.0 28 1

Nested Loop (cost=4.26..23.10 rows=28 width=65) (actual time=0.103..0.177 rows=28 loops=1)

6. 0.010 0.146 ↑ 1.0 28 1

Hash Join (cost=4.12..17.58 rows=28 width=22) (actual time=0.099..0.146 rows=28 loops=1)

  • Hash Cond: (conspecsensors.cs_cmt_id = conspecmonitortypes.cmt_id)
7. 0.053 0.121 ↑ 1.0 57 1

Hash Join (cost=2.28..15.59 rows=57 width=16) (actual time=0.065..0.121 rows=57 loops=1)

  • Hash Cond: (ports.p_id = conspecsensors.cs_p_id)
8. 0.052 0.052 ↑ 1.0 578 1

Seq Scan on ports (cost=0.00..11.78 rows=578 width=12) (actual time=0.004..0.052 rows=578 loops=1)

9. 0.007 0.016 ↑ 1.0 57 1

Hash (cost=1.57..1.57 rows=57 width=12) (actual time=0.016..0.016 rows=57 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
10. 0.009 0.009 ↑ 1.0 57 1

Seq Scan on conspecsensors (cost=0.00..1.57 rows=57 width=12) (actual time=0.003..0.009 rows=57 loops=1)

11. 0.007 0.015 ↑ 1.0 37 1

Hash (cost=1.37..1.37 rows=37 width=14) (actual time=0.015..0.015 rows=37 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
12. 0.008 0.008 ↑ 1.0 37 1

Seq Scan on conspecmonitortypes (cost=0.00..1.37 rows=37 width=14) (actual time=0.004..0.008 rows=37 loops=1)

13. 0.028 0.028 ↑ 1.0 1 28

Index Scan using nodeslogical_pkey on nodeslogical (cost=0.14..0.20 rows=1 width=51) (actual time=0.001..0.001 rows=1 loops=28)

  • Index Cond: (nl_id = ports.p_nl_id)
14. 0.028 0.028 ↑ 1.0 1 28

Index Scan using nodesphysical_pkey on nodesphysical (cost=0.14..0.35 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=28)

  • Index Cond: (np_id = nodeslogical.nl_np_id)
Planning time : 0.875 ms