explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tHl

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

WindowAgg (cost=374,496.07..374,496.39 rows=8 width=68) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=374,496.07..374,496.29 rows=8 width=60) (actual rows= loops=)

  • Group Key: d.keyword_id, d.account_id, d.campaign_id, d.ad_group_id
3. 0.000 0.000 ↓ 0.0

Sort (cost=374,496.07..374,496.09 rows=8 width=28) (actual rows= loops=)

  • Sort Key: d.keyword_id, d.account_id, d.campaign_id, d.ad_group_id
4. 0.000 0.000 ↓ 0.0

Subquery Scan on d (cost=374,495.71..374,495.95 rows=8 width=28) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

CTE Scan on data (cost=374,495.71..374,495.87 rows=8 width=60) (actual rows= loops=)

6.          

CTE data

7. 0.000 0.000 ↓ 0.0

Group (cost=374,495.63..374,495.71 rows=8 width=60) (actual rows= loops=)

  • Group Key: d_1.keyword_id, d_1.campaign_id, d_1.ad_group_id
8. 0.000 0.000 ↓ 0.0

Sort (cost=374,495.63..374,495.65 rows=8 width=24) (actual rows= loops=)

  • Sort Key: d_1.keyword_id, d_1.ad_group_id
9. 0.000 0.000 ↓ 0.0

Append (cost=0.00..374,495.51 rows=8 width=24) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on yandex_direct_keyword d_1 (cost=0.00..0.00 rows=1 width=24) (actual rows= loops=)

  • Filter: ((date >= '2018-11-01'::date) AND (date <= '2018-11-30'::date) AND (account_id = 1) AND (campaign_id = 35227015))
11. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on data_yandex_direct_keyword_2018_11_0 d_2 (cost=3,135.59..274,678.41 rows=4 width=24) (actual rows= loops=)

  • Recheck Cond: ((account_id = 1) AND (date >= '2018-11-01'::date) AND (date <= '2018-11-30'::date))
  • Filter: (campaign_id = 35227015)
12. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on data_yandex_direct_keyword_2018_11_0_account_id_date_idx (cost=0.00..3,135.59 rows=84,402 width=0) (actual rows= loops=)

  • Index Cond: ((account_id = 1) AND (date >= '2018-11-01'::date) AND (date <= '2018-11-30'::date))
13. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on data_yandex_direct_keyword_2018_11_1 d_3 (cost=306.28..31,300.46 rows=1 width=24) (actual rows= loops=)

  • Recheck Cond: ((account_id = 1) AND (date >= '2018-11-01'::date) AND (date <= '2018-11-30'::date))
  • Filter: (campaign_id = 35227015)
14. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on data_yandex_direct_keyword_2018_11_1_account_id_date_idx (cost=0.00..306.28 rows=8,137 width=0) (actual rows= loops=)

  • Index Cond: ((account_id = 1) AND (date >= '2018-11-01'::date) AND (date <= '2018-11-30'::date))
15. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on data_yandex_direct_keyword_2018_11_2 d_4 (cost=295.79..29,350.11 rows=1 width=24) (actual rows= loops=)

  • Recheck Cond: ((account_id = 1) AND (date >= '2018-11-01'::date) AND (date <= '2018-11-30'::date))
  • Filter: (campaign_id = 35227015)
16. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on data_yandex_direct_keyword_2018_11_2_account_id_date_idx (cost=0.00..295.79 rows=7,618 width=0) (actual rows= loops=)

  • Index Cond: ((account_id = 1) AND (date >= '2018-11-01'::date) AND (date <= '2018-11-30'::date))
17. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on data_yandex_direct_keyword_2018_11_3 d_5 (cost=399.43..39,166.52 rows=1 width=24) (actual rows= loops=)

  • Recheck Cond: ((account_id = 1) AND (date >= '2018-11-01'::date) AND (date <= '2018-11-30'::date))
  • Filter: (campaign_id = 35227015)
18. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on data_yandex_direct_keyword_2018_11_3_account_id_date_idx (cost=0.00..399.43 rows=10,149 width=0) (actual rows= loops=)

  • Index Cond: ((account_id = 1) AND (date >= '2018-11-01'::date) AND (date <= '2018-11-30'::date))