explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 3,893.846 4,399.786 ↓ 1.3 867,045 1

Hash Join (cost=4.16..194,381.50 rows=685,966 width=58) (actual time=0.147..4,399.786 rows=867,045 loops=1)

  • Hash Cond: (conspecsensors.cs_cmt_id = conspecmonitortypes.cmt_id)
2. 377.577 505.915 ↑ 1.0 919,818 1

Hash Join (cost=2.33..18,552.47 rows=919,818 width=20) (actual time=0.043..505.915 rows=919,818 loops=1)

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

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

4. 0.010 0.025 ↑ 1.0 59 1

Hash (cost=1.59..1.59 rows=59 width=8) (actual time=0.025..0.025 rows=59 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
5. 0.015 0.015 ↑ 1.0 59 1

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

6. 0.010 0.025 ↑ 1.0 37 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
7. 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)