explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vhki : Optimization for: Optimization for: plan #boIY; plan #On9C

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 4,008.912 4,879.103 ↓ 1.3 867,045 1

Hash Join (cost=91.61..196,272.31 rows=685,966 width=62) (actual time=1.087..4,879.103 rows=867,045 loops=1)

  • Hash Cond: (conspecsensors.cs_p_id = ports.p_id)
2. 294.836 869.268 ↓ 1.3 867,045 1

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

  • Hash Cond: (conspecsensors.cs_cmt_id = conspecmonitortypes.cmt_id)
3. 406.011 574.406 ↑ 1.0 919,818 1

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

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

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

5. 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
6. 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)

7. 0.010 0.026 ↑ 1.0 37 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
8. 0.016 0.016 ↑ 1.0 37 1

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

9. 0.404 0.923 ↑ 1.0 2,820 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 134kB
10. 0.519 0.519 ↑ 1.0 2,820 1

Seq Scan on ports (cost=0.00..52.20 rows=2,820 width=8) (actual time=0.007..0.519 rows=2,820 loops=1)