explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KEVlv

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 62,178.748 ↑ 41.5 29 1

Finalize GroupAggregate (cost=57,821.70..57,965.43 rows=1,204 width=153) (actual time=62,178.613..62,178.748 rows=29 loops=1)

  • Group Key: ga_campaign_creative.date, ga_campaign_creative.campaign, ga_campaign_creative.keyword, ga_campaign_creative.dimension21
2.          

Initplan (for Finalize GroupAggregate)

3. 0.006 617.400 ↑ 1.0 1 1

Result (cost=0.60..0.61 rows=1 width=4) (actual time=617.399..617.400 rows=1 loops=1)

4.          

Initplan (for Result)

5. 0.002 617.394 ↑ 1.0 1 1

Limit (cost=0.57..0.60 rows=1 width=4) (actual time=617.393..617.394 rows=1 loops=1)

6. 617.392 617.392 ↑ 284,417,255.0 1 1

Index Only Scan Backward using idx_22424699_date on ga_campaign_creative ga_campaign_creative_1 (cost=0.57..8,566,925.00 rows=284,417,255 width=4) (actual time=617.391..617.392 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 125,421
7. 623.930 62,180.864 ↑ 24.4 29 1

Gather Merge (cost=57,821.09..57,930.83 rows=708 width=153) (actual time=62,178.591..62,180.864 rows=29 loops=1)

  • Workers Planned: 1
  • Params Evaluated: $1
  • Workers Launched: 1
8. 0.071 61,556.934 ↑ 50.6 14 2 / 2

Partial GroupAggregate (cost=56,821.08..56,851.17 rows=708 width=153) (actual time=61,556.878..61,556.934 rows=14 loops=2)

  • Group Key: ga_campaign_creative.date, ga_campaign_creative.campaign, ga_campaign_creative.keyword, ga_campaign_creative.dimension21
9. 0.118 61,556.863 ↑ 8.4 84 2 / 2

Sort (cost=56,821.08..56,822.85 rows=708 width=129) (actual time=61,556.856..61,556.863 rows=84 loops=2)

  • Sort Key: ga_campaign_creative.campaign, ga_campaign_creative.keyword, ga_campaign_creative.dimension21
  • Sort Method: quicksort Memory: 62kB
  • Worker 0: Sort Method: quicksort Memory: 32kB
10. 1.112 61,556.745 ↑ 8.4 84 2 / 2

Parallel Hash Semi Join (cost=35,720.66..56,787.56 rows=708 width=129) (actual time=738.856..61,556.745 rows=84 loops=2)

  • Hash Cond: (ga_campaign_creative.dimension21 = regexp_replace((as_parameters.asparam)::text, '^.*='::text, ''::text))
11. 60,924.866 60,924.866 ↓ 4.3 6,140 2 / 2

Parallel Index Scan using idx_22424699_date on ga_campaign_creative (cost=0.58..19,191.11 rows=1,416 width=129) (actual time=43.863..60,924.866 rows=6,140 loops=2)

  • Index Cond: (date = (($1 - '5 days'::interval))::date)
  • Filter: ((""left""(campaign, 1) <> '('::text) AND ((""left""(dimension21, 3) = '202'::text) OR (""left""(dimension21, 3) = '203'::text)))
  • Rows Removed by Filter: 135,588
12. 26.452 630.767 ↑ 2.1 13,751 2 / 2

Parallel Hash (cost=35,365.41..35,365.41 rows=28,374 width=16) (actual time=630.767..630.767 rows=13,751 loops=2)

  • Buckets: 65,536 Batches: 1 Memory Usage: 2,048kB
13. 604.315 604.315 ↑ 2.1 13,751 2 / 2

Parallel Seq Scan on as_parameters (cost=0.00..35,365.41 rows=28,374 width=16) (actual time=1.157..604.315 rows=13,751 loops=2)

  • Filter: (((campaign)::text ~~ '%NLaunch%'::text) OR ((campaign)::text ~~ '%_G1%'::text))
  • Rows Removed by Filter: 585,109
Planning time : 24.645 ms