explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N1Tq

Settings
# exclusive inclusive rows x rows loops node
1. 68.289 122.919 ↓ 1.9 72,555 1

Gather (cost=1,444.73..16,143.36 rows=37,657 width=66) (actual time=84.258..122.919 rows=72,555 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 26.698 54.630 ↓ 1.5 24,185 3 / 3

Hash Join (cost=444.73..11,377.66 rows=15,690 width=66) (actual time=44.581..54.630 rows=24,185 loops=3)

  • Hash Cond: (b.smpid = a.smpid)
3. 24.615 24.615 ↑ 1.3 249,467 3 / 3

Parallel Seq Scan on mesval b (cost=0.00..9,917.39 rows=312,139 width=20) (actual time=0.014..24.615 rows=249,467 loops=3)

4. 0.595 3.317 ↓ 1.0 3,455 3 / 3

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 248kB
5. 2.722 2.722 ↓ 1.0 3,455 3 / 3

Index Scan using index_mesreg_2 on mesreg a (cost=0.29..402.38 rows=3,388 width=26) (actual time=0.061..2.722 rows=3,455 loops=3)

  • 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