explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vsIa

Settings
# exclusive inclusive rows x rows loops node
1. 625.773 5,992.439 ↓ 1.3 645,972 1

GroupAggregate (cost=1,099,214.85..1,125,153.15 rows=486,774 width=137) (actual time=4,872.338..5,992.439 rows=645,972 loops=1)

  • Group Key: store_id, date, (split_part(landing_page_path, '?'::text, 1)), product_sku
2. 4,847.573 5,366.666 ↓ 1.5 784,620 1

Sort (cost=1,099,214.85..1,100,538.42 rows=529,430 width=109) (actual time=4,872.323..5,366.666 rows=784,620 loops=1)

  • Sort Key: store_id, date, (split_part(landing_page_path, '?'::text, 1)), product_sku
  • Sort Method: external merge Disk: 98,248kB
3. 463.190 519.093 ↓ 1.5 784,620 1

Bitmap Heap Scan on ga_insights (cost=33,467.64..987,351.72 rows=529,430 width=109) (actual time=60.011..519.093 rows=784,620 loops=1)

  • Recheck Cond: (date > '2020-02-01'::date)
  • Heap Blocks: exact=16,409
4. 55.903 55.903 ↓ 1.5 784,620 1

Bitmap Index Scan on ga_insights_date_index (cost=0.00..33,335.29 rows=529,430 width=0) (actual time=55.903..55.903 rows=784,620 loops=1)

  • Index Cond: (date > '2020-02-01'::date)
Planning time : 0.304 ms
Execution time : 6,046.759 ms