explain.depesz.com

PostgreSQL's explain analyze made readable

Result: On9C : Optimization for: plan #boIY

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 3,901.007 5,047.559 ↓ 1.3 867,045 1

Hash Join (cost=390.37..198,372.58 rows=685,966 width=92) (actual time=4.854..5,047.559 rows=867,045 loops=1)

  • Hash Cond: (ports.p_nl_id = nodeslogical.nl_id)
2. 290.369 1,142.875 ↓ 1.3 867,045 1

Hash Join (cost=91.61..23,065.89 rows=685,966 width=34) (actual time=1.092..1,142.875 rows=867,045 loops=1)

  • Hash Cond: (conspecsensors.cs_p_id = ports.p_id)
3. 302.927 851.503 ↓ 1.3 867,045 1

Hash Join (cost=4.16..21,175.08 rows=685,966 width=30) (actual time=0.082..851.503 rows=867,045 loops=1)

  • Hash Cond: (conspecsensors.cs_cmt_id = conspecmonitortypes.cmt_id)
4. 381.372 548.553 ↑ 1.0 919,818 1

Hash Join (cost=2.33..18,552.47 rows=919,818 width=24) (actual time=0.044..548.553 rows=919,818 loops=1)

  • Hash Cond: (conspecsensordata.csd_cs_id = conspecsensors.cs_id)
5. 167.154 167.154 ↑ 1.0 919,818 1

Seq Scan on conspecsensordata (cost=0.00..15,962.18 rows=919,818 width=20) (actual time=0.006..167.154 rows=919,818 loops=1)

6. 0.011 0.027 ↑ 1.0 59 1

Hash (cost=1.59..1.59 rows=59 width=12) (actual time=0.027..0.027 rows=59 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
7. 0.016 0.016 ↑ 1.0 59 1

Seq Scan on conspecsensors (cost=0.00..1.59 rows=59 width=12) (actual time=0.005..0.016 rows=59 loops=1)

8. 0.008 0.023 ↑ 1.0 37 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
9. 0.015 0.015 ↑ 1.0 37 1

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

10. 0.479 1.003 ↑ 1.0 2,820 1

Hash (cost=52.20..52.20 rows=2,820 width=12) (actual time=1.003..1.003 rows=2,820 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 145kB
11. 0.524 0.524 ↑ 1.0 2,820 1

Seq Scan on ports (cost=0.00..52.20 rows=2,820 width=12) (actual time=0.006..0.524 rows=2,820 loops=1)

12. 1.812 3.677 ↑ 1.0 8,878 1

Hash (cost=187.78..187.78 rows=8,878 width=34) (actual time=3.677..3.677 rows=8,878 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 563kB
13. 1.865 1.865 ↑ 1.0 8,878 1

Seq Scan on nodeslogical (cost=0.00..187.78 rows=8,878 width=34) (actual time=0.009..1.865 rows=8,878 loops=1)