explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 3,718.993 4,312.017 ↓ 1.3 857,829 1

Merge Join (cost=1,119.35..196,428.57 rows=685,966 width=96) (actual time=3.178..4,312.017 rows=857,829 loops=1)

  • Merge Cond: (nodeslogical.nl_np_id = nodesphysical.np_id)
2. 208.028 589.975 ↓ 1.3 857,830 1

Nested Loop (cost=1.13..63,737.75 rows=685,966 width=64) (actual time=0.210..589.975 rows=857,830 loops=1)

3. 1.714 23.523 ↑ 1.0 44 1

Nested Loop (cost=0.71..3,948.23 rows=44 width=52) (actual time=0.153..23.523 rows=44 loops=1)

  • Join Filter: (conspecsensors.cs_cmt_id = conspecmonitortypes.cmt_id)
  • Rows Removed by Join Filter: 822
4. 0.000 21.691 ↑ 1.0 59 1

Nested Loop (cost=0.71..3,914.54 rows=59 width=46) (actual time=0.129..21.691 rows=59 loops=1)

5. 0.000 19.284 ↑ 1.0 2,819 1

Nested Loop (cost=0.57..3,458.41 rows=2,820 width=42) (actual time=0.035..19.284 rows=2,819 loops=1)

6. 2.780 2.780 ↑ 1.0 8,872 1

Index Scan using nl_fk_nodesphysical on nodeslogical (cost=0.29..592.43 rows=8,878 width=38) (actual time=0.007..2.780 rows=8,872 loops=1)

7. 17.744 17.744 ↓ 0.0 0 8,872

Index Scan using p_index_enabled on ports (cost=0.28..0.31 rows=1 width=12) (actual time=0.001..0.002 rows=0 loops=8,872)

  • Index Cond: (p_nl_id = nodeslogical.nl_id)
8. 2.819 2.819 ↓ 0.0 0 2,819

Index Scan using conspecsensors_cs_p_id_key on conspecsensors (cost=0.14..0.16 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=2,819)

  • Index Cond: (cs_p_id = ports.p_id)
9. 0.104 0.118 ↑ 2.5 15 59

Materialize (cost=0.00..1.56 rows=37 width=14) (actual time=0.001..0.002 rows=15 loops=59)

10. 0.014 0.014 ↑ 1.0 37 1

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

11. 358.424 358.424 ↑ 1.3 19,496 44

Index Scan using csd_unique_row on conspecsensordata (cost=0.42..1,096.04 rows=26,281 width=20) (actual time=0.012..8.146 rows=19,496 loops=44)

  • Index Cond: (csd_cs_id = conspecsensors.cs_id)
12. 1.266 3.049 ↑ 1.5 1,798 1

Sort (cost=1,118.22..1,125.01 rows=2,718 width=8) (actual time=2.806..3.049 rows=1,798 loops=1)

  • Sort Key: nodesphysical.np_id
  • Sort Method: quicksort Memory: 224kB
13. 1.783 1.783 ↑ 1.0 2,718 1

Seq Scan on nodesphysical (cost=0.00..963.18 rows=2,718 width=8) (actual time=0.006..1.783 rows=2,718 loops=1)

Planning time : 3.342 ms