explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9U2hH

Settings
# exclusive inclusive rows x rows loops node
1. 46.197 125.471 ↓ 1.0 33,199 1

Gather (cost=3,773.00..17,689.99 rows=31,882 width=24) (actual time=40.758..125.471 rows=33,199 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 5.718 79.274 ↑ 1.2 11,066 3 / 3

Hash Join (cost=2,773.00..13,501.79 rows=13,284 width=24) (actual time=39.945..79.274 rows=11,066 loops=3)

  • Hash Cond: (b.smpid = a.smpid)
3. 34.254 34.254 ↑ 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.114..34.254 rows=11,067 loops=3)

  • Filter: (channelid = 2)
  • Rows Removed by Filter: 238,400
4. 15.991 39.302 ↓ 1.0 67,401 3 / 3

Hash (cost=1,930.50..1,930.50 rows=67,400 width=16) (actual time=39.301..39.302 rows=67,401 loops=3)

  • Buckets: 131,072 Batches: 1 Memory Usage: 4,184kB
5. 23.311 23.311 ↓ 1.0 67,401 3 / 3

Seq Scan on mesreg a (cost=0.00..1,930.50 rows=67,400 width=16) (actual time=0.137..23.311 rows=67,401 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[])))
  • Rows Removed by Filter: 1