explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cIAJ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=94.70..103.61 rows=1 width=51) (actual rows= loops=)

  • Hash Cond: ((id.isin_update_id = iu.id) AND (id.isin = id_1.isin))
2. 0.000 0.000 ↓ 0.0

Seq Scan on isin_data id (cost=0.00..6.80 rows=280 width=51) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=89.57..89.57 rows=342 width=17) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=50.72..89.57 rows=342 width=17) (actual rows= loops=)

  • Hash Cond: (iu.price_date = (max(iu_1.price_date)))
5. 0.000 0.000 ↓ 0.0

Seq Scan on isin_update iu (cost=0.00..28.50 rows=1,850 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=50.25..50.25 rows=37 width=17) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

HashAggregate (cost=49.51..49.88 rows=37 width=17) (actual rows= loops=)

  • Group Key: id_1.isin
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=40.84..49.33 rows=37 width=17) (actual rows= loops=)

  • Hash Cond: (id_1.isin_update_id = iu_1.id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on isin_data id_1 (cost=0.00..8.20 rows=111 width=17) (actual rows= loops=)

  • Filter: ((valid_from <= '2020-09-01'::date) AND (valid_to > '2020-09-01'::date))
10. 0.000 0.000 ↓ 0.0

Hash (cost=33.13..33.13 rows=617 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on isin_update iu_1 (cost=0.00..33.13 rows=617 width=8) (actual rows= loops=)

  • Filter: (price_date < '2020-09-01'::date)