explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cvpc

Settings
# exclusive inclusive rows x rows loops node
1. 8.425 1,354.093 ↓ 7.5 87,732 1

Append (cost=21,837.42..124,269.06 rows=11,641 width=40) (actual time=299.503..1,354.093 rows=87,732 loops=1)

2. 389.344 621.808 ↓ 16.4 25,180 1

Bitmap Heap Scan on stat_default_201908 (cost=21,837.42..58,652.23 rows=1,532 width=40) (actual time=299.502..621.808 rows=25,180 loops=1)

  • Recheck Cond: ((exclude_traffic = ANY ('{1,3}'::integer[])) AND (domain_id = 2,393))
  • Filter: ((create_date >= '2019-08-19'::date) AND (create_date <= '2019-09-17'::date) AND (stat_date >= '2019-08-19'::date) AND (stat_date <= '2019-10-01'::date))
  • Rows Removed by Filter: 198,151
  • Heap Blocks: exact=118,127
3. 16.031 232.464 ↓ 0.0 0 1

BitmapAnd (cost=21,837.42..21,837.42 rows=33,973 width=0) (actual time=232.464..232.464 rows=0 loops=1)

4. 104.353 104.353 ↓ 1.0 513,028 1

Bitmap Index Scan on stat_default_201908_exclude_traffic_idx (cost=0.00..8,324.17 rows=504,300 width=0) (actual time=104.353..104.353 rows=513,028 loops=1)

  • Index Cond: (exclude_traffic = ANY ('{1,3}'::integer[]))
5. 112.080 112.080 ↓ 1.0 816,200 1

Bitmap Index Scan on stat_default_201908_domain_id_longtail_idx (cost=0.00..13,512.23 rows=814,050 width=0) (actual time=112.080..112.080 rows=816,200 loops=1)

  • Index Cond: (domain_id = 2,393)
6. 495.322 718.055 ↓ 6.2 62,321 1

Bitmap Heap Scan on stat_default_201909 (cost=22,175.95..64,347.03 rows=10,037 width=40) (actual time=264.220..718.055 rows=62,321 loops=1)

  • Recheck Cond: ((exclude_traffic = ANY ('{1,3}'::integer[])) AND (domain_id = 2,393))
  • Filter: ((create_date >= '2019-08-19'::date) AND (create_date <= '2019-09-17'::date) AND (stat_date >= '2019-08-19'::date) AND (stat_date <= '2019-10-01'::date))
  • Rows Removed by Filter: 172,664
  • Heap Blocks: exact=126,982
7. 16.640 222.733 ↓ 0.0 0 1

BitmapAnd (cost=22,175.95..22,175.95 rows=38,344 width=0) (actual time=222.733..222.733 rows=0 loops=1)

8. 87.387 87.387 ↓ 1.0 532,697 1

Bitmap Index Scan on stat_default_201909_exclude_traffic_idx (cost=0.00..8,441.65 rows=522,164 width=0) (actual time=87.386..87.387 rows=532,697 loops=1)

  • Index Cond: (exclude_traffic = ANY ('{1,3}'::integer[]))
9. 118.706 118.706 ↓ 1.0 867,993 1

Bitmap Index Scan on stat_default_201909_domain_id_longtail_idx (cost=0.00..13,729.03 rows=844,586 width=0) (actual time=118.706..118.706 rows=867,993 loops=1)

  • Index Cond: (domain_id = 2,393)
10. 3.959 5.805 ↓ 3.2 231 1

Bitmap Heap Scan on stat_default_201910 (cost=243.71..1,211.60 rows=72 width=40) (actual time=2.023..5.805 rows=231 loops=1)

  • Recheck Cond: ((domain_id = 2,393) AND (exclude_traffic = ANY ('{1,3}'::integer[])))
  • Filter: ((create_date >= '2019-08-19'::date) AND (create_date <= '2019-09-17'::date) AND (stat_date >= '2019-08-19'::date) AND (stat_date <= '2019-10-01'::date))
  • Rows Removed by Filter: 3,119
  • Heap Blocks: exact=1,179
11. 0.102 1.846 ↓ 0.0 0 1

BitmapAnd (cost=243.71..243.71 rows=960 width=0) (actual time=1.846..1.846 rows=0 loops=1)

12. 0.850 0.850 ↓ 1.2 11,200 1

Bitmap Index Scan on stat_default_201910_domain_id_longtail_idx (cost=0.00..119.49 rows=9,130 width=0) (actual time=0.850..0.850 rows=11,200 loops=1)

  • Index Cond: (domain_id = 2,393)
13. 0.894 0.894 ↓ 1.1 10,794 1

Bitmap Index Scan on stat_default_201910_exclude_traffic_idx (cost=0.00..123.93 rows=9,666 width=0) (actual time=0.894..0.894 rows=10,794 loops=1)

  • Index Cond: (exclude_traffic = ANY ('{1,3}'::integer[]))
Planning time : 2.298 ms
Execution time : 1,372.385 ms