explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G8rn

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 102.919 284,549.279 ↓ 4.1 104,311 1

Finalize GroupAggregate (cost=1,147,016.26..1,149,543.59 rows=25,213 width=74) (actual time=280,624.235..284,549.279 rows=104,311 loops=1)

  • Group Key: site, link, as_id, utm_content
2. 773.450 284,446.360 ↓ 9.8 148,503 1

Gather Merge (cost=1,147,016.26..1,149,101.86 rows=15,168 width=74) (actual time=280,613.515..284,446.360 rows=148,503 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 709.697 283,672.910 ↓ 4.9 74,252 2 / 2

Partial GroupAggregate (cost=1,146,016.25..1,146,395.45 rows=15,168 width=74) (actual time=280,534.577..283,672.910 rows=74,252 loops=2)

  • Group Key: site, link, as_id, utm_content
4. 16,072.095 282,963.213 ↓ 99.5 1,509,137 2 / 2

Sort (cost=1,146,016.25..1,146,054.17 rows=15,168 width=66) (actual time=280,527.473..282,963.213 rows=1,509,137 loops=2)

  • Sort Key: site, link, as_id, utm_content
  • Sort Method: external merge Disk: 93,128kB
  • Worker 0: Sort Method: external merge Disk: 94,360kB
5. 266,891.118 266,891.118 ↓ 99.5 1,509,137 2 / 2

Parallel Seq Scan on session_counter_normalized (cost=0.00..1,144,962.93 rows=15,168 width=66) (actual time=1.202..266,891.118 rows=1,509,137 loops=2)

  • Filter: ((""timestamp"")::date = (CURRENT_DATE - '1 day'::interval))
  • Rows Removed by Filter: 1,069,462