Обсуждение: Bitmap Heap Scan taking ~60x as long for table when queried aspartition
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?
Thanks,
Stephen
EXPLAIN ANALYZE
SELECT
SUM( server_tx_bytes + client_tx_bytes ) AS tot_bytes,
date_trunc( 'minute', start_time ) AS start_min
FROM
raptor_global_bitrate_20171101_cmts1
WHERE
client_ip_md5='28903ff5-1bb6-2533-23e7-ac5218b30008'
AND start_time >= '2017-10-28 00:00:00 UTC'
AND start_time < '2017-11-28 00:00:00 UTC'
GROUP BY
start_min;
HashAggregate (cost=87530.06..87791.23 rows=17411 width=40) (actual time=2618.322..2619.004 rows=1440 loops=1)
Group Key: date_trunc('minute'::text, start_time)
-> Bitmap Heap Scan on raptor_global_bitrate_20171101_cmts1 (cost=586.25..87302.95 rows=30281 width=24) (actual time=67.735..2548.289 rows=85807 loops=1)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-28 00:00:00+00'::timestamp with time zone) AND (start_time < '2017-11-28 00:00:00+00'::timestamp with time zone))
Heap Blocks: exact=85800
-> Bitmap Index Scan on raptor_global_bitrate_20171101_cmts1_client_ip_md5_idx (cost=0.00..578.68 rows=30281 width=0) (actual time=47.199..47.199 rows=85807 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Planning time: 1.768 ms
Execution time: 2619.368 ms
EXPLAIN ANALYZE
SELECT
SUM( server_tx_bytes + client_tx_bytes ) AS tot_bytes,
date_trunc( 'minute', start_time ) AS start_min
FROM
raptor_global_bitrate_part
WHERE
client_ip_md5='28903ff5-1bb6-2533-23e7-ac5218b30008'
AND start_time >= '2017-10-28 00:00:00 UTC'
AND start_time < '2017-11-28 00:00:00 UTC'
GROUP BY
start_min;
-> Parallel Bitmap Heap Scan on raptor_global_bitrate_20171101_cmts1 (cost=591.99..87814.50 rows=7659 width=24) (actual time=176.151..24760.668 rows=14301 loops=6)
Recheck Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Filter: ((start_time >= '2017-10-28 00:00:00+00'::timestamp with time zone) AND (start_time < '2017-11-28 00:00:00+00'::timestamp with time zone))
Heap Blocks: exact=14477
-> Bitmap Index Scan on raptor_global_bitrate_20171101_cmts1_client_ip_md5_idx (cost=0.00..584.34 rows=30635 width=0) (actual time=131.289..131.289 rows=85807 loops=1)
Index Cond: (client_ip_md5 = '28903ff5-1bb6-2533-23e7-ac5218b30008'::uuid)
Execution time for this sub-table: 148,432.719 ms
(Note this is 24760.668 * 6)
Stephen Froehlich
Sr. Strategist, CableLabs®
s.froehlich@cablelabs.com
Tel: +1 (303) 661-3708
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
RE: Bitmap Heap Scan taking ~60x as long for table when queried aspartition
От
Stephen Froehlich
Дата:
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
Stephen Froehlich wrote: > It took me until this morning to get the EXPLAIN ANALYZE running. Note that it is a > fair amount slower today because I'm in the midst of a pg_dump for the database > in question, but the proportions should be there: That query has to scan all 122 partitions to get its result. This cannot be avoided, because there are matching rows in many partitions. Partitioning doesn't help if all partitions have to be scanned. I notice that there is no parallelization - having several workers scan partitions in parallel should help. You could create a combined index on (client_ip_md5, start_time), that might speed up the index scans. Yours, Laurenz Albe
RE: Bitmap Heap Scan taking ~60x as long for table when queried aspartition
От
Stephen Froehlich
Дата:
Hi Laurenz, Some of the partition scans are quick (those with nothing to return), but my point is that the scan PER TABLE is significantlyslower than if I call the hypertable than if I call the table directly. THIS SHOULDN'T BE THE CASE. Most tablesare scanned quickly and return nothing. There IS a combined index on client_ip_md5, start_time ... its my primary key for all of these tables. Also, the scans are typically parallelized (go back in the thread to the original excerpt), the only reason why not thistime is that the server was busy with a backup. Its still much slower when calling the hypertable than the table directly.The parallelization is usually my first clue that an index scan is not being used but instead a heap scan. --Stephen -----Original Message----- From: Laurenz Albe [mailto:laurenz.albe@cybertec.at] Sent: Wednesday, February 14, 2018 11:00 PM 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 Stephen Froehlich wrote: > It took me until this morning to get the EXPLAIN ANALYZE running. > Note that it is a fair amount slower today because I'm in the midst of > a pg_dump for the database in question, but the proportions should be there: That query has to scan all 122 partitions to get its result. This cannot be avoided, because there are matching rows in many partitions. Partitioning doesn't help if all partitions have to be scanned. I notice that there is no parallelization - having several workers scan partitions in parallel should help. You could create a combined index on (client_ip_md5, start_time), that might speed up the index scans. Yours, Laurenz Albe
Stephen Froehlich wrote: > Some of the partition scans are quick (those with nothing to return), > but my point is that the scan PER TABLE is significantly slower than if > I call the hypertable than if I call the table directly. > THIS SHOULDN'T BE THE CASE. Most tables are scanned quickly and return nothing. > > There IS a combined index on client_ip_md5, start_time ... its my primary key for all of these tables. > > Also, the scans are typically parallelized (go back in the thread to the original excerpt), > the only reason why not this time is that the server was busy with a backup. > Its still much slower when calling the hypertable than the table directly. > The parallelization is usually my first clue that an index scan is not being > used but instead a heap scan. In your complete plan, scanning "raptor_global_bitrate_20171101_cmts1" took only 382.247 microseconds as opposed to 24760.668 in your first e-mail. Also the strange "loops=6" is not present. So it is hard to say what was going on there in the first place... Often caching causes big differences in execution time. Yours, Laurenz Albe
RE: Bitmap Heap Scan taking ~60x as long for table when queried aspartition
От
Stephen Froehlich
Дата:
I think some tables likely got vacuumed per http://ask.use-the-index-luke.com/questions/148/why-is-this-postgres-query-doing-a-bitmap-heap-scan-after-the-index-scan I am now explicitly vacuum analyzing-ing each table after a large write. --Stephen -----Original Message----- From: Laurenz Albe [mailto:laurenz.albe@cybertec.at] Sent: Thursday, February 15, 2018 1:59 PM 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: > Some of the partition scans are quick (those with nothing to return), > but my point is that the scan PER TABLE is significantly slower than > if I call the hypertable than if I call the table directly. > THIS SHOULDN'T BE THE CASE. Most tables are scanned quickly and return nothing. > > There IS a combined index on client_ip_md5, start_time ... its my primary key for all of these tables. > > Also, the scans are typically parallelized (go back in the thread to > the original excerpt), the only reason why not this time is that the server was busy with a backup. > Its still much slower when calling the hypertable than the table directly. > The parallelization is usually my first clue that an index scan is not > being used but instead a heap scan. In your complete plan, scanning "raptor_global_bitrate_20171101_cmts1" took only 382.247 microseconds as opposed to 24760.668in your first e-mail. Also the strange "loops=6" is not present. So it is hard to say what was going on there in the first place... Often caching causes big differences in execution time. Yours, Laurenz Albe