explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pnw9

Settings
# exclusive inclusive rows x rows loops node
1. 2.562 1,790,792.522 ↓ 1.5 1,641 1

GroupAggregate (cost=193,551.76..193,599.32 rows=1,119 width=92) (actual time=1,790,789.592..1,790,792.522 rows=1,641 loops=1)

  • Group Key: account_type, cl_id, account_id, dri_series_name, wefa_series_name, frequency, databank_name, gii_product, access_type, aggregation_date
2. 12.464 1,790,789.960 ↓ 4.4 4,938 1

Sort (cost=193,551.76..193,554.56 rows=1,119 width=88) (actual time=1,790,789.537..1,790,789.960 rows=4,938 loops=1)

  • Sort Key: account_type, cl_id, account_id, dri_series_name, wefa_series_name, frequency, databank_name, gii_product, access_type, aggregation_date
  • Sort Method: quicksort Memory: 887kB
3. 1,790,655.649 1,790,777.496 ↓ 4.4 4,938 1

Bitmap Heap Scan on data_usage d (cost=1,301.49..193,495.10 rows=1,119 width=88) (actual time=1,175.545..1,790,777.496 rows=4,938 loops=1)

  • Recheck Cond: ((dri_series_name = ANY ('{GDP$@HND,GDP$@HKG}'::text[])) OR (wefa_series_name = ANY ('{GDP$@HND,GDP$@HKG}'::text[])))
  • Rows Removed by Index Recheck: 6,137,908
  • Filter: ((account_type = ANY ('{C,I}'::text[])) AND (access_timestamp >= to_date('2020-01-01'::text, 'YYYY-MM-DD'::text)) AND (access_timestamp <= to_date('2020-01-10'::text, 'YYYY-MM-DD'::text)))
  • Rows Removed by Filter: 338,255
  • Heap Blocks: exact=20,221 lossy=162,872
4. 0.006 121.847 ↓ 0.0 0 1

BitmapOr (cost=1,301.49..1,301.49 rows=49,418 width=0) (actual time=121.847..121.847 rows=0 loops=1)

5. 121.761 121.761 ↓ 12.7 390,319 1

Bitmap Index Scan on data_usage_dri_series_name_idx (cost=0.00..759.70 rows=30,740 width=0) (actual time=121.761..121.761 rows=390,319 loops=1)

  • Index Cond: (dri_series_name = ANY ('{GDP$@HND,GDP$@HKG}'::text[]))
6. 0.080 0.080 ↓ 0.0 0 1

Bitmap Index Scan on data_usage_wefa_series_name_idx (cost=0.00..541.24 rows=18,678 width=0) (actual time=0.080..0.080 rows=0 loops=1)

  • Index Cond: (wefa_series_name = ANY ('{GDP$@HND,GDP$@HKG}'::text[]))
Planning time : 5.792 ms
Execution time : 1,790,866.309 ms