Bitmap Heap Scan taking ~60x as long for table when queried as partition

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

Bitmap Heap Scan taking ~60x as long for table when queried as partition

Stephen Froehlich

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®


[hidden email]

Tel: +1 (303) 661-3708

 

Reply | Threaded
Open this post in threaded view
|

Re: Bitmap Heap Scan taking ~60x as long for table when queried as partition

Laurenz Albe
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

Reply | Threaded
Open this post in threaded view
|

RE: Bitmap Heap Scan taking ~60x as long for table when queried as partition

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'm in 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) (actual time=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-27 17: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=30601 width=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) (actual time=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-27 17: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=10887 width=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) (actual time=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-27 17: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=12309 width=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) (actual time=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-27 17: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=12037 width=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) (actual time=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-27 17: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=6731 width=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) (actual time=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-27 17: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=2600 width=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) (actual time=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-27 17: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=12099 width=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) (actual time=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-27 17: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=11164 width=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) (actual time=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-27 17: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=15108 width=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) (actual time=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-27 17: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=5709 width=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) (actual time=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-27 17: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=11760 width=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) (actual time=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-27 17: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=12234 width=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) (actual time=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-27 17: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=30349 width=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) (actual time=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-27 17: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=10487 width=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) (actual time=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-27 17: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=12006 width=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) (actual time=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-27 17: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=12088 width=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) (actual time=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-27 17: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=28059 width=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) (actual time=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-27 17: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=10053 width=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) (actual time=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-27 17: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=12121 width=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) (actual time=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-27 17: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=12102 width=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) (actual time=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-27 17: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=25550 width=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) (actual time=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-27 17: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=9181 width=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) (actual time=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-27 17: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=12185 width=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) (actual time=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-27 17: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=11931 width=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) (actual time=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-27 17: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=31887 width=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) (actual time=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-27 17: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=10758 width=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) (actual time=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-27 17: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=11987 width=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) (actual time=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-27 17: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=11795 width=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-27 17: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.82 rows=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) (actual time=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-27 17: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=10798 width=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) (actual time=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-27 17: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=11539 width=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) (actual time=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-27 17: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=11948 width=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) (actual time=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-27 17: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=18632 width=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) (actual time=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-27 17: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=7124 width=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) (actual time=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-27 17: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=12248 width=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) (actual time=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-27 17: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=12127 width=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) (actual time=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-27 17: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=10457 width=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) (actual time=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-27 17: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=1091 width=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) (actual time=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-27 17: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=12385 width=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) (actual time=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-27 17: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=12152 width=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) (actual time=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-27 17: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=2432 width=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) (actual time=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-27 17: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=5728 width=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) (actual time=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-27 17: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=12346 width=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) (actual time=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-27 17: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=11644 width=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) (actual time=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-27 17: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=30459 width=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) (actual time=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-27 17: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=10796 width=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) (actual time=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-27 17: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=12655 width=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) (actual time=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-27 17: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=12072 width=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) (actual time=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-27 17: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=30593 width=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) (actual time=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-27 17: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=11029 width=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) (actual time=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-27 17: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=12481 width=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) (actual time=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-27 17: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=12347 width=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) (actual time=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-27 17: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=32203 width=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) (actual time=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-27 17: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=11065 width=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) (actual time=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-27 17: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=12527 width=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) (actual time=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-27 17: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=11952 width=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) (actual time=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-27 17: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=32909 width=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) (actual time=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-27 17: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=11065 width=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) (actual time=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-27 17: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=12460 width=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) (actual time=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-27 17: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=11875 width=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) (actual time=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-27 17: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=31604 width=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) (actual time=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-27 17: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=9751 width=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) (actual time=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-27 17: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=10842 width=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) (actual time=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-27 17: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=10306 width=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) (actual time=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-27 17: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=30548 width=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) (actual time=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-27 17: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=32133 width=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) (actual time=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-27 17: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=32350 width=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) (actual time=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-27 17: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=31730 width=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) (actual time=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-27 17: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=31486 width=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) (actual time=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-27 17: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=32264 width=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) (actual time=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-27 17: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=32868 width=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) (actual time=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-27 17: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=32639 width=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) (actual time=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-27 17: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=31340 width=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) (actual time=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-27 17: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=32275 width=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) (actual time=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-27 17: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=32951 width=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) (actual time=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-27 17: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=32156 width=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-27 17: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.03 rows=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) (actual time=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-27 17: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=32820 width=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) (actual time=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-27 17: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=33001 width=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) (actual time=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-27 17: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=32421 width=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-27 17: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.71 rows=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) (actual time=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-27 17: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=34219 width=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-27 17: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=35304 width=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) (actual time=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-27 17: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=34163 width=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-27 17: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.49 rows=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-27 17: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=34937 width=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-27 17: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=34860 width=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-27 17: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=35125 width=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) (actual time=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-27 17: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=30798 width=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) (actual time=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-27 17: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=32214 width=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) (actual time=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-27 17: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=31603 width=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) (actual time=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-27 17: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=32183 width=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) (actual time=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-27 17: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=31500 width=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) (actual time=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-27 17: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=32987 width=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) (actual time=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-27 17: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=33398 width=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) (actual time=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-27 17: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=32940 width=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) (actual time=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-27 17: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=32377 width=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) (actual time=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-27 17: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=33799 width=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) (actual time=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-27 17: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=33787 width=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) (actual time=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-27 17: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=32692 width=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) (actual time=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-27 17: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=28177 width=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) (actual time=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-27 17: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=33742 width=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) (actual time=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-27 17: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=33468 width=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) (actual time=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-27 17: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=33837 width=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) (actual time=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-27 17: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=31401 width=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) (actual time=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-27 17: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=33409 width=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) (actual time=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-27 17: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=33857 width=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) (actual time=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-27 17: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=33658 width=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) (actual time=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-27 17: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=32597 width=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) (actual time=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-27 17: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=34213 width=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) (actual time=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-27 17: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=18760 width=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) (actual time=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-27 17: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=18818 width=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) (actual time=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-27 17: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=33422 width=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-27 17: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=35293 width=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-27 17: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=35201 width=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-27 17: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=34909 width=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) (actual time=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-27 17: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=31987 width=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) (actual time=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-27 17: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=33267 width=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) (actual time=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-27 17: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=33218 width=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) (actual time=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-27 17: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=33224 width=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) (actual time=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-27 17: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=11820 width=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) (actual time=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-27 17: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=11974 width=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:[hidden email]]
Sent: Tuesday, February 13, 2018 1:23 AM
To: Stephen Froehlich <[hidden email]>; [hidden email]
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
Reply | Threaded
Open this post in threaded view
|

Re: Bitmap Heap Scan taking ~60x as long for table when queried as partition

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

Reply | Threaded
Open this post in threaded view
|

RE: Bitmap Heap Scan taking ~60x as long for table when queried as partition

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 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.

--Stephen

-----Original Message-----
From: Laurenz Albe [mailto:[hidden email]]
Sent: Wednesday, February 14, 2018 11:00 PM
To: Stephen Froehlich <[hidden email]>; [hidden email]
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

Reply | Threaded
Open this post in threaded view
|

Re: Bitmap Heap Scan taking ~60x as long for table when queried as partition

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

Reply | Threaded
Open this post in threaded view
|

RE: Bitmap Heap Scan taking ~60x as long for table when queried as partition

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:[hidden email]]
Sent: Thursday, February 15, 2018 1:59 PM
To: Stephen Froehlich <[hidden email]>; [hidden email]
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.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
Previous Thread Next Thread