explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L6OT : Optimization for: plan #vzGM

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 65.734 141,944.667 ↓ 3.4 85,033 1

Finalize GroupAggregate (cost=1,147,016.26..1,149,467.75 rows=25,213 width=61) (actual time=139,092.567..141,944.667 rows=85,033 loops=1)

  • Group Key: site, link, as_id
2. 341.053 141,878.933 ↓ 8.3 126,095 1

Gather Merge (cost=1,147,016.26..1,149,063.94 rows=15,168 width=61) (actual time=139,092.556..141,878.933 rows=126,095 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 638.195 141,537.880 ↓ 4.2 63,048 2 / 2

Partial GroupAggregate (cost=1,146,016.25..1,146,357.53 rows=15,168 width=61) (actual time=139,064.100..141,537.880 rows=63,048 loops=2)

  • Group Key: site, link, as_id
4. 10,155.789 140,899.685 ↓ 99.5 1,509,137 2 / 2

Sort (cost=1,146,016.25..1,146,054.17 rows=15,168 width=53) (actual time=139,063.732..140,899.685 rows=1,509,137 loops=2)

  • Sort Key: site, link, as_id
  • Sort Method: external merge Disk: 92,480kB
  • Worker 0: Sort Method: external merge Disk: 92,688kB
5. 130,743.896 130,743.896 ↓ 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=53) (actual time=178.970..130,743.896 rows=1,509,137 loops=2)

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