explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xebs

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 125.827 ↑ 1.0 1 1

Aggregate (cost=17,317.64..17,317.65 rows=1 width=40) (actual time=125.827..125.827 rows=1 loops=1)

2. 0.006 125.797 ↑ 28.6 35 1

Limit (cost=17,300.14..17,302.64 rows=1,000 width=72) (actual time=125.787..125.797 rows=35 loops=1)

3. 0.028 125.791 ↑ 461.2 35 1

Sort (cost=17,300.14..17,340.49 rows=16,143 width=72) (actual time=125.786..125.791 rows=35 loops=1)

  • Sort Key: p.compdate
  • Sort Method: quicksort Memory: 27kB
4. 0.090 125.763 ↑ 461.2 35 1

Subquery Scan on p (cost=15,890.39..16,415.03 rows=16,143 width=72) (actual time=125.472..125.763 rows=35 loops=1)

5. 0.000 125.673 ↑ 461.2 35 1

Finalize HashAggregate (cost=15,890.39..16,132.53 rows=16,143 width=52) (actual time=125.445..125.673 rows=35 loops=1)

  • Group Key: b.channelid, (to_char(a.smpdate, 'YYYY-WW'::text))
6. 73.981 150.479 ↑ 213.5 63 1

Gather (cost=14,326.59..15,755.87 rows=13,452 width=76) (actual time=124.282..150.479 rows=63 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 4.205 76.498 ↑ 320.3 21 3 / 3

Partial HashAggregate (cost=13,326.59..13,410.67 rows=6,726 width=76) (actual time=76.443..76.498 rows=21 loops=3)

  • Group Key: b.channelid, to_char(a.smpdate, 'YYYY-WW'::text)
8. 11.262 72.293 ↓ 1.6 11,066 3 / 3

Hash Join (cost=2,512.64..13,259.33 rows=6,726 width=52) (actual time=29.593..72.293 rows=11,066 loops=3)

  • Hash Cond: (b.smpid = a.smpid)
9. 31.967 31.967 ↑ 1.2 11,067 3 / 3

Parallel Seq Scan on mesval b (cost=0.00..10,693.92 rows=13,700 width=20) (actual time=0.110..31.967 rows=11,067 loops=3)

  • Filter: (channelid = 5)
  • Rows Removed by Filter: 238,400
10. 7.180 29.064 ↓ 1.0 33,199 3 / 3

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

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

Seq Scan on mesreg a (cost=0.00..2,099.00 rows=33,091 width=16) (actual time=0.480..21.884 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