explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xrv9

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 87,494.680 ↓ 2.7 1,153 1

Finalize GroupAggregate (cost=1,653,619.20..1,653,658.30 rows=424 width=31) (actual time=87,488.583..87,494.680 rows=1,153 loops=1)

  • Group Key: date, dimension21
2. 9.276 87,495.610 ↓ 7.0 1,732 1

Gather Merge (cost=1,653,619.20..1,653,652.20 rows=249 width=31) (actual time=87,488.567..87,495.610 rows=1,732 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 3.354 87,486.334 ↓ 3.5 866 2 / 2

Partial GroupAggregate (cost=1,652,619.19..1,652,624.17 rows=249 width=31) (actual time=87,481.852..87,486.334 rows=866 loops=2)

  • Group Key: date, dimension21
4. 15.734 87,482.980 ↓ 49.7 12,383 2 / 2

Sort (cost=1,652,619.19..1,652,619.82 rows=249 width=31) (actual time=87,481.842..87,482.980 rows=12,383 loops=2)

  • Sort Key: date, dimension21
  • Sort Method: quicksort Memory: 1,456kB
  • Worker 0: Sort Method: quicksort Memory: 1,246kB
5. 87,467.246 87,467.246 ↓ 49.7 12,383 2 / 2

Parallel Index Scan using idx_17910449_date on ga_gemini_tag (cost=0.57..1,652,609.28 rows=249 width=31) (actual time=40.624..87,467.246 rows=12,383 loops=2)

  • Index Cond: (date >= '2020-08-18'::date)
  • Filter: (dimension21 ~~ '211%%'::text)
  • Rows Removed by Filter: 2,247,754
Planning time : 0.579 ms