explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JKIe

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=3,360,002.69..3,620,268.78 rows=1,530,977 width=28) (actual rows= loops=)

  • Group Key: dataset_id, merchant_id, cohort_id
  • Filter: (max(transaction_date) < ((now() - '30 days'::interval))::date)
2. 0.000 0.000 ↓ 0.0

Sort (cost=3,360,002.69..3,398,277.11 rows=15,309,770 width=28) (actual rows= loops=)

  • Sort Key: dataset_id, merchant_id, cohort_id
3. 0.000 0.000 ↓ 0.0

Seq Scan on tbl_merchant_forcasted_index (cost=0.00..800,339.62 rows=15,309,770 width=28) (actual rows= loops=)

  • Filter: (NOT is_forcasted)