RE: Bitmap Heap Scan taking ~60x as long for table when queried aspartition - Mailing list pgsql-novice
| From | Stephen Froehlich |
|---|---|
| Subject | RE: Bitmap Heap Scan taking ~60x as long for table when queried aspartition |
| Date | |
| Msg-id | CY1PR0601MB1927737C288366CC06362FB6E5F50@CY1PR0601MB1927.namprd06.prod.outlook.com Whole thread Raw |
| In response to | Re: Bitmap Heap Scan taking ~60x as long for table when queried aspartition (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Responses |
Re: Bitmap Heap Scan taking ~60x as long for table when queried aspartition
(Laurenz Albe <laurenz.albe@cybertec.at>)
|
| List | pgsql-novice |
Hello Laurenz,
It took me until this morning to get the EXPLAIN ANALYZE running. Note that it is a fair amount slower today because
I'min the midst of a pg_dump for the database in question, but the proportions should be there:
HashAggregate (cost=9024874.50..9025341.87 rows=31158 width=40) (actual time=9101899.556..9101928.490 rows=37627
loops=1)
Group Key: date_trunc('minute'::text, raptor_global_bitrate_20171031_cmts1.start_time)
-> Result (cost=591.73..9001416.19 rows=3127775 width=24) (actual time=53.734..9097730.872 rows=2231911 loops=1)
-> Append (cost=591.73..8962319.00 rows=3127775 width=24) (actual time=53.608..9092595.460 rows=2231911
loops=1)
-> Bitmap Heap Scan on raptor_global_bitrate_20171031_cmts1 (cost=591.73..88123.86 rows=30601 width=24)
(actualtime=53.607..494.037 rows=85168 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=85160
-> Bitmap Index Scan on raptor_global_bitrate_20171031_cmts1_client_ip_md5_idx (cost=0.00..584.08
rows=30601width=0) (actual time=36.472..36.472 rows=85168 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171031_cmts3 (cost=210.95..32294.89 rows=10887 width=24)
(actualtime=0.049..0.049 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171031_cmts3_client_ip_md5_idx (cost=0.00..208.22
rows=10887width=0) (actual time=0.048..0.048 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171031_cmts2 (cost=278.97..36475.71 rows=12309 width=24)
(actualtime=0.044..0.044 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171031_cmts2_client_ip_md5_idx (cost=0.00..275.89
rows=12309width=0) (actual time=0.040..0.040 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171031_cmts4 (cost=273.86..35680.16 rows=12037 width=24)
(actualtime=0.030..0.030 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171031_cmts4_client_ip_md5_idx (cost=0.00..270.85
rows=12037width=0) (actual time=0.029..0.029 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171028_cmts1 (cost=130.73..19317.62 rows=6731 width=24)
(actualtime=6.217..78.698 rows=13699 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=13699
-> Bitmap Index Scan on raptor_global_bitrate_20171028_cmts1_client_ip_md5_idx (cost=0.00..129.05
rows=6731width=0) (actual time=3.831..3.831 rows=13699 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171028_cmts3 (cost=53.72..7695.84 rows=2600 width=24)
(actualtime=0.031..0.031 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171028_cmts3_client_ip_md5_idx (cost=0.00..53.07
rows=2600width=0) (actual time=0.029..0.029 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171028_cmts2 (cost=274.34..35863.77 rows=12099 width=24)
(actualtime=0.034..0.034 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171028_cmts2_client_ip_md5_idx (cost=0.00..271.31
rows=12099width=0) (actual time=0.029..0.029 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171028_cmts4 (cost=255.10..33154.64 rows=11164 width=24)
(actualtime=0.027..0.027 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171028_cmts4_client_ip_md5_idx (cost=0.00..252.31
rows=11164width=0) (actual time=0.027..0.027 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171030_cmts1 (cost=294.66..43489.48 rows=15108 width=24)
(actualtime=23.127..219.766 rows=40279 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=40276
-> Bitmap Index Scan on raptor_global_bitrate_20171030_cmts1_client_ip_md5_idx (cost=0.00..290.88
rows=15108width=0) (actual time=15.308..15.308 rows=40279 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171030_cmts3 (cost=113.81..16938.45 rows=5709 width=24)
(actualtime=0.045..0.045 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171030_cmts3_client_ip_md5_idx (cost=0.00..112.39
rows=5709width=0) (actual time=0.041..0.041 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171030_cmts2 (cost=268.71..34900.64 rows=11760 width=24)
(actualtime=0.028..0.028 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171030_cmts2_client_ip_md5_idx (cost=0.00..265.77
rows=11760width=0) (actual time=0.023..0.023 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171030_cmts4 (cost=278.39..36263.40 rows=12234 width=24)
(actualtime=0.028..0.028 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171030_cmts4_client_ip_md5_idx (cost=0.00..275.33
rows=12234width=0) (actual time=0.026..0.026 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171101_cmts1 (cost=586.78..87417.82 rows=30349 width=24)
(actualtime=50.762..382.247 rows=85807 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=85800
-> Bitmap Index Scan on raptor_global_bitrate_20171101_cmts1_client_ip_md5_idx (cost=0.00..579.19
rows=30349width=0) (actual time=32.602..32.602 rows=85807 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171101_cmts3 (cost=204.85..31101.67 rows=10487 width=24)
(actualtime=0.037..0.037 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171101_cmts3_client_ip_md5_idx (cost=0.00..202.22
rows=10487width=0) (actual time=0.033..0.033 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171101_cmts2 (cost=273.62..35593.73 rows=12006 width=24)
(actualtime=0.034..0.034 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171101_cmts2_client_ip_md5_idx (cost=0.00..270.62
rows=12006width=0) (actual time=0.027..0.027 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171101_cmts4 (cost=280.25..35851.89 rows=12088 width=24)
(actualtime=0.040..0.040 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171101_cmts4_client_ip_md5_idx (cost=0.00..277.23
rows=12088width=0) (actual time=0.037..0.037 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171102_cmts1 (cost=545.03..80856.28 rows=28059 width=24)
(actualtime=43.723..416.638 rows=80678 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=80663
-> Bitmap Index Scan on raptor_global_bitrate_20171102_cmts1_client_ip_md5_idx (cost=0.00..538.01
rows=28059width=0) (actual time=26.764..26.764 rows=80678 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171102_cmts3 (cost=195.48..29803.02 rows=10053 width=24)
(actualtime=0.031..0.031 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171102_cmts3_client_ip_md5_idx (cost=0.00..192.97
rows=10053width=0) (actual time=0.029..0.029 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171102_cmts2 (cost=286.51..35981.37 rows=12121 width=24)
(actualtime=0.035..0.035 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171102_cmts2_client_ip_md5_idx (cost=0.00..283.48
rows=12121width=0) (actual time=0.025..0.025 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171102_cmts4 (cost=280.36..35897.82 rows=12102 width=24)
(actualtime=0.017..0.017 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171102_cmts4_client_ip_md5_idx (cost=0.00..277.34
rows=12102width=0) (actual time=0.014..0.014 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171103_cmts1 (cost=495.58..73601.79 rows=25550 width=24)
(actualtime=50.367..357.023 rows=73938 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=73923
-> Bitmap Index Scan on raptor_global_bitrate_20171103_cmts1_client_ip_md5_idx (cost=0.00..489.20
rows=25550width=0) (actual time=34.812..34.812 rows=73938 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171103_cmts3 (cost=179.73..27216.34 rows=9181 width=24)
(actualtime=0.035..0.035 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171103_cmts3_client_ip_md5_idx (cost=0.00..177.43
rows=9181width=0) (actual time=0.032..0.032 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171103_cmts2 (cost=278.01..36130.31 rows=12185 width=24)
(actualtime=0.025..0.025 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171103_cmts2_client_ip_md5_idx (cost=0.00..274.96
rows=12185width=0) (actual time=0.023..0.023 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171103_cmts4 (cost=270.04..35378.83 rows=11931 width=24)
(actualtime=0.021..0.021 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171103_cmts4_client_ip_md5_idx (cost=0.00..267.06
rows=11931width=0) (actual time=0.019..0.019 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171104_cmts1 (cost=616.70..91805.66 rows=31887 width=24)
(actualtime=44.315..351.107 rows=84476 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=84464
-> Bitmap Index Scan on raptor_global_bitrate_20171104_cmts1_client_ip_md5_idx (cost=0.00..608.73
rows=31887width=0) (actual time=26.479..26.479 rows=84476 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171104_cmts3 (cost=209.95..31915.94 rows=10758 width=24)
(actualtime=0.039..0.039 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171104_cmts3_client_ip_md5_idx (cost=0.00..207.26
rows=10758width=0) (actual time=0.036..0.036 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171104_cmts2 (cost=276.47..35562.85 rows=11987 width=24)
(actualtime=0.020..0.020 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171104_cmts2_client_ip_md5_idx (cost=0.00..273.48
rows=11987width=0) (actual time=0.018..0.018 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171104_cmts4 (cost=268.98..35000.19 rows=11795 width=24)
(actualtime=0.027..0.027 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171104_cmts4_client_ip_md5_idx (cost=0.00..266.03
rows=11795width=0) (actual time=0.023..0.023 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171105_cmts1 (cost=2541.73..355805.69 rows=131633
width=24)(actual time=46.240..308.448 rows=85328 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=85314
-> Bitmap Index Scan on raptor_global_bitrate_20171105_cmts1_client_ip_md5_idx
(cost=0.00..2508.82rows=131633 width=0) (actual time=28.245..28.245 rows=85328 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171105_cmts3 (cost=210.26..32036.69 rows=10798 width=24)
(actualtime=0.038..0.038 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171105_cmts3_client_ip_md5_idx (cost=0.00..207.56
rows=10798width=0) (actual time=0.034..0.034 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171105_cmts2 (cost=267.00..34256.40 rows=11539 width=24)
(actualtime=0.028..0.028 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171105_cmts2_client_ip_md5_idx (cost=0.00..264.12
rows=11539width=0) (actual time=0.027..0.027 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171105_cmts4 (cost=279.17..35468.15 rows=11948 width=24)
(actualtime=0.023..0.023 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171105_cmts4_client_ip_md5_idx (cost=0.00..276.19
rows=11948width=0) (actual time=0.019..0.019 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171106_cmts1 (cost=360.97..53674.23 rows=18632 width=24)
(actualtime=16.145..155.124 rows=46402 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=46392
-> Bitmap Index Scan on raptor_global_bitrate_20171106_cmts1_client_ip_md5_idx (cost=0.00..356.31
rows=18632width=0) (actual time=7.335..7.335 rows=46402 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171106_cmts3 (cost=139.78..21116.27 rows=7124 width=24)
(actualtime=0.033..0.033 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171106_cmts3_client_ip_md5_idx (cost=0.00..138.00
rows=7124width=0) (actual time=0.029..0.029 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171106_cmts2 (cost=281.50..36340.26 rows=12248 width=24)
(actualtime=0.033..0.033 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171106_cmts2_client_ip_md5_idx (cost=0.00..278.44
rows=12248width=0) (actual time=0.030..0.030 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171106_cmts4 (cost=274.56..35974.27 rows=12127 width=24)
(actualtime=0.018..0.018 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171106_cmts4_client_ip_md5_idx (cost=0.00..271.53
rows=12127width=0) (actual time=0.014..0.014 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171107_cmts1 (cost=204.60..28270.33 rows=10457 width=24)
(actualtime=1.677..14.445 rows=5548 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=5547
-> Bitmap Index Scan on raptor_global_bitrate_20171107_cmts1_client_ip_md5_idx (cost=0.00..201.99
rows=10457width=0) (actual time=0.842..0.842 rows=5548 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171107_cmts3 (cost=24.02..3229.45 rows=1091 width=24)
(actualtime=0.029..0.029 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171107_cmts3_client_ip_md5_idx (cost=0.00..23.75
rows=1091width=0) (actual time=0.024..0.024 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171107_cmts2 (cost=285.56..36755.85 rows=12385 width=24)
(actualtime=0.025..0.025 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171107_cmts2_client_ip_md5_idx (cost=0.00..282.46
rows=12385width=0) (actual time=0.023..0.023 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171107_cmts4 (cost=286.75..36086.46 rows=12152 width=24)
(actualtime=0.018..0.018 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171107_cmts4_client_ip_md5_idx (cost=0.00..283.71
rows=12152width=0) (actual time=0.015..0.015 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171108_cmts3 (cost=49.42..7198.52 rows=2432 width=24)
(actualtime=0.016..0.016 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171108_cmts3_client_ip_md5_idx (cost=0.00..48.81
rows=2432width=0) (actual time=0.015..0.015 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171108_cmts1 (cost=113.96..16487.87 rows=5728 width=24)
(actualtime=5.630..40.808 rows=14401 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=14397
-> Bitmap Index Scan on raptor_global_bitrate_20171108_cmts1_client_ip_md5_idx (cost=0.00..112.53
rows=5728width=0) (actual time=3.078..3.078 rows=14401 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171108_cmts2 (cost=285.25..36620.14 rows=12346 width=24)
(actualtime=0.035..0.035 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171108_cmts2_client_ip_md5_idx (cost=0.00..282.17
rows=12346width=0) (actual time=0.032..0.032 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171108_cmts4 (cost=267.82..34591.36 rows=11644 width=24)
(actualtime=0.032..0.032 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171108_cmts4_client_ip_md5_idx (cost=0.00..264.90
rows=11644width=0) (actual time=0.023..0.023 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171109_cmts1 (cost=590.63..87716.97 rows=30459 width=24)
(actualtime=51.726..287.876 rows=86043 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=86026
-> Bitmap Index Scan on raptor_global_bitrate_20171109_cmts1_client_ip_md5_idx (cost=0.00..583.01
rows=30459width=0) (actual time=33.704..33.704 rows=86043 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171109_cmts3 (cost=210.24..32005.01 rows=10796 width=24)
(actualtime=0.074..0.074 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171109_cmts3_client_ip_md5_idx (cost=0.00..207.54
rows=10796width=0) (actual time=0.072..0.072 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171109_cmts2 (cost=296.65..37530.12 rows=12655 width=24)
(actualtime=0.028..0.028 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171109_cmts2_client_ip_md5_idx (cost=0.00..293.49
rows=12655width=0) (actual time=0.026..0.026 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171109_cmts4 (cost=274.13..35802.16 rows=12072 width=24)
(actualtime=0.027..0.027 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171109_cmts4_client_ip_md5_idx (cost=0.00..271.11
rows=12072width=0) (actual time=0.025..0.025 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171110_cmts1 (cost=591.67..88065.51 rows=30593 width=24)
(actualtime=45.113..267.056 rows=86161 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=86130
-> Bitmap Index Scan on raptor_global_bitrate_20171110_cmts1_client_ip_md5_idx (cost=0.00..584.02
rows=30593width=0) (actual time=27.546..27.546 rows=86161 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171110_cmts3 (cost=215.05..32691.67 rows=11029 width=24)
(actualtime=0.030..0.030 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171110_cmts3_client_ip_md5_idx (cost=0.00..212.29
rows=11029width=0) (actual time=0.028..0.028 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171110_cmts2 (cost=283.30..36991.00 rows=12481 width=24)
(actualtime=0.016..0.016 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171110_cmts2_client_ip_md5_idx (cost=0.00..280.18
rows=12481width=0) (actual time=0.015..0.015 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171110_cmts4 (cost=279.26..36608.44 rows=12347 width=24)
(actualtime=0.016..0.016 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171110_cmts4_client_ip_md5_idx (cost=0.00..276.17
rows=12347width=0) (actual time=0.014..0.014 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171111_cmts1 (cost=622.15..92585.42 rows=32203 width=24)
(actualtime=45.338..263.019 rows=85654 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=85636
-> Bitmap Index Scan on raptor_global_bitrate_20171111_cmts1_client_ip_md5_idx (cost=0.00..614.10
rows=32203width=0) (actual time=27.304..27.304 rows=85654 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171111_cmts3 (cost=215.33..32839.66 rows=11065 width=24)
(actualtime=0.042..0.042 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171111_cmts3_client_ip_md5_idx (cost=0.00..212.56
rows=11065width=0) (actual time=0.040..0.040 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171111_cmts2 (cost=283.66..37132.39 rows=12527 width=24)
(actualtime=0.021..0.021 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171111_cmts2_client_ip_md5_idx (cost=0.00..280.52
rows=12527width=0) (actual time=0.019..0.019 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171111_cmts4 (cost=273.20..35468.98 rows=11952 width=24)
(actualtime=0.017..0.017 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171111_cmts4_client_ip_md5_idx (cost=0.00..270.21
rows=11952width=0) (actual time=0.016..0.016 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171112_cmts1 (cost=636.62..94609.89 rows=32909 width=24)
(actualtime=44.591..283.585 rows=85445 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=85428
-> Bitmap Index Scan on raptor_global_bitrate_20171112_cmts1_client_ip_md5_idx (cost=0.00..628.39
rows=32909width=0) (actual time=27.348..27.348 rows=85445 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171112_cmts3 (cost=221.33..32834.90 rows=11065 width=24)
(actualtime=0.027..0.027 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171112_cmts3_client_ip_md5_idx (cost=0.00..218.56
rows=11065width=0) (actual time=0.024..0.024 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171112_cmts2 (cost=283.14..36951.71 rows=12460 width=24)
(actualtime=0.020..0.020 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171112_cmts2_client_ip_md5_idx (cost=0.00..280.02
rows=12460width=0) (actual time=0.015..0.015 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171112_cmts4 (cost=269.61..35255.29 rows=11875 width=24)
(actualtime=0.016..0.016 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171112_cmts4_client_ip_md5_idx (cost=0.00..266.64
rows=11875width=0) (actual time=0.015..0.015 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171113_cmts1 (cost=620.50..91057.26 rows=31604 width=24)
(actualtime=44.387..595805.437 rows=84717 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=84695
-> Bitmap Index Scan on raptor_global_bitrate_20171113_cmts1_client_ip_md5_idx (cost=0.00..612.60
rows=31604width=0) (actual time=26.093..26.093 rows=84717 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171113_cmts3 (cost=205.14..28968.36 rows=9751 width=24)
(actualtime=1142.727..1142.727 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171113_cmts3_client_ip_md5_idx (cost=0.00..202.70
rows=9751width=0) (actual time=1142.666..1142.666 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171113_cmts2 (cost=210.60..32125.37 rows=10842 width=24)
(actualtime=176.362..176.362 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171113_cmts2_client_ip_md5_idx (cost=0.00..207.89
rows=10842width=0) (actual time=176.341..176.341 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171113_cmts4 (cost=200.44..30566.57 rows=10306 width=24)
(actualtime=77.112..77.112 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171113_cmts4_client_ip_md5_idx (cost=0.00..197.87
rows=10306width=0) (actual time=77.077..77.077 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171114_cmts1 (cost=660.32..88218.03 rows=30548 width=24)
(actualtime=4303.399..383147.510 rows=83115 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=85892
-> Bitmap Index Scan on raptor_global_bitrate_20171114_cmts1_client_ip_md5_idx (cost=0.00..652.68
rows=30548width=0) (actual time=4247.289..4247.289 rows=85908 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171114_cmts3 (cost=696.60..92351.92 rows=32133 width=24)
(actualtime=428.876..428.876 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171114_cmts3_client_ip_md5_idx (cost=0.00..688.57
rows=32133width=0) (actual time=428.862..428.862 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171114_cmts2 (cost=713.28..93041.12 rows=32350 width=24)
(actualtime=143.849..143.849 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171114_cmts2_client_ip_md5_idx (cost=0.00..705.20
rows=32350width=0) (actual time=143.831..143.831 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171114_cmts4 (cost=699.48..91227.67 rows=31730 width=24)
(actualtime=139.954..139.954 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171114_cmts4_client_ip_md5_idx (cost=0.00..691.55
rows=31730width=0) (actual time=139.939..139.939 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171115_cmts1 (cost=694.59..90734.49 rows=31486 width=24)
(actualtime=6246.195..546350.352 rows=82328 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=82313
-> Bitmap Index Scan on raptor_global_bitrate_20171115_cmts1_client_ip_md5_idx (cost=0.00..686.72
rows=31486width=0) (actual time=6179.919..6179.919 rows=82328 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171115_cmts3 (cost=709.62..92785.36 rows=32264 width=24)
(actualtime=972.830..972.830 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171115_cmts3_client_ip_md5_idx (cost=0.00..701.55
rows=32264width=0) (actual time=972.823..972.823 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171115_cmts2 (cost=723.30..94553.22 rows=32868 width=24)
(actualtime=145.748..145.748 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171115_cmts2_client_ip_md5_idx (cost=0.00..715.08
rows=32868width=0) (actual time=145.729..145.729 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171115_cmts4 (cost=718.52..93846.51 rows=32639 width=24)
(actualtime=230.146..230.146 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171115_cmts4_client_ip_md5_idx (cost=0.00..710.37
rows=32639width=0) (actual time=230.132..230.132 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171116_cmts1 (cost=690.46..90305.19 rows=31340 width=24)
(actualtime=6293.326..610943.016 rows=85678 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=85665
-> Bitmap Index Scan on raptor_global_bitrate_20171116_cmts1_client_ip_md5_idx (cost=0.00..682.62
rows=31340width=0) (actual time=6213.182..6213.182 rows=85678 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171116_cmts3 (cost=709.70..92803.34 rows=32275 width=24)
(actualtime=1172.362..1172.362 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171116_cmts3_client_ip_md5_idx (cost=0.00..701.63
rows=32275width=0) (actual time=1172.345..1172.345 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171116_cmts2 (cost=723.94..94779.51 rows=32951 width=24)
(actualtime=139.294..139.294 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171116_cmts2_client_ip_md5_idx (cost=0.00..715.70
rows=32951width=0) (actual time=139.270..139.270 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171116_cmts4 (cost=708.78..92482.71 rows=32156 width=24)
(actualtime=82.850..82.850 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171116_cmts4_client_ip_md5_idx (cost=0.00..700.74
rows=32156width=0) (actual time=82.835..82.835 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171117_cmts1 (cost=2595.55..321256.35 rows=118061
width=24)(actual time=6463.136..554187.115 rows=86042 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=86026
-> Bitmap Index Scan on raptor_global_bitrate_20171117_cmts1_client_ip_md5_idx
(cost=0.00..2566.03rows=118061 width=0) (actual time=6402.374..6402.374 rows=86042 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171117_cmts3 (cost=722.93..94309.90 rows=32820 width=24)
(actualtime=1106.462..1106.462 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171117_cmts3_client_ip_md5_idx (cost=0.00..714.72
rows=32820width=0) (actual time=1106.449..1106.449 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171117_cmts2 (cost=727.33..94926.26 rows=33001 width=24)
(actualtime=116.485..116.485 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171117_cmts2_client_ip_md5_idx (cost=0.00..719.08
rows=33001width=0) (actual time=116.464..116.464 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171117_cmts4 (cost=713.84..93233.42 rows=32421 width=24)
(actualtime=131.350..131.350 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171117_cmts4_client_ip_md5_idx (cost=0.00..705.73
rows=32421width=0) (actual time=131.336..131.336 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171118_cmts1 (cost=2949.28..363337.79 rows=134285
width=24)(actual time=6500.486..559854.252 rows=85343 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=85333
-> Bitmap Index Scan on raptor_global_bitrate_20171118_cmts1_client_ip_md5_idx
(cost=0.00..2915.71rows=134285 width=0) (actual time=6350.791..6350.791 rows=85343 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171118_cmts3 (cost=751.77..98341.11 rows=34219 width=24)
(actualtime=1135.702..1135.702 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171118_cmts3_client_ip_md5_idx (cost=0.00..743.21
rows=34219width=0) (actual time=1135.685..1135.685 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171118_cmts2 (cost=775.18..101457.04 rows=35304
width=24)(actual time=160.024..160.024 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171118_cmts2_client_ip_md5_idx (cost=0.00..766.35
rows=35304width=0) (actual time=160.008..160.008 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171118_cmts4 (cost=751.34..98201.06 rows=34163 width=24)
(actualtime=125.309..125.309 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171118_cmts4_client_ip_md5_idx (cost=0.00..742.79
rows=34163width=0) (actual time=125.301..125.301 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171119_cmts1 (cost=2685.06..332645.33 rows=122256
width=24)(actual time=6123.173..731915.991 rows=85388 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=85383
-> Bitmap Index Scan on raptor_global_bitrate_20171119_cmts1_client_ip_md5_idx
(cost=0.00..2654.49rows=122256 width=0) (actual time=6044.060..6044.060 rows=85388 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171119_cmts3 (cost=1006.33..100570.73 rows=34937
width=24)(actual time=1190.762..1190.762 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171119_cmts3_client_ip_md5_idx (cost=0.00..997.60
rows=34937width=0) (actual time=1190.746..1190.746 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171119_cmts2 (cost=861.74..100798.85 rows=34860
width=24)(actual time=162.466..162.466 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171119_cmts2_client_ip_md5_idx (cost=0.00..853.02
rows=34860width=0) (actual time=162.460..162.460 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171119_cmts4 (cost=773.79..100878.87 rows=35125
width=24)(actual time=121.208..121.208 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171119_cmts4_client_ip_md5_idx (cost=0.00..765.01
rows=35125width=0) (actual time=121.189..121.189 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171120_cmts1 (cost=677.26..88723.45 rows=30798 width=24)
(actualtime=5608.703..712694.587 rows=82065 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=82059
-> Bitmap Index Scan on raptor_global_bitrate_20171120_cmts1_client_ip_md5_idx (cost=0.00..669.56
rows=30798width=0) (actual time=5527.771..5527.771 rows=82065 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171120_cmts2 (cost=709.23..92675.06 rows=32214 width=24)
(actualtime=1111.615..1111.615 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171120_cmts2_client_ip_md5_idx (cost=0.00..701.18
rows=32214width=0) (actual time=1111.601..1111.601 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171120_cmts3 (cost=695.50..90827.70 rows=31603 width=24)
(actualtime=131.172..131.172 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171120_cmts3_client_ip_md5_idx (cost=0.00..687.60
rows=31603width=0) (actual time=131.158..131.158 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171120_cmts4 (cost=708.99..92518.14 rows=32183 width=24)
(actualtime=129.362..129.362 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171120_cmts4_client_ip_md5_idx (cost=0.00..700.94
rows=32183width=0) (actual time=129.347..129.347 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171121_cmts1 (cost=694.70..90818.94 rows=31500 width=24)
(actualtime=5866.883..737234.798 rows=86151 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=86146
-> Bitmap Index Scan on raptor_global_bitrate_20171121_cmts1_client_ip_md5_idx (cost=0.00..686.82
rows=31500width=0) (actual time=5796.570..5796.570 rows=86151 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171121_cmts3 (cost=724.22..94826.88 rows=32987 width=24)
(actualtime=1095.928..1095.928 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171121_cmts3_client_ip_md5_idx (cost=0.00..715.98
rows=32987width=0) (actual time=1095.916..1095.916 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171121_cmts2 (cost=736.41..96079.05 rows=33398 width=24)
(actualtime=154.123..154.123 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171121_cmts2_client_ip_md5_idx (cost=0.00..728.06
rows=33398width=0) (actual time=154.109..154.109 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171121_cmts4 (cost=723.86..94734.00 rows=32940 width=24)
(actualtime=114.312..114.312 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171121_cmts4_client_ip_md5_idx (cost=0.00..715.62
rows=32940width=0) (actual time=114.295..114.295 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171122_cmts1 (cost=713.49..93363.18 rows=32377 width=24)
(actualtime=6045.684..754773.882 rows=86100 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=86091
-> Bitmap Index Scan on raptor_global_bitrate_20171122_cmts1_client_ip_md5_idx (cost=0.00..705.40
rows=32377width=0) (actual time=5842.652..5842.652 rows=86100 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171122_cmts2 (cost=742.51..97279.25 rows=33799 width=24)
(actualtime=1152.831..1152.831 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171122_cmts2_client_ip_md5_idx (cost=0.00..734.06
rows=33799width=0) (actual time=1152.812..1152.812 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171122_cmts3 (cost=742.42..97170.47 rows=33787 width=24)
(actualtime=155.284..155.284 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171122_cmts3_client_ip_md5_idx (cost=0.00..733.98
rows=33787width=0) (actual time=155.277..155.277 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171122_cmts4 (cost=916.94..94350.72 rows=32692 width=24)
(actualtime=147.894..147.894 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171122_cmts4_client_ip_md5_idx (cost=0.00..908.76
rows=32692width=0) (actual time=147.880..147.880 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171123_cmts1 (cost=728.94..81572.09 rows=28177 width=24)
(actualtime=7025.459..711687.642 rows=84951 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=84939
-> Bitmap Index Scan on raptor_global_bitrate_20171123_cmts1_client_ip_md5_idx (cost=0.00..721.90
rows=28177width=0) (actual time=6890.630..6890.630 rows=84951 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171123_cmts2 (cost=742.07..97005.49 rows=33742 width=24)
(actualtime=1073.776..1073.776 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171123_cmts2_client_ip_md5_idx (cost=0.00..733.64
rows=33742width=0) (actual time=1073.755..1073.755 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171123_cmts3 (cost=739.95..96172.28 rows=33468 width=24)
(actualtime=181.416..181.416 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171123_cmts3_client_ip_md5_idx (cost=0.00..731.58
rows=33468width=0) (actual time=181.399..181.399 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171123_cmts4 (cost=745.81..97239.31 rows=33837 width=24)
(actualtime=146.642..146.642 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171123_cmts4_client_ip_md5_idx (cost=0.00..737.35
rows=33837width=0) (actual time=146.625..146.625 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171124_cmts1 (cost=693.93..90462.60 rows=31401 width=24)
(actualtime=5855.644..549224.844 rows=84986 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=84971
-> Bitmap Index Scan on raptor_global_bitrate_20171124_cmts1_client_ip_md5_idx (cost=0.00..686.08
rows=31401width=0) (actual time=5777.093..5777.093 rows=84986 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171124_cmts3 (cost=733.49..95953.71 rows=33409 width=24)
(actualtime=1141.852..1141.852 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171124_cmts3_client_ip_md5_idx (cost=0.00..725.14
rows=33409width=0) (actual time=1141.839..1141.839 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171124_cmts2 (cost=745.96..97275.57 rows=33857 width=24)
(actualtime=146.728..146.728 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171124_cmts2_client_ip_md5_idx (cost=0.00..737.50
rows=33857width=0) (actual time=146.715..146.715 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171124_cmts4 (cost=741.42..96697.15 rows=33658 width=24)
(actualtime=118.831..118.831 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171124_cmts4_client_ip_md5_idx (cost=0.00..733.01
rows=33658width=0) (actual time=118.812..118.812 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171125_cmts1 (cost=718.20..93842.29 rows=32597 width=24)
(actualtime=6471.121..501023.752 rows=85496 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=85481
-> Bitmap Index Scan on raptor_global_bitrate_20171125_cmts1_client_ip_md5_idx (cost=0.00..710.05
rows=32597width=0) (actual time=6367.897..6367.897 rows=85496 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171125_cmts3 (cost=751.72..98230.71 rows=34213 width=24)
(actualtime=1156.071..1156.071 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171125_cmts3_client_ip_md5_idx (cost=0.00..743.17
rows=34213width=0) (actual time=1156.060..1156.060 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171125_cmts2 (cost=415.96..53886.20 rows=18760 width=24)
(actualtime=150.121..150.121 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171125_cmts2_client_ip_md5_idx (cost=0.00..411.27
rows=18760width=0) (actual time=150.105..150.105 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171125_cmts4 (cost=416.41..54041.84 rows=18818 width=24)
(actualtime=114.580..114.580 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171125_cmts4_client_ip_md5_idx (cost=0.00..411.70
rows=18818width=0) (actual time=114.569..114.569 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171126_cmts1 (cost=736.59..96193.73 rows=33422 width=24)
(actualtime=5657.828..532531.201 rows=84771 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=84759
-> Bitmap Index Scan on raptor_global_bitrate_20171126_cmts1_client_ip_md5_idx (cost=0.00..728.24
rows=33422width=0) (actual time=5600.944..5600.944 rows=84771 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171126_cmts2 (cost=778.09..101368.94 rows=35293
width=24)(actual time=1114.213..1114.213 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171126_cmts2_client_ip_md5_idx (cost=0.00..769.27
rows=35293width=0) (actual time=1114.206..1114.206 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171126_cmts3 (cost=774.38..101049.32 rows=35201
width=24)(actual time=195.180..195.180 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171126_cmts3_client_ip_md5_idx (cost=0.00..765.58
rows=35201width=0) (actual time=195.172..195.172 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171126_cmts4 (cost=769.12..100260.91 rows=34909
width=24)(actual time=117.797..117.797 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171126_cmts4_client_ip_md5_idx (cost=0.00..760.39
rows=34909width=0) (actual time=117.778..117.778 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171127_cmts1 (cost=704.47..92202.79 rows=31987 width=24)
(actualtime=6235.505..585748.193 rows=85753 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
Heap Blocks: exact=85749
-> Bitmap Index Scan on raptor_global_bitrate_20171127_cmts1_client_ip_md5_idx (cost=0.00..696.48
rows=31987width=0) (actual time=6112.894..6112.894 rows=85753 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171127_cmts2 (cost=732.39..95734.84 rows=33267 width=24)
(actualtime=1148.623..1148.623 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171127_cmts2_client_ip_md5_idx (cost=0.00..724.08
rows=33267width=0) (actual time=1148.610..1148.610 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171127_cmts3 (cost=732.01..95508.36 rows=33218 width=24)
(actualtime=154.929..154.929 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171127_cmts3_client_ip_md5_idx (cost=0.00..723.71
rows=33218width=0) (actual time=154.913..154.913 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171127_cmts4 (cost=732.06..95560.98 rows=33224 width=24)
(actualtime=140.116..140.116 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171127_cmts4_client_ip_md5_idx (cost=0.00..723.75
rows=33224width=0) (actual time=140.101..140.101 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171029_cmts2 (cost=269.18..35061.55 rows=11820 width=24)
(actualtime=149.852..149.852 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171029_cmts2_client_ip_md5_idx (cost=0.00..266.22
rows=11820width=0) (actual time=149.842..149.842 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
-> Bitmap Heap Scan on raptor_global_bitrate_20171029_cmts4 (cost=273.37..35513.16 rows=11974 width=24)
(actualtime=143.167..143.167 rows=0 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-27 18:00:00-06'::timestamp with time zone) AND (start_time <
'2017-11-2717:00:00-07'::timestamp with time zone))
-> Bitmap Index Scan on raptor_global_bitrate_20171029_cmts4_client_ip_md5_idx (cost=0.00..270.38
rows=11974width=0) (actual time=143.151..143.151 rows=0 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Planning time: 19937.893 ms
Execution time: 9101951.406 ms
-----Original Message-----
From: Laurenz Albe [mailto:laurenz.albe@cybertec.at]
Sent: Tuesday, February 13, 2018 1:23 AM
To: Stephen Froehlich <s.froehlich@cablelabs.com>; pgsql-novice@postgresql.org
Subject: Re: Bitmap Heap Scan taking ~60x as long for table when queried as partition
CableLabs WARNING: The sender of this email could not be validated and may not match the person in the "From" field.
Stephen Froehlich wrote:
> I have a fairly large partitioned table, but annoyingly if I query the
> hypertable directly it takes ~60x as long to scan each subtable than if I query each sub-table directly.
> I have freshly vacuumed and analyzed the tables in question and this persists.
> What is going on?
Can you send the complete execution plan for the second query?
Yours,
Laurenz Albe
pgsql-novice by date: