explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vgeS

Settings
# exclusive inclusive rows x rows loops node
1. 43.765 748.423 ↑ 1.1 3,455 1

GroupAggregate (cost=22,254.41..22,357.86 rows=3,762 width=58) (actual time=696.789..748.423 rows=3,455 loops=1)

  • Group Key: mesreg.smpdate, a.smpid, mesreg.alarm, mesreg.received
2. 40.407 704.658 ↓ 19.3 72,555 1

Sort (cost=22,254.41..22,263.81 rows=3,762 width=38) (actual time=696.719..704.658 rows=72,555 loops=1)

  • Sort Key: mesreg.smpdate, a.smpid, mesreg.alarm, mesreg.received
  • Sort Method: quicksort Memory: 8,741kB
3. 77.797 664.251 ↓ 19.3 72,555 1

Hash Join (cost=20,337.73..22,031.00 rows=3,762 width=38) (actual time=410.115..664.251 rows=72,555 loops=1)

  • Hash Cond: (a.smpid = mesreg.smpid)
4. 520.157 583.730 ↓ 10.0 748,400 1

HashAggregate (cost=19,893.00..20,641.40 rows=74,840 width=20) (actual time=407.371..583.730 rows=748,400 loops=1)

  • Group Key: a.smpid, a.channelid
5. 63.573 63.573 ↑ 1.0 748,400 1

Seq Scan on mesval a (cost=0.00..14,280.00 rows=748,400 width=20) (actual time=0.022..63.573 rows=748,400 loops=1)

6. 0.562 2.724 ↓ 1.0 3,455 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 248kB
7. 2.162 2.162 ↓ 1.0 3,455 1

Index Scan using index_mesreg_2 on mesreg (cost=0.29..402.38 rows=3,388 width=26) (actual time=0.020..2.162 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