explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mNdD

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

GroupAggregate (cost=1,251,583.63..1,259,532.38 rows=176,639 width=265) (actual rows= loops=)

  • Group Key: pv.tunnus, pv.tr_numero, pv.nimi, ts.talvisuolaraja
2. 0.000 0.000 ↓ 0.0

Sort (cost=1,251,583.63..1,252,025.22 rows=176,639 width=265) (actual rows= loops=)

  • Sort Key: pv.tunnus, pv.tr_numero, pv.nimi, ts.talvisuolaraja
3. 0.000 0.000 ↓ 0.0

Merge Join (cost=1,233,560.66..1,236,189.14 rows=176,639 width=265) (actual rows= loops=)

  • Merge Cond: ((pv.tunnus)::text = (rp.pohjavesialue)::text)
4. 0.000 0.000 ↓ 0.0

Sort (cost=9,454.55..9,609.27 rows=61,890 width=227) (actual rows= loops=)

  • Sort Key: pv.tunnus
5. 0.000 0.000 ↓ 0.0

Seq Scan on pohjavesialue pv (cost=0.00..4,528.90 rows=61,890 width=227) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Materialize (cost=1,224,106.02..1,224,500.41 rows=36,589 width=46) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=1,224,106.02..1,224,408.94 rows=36,589 width=46) (actual rows= loops=)

  • Merge Cond: ((rp.pohjavesialue)::text = (ts.pohjavesialue)::text)
8. 0.000 0.000 ↓ 0.0

Sort (cost=1,224,055.94..1,224,147.41 rows=36,589 width=14) (actual rows= loops=)

  • Sort Key: rp.pohjavesialue
9. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,154,939.88..1,221,282.66 rows=36,589 width=14) (actual rows= loops=)

  • Hash Cond: (rp.toteuma = tot.id)
10. 0.000 0.000 ↓ 0.0

Seq Scan on suolatoteuma_reittipiste rp (cost=0.00..60,391.76 rows=1,489,368 width=18) (actual rows= loops=)

  • Filter: ((aika >= '2018-12-01 00:00:00'::timestamp without time zone) AND (aika < '2019-01-01 00:00:00'::timestamp without time zone))
11. 0.000 0.000 ↓ 0.0

Hash (cost=1,148,908.13..1,148,908.13 rows=482,540 width=4) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on toteuma tot (cost=16,652.25..1,148,908.13 rows=482,540 width=4) (actual rows= loops=)

  • Recheck Cond: (urakka = 270)
13. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on toteuma_urakka_idx (cost=0.00..16,531.61 rows=482,540 width=0) (actual rows= loops=)

  • Index Cond: (urakka = 270)
14. 0.000 0.000 ↓ 0.0

Sort (cost=50.08..51.83 rows=700 width=82) (actual rows= loops=)

  • Sort Key: ts.pohjavesialue
15. 0.000 0.000 ↓ 0.0

Seq Scan on pohjavesialue_talvisuola ts (cost=0.00..17.00 rows=700 width=82) (actual rows= loops=)