explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vUdtO

Settings
# exclusive inclusive rows x rows loops node
1. 1.865 158.981 ↓ 1.0 3,455 1

Sort (cost=20,777.98..20,786.45 rows=3,388 width=187) (actual time=158.774..158.981 rows=3,455 loops=1)

  • Sort Key: a.smpdate
  • Sort Method: quicksort Memory: 1,014kB
2. 35.736 157.116 ↓ 1.0 3,455 1

HashAggregate (cost=20,545.45..20,579.33 rows=3,388 width=187) (actual time=154.876..157.116 rows=3,455 loops=1)

  • Group Key: a.smpid
3. 66.117 121.380 ↓ 1.9 72,555 1

Hash Right Join (cost=444.73..16,689.40 rows=37,620 width=39) (actual time=101.173..121.380 rows=72,555 loops=1)

  • Hash Cond: (b.smpid = a.smpid)
4. 52.628 52.628 ↑ 1.0 748,400 1

Seq Scan on mesval b (cost=0.00..14,280.00 rows=748,400 width=20) (actual time=0.019..52.628 rows=748,400 loops=1)

5. 0.542 2.635 ↓ 1.0 3,455 1

Hash (cost=402.38..402.38 rows=3,388 width=27) (actual time=2.635..2.635 rows=3,455 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 252kB
6. 2.093 2.093 ↓ 1.0 3,455 1

Index Scan using index_mesreg_2 on mesreg a (cost=0.29..402.38 rows=3,388 width=27) (actual time=0.016..2.093 rows=3,455 loops=1)

  • Index Cond: ((smpdate >= '2020-06-01 00:00:00+02'::timestamp with time zone) AND (smpdate <= '2020-06-30 00:00:00+02'::timestamp with time zone))
  • Filter: (((paramtype)::text = ANY ('{FIL,UPL}'::text[])) AND (stationid = 4))
  • Rows Removed by Filter: 3,457