explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OnRt

Settings
# exclusive inclusive rows x rows loops node
1. 76.481 138.178 ↓ 2.1 33,199 1

Gather (cost=3,512.64..15,806.72 rows=15,653 width=24) (actual time=30.896..138.178 rows=33,199 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 4.680 61.697 ↓ 1.7 11,066 3 / 3

Hash Join (cost=2,512.64..13,241.42 rows=6,522 width=24) (actual time=27.788..61.697 rows=11,066 loops=3)

  • Hash Cond: (b.smpid = mesreg.smpid)
3. 29.930 29.930 ↑ 1.2 11,067 3 / 3

Parallel Seq Scan on mesval b (cost=0.00..10,693.92 rows=13,284 width=16) (actual time=0.326..29.930 rows=11,067 loops=3)

  • Filter: (channelid = 2)
  • Rows Removed by Filter: 238,400
4. 7.419 27.087 ↓ 1.0 33,199 3 / 3

Hash (cost=2,099.00..2,099.00 rows=33,091 width=16) (actual time=27.087..27.087 rows=33,199 loops=3)

  • Buckets: 65,536 Batches: 1 Memory Usage: 2,069kB
5. 19.668 19.668 ↓ 1.0 33,199 3 / 3

Seq Scan on mesreg (cost=0.00..2,099.00 rows=33,091 width=16) (actual time=0.324..19.668 rows=33,199 loops=3)

  • Filter: ((smpdate >= '2000-01-01 00:00:00+01'::timestamp with time zone) AND (smpdate <= '2020-08-01 00:00:00+02'::timestamp with time zone) AND ((paramtype)::text = ANY ('{FIL,UPL}'::text[])) AND (stationid = 4))
  • Rows Removed by Filter: 34,203