explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r4EQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.119 103,150.997 ↓ 44.3 1,153 1

Finalize GroupAggregate (cost=222,691.32..222,693.68 rows=26 width=31) (actual time=103,145.696..103,150.997 rows=1,153 loops=1)

  • Group Key: date, dimension21
2. 5.776 103,150.878 ↓ 84.1 1,261 1

Gather Merge (cost=222,691.32..222,693.31 rows=15 width=31) (actual time=103,145.678..103,150.878 rows=1,261 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 3.006 103,145.102 ↓ 42.0 630 2 / 2

Partial GroupAggregate (cost=221,691.31..221,691.61 rows=15 width=31) (actual time=103,141.075..103,145.102 rows=630 loops=2)

  • Group Key: date, dimension21
4. 13.812 103,142.096 ↓ 825.5 12,383 2 / 2

Sort (cost=221,691.31..221,691.35 rows=15 width=31) (actual time=103,141.062..103,142.096 rows=12,383 loops=2)

  • Sort Key: date, dimension21
  • Sort Method: quicksort Memory: 1,397kB
  • Worker 0: Sort Method: quicksort Memory: 1,305kB
5. 103,128.284 103,128.284 ↓ 825.5 12,383 2 / 2

Parallel Index Scan using idx_17910449_timestamp on ga_gemini_tag (cost=0.57..221,691.02 rows=15 width=31) (actual time=3,367.030..103,128.284 rows=12,383 loops=2)

  • Index Cond: (""timestamp"" >= '2020-08-18 00:00:00'::timestamp without time zone)
  • Filter: ((date >= '2020-08-18'::date) AND (dimension21 ~~ '211%%'::text))
  • Rows Removed by Filter: 2,494,771
Planning time : 2.034 ms