explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k0YF

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 2,875.469 ↑ 3.0 2 1

Append (cost=0.00..12,503.79 rows=6 width=294) (actual time=2,565.000..2,875.469 rows=2 loops=1)

2. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on offers (cost=0.00..0.00 rows=1 width=1,048) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((hashes @> '{78612031749_4069_2015,78612002687_4069_2015,78612012480_4069_2015,78612014849_4069_2015,78612014949_4069_2015,78612023917_4069_2015,78612027187_4069_2015,78612030037_4069_2015,78612030056_4069_2015,78612030088_4069_2015,78612030136_4069_2015,78612030151_4069_2015,78612030217_4069_2015,78612030285_4069_2015,78612030310_4069_2015,78612030316_4069_2015,78612030332_4069_2015,78612030335_4069_2015,78612030350_4069_2015,78612030354_4069_2015,78612030359_4069_2015,78612030382_4069_2015,78612030410_4069_2015,78612030437_4069_2015,78612030481_4069_2015,78612030482_4069_2015,78612030492_4069_2015,78612030582_4069_2015,78612030612_4069_2015,78612030645_4069_2015,78612030667_4069_2015,78612030676_4069_2015,78612030677_4069_2015,78612030755_4069_2015,78612030860_4069_2015,78612030979_4069_2015,78612031011_4069_2015,78612031051_4069_2015,78612031056_4069_2015,78612031290_4069_2015,78612031412_4069_2015,78612031468_4069_2015,78612031619_4069_2015,78612031702_4069_2015,78612031711_4069_2015,78612031733_4069_2015,78612031734_4069_2015,78612031766_4069_2015,78612031786_4069_2015,78612031806_4069_2015,78612031874_4069_2015,78612031900_4069_2015,78612031983_4069_2015,78612031985_4069_2015,78612032014_4069_2015,78612032020_4069_2015,78612032121_4069_2015,78612032196_4069_2015,78612032199_4069_2015,78612032212_4069_2015,78612032366_4069_2015,78612032402_4069_2015,78612032436_4069_2015,78612032503_4069_2015,78612032536_4069_2015,78612032631_4069_2015,78612032649_4069_2015,78612032741_4069_2015,78612032815_4069_2015,78612032831_4069_2015,78612032903_4069_2015,78612032906_4069_2015,78612032999_4069_2015,78612033028_4069_2015,78612033033_4069_2015,78612033057_4069_2015,78612033086_4069_2015,78612033187_4069_2015,78612033193_4069_2015,78612033199_4069_2015,78612033233_4069_2015,78612033287_4069_2015,78612033295_4069_2015,78612033299_4069_2015,78612033300_4069_2015,78612033301_4069_2015,78612033310_4069_2015,78612033412_4069_2015,78612033435_4069_2015,78612033477_4069_2015,78612033537_4069_2015,78612033691_4069_2015,78612033750_4069_2015,78612033768_4069_2015,78612033852_4069_2015,78612034194_4069_2015,78612034214_4069_2015,78612034232_4069_2015,78612034242_4069_2015,78612034537_4069_2015,78612034559_4069_2015,78612034599_4069_2015,78612034651_4069_2015,78612034680_4069_2015,78612034699_4069_2015,78612034735_4069_2015,78612034848_4069_2015,78612034855_4069_2015,78612034861_4069_2015,78612034954_4069_2015,78612034969_4069_2015,78612035072_4069_2015,78612035183_4069_2015,78612035229_4069_2015,78612035239_4069_2015,78612035251_4069_2015,78612035282_4069_2015,78612035336_4069_2015,78612035339_4069_2015,78612035389_4069_2015,78612035399_4069_2015,78612035497_4069_2015,78612035511_4069_2015,78612035523_4069_2015,78612035532_4069_2015,78612035575_4069_2015,78612035612_4069_2015,78612035680_4069_2015,78612035724_4069_2015,78612035802_4069_2015,78612036099_4069_2015,78612036131_4069_2015,78612036136_4069_2015,78612036183_4069_2015,78612036190_4069_2015,78612036195_4069_2015,78612036231_4069_2015,78612036252_4069_2015,78612036281_4069_2015,78612036283_4069_2015,78612036430_4069_2015,78612036510_4069_2015,78612036554_4069_2015,78612036599_4069_2015,78612036695_4069_2015,78612036810_4069_2015,78612036823_4069_2015,78612036880_4069_2015,78612036889_4069_2015,78612036936_4069_2015,78612036937_4069_2015,78612036969_4069_2015,78612037075_4069_2015,78612037077_4069_2015,78612037145_4069_2015,78612037193_4069_2015,78612037325_4069_2015,78612037329_4069_2015,78612037352_4069_2015,78612037368_4069_2015,78612037373_4069_2015,78612037457_4069_2015,78612037507_4069_2015,78612037616_4069_2015,78612037659_4069_2015,78612037668_4069_2015,78612037707_4069_2015,78612037774_4069_2015,78612037868_4069_2015,78612037900_4069_2015,78612037903_4069_2015,78612037940_4069_2015,78612037982_4069_2015,78612037996_4069_2015,78612038056_4069_2015,78612038085_4069_2015,78612038112_4069_2015,78612038113_4069_2015,78612038119_4069_2015,78612038166_4069_2015,78612038210_4069_2015,78612038246_4069_2015,78612038305_4069_2015,78612038343_4069_2015,78612038382_4069_2015,78612038405_4069_2015,78612038411_4069_2015,78612038450_4069_2015,78612038471_4069_2015,78612038488_4069_2015,78612038509_4069_2015,78612038511_4069_2015,78612038546_4069_2015,78612038594_4069_2015,78612038785_4069_2015,78612038856_4069_2015,78612038924_4069_2015,78612039122_4069_2015,78612039148_4069_2015,78612039173_4069_2015,78612039366_4069_2015,78612039395_4069_2015,78612039495_4069_2015,78612039602_4069_2015,78612039612_4069_2015,78612039629_4069_2015,78612039675_4069_2015,78612039730_4069_2015,78612039791_4069_2015,78612039837_4069_2015,78612039853_4069_2015,78612039862_4069_2015,78612039913_4069_2015,78612039929_4069_2015,78612039945_4069_2015,78612039977_4069_2015,78612040649_4069_2015,78612045184_4069_2015,78612046700_4069_2015,78612046944_4069_2015,78612050349_4069_2015,78612051971_4069_2015,78612057686_4069_2015,78612058164_4069_2015,78612061274_4069_2015,78612066111_4069_2015,78612067349_4069_2015,78612074764_4069_2015,78612075802_4069_2015,78612086285_4069_2015,78612087125_4069_2015,78612087216_4069_2015,78612090902_4069_2015,78612094163_4069_2015,78612097802_4069_2015,78612101044_4069_2015,78612103149_4069_2015,78612105393_4069_2015,78612106566_4069_2015,78612112390_4069_2015,78612112424_4069_2015,78612112449_4069_2015,78612113198_4069_2015,78612122412_4069_2015,78612122649_4069_2015,78612123749_4069_2015,78612123874_4069_2015,78612125339_4069_2015,78612128038_4069_2015,78612131529_4069_2015,78612136049_4069_2015,78612137666_4069_2015,78612143853_4069_2015,78612145105_4069_2015,78612145649_4069_2015,78612148142_4069_2015,78612152547_4069_2015,78612157349_4069_2015,78612159785_4069_2015,78612159865_4069_2015,78612159880_4069_2015,78612160302_4069_2015,78612164394_4069_2015,78612164532_4069_2015,78612167502_4069_2015,78612169994_4069_2015,78612170138_4069_2015,78612172384_4069_2015,78612174102_4069_2015,78612174714_4069_2015,78612176633_4069_2015,78612180535_4069_2015,78612182452_4069_2015,78612182772_4069_2015,78612184002_4069_2015,78612186117_4069_2015,78612187149_4069_2015,78612188415_4069_2015,78612188722_4069_2015,78612195628_4069_2015,78612199629_4069_2015,78612208102_4069_2015,78612224849_4069_2015,78612227888_4069_2015,78612231102_4069_2015,78612237649_4069_2015,78612251749_4069_2015,78612262802_4069_2015,78612263449_4069_2015,78612264149_4069_2015,78612306166_4069_2015,78612306901_4069_2015,78612311976_4069_2015,78612317619_4069_2015,78612318924_4069_2015,78612322490_4069_2015,78612329205_4069_2015,78612330349_4069_2015,78612337064_4069_2015,78612342355_4069_2015,78612350103_4069_2015,78612357553_4069_2015,78612360975_4069_2015,78612364400_4069_2015,78612374549_4069_2015,78612374558_4069_2015,78612376814_4069_2015,78612389345_4069_2015,78612399010_4069_2015,78612399499_4069_2015,78612413187_4069_2015,78612420034_4069_2015,78612429675_4069_2015,78612436325_4069_2015,78612436365_4069_2015,78612441277_4069_2015,78612444001_4069_2015,78612445149_4069_2015,78612450841_4069_2015,78612456150_4069_2015,78612466150_4069_2015,78612472995_4069_2015,78612473702_4069_2015,78612480405_4069_2015,78612480588_4069_2015,78612482020_4069_2015,78612489186_4069_2015,78612499697_4069_2015,78612504832_4069_2015,78612504881_4069_2015,78612507441_4069_2015,78612507449_4069_2015,78612520485_4069_2015,78612522654_4069_2015,78612524892_4069_2015,78612529596_4069_2015,78612539649_4069_2015,78612540303_4069_2015,78612543928_4069_2015,78612544464_4069_2015,78612551318_4069_2015,78612551964_4069_2015,78612559699_4069_2015,78612567601_4069_2015,78612572265_4069_2015,78612572360_4069_2015,78612574749_4069_2015,78612580415_4069_2015,78612582370_4069_2015,78612583010_4069_2015,78612597382_4069_2015,78612606834_4069_2015,78612611085_4069_2015,78612616549_4069_2015,78612620234_4069_2015,78612623085_4069_2015,78612627081_4069_2015,78612627085_4069_2015,78612637549_4069_2015,78612642749_4069_2015,78612646197_4069_2015,78612652002_4069_2015,78612652087_4069_2015,78612664485_4069_2015,78612668485_4069_2015,78612682020_4069_2015,78612704702_4069_2015,78612704749_4069_2015,78612706449_4069_2015,78612709024_4069_2015,78612709714_4069_2015,78612712631_4069_2015,78612712636_4069_2015,78612714849_4069_2015,78612720239_4069_2015,78612722321_4069_2015,78612726564_4069_2015,78612728431_4069_2015,78612729278_4069_2015,78612735420_4069_2015,78612737329_4069_2015,78612739349_4069_2015,78612740202_4069_2015,78612743458_4069_2015,78612752640_4069_2015,78612759102_4069_2015,78612759113_4069_2015,78612759702_4069_2015,78612763238_4069_2015,78612768484_4069_2015,78612772142_4069_2015,78612772977_4069_2015,78612774149_4069_2015,78612775821_4069_2015,78612775911_4069_2015,78612775985_4069_2015,78612776102_4069_2015,78612776549_4069_2015,78612779484_4069_2015,78612780849_4069_2015,78612789925_4069_2015,78612790099_4069_2015,78612792649_4069_2015,78612796349_4069_2015,78612799602_4069_2015,78612803258_4069_2015,78612805178_4069_2015,78612811085_4069_2015,78612826087_4069_2015,78612834549_4069_2015,78612834802_4069_2015,78612836038_4069_2015,78612842849_4069_2015,78612850449_4069_2015,78612850771_4069_2015,78612852717_4069_2015,78612857485_4069_2015,78612857581_4069_2015,78612859785_4069_2015,78612863385_4069_2015,78612872697_4069_2015,78612880410_4069_2015,78612880449_4069_2015,78612881049_4069_2015,78612883579_4069_2015,78612893077_4069_2015,78612895262_4069_2015,78612896202_4069_2015,78612911602_4069_2015,78612941221_4069_2015,78612947902_4069_2015,78612956653_4069_2015,78612964002_4069_2015,78612965532_4069_2015,78612967607_4069_2015,78612978949_4069_2015,78612999221_4069_2015}'::character varying[]) AND (created_at >= '2019-05-05 15:16:49'::timestamp without time zone) AND (id <> 63908383))
3. 0.003 331.667 ↓ 0.0 0 1

Bitmap Heap Scan on offers_2019_5 (cost=2,686.20..2,687.32 rows=1 width=142) (actual time=331.667..331.667 rows=0 loops=1)

  • Recheck Cond: (hashes @> '{78612031749_4069_2015,78612002687_4069_2015,78612012480_4069_2015,78612014849_4069_2015,78612014949_4069_2015,78612023917_4069_2015,78612027187_4069_2015,78612030037_4069_2015,78612030056_4069_2015,78612030088_4069_2015,78612030136_4069_2015,78612030151_4069_2015,78612030217_4069_2015,78612030285_4069_2015,78612030310_4069_2015,78612030316_4069_2015,78612030332_4069_2015,78612030335_4069_2015,78612030350_4069_2015,78612030354_4069_2015,78612030359_4069_2015,78612030382_4069_2015,78612030410_4069_2015,78612030437_4069_2015,78612030481_4069_2015,78612030482_4069_2015,78612030492_4069_2015,78612030582_4069_2015,78612030612_4069_2015,78612030645_4069_2015,78612030667_4069_2015,78612030676_4069_2015,78612030677_4069_2015,78612030755_4069_2015,78612030860_4069_2015,78612030979_4069_2015,78612031011_4069_2015,78612031051_4069_2015,78612031056_4069_2015,78612031290_4069_2015,78612031412_4069_2015,78612031468_4069_2015,78612031619_4069_2015,78612031702_4069_2015,78612031711_4069_2015,78612031733_4069_2015,78612031734_4069_2015,78612031766_4069_2015,78612031786_4069_2015,78612031806_4069_2015,78612031874_4069_2015,78612031900_4069_2015,78612031983_4069_2015,78612031985_4069_2015,78612032014_4069_2015,78612032020_4069_2015,78612032121_4069_2015,78612032196_4069_2015,78612032199_4069_2015,78612032212_4069_2015,78612032366_4069_2015,78612032402_4069_2015,78612032436_4069_2015,78612032503_4069_2015,78612032536_4069_2015,78612032631_4069_2015,78612032649_4069_2015,78612032741_4069_2015,78612032815_4069_2015,78612032831_4069_2015,78612032903_4069_2015,78612032906_4069_2015,78612032999_4069_2015,78612033028_4069_2015,78612033033_4069_2015,78612033057_4069_2015,78612033086_4069_2015,78612033187_4069_2015,78612033193_4069_2015,78612033199_4069_2015,78612033233_4069_2015,78612033287_4069_2015,78612033295_4069_2015,78612033299_4069_2015,78612033300_4069_2015,78612033301_4069_2015,78612033310_4069_2015,78612033412_4069_2015,78612033435_4069_2015,78612033477_4069_2015,78612033537_4069_2015,78612033691_4069_2015,78612033750_4069_2015,78612033768_4069_2015,78612033852_4069_2015,78612034194_4069_2015,78612034214_4069_2015,78612034232_4069_2015,78612034242_4069_2015,78612034537_4069_2015,78612034559_4069_2015,78612034599_4069_2015,78612034651_4069_2015,78612034680_4069_2015,78612034699_4069_2015,78612034735_4069_2015,78612034848_4069_2015,78612034855_4069_2015,78612034861_4069_2015,78612034954_4069_2015,78612034969_4069_2015,78612035072_4069_2015,78612035183_4069_2015,78612035229_4069_2015,78612035239_4069_2015,78612035251_4069_2015,78612035282_4069_2015,78612035336_4069_2015,78612035339_4069_2015,78612035389_4069_2015,78612035399_4069_2015,78612035497_4069_2015,78612035511_4069_2015,78612035523_4069_2015,78612035532_4069_2015,78612035575_4069_2015,78612035612_4069_2015,78612035680_4069_2015,78612035724_4069_2015,78612035802_4069_2015,78612036099_4069_2015,78612036131_4069_2015,78612036136_4069_2015,78612036183_4069_2015,78612036190_4069_2015,78612036195_4069_2015,78612036231_4069_2015,78612036252_4069_2015,78612036281_4069_2015,78612036283_4069_2015,78612036430_4069_2015,78612036510_4069_2015,78612036554_4069_2015,78612036599_4069_2015,78612036695_4069_2015,78612036810_4069_2015,78612036823_4069_2015,78612036880_4069_2015,78612036889_4069_2015,78612036936_4069_2015,78612036937_4069_2015,78612036969_4069_2015,78612037075_4069_2015,78612037077_4069_2015,78612037145_4069_2015,78612037193_4069_2015,78612037325_4069_2015,78612037329_4069_2015,78612037352_4069_2015,78612037368_4069_2015,78612037373_4069_2015,78612037457_4069_2015,78612037507_4069_2015,78612037616_4069_2015,78612037659_4069_2015,78612037668_4069_2015,78612037707_4069_2015,78612037774_4069_2015,78612037868_4069_2015,78612037900_4069_2015,78612037903_4069_2015,78612037940_4069_2015,78612037982_4069_2015,78612037996_4069_2015,78612038056_4069_2015,78612038085_4069_2015,78612038112_4069_2015,78612038113_4069_2015,78612038119_4069_2015,78612038166_4069_2015,78612038210_4069_2015,78612038246_4069_2015,78612038305_4069_2015,78612038343_4069_2015,78612038382_4069_2015,78612038405_4069_2015,78612038411_4069_2015,78612038450_4069_2015,78612038471_4069_2015,78612038488_4069_2015,78612038509_4069_2015,78612038511_4069_2015,78612038546_4069_2015,78612038594_4069_2015,78612038785_4069_2015,78612038856_4069_2015,78612038924_4069_2015,78612039122_4069_2015,78612039148_4069_2015,78612039173_4069_2015,78612039366_4069_2015,78612039395_4069_2015,78612039495_4069_2015,78612039602_4069_2015,78612039612_4069_2015,78612039629_4069_2015,78612039675_4069_2015,78612039730_4069_2015,78612039791_4069_2015,78612039837_4069_2015,78612039853_4069_2015,78612039862_4069_2015,78612039913_4069_2015,78612039929_4069_2015,78612039945_4069_2015,78612039977_4069_2015,78612040649_4069_2015,78612045184_4069_2015,78612046700_4069_2015,78612046944_4069_2015,78612050349_4069_2015,78612051971_4069_2015,78612057686_4069_2015,78612058164_4069_2015,78612061274_4069_2015,78612066111_4069_2015,78612067349_4069_2015,78612074764_4069_2015,78612075802_4069_2015,78612086285_4069_2015,78612087125_4069_2015,78612087216_4069_2015,78612090902_4069_2015,78612094163_4069_2015,78612097802_4069_2015,78612101044_4069_2015,78612103149_4069_2015,78612105393_4069_2015,78612106566_4069_2015,78612112390_4069_2015,78612112424_4069_2015,78612112449_4069_2015,78612113198_4069_2015,78612122412_4069_2015,78612122649_4069_2015,78612123749_4069_2015,78612123874_4069_2015,78612125339_4069_2015,78612128038_4069_2015,78612131529_4069_2015,78612136049_4069_2015,78612137666_4069_2015,78612143853_4069_2015,78612145105_4069_2015,78612145649_4069_2015,78612148142_4069_2015,78612152547_4069_2015,78612157349_4069_2015,78612159785_4069_2015,78612159865_4069_2015,78612159880_4069_2015,78612160302_4069_2015,78612164394_4069_2015,78612164532_4069_2015,78612167502_4069_2015,78612169994_4069_2015,78612170138_4069_2015,78612172384_4069_2015,78612174102_4069_2015,78612174714_4069_2015,78612176633_4069_2015,78612180535_4069_2015,78612182452_4069_2015,78612182772_4069_2015,78612184002_4069_2015,78612186117_4069_2015,78612187149_4069_2015,78612188415_4069_2015,78612188722_4069_2015,78612195628_4069_2015,78612199629_4069_2015,78612208102_4069_2015,78612224849_4069_2015,78612227888_4069_2015,78612231102_4069_2015,78612237649_4069_2015,78612251749_4069_2015,78612262802_4069_2015,78612263449_4069_2015,78612264149_4069_2015,78612306166_4069_2015,78612306901_4069_2015,78612311976_4069_2015,78612317619_4069_2015,78612318924_4069_2015,78612322490_4069_2015,78612329205_4069_2015,78612330349_4069_2015,78612337064_4069_2015,78612342355_4069_2015,78612350103_4069_2015,78612357553_4069_2015,78612360975_4069_2015,78612364400_4069_2015,78612374549_4069_2015,78612374558_4069_2015,78612376814_4069_2015,78612389345_4069_2015,78612399010_4069_2015,78612399499_4069_2015,78612413187_4069_2015,78612420034_4069_2015,78612429675_4069_2015,78612436325_4069_2015,78612436365_4069_2015,78612441277_4069_2015,78612444001_4069_2015,78612445149_4069_2015,78612450841_4069_2015,78612456150_4069_2015,78612466150_4069_2015,78612472995_4069_2015,78612473702_4069_2015,78612480405_4069_2015,78612480588_4069_2015,78612482020_4069_2015,78612489186_4069_2015,78612499697_4069_2015,78612504832_4069_2015,78612504881_4069_2015,78612507441_4069_2015,78612507449_4069_2015,78612520485_4069_2015,78612522654_4069_2015,78612524892_4069_2015,78612529596_4069_2015,78612539649_4069_2015,78612540303_4069_2015,78612543928_4069_2015,78612544464_4069_2015,78612551318_4069_2015,78612551964_4069_2015,78612559699_4069_2015,78612567601_4069_2015,78612572265_4069_2015,78612572360_4069_2015,78612574749_4069_2015,78612580415_4069_2015,78612582370_4069_2015,78612583010_4069_2015,78612597382_4069_2015,78612606834_4069_2015,78612611085_4069_2015,78612616549_4069_2015,78612620234_4069_2015,78612623085_4069_2015,78612627081_4069_2015,78612627085_4069_2015,78612637549_4069_2015,78612642749_4069_2015,78612646197_4069_2015,78612652002_4069_2015,78612652087_4069_2015,78612664485_4069_2015,78612668485_4069_2015,78612682020_4069_2015,78612704702_4069_2015,78612704749_4069_2015,78612706449_4069_2015,78612709024_4069_2015,78612709714_4069_2015,78612712631_4069_2015,78612712636_4069_2015,78612714849_4069_2015,78612720239_4069_2015,78612722321_4069_2015,78612726564_4069_2015,78612728431_4069_2015,78612729278_4069_2015,78612735420_4069_2015,78612737329_4069_2015,78612739349_4069_2015,78612740202_4069_2015,78612743458_4069_2015,78612752640_4069_2015,78612759102_4069_2015,78612759113_4069_2015,78612759702_4069_2015,78612763238_4069_2015,78612768484_4069_2015,78612772142_4069_2015,78612772977_4069_2015,78612774149_4069_2015,78612775821_4069_2015,78612775911_4069_2015,78612775985_4069_2015,78612776102_4069_2015,78612776549_4069_2015,78612779484_4069_2015,78612780849_4069_2015,78612789925_4069_2015,78612790099_4069_2015,78612792649_4069_2015,78612796349_4069_2015,78612799602_4069_2015,78612803258_4069_2015,78612805178_4069_2015,78612811085_4069_2015,78612826087_4069_2015,78612834549_4069_2015,78612834802_4069_2015,78612836038_4069_2015,78612842849_4069_2015,78612850449_4069_2015,78612850771_4069_2015,78612852717_4069_2015,78612857485_4069_2015,78612857581_4069_2015,78612859785_4069_2015,78612863385_4069_2015,78612872697_4069_2015,78612880410_4069_2015,78612880449_4069_2015,78612881049_4069_2015,78612883579_4069_2015,78612893077_4069_2015,78612895262_4069_2015,78612896202_4069_2015,78612911602_4069_2015,78612941221_4069_2015,78612947902_4069_2015,78612956653_4069_2015,78612964002_4069_2015,78612965532_4069_2015,78612967607_4069_2015,78612978949_4069_2015,78612999221_4069_2015}'::character varying[])
  • Filter: ((created_at >= '2019-05-05 15:16:49'::timestamp without time zone) AND (id <> 63908383))
4. 331.664 331.664 ↓ 0.0 0 1

Bitmap Index Scan on offers_2019_5_hashes (cost=0.00..2,686.20 rows=1 width=0) (actual time=331.664..331.664 rows=0 loops=1)

  • Index Cond: (hashes @> '{78612031749_4069_2015,78612002687_4069_2015,78612012480_4069_2015,78612014849_4069_2015,78612014949_4069_2015,78612023917_4069_2015,78612027187_4069_2015,78612030037_4069_2015,78612030056_4069_2015,78612030088_4069_2015,78612030136_4069_2015,78612030151_4069_2015,78612030217_4069_2015,78612030285_4069_2015,78612030310_4069_2015,78612030316_4069_2015,78612030332_4069_2015,78612030335_4069_2015,78612030350_4069_2015,78612030354_4069_2015,78612030359_4069_2015,78612030382_4069_2015,78612030410_4069_2015,78612030437_4069_2015,78612030481_4069_2015,78612030482_4069_2015,78612030492_4069_2015,78612030582_4069_2015,78612030612_4069_2015,78612030645_4069_2015,78612030667_4069_2015,78612030676_4069_2015,78612030677_4069_2015,78612030755_4069_2015,78612030860_4069_2015,78612030979_4069_2015,78612031011_4069_2015,78612031051_4069_2015,78612031056_4069_2015,78612031290_4069_2015,78612031412_4069_2015,78612031468_4069_2015,78612031619_4069_2015,78612031702_4069_2015,78612031711_4069_2015,78612031733_4069_2015,78612031734_4069_2015,78612031766_4069_2015,78612031786_4069_2015,78612031806_4069_2015,78612031874_4069_2015,78612031900_4069_2015,78612031983_4069_2015,78612031985_4069_2015,78612032014_4069_2015,78612032020_4069_2015,78612032121_4069_2015,78612032196_4069_2015,78612032199_4069_2015,78612032212_4069_2015,78612032366_4069_2015,78612032402_4069_2015,78612032436_4069_2015,78612032503_4069_2015,78612032536_4069_2015,78612032631_4069_2015,78612032649_4069_2015,78612032741_4069_2015,78612032815_4069_2015,78612032831_4069_2015,78612032903_4069_2015,78612032906_4069_2015,78612032999_4069_2015,78612033028_4069_2015,78612033033_4069_2015,78612033057_4069_2015,78612033086_4069_2015,78612033187_4069_2015,78612033193_4069_2015,78612033199_4069_2015,78612033233_4069_2015,78612033287_4069_2015,78612033295_4069_2015,78612033299_4069_2015,78612033300_4069_2015,78612033301_4069_2015,78612033310_4069_2015,78612033412_4069_2015,78612033435_4069_2015,78612033477_4069_2015,78612033537_4069_2015,78612033691_4069_2015,78612033750_4069_2015,78612033768_4069_2015,78612033852_4069_2015,78612034194_4069_2015,78612034214_4069_2015,78612034232_4069_2015,78612034242_4069_2015,78612034537_4069_2015,78612034559_4069_2015,78612034599_4069_2015,78612034651_4069_2015,78612034680_4069_2015,78612034699_4069_2015,78612034735_4069_2015,78612034848_4069_2015,78612034855_4069_2015,78612034861_4069_2015,78612034954_4069_2015,78612034969_4069_2015,78612035072_4069_2015,78612035183_4069_2015,78612035229_4069_2015,78612035239_4069_2015,78612035251_4069_2015,78612035282_4069_2015,78612035336_4069_2015,78612035339_4069_2015,78612035389_4069_2015,78612035399_4069_2015,78612035497_4069_2015,78612035511_4069_2015,78612035523_4069_2015,78612035532_4069_2015,78612035575_4069_2015,78612035612_4069_2015,78612035680_4069_2015,78612035724_4069_2015,78612035802_4069_2015,78612036099_4069_2015,78612036131_4069_2015,78612036136_4069_2015,78612036183_4069_2015,78612036190_4069_2015,78612036195_4069_2015,78612036231_4069_2015,78612036252_4069_2015,78612036281_4069_2015,78612036283_4069_2015,78612036430_4069_2015,78612036510_4069_2015,78612036554_4069_2015,78612036599_4069_2015,78612036695_4069_2015,78612036810_4069_2015,78612036823_4069_2015,78612036880_4069_2015,78612036889_4069_2015,78612036936_4069_2015,78612036937_4069_2015,78612036969_4069_2015,78612037075_4069_2015,78612037077_4069_2015,78612037145_4069_2015,78612037193_4069_2015,78612037325_4069_2015,78612037329_4069_2015,78612037352_4069_2015,78612037368_4069_2015,78612037373_4069_2015,78612037457_4069_2015,78612037507_4069_2015,78612037616_4069_2015,78612037659_4069_2015,78612037668_4069_2015,78612037707_4069_2015,78612037774_4069_2015,78612037868_4069_2015,78612037900_4069_2015,78612037903_4069_2015,78612037940_4069_2015,78612037982_4069_2015,78612037996_4069_2015,78612038056_4069_2015,78612038085_4069_2015,78612038112_4069_2015,78612038113_4069_2015,78612038119_4069_2015,78612038166_4069_2015,78612038210_4069_2015,78612038246_4069_2015,78612038305_4069_2015,78612038343_4069_2015,78612038382_4069_2015,78612038405_4069_2015,78612038411_4069_2015,78612038450_4069_2015,78612038471_4069_2015,78612038488_4069_2015,78612038509_4069_2015,78612038511_4069_2015,78612038546_4069_2015,78612038594_4069_2015,78612038785_4069_2015,78612038856_4069_2015,78612038924_4069_2015,78612039122_4069_2015,78612039148_4069_2015,78612039173_4069_2015,78612039366_4069_2015,78612039395_4069_2015,78612039495_4069_2015,78612039602_4069_2015,78612039612_4069_2015,78612039629_4069_2015,78612039675_4069_2015,78612039730_4069_2015,78612039791_4069_2015,78612039837_4069_2015,78612039853_4069_2015,78612039862_4069_2015,78612039913_4069_2015,78612039929_4069_2015,78612039945_4069_2015,78612039977_4069_2015,78612040649_4069_2015,78612045184_4069_2015,78612046700_4069_2015,78612046944_4069_2015,78612050349_4069_2015,78612051971_4069_2015,78612057686_4069_2015,78612058164_4069_2015,78612061274_4069_2015,78612066111_4069_2015,78612067349_4069_2015,78612074764_4069_2015,78612075802_4069_2015,78612086285_4069_2015,78612087125_4069_2015,78612087216_4069_2015,78612090902_4069_2015,78612094163_4069_2015,78612097802_4069_2015,78612101044_4069_2015,78612103149_4069_2015,78612105393_4069_2015,78612106566_4069_2015,78612112390_4069_2015,78612112424_4069_2015,78612112449_4069_2015,78612113198_4069_2015,78612122412_4069_2015,78612122649_4069_2015,78612123749_4069_2015,78612123874_4069_2015,78612125339_4069_2015,78612128038_4069_2015,78612131529_4069_2015,78612136049_4069_2015,78612137666_4069_2015,78612143853_4069_2015,78612145105_4069_2015,78612145649_4069_2015,78612148142_4069_2015,78612152547_4069_2015,78612157349_4069_2015,78612159785_4069_2015,78612159865_4069_2015,78612159880_4069_2015,78612160302_4069_2015,78612164394_4069_2015,78612164532_4069_2015,78612167502_4069_2015,78612169994_4069_2015,78612170138_4069_2015,78612172384_4069_2015,78612174102_4069_2015,78612174714_4069_2015,78612176633_4069_2015,78612180535_4069_2015,78612182452_4069_2015,78612182772_4069_2015,78612184002_4069_2015,78612186117_4069_2015,78612187149_4069_2015,78612188415_4069_2015,78612188722_4069_2015,78612195628_4069_2015,78612199629_4069_2015,78612208102_4069_2015,78612224849_4069_2015,78612227888_4069_2015,78612231102_4069_2015,78612237649_4069_2015,78612251749_4069_2015,78612262802_4069_2015,78612263449_4069_2015,78612264149_4069_2015,78612306166_4069_2015,78612306901_4069_2015,78612311976_4069_2015,78612317619_4069_2015,78612318924_4069_2015,78612322490_4069_2015,78612329205_4069_2015,78612330349_4069_2015,78612337064_4069_2015,78612342355_4069_2015,78612350103_4069_2015,78612357553_4069_2015,78612360975_4069_2015,78612364400_4069_2015,78612374549_4069_2015,78612374558_4069_2015,78612376814_4069_2015,78612389345_4069_2015,78612399010_4069_2015,78612399499_4069_2015,78612413187_4069_2015,78612420034_4069_2015,78612429675_4069_2015,78612436325_4069_2015,78612436365_4069_2015,78612441277_4069_2015,78612444001_4069_2015,78612445149_4069_2015,78612450841_4069_2015,78612456150_4069_2015,78612466150_4069_2015,78612472995_4069_2015,78612473702_4069_2015,78612480405_4069_2015,78612480588_4069_2015,78612482020_4069_2015,78612489186_4069_2015,78612499697_4069_2015,78612504832_4069_2015,78612504881_4069_2015,78612507441_4069_2015,78612507449_4069_2015,78612520485_4069_2015,78612522654_4069_2015,78612524892_4069_2015,78612529596_4069_2015,78612539649_4069_2015,78612540303_4069_2015,78612543928_4069_2015,78612544464_4069_2015,78612551318_4069_2015,78612551964_4069_2015,78612559699_4069_2015,78612567601_4069_2015,78612572265_4069_2015,78612572360_4069_2015,78612574749_4069_2015,78612580415_4069_2015,78612582370_4069_2015,78612583010_4069_2015,78612597382_4069_2015,78612606834_4069_2015,78612611085_4069_2015,78612616549_4069_2015,78612620234_4069_2015,78612623085_4069_2015,78612627081_4069_2015,78612627085_4069_2015,78612637549_4069_2015,78612642749_4069_2015,78612646197_4069_2015,78612652002_4069_2015,78612652087_4069_2015,78612664485_4069_2015,78612668485_4069_2015,78612682020_4069_2015,78612704702_4069_2015,78612704749_4069_2015,78612706449_4069_2015,78612709024_4069_2015,78612709714_4069_2015,78612712631_4069_2015,78612712636_4069_2015,78612714849_4069_2015,78612720239_4069_2015,78612722321_4069_2015,78612726564_4069_2015,78612728431_4069_2015,78612729278_4069_2015,78612735420_4069_2015,78612737329_4069_2015,78612739349_4069_2015,78612740202_4069_2015,78612743458_4069_2015,78612752640_4069_2015,78612759102_4069_2015,78612759113_4069_2015,78612759702_4069_2015,78612763238_4069_2015,78612768484_4069_2015,78612772142_4069_2015,78612772977_4069_2015,78612774149_4069_2015,78612775821_4069_2015,78612775911_4069_2015,78612775985_4069_2015,78612776102_4069_2015,78612776549_4069_2015,78612779484_4069_2015,78612780849_4069_2015,78612789925_4069_2015,78612790099_4069_2015,78612792649_4069_2015,78612796349_4069_2015,78612799602_4069_2015,78612803258_4069_2015,78612805178_4069_2015,78612811085_4069_2015,78612826087_4069_2015,78612834549_4069_2015,78612834802_4069_2015,78612836038_4069_2015,78612842849_4069_2015,78612850449_4069_2015,78612850771_4069_2015,78612852717_4069_2015,78612857485_4069_2015,78612857581_4069_2015,78612859785_4069_2015,78612863385_4069_2015,78612872697_4069_2015,78612880410_4069_2015,78612880449_4069_2015,78612881049_4069_2015,78612883579_4069_2015,78612893077_4069_2015,78612895262_4069_2015,78612896202_4069_2015,78612911602_4069_2015,78612941221_4069_2015,78612947902_4069_2015,78612956653_4069_2015,78612964002_4069_2015,78612965532_4069_2015,78612967607_4069_2015,78612978949_4069_2015,78612999221_4069_2015}'::character varying[])
5. 0.003 428.073 ↓ 0.0 0 1

Bitmap Heap Scan on offers_2019_6 (cost=2,688.40..2,689.52 rows=1 width=145) (actual time=428.073..428.073 rows=0 loops=1)

  • Recheck Cond: (hashes @> '{78612031749_4069_2015,78612002687_4069_2015,78612012480_4069_2015,78612014849_4069_2015,78612014949_4069_2015,78612023917_4069_2015,78612027187_4069_2015,78612030037_4069_2015,78612030056_4069_2015,78612030088_4069_2015,78612030136_4069_2015,78612030151_4069_2015,78612030217_4069_2015,78612030285_4069_2015,78612030310_4069_2015,78612030316_4069_2015,78612030332_4069_2015,78612030335_4069_2015,78612030350_4069_2015,78612030354_4069_2015,78612030359_4069_2015,78612030382_4069_2015,78612030410_4069_2015,78612030437_4069_2015,78612030481_4069_2015,78612030482_4069_2015,78612030492_4069_2015,78612030582_4069_2015,78612030612_4069_2015,78612030645_4069_2015,78612030667_4069_2015,78612030676_4069_2015,78612030677_4069_2015,78612030755_4069_2015,78612030860_4069_2015,78612030979_4069_2015,78612031011_4069_2015,78612031051_4069_2015,78612031056_4069_2015,78612031290_4069_2015,78612031412_4069_2015,78612031468_4069_2015,78612031619_4069_2015,78612031702_4069_2015,78612031711_4069_2015,78612031733_4069_2015,78612031734_4069_2015,78612031766_4069_2015,78612031786_4069_2015,78612031806_4069_2015,78612031874_4069_2015,78612031900_4069_2015,78612031983_4069_2015,78612031985_4069_2015,78612032014_4069_2015,78612032020_4069_2015,78612032121_4069_2015,78612032196_4069_2015,78612032199_4069_2015,78612032212_4069_2015,78612032366_4069_2015,78612032402_4069_2015,78612032436_4069_2015,78612032503_4069_2015,78612032536_4069_2015,78612032631_4069_2015,78612032649_4069_2015,78612032741_4069_2015,78612032815_4069_2015,78612032831_4069_2015,78612032903_4069_2015,78612032906_4069_2015,78612032999_4069_2015,78612033028_4069_2015,78612033033_4069_2015,78612033057_4069_2015,78612033086_4069_2015,78612033187_4069_2015,78612033193_4069_2015,78612033199_4069_2015,78612033233_4069_2015,78612033287_4069_2015,78612033295_4069_2015,78612033299_4069_2015,78612033300_4069_2015,78612033301_4069_2015,78612033310_4069_2015,78612033412_4069_2015,78612033435_4069_2015,78612033477_4069_2015,78612033537_4069_2015,78612033691_4069_2015,78612033750_4069_2015,78612033768_4069_2015,78612033852_4069_2015,78612034194_4069_2015,78612034214_4069_2015,78612034232_4069_2015,78612034242_4069_2015,78612034537_4069_2015,78612034559_4069_2015,78612034599_4069_2015,78612034651_4069_2015,78612034680_4069_2015,78612034699_4069_2015,78612034735_4069_2015,78612034848_4069_2015,78612034855_4069_2015,78612034861_4069_2015,78612034954_4069_2015,78612034969_4069_2015,78612035072_4069_2015,78612035183_4069_2015,78612035229_4069_2015,78612035239_4069_2015,78612035251_4069_2015,78612035282_4069_2015,78612035336_4069_2015,78612035339_4069_2015,78612035389_4069_2015,78612035399_4069_2015,78612035497_4069_2015,78612035511_4069_2015,78612035523_4069_2015,78612035532_4069_2015,78612035575_4069_2015,78612035612_4069_2015,78612035680_4069_2015,78612035724_4069_2015,78612035802_4069_2015,78612036099_4069_2015,78612036131_4069_2015,78612036136_4069_2015,78612036183_4069_2015,78612036190_4069_2015,78612036195_4069_2015,78612036231_4069_2015,78612036252_4069_2015,78612036281_4069_2015,78612036283_4069_2015,78612036430_4069_2015,78612036510_4069_2015,78612036554_4069_2015,78612036599_4069_2015,78612036695_4069_2015,78612036810_4069_2015,78612036823_4069_2015,78612036880_4069_2015,78612036889_4069_2015,78612036936_4069_2015,78612036937_4069_2015,78612036969_4069_2015,78612037075_4069_2015,78612037077_4069_2015,78612037145_4069_2015,78612037193_4069_2015,78612037325_4069_2015,78612037329_4069_2015,78612037352_4069_2015,78612037368_4069_2015,78612037373_4069_2015,78612037457_4069_2015,78612037507_4069_2015,78612037616_4069_2015,78612037659_4069_2015,78612037668_4069_2015,78612037707_4069_2015,78612037774_4069_2015,78612037868_4069_2015,78612037900_4069_2015,78612037903_4069_2015,78612037940_4069_2015,78612037982_4069_2015,78612037996_4069_2015,78612038056_4069_2015,78612038085_4069_2015,78612038112_4069_2015,78612038113_4069_2015,78612038119_4069_2015,78612038166_4069_2015,78612038210_4069_2015,78612038246_4069_2015,78612038305_4069_2015,78612038343_4069_2015,78612038382_4069_2015,78612038405_4069_2015,78612038411_4069_2015,78612038450_4069_2015,78612038471_4069_2015,78612038488_4069_2015,78612038509_4069_2015,78612038511_4069_2015,78612038546_4069_2015,78612038594_4069_2015,78612038785_4069_2015,78612038856_4069_2015,78612038924_4069_2015,78612039122_4069_2015,78612039148_4069_2015,78612039173_4069_2015,78612039366_4069_2015,78612039395_4069_2015,78612039495_4069_2015,78612039602_4069_2015,78612039612_4069_2015,78612039629_4069_2015,78612039675_4069_2015,78612039730_4069_2015,78612039791_4069_2015,78612039837_4069_2015,78612039853_4069_2015,78612039862_4069_2015,78612039913_4069_2015,78612039929_4069_2015,78612039945_4069_2015,78612039977_4069_2015,78612040649_4069_2015,78612045184_4069_2015,78612046700_4069_2015,78612046944_4069_2015,78612050349_4069_2015,78612051971_4069_2015,78612057686_4069_2015,78612058164_4069_2015,78612061274_4069_2015,78612066111_4069_2015,78612067349_4069_2015,78612074764_4069_2015,78612075802_4069_2015,78612086285_4069_2015,78612087125_4069_2015,78612087216_4069_2015,78612090902_4069_2015,78612094163_4069_2015,78612097802_4069_2015,78612101044_4069_2015,78612103149_4069_2015,78612105393_4069_2015,78612106566_4069_2015,78612112390_4069_2015,78612112424_4069_2015,78612112449_4069_2015,78612113198_4069_2015,78612122412_4069_2015,78612122649_4069_2015,78612123749_4069_2015,78612123874_4069_2015,78612125339_4069_2015,78612128038_4069_2015,78612131529_4069_2015,78612136049_4069_2015,78612137666_4069_2015,78612143853_4069_2015,78612145105_4069_2015,78612145649_4069_2015,78612148142_4069_2015,78612152547_4069_2015,78612157349_4069_2015,78612159785_4069_2015,78612159865_4069_2015,78612159880_4069_2015,78612160302_4069_2015,78612164394_4069_2015,78612164532_4069_2015,78612167502_4069_2015,78612169994_4069_2015,78612170138_4069_2015,78612172384_4069_2015,78612174102_4069_2015,78612174714_4069_2015,78612176633_4069_2015,78612180535_4069_2015,78612182452_4069_2015,78612182772_4069_2015,78612184002_4069_2015,78612186117_4069_2015,78612187149_4069_2015,78612188415_4069_2015,78612188722_4069_2015,78612195628_4069_2015,78612199629_4069_2015,78612208102_4069_2015,78612224849_4069_2015,78612227888_4069_2015,78612231102_4069_2015,78612237649_4069_2015,78612251749_4069_2015,78612262802_4069_2015,78612263449_4069_2015,78612264149_4069_2015,78612306166_4069_2015,78612306901_4069_2015,78612311976_4069_2015,78612317619_4069_2015,78612318924_4069_2015,78612322490_4069_2015,78612329205_4069_2015,78612330349_4069_2015,78612337064_4069_2015,78612342355_4069_2015,78612350103_4069_2015,78612357553_4069_2015,78612360975_4069_2015,78612364400_4069_2015,78612374549_4069_2015,78612374558_4069_2015,78612376814_4069_2015,78612389345_4069_2015,78612399010_4069_2015,78612399499_4069_2015,78612413187_4069_2015,78612420034_4069_2015,78612429675_4069_2015,78612436325_4069_2015,78612436365_4069_2015,78612441277_4069_2015,78612444001_4069_2015,78612445149_4069_2015,78612450841_4069_2015,78612456150_4069_2015,78612466150_4069_2015,78612472995_4069_2015,78612473702_4069_2015,78612480405_4069_2015,78612480588_4069_2015,78612482020_4069_2015,78612489186_4069_2015,78612499697_4069_2015,78612504832_4069_2015,78612504881_4069_2015,78612507441_4069_2015,78612507449_4069_2015,78612520485_4069_2015,78612522654_4069_2015,78612524892_4069_2015,78612529596_4069_2015,78612539649_4069_2015,78612540303_4069_2015,78612543928_4069_2015,78612544464_4069_2015,78612551318_4069_2015,78612551964_4069_2015,78612559699_4069_2015,78612567601_4069_2015,78612572265_4069_2015,78612572360_4069_2015,78612574749_4069_2015,78612580415_4069_2015,78612582370_4069_2015,78612583010_4069_2015,78612597382_4069_2015,78612606834_4069_2015,78612611085_4069_2015,78612616549_4069_2015,78612620234_4069_2015,78612623085_4069_2015,78612627081_4069_2015,78612627085_4069_2015,78612637549_4069_2015,78612642749_4069_2015,78612646197_4069_2015,78612652002_4069_2015,78612652087_4069_2015,78612664485_4069_2015,78612668485_4069_2015,78612682020_4069_2015,78612704702_4069_2015,78612704749_4069_2015,78612706449_4069_2015,78612709024_4069_2015,78612709714_4069_2015,78612712631_4069_2015,78612712636_4069_2015,78612714849_4069_2015,78612720239_4069_2015,78612722321_4069_2015,78612726564_4069_2015,78612728431_4069_2015,78612729278_4069_2015,78612735420_4069_2015,78612737329_4069_2015,78612739349_4069_2015,78612740202_4069_2015,78612743458_4069_2015,78612752640_4069_2015,78612759102_4069_2015,78612759113_4069_2015,78612759702_4069_2015,78612763238_4069_2015,78612768484_4069_2015,78612772142_4069_2015,78612772977_4069_2015,78612774149_4069_2015,78612775821_4069_2015,78612775911_4069_2015,78612775985_4069_2015,78612776102_4069_2015,78612776549_4069_2015,78612779484_4069_2015,78612780849_4069_2015,78612789925_4069_2015,78612790099_4069_2015,78612792649_4069_2015,78612796349_4069_2015,78612799602_4069_2015,78612803258_4069_2015,78612805178_4069_2015,78612811085_4069_2015,78612826087_4069_2015,78612834549_4069_2015,78612834802_4069_2015,78612836038_4069_2015,78612842849_4069_2015,78612850449_4069_2015,78612850771_4069_2015,78612852717_4069_2015,78612857485_4069_2015,78612857581_4069_2015,78612859785_4069_2015,78612863385_4069_2015,78612872697_4069_2015,78612880410_4069_2015,78612880449_4069_2015,78612881049_4069_2015,78612883579_4069_2015,78612893077_4069_2015,78612895262_4069_2015,78612896202_4069_2015,78612911602_4069_2015,78612941221_4069_2015,78612947902_4069_2015,78612956653_4069_2015,78612964002_4069_2015,78612965532_4069_2015,78612967607_4069_2015,78612978949_4069_2015,78612999221_4069_2015}'::character varying[])
  • Filter: ((created_at >= '2019-05-05 15:16:49'::timestamp without time zone) AND (id <> 63908383))
6. 428.070 428.070 ↓ 0.0 0 1

Bitmap Index Scan on offers_2019_6_hashes (cost=0.00..2,688.40 rows=1 width=0) (actual time=428.069..428.070 rows=0 loops=1)

  • Index Cond: (hashes @> '{78612031749_4069_2015,78612002687_4069_2015,78612012480_4069_2015,78612014849_4069_2015,78612014949_4069_2015,78612023917_4069_2015,78612027187_4069_2015,78612030037_4069_2015,78612030056_4069_2015,78612030088_4069_2015,78612030136_4069_2015,78612030151_4069_2015,78612030217_4069_2015,78612030285_4069_2015,78612030310_4069_2015,78612030316_4069_2015,78612030332_4069_2015,78612030335_4069_2015,78612030350_4069_2015,78612030354_4069_2015,78612030359_4069_2015,78612030382_4069_2015,78612030410_4069_2015,78612030437_4069_2015,78612030481_4069_2015,78612030482_4069_2015,78612030492_4069_2015,78612030582_4069_2015,78612030612_4069_2015,78612030645_4069_2015,78612030667_4069_2015,78612030676_4069_2015,78612030677_4069_2015,78612030755_4069_2015,78612030860_4069_2015,78612030979_4069_2015,78612031011_4069_2015,78612031051_4069_2015,78612031056_4069_2015,78612031290_4069_2015,78612031412_4069_2015,78612031468_4069_2015,78612031619_4069_2015,78612031702_4069_2015,78612031711_4069_2015,78612031733_4069_2015,78612031734_4069_2015,78612031766_4069_2015,78612031786_4069_2015,78612031806_4069_2015,78612031874_4069_2015,78612031900_4069_2015,78612031983_4069_2015,78612031985_4069_2015,78612032014_4069_2015,78612032020_4069_2015,78612032121_4069_2015,78612032196_4069_2015,78612032199_4069_2015,78612032212_4069_2015,78612032366_4069_2015,78612032402_4069_2015,78612032436_4069_2015,78612032503_4069_2015,78612032536_4069_2015,78612032631_4069_2015,78612032649_4069_2015,78612032741_4069_2015,78612032815_4069_2015,78612032831_4069_2015,78612032903_4069_2015,78612032906_4069_2015,78612032999_4069_2015,78612033028_4069_2015,78612033033_4069_2015,78612033057_4069_2015,78612033086_4069_2015,78612033187_4069_2015,78612033193_4069_2015,78612033199_4069_2015,78612033233_4069_2015,78612033287_4069_2015,78612033295_4069_2015,78612033299_4069_2015,78612033300_4069_2015,78612033301_4069_2015,78612033310_4069_2015,78612033412_4069_2015,78612033435_4069_2015,78612033477_4069_2015,78612033537_4069_2015,78612033691_4069_2015,78612033750_4069_2015,78612033768_4069_2015,78612033852_4069_2015,78612034194_4069_2015,78612034214_4069_2015,78612034232_4069_2015,78612034242_4069_2015,78612034537_4069_2015,78612034559_4069_2015,78612034599_4069_2015,78612034651_4069_2015,78612034680_4069_2015,78612034699_4069_2015,78612034735_4069_2015,78612034848_4069_2015,78612034855_4069_2015,78612034861_4069_2015,78612034954_4069_2015,78612034969_4069_2015,78612035072_4069_2015,78612035183_4069_2015,78612035229_4069_2015,78612035239_4069_2015,78612035251_4069_2015,78612035282_4069_2015,78612035336_4069_2015,78612035339_4069_2015,78612035389_4069_2015,78612035399_4069_2015,78612035497_4069_2015,78612035511_4069_2015,78612035523_4069_2015,78612035532_4069_2015,78612035575_4069_2015,78612035612_4069_2015,78612035680_4069_2015,78612035724_4069_2015,78612035802_4069_2015,78612036099_4069_2015,78612036131_4069_2015,78612036136_4069_2015,78612036183_4069_2015,78612036190_4069_2015,78612036195_4069_2015,78612036231_4069_2015,78612036252_4069_2015,78612036281_4069_2015,78612036283_4069_2015,78612036430_4069_2015,78612036510_4069_2015,78612036554_4069_2015,78612036599_4069_2015,78612036695_4069_2015,78612036810_4069_2015,78612036823_4069_2015,78612036880_4069_2015,78612036889_4069_2015,78612036936_4069_2015,78612036937_4069_2015,78612036969_4069_2015,78612037075_4069_2015,78612037077_4069_2015,78612037145_4069_2015,78612037193_4069_2015,78612037325_4069_2015,78612037329_4069_2015,78612037352_4069_2015,78612037368_4069_2015,78612037373_4069_2015,78612037457_4069_2015,78612037507_4069_2015,78612037616_4069_2015,78612037659_4069_2015,78612037668_4069_2015,78612037707_4069_2015,78612037774_4069_2015,78612037868_4069_2015,78612037900_4069_2015,78612037903_4069_2015,78612037940_4069_2015,78612037982_4069_2015,78612037996_4069_2015,78612038056_4069_2015,78612038085_4069_2015,78612038112_4069_2015,78612038113_4069_2015,78612038119_4069_2015,78612038166_4069_2015,78612038210_4069_2015,78612038246_4069_2015,78612038305_4069_2015,78612038343_4069_2015,78612038382_4069_2015,78612038405_4069_2015,78612038411_4069_2015,78612038450_4069_2015,78612038471_4069_2015,78612038488_4069_2015,78612038509_4069_2015,78612038511_4069_2015,78612038546_4069_2015,78612038594_4069_2015,78612038785_4069_2015,78612038856_4069_2015,78612038924_4069_2015,78612039122_4069_2015,78612039148_4069_2015,78612039173_4069_2015,78612039366_4069_2015,78612039395_4069_2015,78612039495_4069_2015,78612039602_4069_2015,78612039612_4069_2015,78612039629_4069_2015,78612039675_4069_2015,78612039730_4069_2015,78612039791_4069_2015,78612039837_4069_2015,78612039853_4069_2015,78612039862_4069_2015,78612039913_4069_2015,78612039929_4069_2015,78612039945_4069_2015,78612039977_4069_2015,78612040649_4069_2015,78612045184_4069_2015,78612046700_4069_2015,78612046944_4069_2015,78612050349_4069_2015,78612051971_4069_2015,78612057686_4069_2015,78612058164_4069_2015,78612061274_4069_2015,78612066111_4069_2015,78612067349_4069_2015,78612074764_4069_2015,78612075802_4069_2015,78612086285_4069_2015,78612087125_4069_2015,78612087216_4069_2015,78612090902_4069_2015,78612094163_4069_2015,78612097802_4069_2015,78612101044_4069_2015,78612103149_4069_2015,78612105393_4069_2015,78612106566_4069_2015,78612112390_4069_2015,78612112424_4069_2015,78612112449_4069_2015,78612113198_4069_2015,78612122412_4069_2015,78612122649_4069_2015,78612123749_4069_2015,78612123874_4069_2015,78612125339_4069_2015,78612128038_4069_2015,78612131529_4069_2015,78612136049_4069_2015,78612137666_4069_2015,78612143853_4069_2015,78612145105_4069_2015,78612145649_4069_2015,78612148142_4069_2015,78612152547_4069_2015,78612157349_4069_2015,78612159785_4069_2015,78612159865_4069_2015,78612159880_4069_2015,78612160302_4069_2015,78612164394_4069_2015,78612164532_4069_2015,78612167502_4069_2015,78612169994_4069_2015,78612170138_4069_2015,78612172384_4069_2015,78612174102_4069_2015,78612174714_4069_2015,78612176633_4069_2015,78612180535_4069_2015,78612182452_4069_2015,78612182772_4069_2015,78612184002_4069_2015,78612186117_4069_2015,78612187149_4069_2015,78612188415_4069_2015,78612188722_4069_2015,78612195628_4069_2015,78612199629_4069_2015,78612208102_4069_2015,78612224849_4069_2015,78612227888_4069_2015,78612231102_4069_2015,78612237649_4069_2015,78612251749_4069_2015,78612262802_4069_2015,78612263449_4069_2015,78612264149_4069_2015,78612306166_4069_2015,78612306901_4069_2015,78612311976_4069_2015,78612317619_4069_2015,78612318924_4069_2015,78612322490_4069_2015,78612329205_4069_2015,78612330349_4069_2015,78612337064_4069_2015,78612342355_4069_2015,78612350103_4069_2015,78612357553_4069_2015,78612360975_4069_2015,78612364400_4069_2015,78612374549_4069_2015,78612374558_4069_2015,78612376814_4069_2015,78612389345_4069_2015,78612399010_4069_2015,78612399499_4069_2015,78612413187_4069_2015,78612420034_4069_2015,78612429675_4069_2015,78612436325_4069_2015,78612436365_4069_2015,78612441277_4069_2015,78612444001_4069_2015,78612445149_4069_2015,78612450841_4069_2015,78612456150_4069_2015,78612466150_4069_2015,78612472995_4069_2015,78612473702_4069_2015,78612480405_4069_2015,78612480588_4069_2015,78612482020_4069_2015,78612489186_4069_2015,78612499697_4069_2015,78612504832_4069_2015,78612504881_4069_2015,78612507441_4069_2015,78612507449_4069_2015,78612520485_4069_2015,78612522654_4069_2015,78612524892_4069_2015,78612529596_4069_2015,78612539649_4069_2015,78612540303_4069_2015,78612543928_4069_2015,78612544464_4069_2015,78612551318_4069_2015,78612551964_4069_2015,78612559699_4069_2015,78612567601_4069_2015,78612572265_4069_2015,78612572360_4069_2015,78612574749_4069_2015,78612580415_4069_2015,78612582370_4069_2015,78612583010_4069_2015,78612597382_4069_2015,78612606834_4069_2015,78612611085_4069_2015,78612616549_4069_2015,78612620234_4069_2015,78612623085_4069_2015,78612627081_4069_2015,78612627085_4069_2015,78612637549_4069_2015,78612642749_4069_2015,78612646197_4069_2015,78612652002_4069_2015,78612652087_4069_2015,78612664485_4069_2015,78612668485_4069_2015,78612682020_4069_2015,78612704702_4069_2015,78612704749_4069_2015,78612706449_4069_2015,78612709024_4069_2015,78612709714_4069_2015,78612712631_4069_2015,78612712636_4069_2015,78612714849_4069_2015,78612720239_4069_2015,78612722321_4069_2015,78612726564_4069_2015,78612728431_4069_2015,78612729278_4069_2015,78612735420_4069_2015,78612737329_4069_2015,78612739349_4069_2015,78612740202_4069_2015,78612743458_4069_2015,78612752640_4069_2015,78612759102_4069_2015,78612759113_4069_2015,78612759702_4069_2015,78612763238_4069_2015,78612768484_4069_2015,78612772142_4069_2015,78612772977_4069_2015,78612774149_4069_2015,78612775821_4069_2015,78612775911_4069_2015,78612775985_4069_2015,78612776102_4069_2015,78612776549_4069_2015,78612779484_4069_2015,78612780849_4069_2015,78612789925_4069_2015,78612790099_4069_2015,78612792649_4069_2015,78612796349_4069_2015,78612799602_4069_2015,78612803258_4069_2015,78612805178_4069_2015,78612811085_4069_2015,78612826087_4069_2015,78612834549_4069_2015,78612834802_4069_2015,78612836038_4069_2015,78612842849_4069_2015,78612850449_4069_2015,78612850771_4069_2015,78612852717_4069_2015,78612857485_4069_2015,78612857581_4069_2015,78612859785_4069_2015,78612863385_4069_2015,78612872697_4069_2015,78612880410_4069_2015,78612880449_4069_2015,78612881049_4069_2015,78612883579_4069_2015,78612893077_4069_2015,78612895262_4069_2015,78612896202_4069_2015,78612911602_4069_2015,78612941221_4069_2015,78612947902_4069_2015,78612956653_4069_2015,78612964002_4069_2015,78612965532_4069_2015,78612967607_4069_2015,78612978949_4069_2015,78612999221_4069_2015}'::character varying[])
7. 0.003 701.407 ↓ 0.0 0 1

Bitmap Heap Scan on offers_2019_7 (cost=2,721.40..2,722.52 rows=1 width=143) (actual time=701.407..701.407 rows=0 loops=1)

  • Recheck Cond: (hashes @> '{78612031749_4069_2015,78612002687_4069_2015,78612012480_4069_2015,78612014849_4069_2015,78612014949_4069_2015,78612023917_4069_2015,78612027187_4069_2015,78612030037_4069_2015,78612030056_4069_2015,78612030088_4069_2015,78612030136_4069_2015,78612030151_4069_2015,78612030217_4069_2015,78612030285_4069_2015,78612030310_4069_2015,78612030316_4069_2015,78612030332_4069_2015,78612030335_4069_2015,78612030350_4069_2015,78612030354_4069_2015,78612030359_4069_2015,78612030382_4069_2015,78612030410_4069_2015,78612030437_4069_2015,78612030481_4069_2015,78612030482_4069_2015,78612030492_4069_2015,78612030582_4069_2015,78612030612_4069_2015,78612030645_4069_2015,78612030667_4069_2015,78612030676_4069_2015,78612030677_4069_2015,78612030755_4069_2015,78612030860_4069_2015,78612030979_4069_2015,78612031011_4069_2015,78612031051_4069_2015,78612031056_4069_2015,78612031290_4069_2015,78612031412_4069_2015,78612031468_4069_2015,78612031619_4069_2015,78612031702_4069_2015,78612031711_4069_2015,78612031733_4069_2015,78612031734_4069_2015,78612031766_4069_2015,78612031786_4069_2015,78612031806_4069_2015,78612031874_4069_2015,78612031900_4069_2015,78612031983_4069_2015,78612031985_4069_2015,78612032014_4069_2015,78612032020_4069_2015,78612032121_4069_2015,78612032196_4069_2015,78612032199_4069_2015,78612032212_4069_2015,78612032366_4069_2015,78612032402_4069_2015,78612032436_4069_2015,78612032503_4069_2015,78612032536_4069_2015,78612032631_4069_2015,78612032649_4069_2015,78612032741_4069_2015,78612032815_4069_2015,78612032831_4069_2015,78612032903_4069_2015,78612032906_4069_2015,78612032999_4069_2015,78612033028_4069_2015,78612033033_4069_2015,78612033057_4069_2015,78612033086_4069_2015,78612033187_4069_2015,78612033193_4069_2015,78612033199_4069_2015,78612033233_4069_2015,78612033287_4069_2015,78612033295_4069_2015,78612033299_4069_2015,78612033300_4069_2015,78612033301_4069_2015,78612033310_4069_2015,78612033412_4069_2015,78612033435_4069_2015,78612033477_4069_2015,78612033537_4069_2015,78612033691_4069_2015,78612033750_4069_2015,78612033768_4069_2015,78612033852_4069_2015,78612034194_4069_2015,78612034214_4069_2015,78612034232_4069_2015,78612034242_4069_2015,78612034537_4069_2015,78612034559_4069_2015,78612034599_4069_2015,78612034651_4069_2015,78612034680_4069_2015,78612034699_4069_2015,78612034735_4069_2015,78612034848_4069_2015,78612034855_4069_2015,78612034861_4069_2015,78612034954_4069_2015,78612034969_4069_2015,78612035072_4069_2015,78612035183_4069_2015,78612035229_4069_2015,78612035239_4069_2015,78612035251_4069_2015,78612035282_4069_2015,78612035336_4069_2015,78612035339_4069_2015,78612035389_4069_2015,78612035399_4069_2015,78612035497_4069_2015,78612035511_4069_2015,78612035523_4069_2015,78612035532_4069_2015,78612035575_4069_2015,78612035612_4069_2015,78612035680_4069_2015,78612035724_4069_2015,78612035802_4069_2015,78612036099_4069_2015,78612036131_4069_2015,78612036136_4069_2015,78612036183_4069_2015,78612036190_4069_2015,78612036195_4069_2015,78612036231_4069_2015,78612036252_4069_2015,78612036281_4069_2015,78612036283_4069_2015,78612036430_4069_2015,78612036510_4069_2015,78612036554_4069_2015,78612036599_4069_2015,78612036695_4069_2015,78612036810_4069_2015,78612036823_4069_2015,78612036880_4069_2015,78612036889_4069_2015,78612036936_4069_2015,78612036937_4069_2015,78612036969_4069_2015,78612037075_4069_2015,78612037077_4069_2015,78612037145_4069_2015,78612037193_4069_2015,78612037325_4069_2015,78612037329_4069_2015,78612037352_4069_2015,78612037368_4069_2015,78612037373_4069_2015,78612037457_4069_2015,78612037507_4069_2015,78612037616_4069_2015,78612037659_4069_2015,78612037668_4069_2015,78612037707_4069_2015,78612037774_4069_2015,78612037868_4069_2015,78612037900_4069_2015,78612037903_4069_2015,78612037940_4069_2015,78612037982_4069_2015,78612037996_4069_2015,78612038056_4069_2015,78612038085_4069_2015,78612038112_4069_2015,78612038113_4069_2015,78612038119_4069_2015,78612038166_4069_2015,78612038210_4069_2015,78612038246_4069_2015,78612038305_4069_2015,78612038343_4069_2015,78612038382_4069_2015,78612038405_4069_2015,78612038411_4069_2015,78612038450_4069_2015,78612038471_4069_2015,78612038488_4069_2015,78612038509_4069_2015,78612038511_4069_2015,78612038546_4069_2015,78612038594_4069_2015,78612038785_4069_2015,78612038856_4069_2015,78612038924_4069_2015,78612039122_4069_2015,78612039148_4069_2015,78612039173_4069_2015,78612039366_4069_2015,78612039395_4069_2015,78612039495_4069_2015,78612039602_4069_2015,78612039612_4069_2015,78612039629_4069_2015,78612039675_4069_2015,78612039730_4069_2015,78612039791_4069_2015,78612039837_4069_2015,78612039853_4069_2015,78612039862_4069_2015,78612039913_4069_2015,78612039929_4069_2015,78612039945_4069_2015,78612039977_4069_2015,78612040649_4069_2015,78612045184_4069_2015,78612046700_4069_2015,78612046944_4069_2015,78612050349_4069_2015,78612051971_4069_2015,78612057686_4069_2015,78612058164_4069_2015,78612061274_4069_2015,78612066111_4069_2015,78612067349_4069_2015,78612074764_4069_2015,78612075802_4069_2015,78612086285_4069_2015,78612087125_4069_2015,78612087216_4069_2015,78612090902_4069_2015,78612094163_4069_2015,78612097802_4069_2015,78612101044_4069_2015,78612103149_4069_2015,78612105393_4069_2015,78612106566_4069_2015,78612112390_4069_2015,78612112424_4069_2015,78612112449_4069_2015,78612113198_4069_2015,78612122412_4069_2015,78612122649_4069_2015,78612123749_4069_2015,78612123874_4069_2015,78612125339_4069_2015,78612128038_4069_2015,78612131529_4069_2015,78612136049_4069_2015,78612137666_4069_2015,78612143853_4069_2015,78612145105_4069_2015,78612145649_4069_2015,78612148142_4069_2015,78612152547_4069_2015,78612157349_4069_2015,78612159785_4069_2015,78612159865_4069_2015,78612159880_4069_2015,78612160302_4069_2015,78612164394_4069_2015,78612164532_4069_2015,78612167502_4069_2015,78612169994_4069_2015,78612170138_4069_2015,78612172384_4069_2015,78612174102_4069_2015,78612174714_4069_2015,78612176633_4069_2015,78612180535_4069_2015,78612182452_4069_2015,78612182772_4069_2015,78612184002_4069_2015,78612186117_4069_2015,78612187149_4069_2015,78612188415_4069_2015,78612188722_4069_2015,78612195628_4069_2015,78612199629_4069_2015,78612208102_4069_2015,78612224849_4069_2015,78612227888_4069_2015,78612231102_4069_2015,78612237649_4069_2015,78612251749_4069_2015,78612262802_4069_2015,78612263449_4069_2015,78612264149_4069_2015,78612306166_4069_2015,78612306901_4069_2015,78612311976_4069_2015,78612317619_4069_2015,78612318924_4069_2015,78612322490_4069_2015,78612329205_4069_2015,78612330349_4069_2015,78612337064_4069_2015,78612342355_4069_2015,78612350103_4069_2015,78612357553_4069_2015,78612360975_4069_2015,78612364400_4069_2015,78612374549_4069_2015,78612374558_4069_2015,78612376814_4069_2015,78612389345_4069_2015,78612399010_4069_2015,78612399499_4069_2015,78612413187_4069_2015,78612420034_4069_2015,78612429675_4069_2015,78612436325_4069_2015,78612436365_4069_2015,78612441277_4069_2015,78612444001_4069_2015,78612445149_4069_2015,78612450841_4069_2015,78612456150_4069_2015,78612466150_4069_2015,78612472995_4069_2015,78612473702_4069_2015,78612480405_4069_2015,78612480588_4069_2015,78612482020_4069_2015,78612489186_4069_2015,78612499697_4069_2015,78612504832_4069_2015,78612504881_4069_2015,78612507441_4069_2015,78612507449_4069_2015,78612520485_4069_2015,78612522654_4069_2015,78612524892_4069_2015,78612529596_4069_2015,78612539649_4069_2015,78612540303_4069_2015,78612543928_4069_2015,78612544464_4069_2015,78612551318_4069_2015,78612551964_4069_2015,78612559699_4069_2015,78612567601_4069_2015,78612572265_4069_2015,78612572360_4069_2015,78612574749_4069_2015,78612580415_4069_2015,78612582370_4069_2015,78612583010_4069_2015,78612597382_4069_2015,78612606834_4069_2015,78612611085_4069_2015,78612616549_4069_2015,78612620234_4069_2015,78612623085_4069_2015,78612627081_4069_2015,78612627085_4069_2015,78612637549_4069_2015,78612642749_4069_2015,78612646197_4069_2015,78612652002_4069_2015,78612652087_4069_2015,78612664485_4069_2015,78612668485_4069_2015,78612682020_4069_2015,78612704702_4069_2015,78612704749_4069_2015,78612706449_4069_2015,78612709024_4069_2015,78612709714_4069_2015,78612712631_4069_2015,78612712636_4069_2015,78612714849_4069_2015,78612720239_4069_2015,78612722321_4069_2015,78612726564_4069_2015,78612728431_4069_2015,78612729278_4069_2015,78612735420_4069_2015,78612737329_4069_2015,78612739349_4069_2015,78612740202_4069_2015,78612743458_4069_2015,78612752640_4069_2015,78612759102_4069_2015,78612759113_4069_2015,78612759702_4069_2015,78612763238_4069_2015,78612768484_4069_2015,78612772142_4069_2015,78612772977_4069_2015,78612774149_4069_2015,78612775821_4069_2015,78612775911_4069_2015,78612775985_4069_2015,78612776102_4069_2015,78612776549_4069_2015,78612779484_4069_2015,78612780849_4069_2015,78612789925_4069_2015,78612790099_4069_2015,78612792649_4069_2015,78612796349_4069_2015,78612799602_4069_2015,78612803258_4069_2015,78612805178_4069_2015,78612811085_4069_2015,78612826087_4069_2015,78612834549_4069_2015,78612834802_4069_2015,78612836038_4069_2015,78612842849_4069_2015,78612850449_4069_2015,78612850771_4069_2015,78612852717_4069_2015,78612857485_4069_2015,78612857581_4069_2015,78612859785_4069_2015,78612863385_4069_2015,78612872697_4069_2015,78612880410_4069_2015,78612880449_4069_2015,78612881049_4069_2015,78612883579_4069_2015,78612893077_4069_2015,78612895262_4069_2015,78612896202_4069_2015,78612911602_4069_2015,78612941221_4069_2015,78612947902_4069_2015,78612956653_4069_2015,78612964002_4069_2015,78612965532_4069_2015,78612967607_4069_2015,78612978949_4069_2015,78612999221_4069_2015}'::character varying[])
  • Filter: ((created_at >= '2019-05-05 15:16:49'::timestamp without time zone) AND (id <> 63908383))
8. 701.404 701.404 ↓ 0.0 0 1

Bitmap Index Scan on offers_2019_7_hashes (cost=0.00..2,721.40 rows=1 width=0) (actual time=701.403..701.404 rows=0 loops=1)

  • Index Cond: (hashes @> '{78612031749_4069_2015,78612002687_4069_2015,78612012480_4069_2015,78612014849_4069_2015,78612014949_4069_2015,78612023917_4069_2015,78612027187_4069_2015,78612030037_4069_2015,78612030056_4069_2015,78612030088_4069_2015,78612030136_4069_2015,78612030151_4069_2015,78612030217_4069_2015,78612030285_4069_2015,78612030310_4069_2015,78612030316_4069_2015,78612030332_4069_2015,78612030335_4069_2015,78612030350_4069_2015,78612030354_4069_2015,78612030359_4069_2015,78612030382_4069_2015,78612030410_4069_2015,78612030437_4069_2015,78612030481_4069_2015,78612030482_4069_2015,78612030492_4069_2015,78612030582_4069_2015,78612030612_4069_2015,78612030645_4069_2015,78612030667_4069_2015,78612030676_4069_2015,78612030677_4069_2015,78612030755_4069_2015,78612030860_4069_2015,78612030979_4069_2015,78612031011_4069_2015,78612031051_4069_2015,78612031056_4069_2015,78612031290_4069_2015,78612031412_4069_2015,78612031468_4069_2015,78612031619_4069_2015,78612031702_4069_2015,78612031711_4069_2015,78612031733_4069_2015,78612031734_4069_2015,78612031766_4069_2015,78612031786_4069_2015,78612031806_4069_2015,78612031874_4069_2015,78612031900_4069_2015,78612031983_4069_2015,78612031985_4069_2015,78612032014_4069_2015,78612032020_4069_2015,78612032121_4069_2015,78612032196_4069_2015,78612032199_4069_2015,78612032212_4069_2015,78612032366_4069_2015,78612032402_4069_2015,78612032436_4069_2015,78612032503_4069_2015,78612032536_4069_2015,78612032631_4069_2015,78612032649_4069_2015,78612032741_4069_2015,78612032815_4069_2015,78612032831_4069_2015,78612032903_4069_2015,78612032906_4069_2015,78612032999_4069_2015,78612033028_4069_2015,78612033033_4069_2015,78612033057_4069_2015,78612033086_4069_2015,78612033187_4069_2015,78612033193_4069_2015,78612033199_4069_2015,78612033233_4069_2015,78612033287_4069_2015,78612033295_4069_2015,78612033299_4069_2015,78612033300_4069_2015,78612033301_4069_2015,78612033310_4069_2015,78612033412_4069_2015,78612033435_4069_2015,78612033477_4069_2015,78612033537_4069_2015,78612033691_4069_2015,78612033750_4069_2015,78612033768_4069_2015,78612033852_4069_2015,78612034194_4069_2015,78612034214_4069_2015,78612034232_4069_2015,78612034242_4069_2015,78612034537_4069_2015,78612034559_4069_2015,78612034599_4069_2015,78612034651_4069_2015,78612034680_4069_2015,78612034699_4069_2015,78612034735_4069_2015,78612034848_4069_2015,78612034855_4069_2015,78612034861_4069_2015,78612034954_4069_2015,78612034969_4069_2015,78612035072_4069_2015,78612035183_4069_2015,78612035229_4069_2015,78612035239_4069_2015,78612035251_4069_2015,78612035282_4069_2015,78612035336_4069_2015,78612035339_4069_2015,78612035389_4069_2015,78612035399_4069_2015,78612035497_4069_2015,78612035511_4069_2015,78612035523_4069_2015,78612035532_4069_2015,78612035575_4069_2015,78612035612_4069_2015,78612035680_4069_2015,78612035724_4069_2015,78612035802_4069_2015,78612036099_4069_2015,78612036131_4069_2015,78612036136_4069_2015,78612036183_4069_2015,78612036190_4069_2015,78612036195_4069_2015,78612036231_4069_2015,78612036252_4069_2015,78612036281_4069_2015,78612036283_4069_2015,78612036430_4069_2015,78612036510_4069_2015,78612036554_4069_2015,78612036599_4069_2015,78612036695_4069_2015,78612036810_4069_2015,78612036823_4069_2015,78612036880_4069_2015,78612036889_4069_2015,78612036936_4069_2015,78612036937_4069_2015,78612036969_4069_2015,78612037075_4069_2015,78612037077_4069_2015,78612037145_4069_2015,78612037193_4069_2015,78612037325_4069_2015,78612037329_4069_2015,78612037352_4069_2015,78612037368_4069_2015,78612037373_4069_2015,78612037457_4069_2015,78612037507_4069_2015,78612037616_4069_2015,78612037659_4069_2015,78612037668_4069_2015,78612037707_4069_2015,78612037774_4069_2015,78612037868_4069_2015,78612037900_4069_2015,78612037903_4069_2015,78612037940_4069_2015,78612037982_4069_2015,78612037996_4069_2015,78612038056_4069_2015,78612038085_4069_2015,78612038112_4069_2015,78612038113_4069_2015,78612038119_4069_2015,78612038166_4069_2015,78612038210_4069_2015,78612038246_4069_2015,78612038305_4069_2015,78612038343_4069_2015,78612038382_4069_2015,78612038405_4069_2015,78612038411_4069_2015,78612038450_4069_2015,78612038471_4069_2015,78612038488_4069_2015,78612038509_4069_2015,78612038511_4069_2015,78612038546_4069_2015,78612038594_4069_2015,78612038785_4069_2015,78612038856_4069_2015,78612038924_4069_2015,78612039122_4069_2015,78612039148_4069_2015,78612039173_4069_2015,78612039366_4069_2015,78612039395_4069_2015,78612039495_4069_2015,78612039602_4069_2015,78612039612_4069_2015,78612039629_4069_2015,78612039675_4069_2015,78612039730_4069_2015,78612039791_4069_2015,78612039837_4069_2015,78612039853_4069_2015,78612039862_4069_2015,78612039913_4069_2015,78612039929_4069_2015,78612039945_4069_2015,78612039977_4069_2015,78612040649_4069_2015,78612045184_4069_2015,78612046700_4069_2015,78612046944_4069_2015,78612050349_4069_2015,78612051971_4069_2015,78612057686_4069_2015,78612058164_4069_2015,78612061274_4069_2015,78612066111_4069_2015,78612067349_4069_2015,78612074764_4069_2015,78612075802_4069_2015,78612086285_4069_2015,78612087125_4069_2015,78612087216_4069_2015,78612090902_4069_2015,78612094163_4069_2015,78612097802_4069_2015,78612101044_4069_2015,78612103149_4069_2015,78612105393_4069_2015,78612106566_4069_2015,78612112390_4069_2015,78612112424_4069_2015,78612112449_4069_2015,78612113198_4069_2015,78612122412_4069_2015,78612122649_4069_2015,78612123749_4069_2015,78612123874_4069_2015,78612125339_4069_2015,78612128038_4069_2015,78612131529_4069_2015,78612136049_4069_2015,78612137666_4069_2015,78612143853_4069_2015,78612145105_4069_2015,78612145649_4069_2015,78612148142_4069_2015,78612152547_4069_2015,78612157349_4069_2015,78612159785_4069_2015,78612159865_4069_2015,78612159880_4069_2015,78612160302_4069_2015,78612164394_4069_2015,78612164532_4069_2015,78612167502_4069_2015,78612169994_4069_2015,78612170138_4069_2015,78612172384_4069_2015,78612174102_4069_2015,78612174714_4069_2015,78612176633_4069_2015,78612180535_4069_2015,78612182452_4069_2015,78612182772_4069_2015,78612184002_4069_2015,78612186117_4069_2015,78612187149_4069_2015,78612188415_4069_2015,78612188722_4069_2015,78612195628_4069_2015,78612199629_4069_2015,78612208102_4069_2015,78612224849_4069_2015,78612227888_4069_2015,78612231102_4069_2015,78612237649_4069_2015,78612251749_4069_2015,78612262802_4069_2015,78612263449_4069_2015,78612264149_4069_2015,78612306166_4069_2015,78612306901_4069_2015,78612311976_4069_2015,78612317619_4069_2015,78612318924_4069_2015,78612322490_4069_2015,78612329205_4069_2015,78612330349_4069_2015,78612337064_4069_2015,78612342355_4069_2015,78612350103_4069_2015,78612357553_4069_2015,78612360975_4069_2015,78612364400_4069_2015,78612374549_4069_2015,78612374558_4069_2015,78612376814_4069_2015,78612389345_4069_2015,78612399010_4069_2015,78612399499_4069_2015,78612413187_4069_2015,78612420034_4069_2015,78612429675_4069_2015,78612436325_4069_2015,78612436365_4069_2015,78612441277_4069_2015,78612444001_4069_2015,78612445149_4069_2015,78612450841_4069_2015,78612456150_4069_2015,78612466150_4069_2015,78612472995_4069_2015,78612473702_4069_2015,78612480405_4069_2015,78612480588_4069_2015,78612482020_4069_2015,78612489186_4069_2015,78612499697_4069_2015,78612504832_4069_2015,78612504881_4069_2015,78612507441_4069_2015,78612507449_4069_2015,78612520485_4069_2015,78612522654_4069_2015,78612524892_4069_2015,78612529596_4069_2015,78612539649_4069_2015,78612540303_4069_2015,78612543928_4069_2015,78612544464_4069_2015,78612551318_4069_2015,78612551964_4069_2015,78612559699_4069_2015,78612567601_4069_2015,78612572265_4069_2015,78612572360_4069_2015,78612574749_4069_2015,78612580415_4069_2015,78612582370_4069_2015,78612583010_4069_2015,78612597382_4069_2015,78612606834_4069_2015,78612611085_4069_2015,78612616549_4069_2015,78612620234_4069_2015,78612623085_4069_2015,78612627081_4069_2015,78612627085_4069_2015,78612637549_4069_2015,78612642749_4069_2015,78612646197_4069_2015,78612652002_4069_2015,78612652087_4069_2015,78612664485_4069_2015,78612668485_4069_2015,78612682020_4069_2015,78612704702_4069_2015,78612704749_4069_2015,78612706449_4069_2015,78612709024_4069_2015,78612709714_4069_2015,78612712631_4069_2015,78612712636_4069_2015,78612714849_4069_2015,78612720239_4069_2015,78612722321_4069_2015,78612726564_4069_2015,78612728431_4069_2015,78612729278_4069_2015,78612735420_4069_2015,78612737329_4069_2015,78612739349_4069_2015,78612740202_4069_2015,78612743458_4069_2015,78612752640_4069_2015,78612759102_4069_2015,78612759113_4069_2015,78612759702_4069_2015,78612763238_4069_2015,78612768484_4069_2015,78612772142_4069_2015,78612772977_4069_2015,78612774149_4069_2015,78612775821_4069_2015,78612775911_4069_2015,78612775985_4069_2015,78612776102_4069_2015,78612776549_4069_2015,78612779484_4069_2015,78612780849_4069_2015,78612789925_4069_2015,78612790099_4069_2015,78612792649_4069_2015,78612796349_4069_2015,78612799602_4069_2015,78612803258_4069_2015,78612805178_4069_2015,78612811085_4069_2015,78612826087_4069_2015,78612834549_4069_2015,78612834802_4069_2015,78612836038_4069_2015,78612842849_4069_2015,78612850449_4069_2015,78612850771_4069_2015,78612852717_4069_2015,78612857485_4069_2015,78612857581_4069_2015,78612859785_4069_2015,78612863385_4069_2015,78612872697_4069_2015,78612880410_4069_2015,78612880449_4069_2015,78612881049_4069_2015,78612883579_4069_2015,78612893077_4069_2015,78612895262_4069_2015,78612896202_4069_2015,78612911602_4069_2015,78612941221_4069_2015,78612947902_4069_2015,78612956653_4069_2015,78612964002_4069_2015,78612965532_4069_2015,78612967607_4069_2015,78612978949_4069_2015,78612999221_4069_2015}'::character varying[])
9. 0.034 1,103.849 ↓ 2.0 2 1

Bitmap Heap Scan on offers_2019_8 (cost=2,904.00..2,905.12 rows=1 width=142) (actual time=1,103.842..1,103.849 rows=2 loops=1)

  • Recheck Cond: (hashes @> '{78612031749_4069_2015,78612002687_4069_2015,78612012480_4069_2015,78612014849_4069_2015,78612014949_4069_2015,78612023917_4069_2015,78612027187_4069_2015,78612030037_4069_2015,78612030056_4069_2015,78612030088_4069_2015,78612030136_4069_2015,78612030151_4069_2015,78612030217_4069_2015,78612030285_4069_2015,78612030310_4069_2015,78612030316_4069_2015,78612030332_4069_2015,78612030335_4069_2015,78612030350_4069_2015,78612030354_4069_2015,78612030359_4069_2015,78612030382_4069_2015,78612030410_4069_2015,78612030437_4069_2015,78612030481_4069_2015,78612030482_4069_2015,78612030492_4069_2015,78612030582_4069_2015,78612030612_4069_2015,78612030645_4069_2015,78612030667_4069_2015,78612030676_4069_2015,78612030677_4069_2015,78612030755_4069_2015,78612030860_4069_2015,78612030979_4069_2015,78612031011_4069_2015,78612031051_4069_2015,78612031056_4069_2015,78612031290_4069_2015,78612031412_4069_2015,78612031468_4069_2015,78612031619_4069_2015,78612031702_4069_2015,78612031711_4069_2015,78612031733_4069_2015,78612031734_4069_2015,78612031766_4069_2015,78612031786_4069_2015,78612031806_4069_2015,78612031874_4069_2015,78612031900_4069_2015,78612031983_4069_2015,78612031985_4069_2015,78612032014_4069_2015,78612032020_4069_2015,78612032121_4069_2015,78612032196_4069_2015,78612032199_4069_2015,78612032212_4069_2015,78612032366_4069_2015,78612032402_4069_2015,78612032436_4069_2015,78612032503_4069_2015,78612032536_4069_2015,78612032631_4069_2015,78612032649_4069_2015,78612032741_4069_2015,78612032815_4069_2015,78612032831_4069_2015,78612032903_4069_2015,78612032906_4069_2015,78612032999_4069_2015,78612033028_4069_2015,78612033033_4069_2015,78612033057_4069_2015,78612033086_4069_2015,78612033187_4069_2015,78612033193_4069_2015,78612033199_4069_2015,78612033233_4069_2015,78612033287_4069_2015,78612033295_4069_2015,78612033299_4069_2015,78612033300_4069_2015,78612033301_4069_2015,78612033310_4069_2015,78612033412_4069_2015,78612033435_4069_2015,78612033477_4069_2015,78612033537_4069_2015,78612033691_4069_2015,78612033750_4069_2015,78612033768_4069_2015,78612033852_4069_2015,78612034194_4069_2015,78612034214_4069_2015,78612034232_4069_2015,78612034242_4069_2015,78612034537_4069_2015,78612034559_4069_2015,78612034599_4069_2015,78612034651_4069_2015,78612034680_4069_2015,78612034699_4069_2015,78612034735_4069_2015,78612034848_4069_2015,78612034855_4069_2015,78612034861_4069_2015,78612034954_4069_2015,78612034969_4069_2015,78612035072_4069_2015,78612035183_4069_2015,78612035229_4069_2015,78612035239_4069_2015,78612035251_4069_2015,78612035282_4069_2015,78612035336_4069_2015,78612035339_4069_2015,78612035389_4069_2015,78612035399_4069_2015,78612035497_4069_2015,78612035511_4069_2015,78612035523_4069_2015,78612035532_4069_2015,78612035575_4069_2015,78612035612_4069_2015,78612035680_4069_2015,78612035724_4069_2015,78612035802_4069_2015,78612036099_4069_2015,78612036131_4069_2015,78612036136_4069_2015,78612036183_4069_2015,78612036190_4069_2015,78612036195_4069_2015,78612036231_4069_2015,78612036252_4069_2015,78612036281_4069_2015,78612036283_4069_2015,78612036430_4069_2015,78612036510_4069_2015,78612036554_4069_2015,78612036599_4069_2015,78612036695_4069_2015,78612036810_4069_2015,78612036823_4069_2015,78612036880_4069_2015,78612036889_4069_2015,78612036936_4069_2015,78612036937_4069_2015,78612036969_4069_2015,78612037075_4069_2015,78612037077_4069_2015,78612037145_4069_2015,78612037193_4069_2015,78612037325_4069_2015,78612037329_4069_2015,78612037352_4069_2015,78612037368_4069_2015,78612037373_4069_2015,78612037457_4069_2015,78612037507_4069_2015,78612037616_4069_2015,78612037659_4069_2015,78612037668_4069_2015,78612037707_4069_2015,78612037774_4069_2015,78612037868_4069_2015,78612037900_4069_2015,78612037903_4069_2015,78612037940_4069_2015,78612037982_4069_2015,78612037996_4069_2015,78612038056_4069_2015,78612038085_4069_2015,78612038112_4069_2015,78612038113_4069_2015,78612038119_4069_2015,78612038166_4069_2015,78612038210_4069_2015,78612038246_4069_2015,78612038305_4069_2015,78612038343_4069_2015,78612038382_4069_2015,78612038405_4069_2015,78612038411_4069_2015,78612038450_4069_2015,78612038471_4069_2015,78612038488_4069_2015,78612038509_4069_2015,78612038511_4069_2015,78612038546_4069_2015,78612038594_4069_2015,78612038785_4069_2015,78612038856_4069_2015,78612038924_4069_2015,78612039122_4069_2015,78612039148_4069_2015,78612039173_4069_2015,78612039366_4069_2015,78612039395_4069_2015,78612039495_4069_2015,78612039602_4069_2015,78612039612_4069_2015,78612039629_4069_2015,78612039675_4069_2015,78612039730_4069_2015,78612039791_4069_2015,78612039837_4069_2015,78612039853_4069_2015,78612039862_4069_2015,78612039913_4069_2015,78612039929_4069_2015,78612039945_4069_2015,78612039977_4069_2015,78612040649_4069_2015,78612045184_4069_2015,78612046700_4069_2015,78612046944_4069_2015,78612050349_4069_2015,78612051971_4069_2015,78612057686_4069_2015,78612058164_4069_2015,78612061274_4069_2015,78612066111_4069_2015,78612067349_4069_2015,78612074764_4069_2015,78612075802_4069_2015,78612086285_4069_2015,78612087125_4069_2015,78612087216_4069_2015,78612090902_4069_2015,78612094163_4069_2015,78612097802_4069_2015,78612101044_4069_2015,78612103149_4069_2015,78612105393_4069_2015,78612106566_4069_2015,78612112390_4069_2015,78612112424_4069_2015,78612112449_4069_2015,78612113198_4069_2015,78612122412_4069_2015,78612122649_4069_2015,78612123749_4069_2015,78612123874_4069_2015,78612125339_4069_2015,78612128038_4069_2015,78612131529_4069_2015,78612136049_4069_2015,78612137666_4069_2015,78612143853_4069_2015,78612145105_4069_2015,78612145649_4069_2015,78612148142_4069_2015,78612152547_4069_2015,78612157349_4069_2015,78612159785_4069_2015,78612159865_4069_2015,78612159880_4069_2015,78612160302_4069_2015,78612164394_4069_2015,78612164532_4069_2015,78612167502_4069_2015,78612169994_4069_2015,78612170138_4069_2015,78612172384_4069_2015,78612174102_4069_2015,78612174714_4069_2015,78612176633_4069_2015,78612180535_4069_2015,78612182452_4069_2015,78612182772_4069_2015,78612184002_4069_2015,78612186117_4069_2015,78612187149_4069_2015,78612188415_4069_2015,78612188722_4069_2015,78612195628_4069_2015,78612199629_4069_2015,78612208102_4069_2015,78612224849_4069_2015,78612227888_4069_2015,78612231102_4069_2015,78612237649_4069_2015,78612251749_4069_2015,78612262802_4069_2015,78612263449_4069_2015,78612264149_4069_2015,78612306166_4069_2015,78612306901_4069_2015,78612311976_4069_2015,78612317619_4069_2015,78612318924_4069_2015,78612322490_4069_2015,78612329205_4069_2015,78612330349_4069_2015,78612337064_4069_2015,78612342355_4069_2015,78612350103_4069_2015,78612357553_4069_2015,78612360975_4069_2015,78612364400_4069_2015,78612374549_4069_2015,78612374558_4069_2015,78612376814_4069_2015,78612389345_4069_2015,78612399010_4069_2015,78612399499_4069_2015,78612413187_4069_2015,78612420034_4069_2015,78612429675_4069_2015,78612436325_4069_2015,78612436365_4069_2015,78612441277_4069_2015,78612444001_4069_2015,78612445149_4069_2015,78612450841_4069_2015,78612456150_4069_2015,78612466150_4069_2015,78612472995_4069_2015,78612473702_4069_2015,78612480405_4069_2015,78612480588_4069_2015,78612482020_4069_2015,78612489186_4069_2015,78612499697_4069_2015,78612504832_4069_2015,78612504881_4069_2015,78612507441_4069_2015,78612507449_4069_2015,78612520485_4069_2015,78612522654_4069_2015,78612524892_4069_2015,78612529596_4069_2015,78612539649_4069_2015,78612540303_4069_2015,78612543928_4069_2015,78612544464_4069_2015,78612551318_4069_2015,78612551964_4069_2015,78612559699_4069_2015,78612567601_4069_2015,78612572265_4069_2015,78612572360_4069_2015,78612574749_4069_2015,78612580415_4069_2015,78612582370_4069_2015,78612583010_4069_2015,78612597382_4069_2015,78612606834_4069_2015,78612611085_4069_2015,78612616549_4069_2015,78612620234_4069_2015,78612623085_4069_2015,78612627081_4069_2015,78612627085_4069_2015,78612637549_4069_2015,78612642749_4069_2015,78612646197_4069_2015,78612652002_4069_2015,78612652087_4069_2015,78612664485_4069_2015,78612668485_4069_2015,78612682020_4069_2015,78612704702_4069_2015,78612704749_4069_2015,78612706449_4069_2015,78612709024_4069_2015,78612709714_4069_2015,78612712631_4069_2015,78612712636_4069_2015,78612714849_4069_2015,78612720239_4069_2015,78612722321_4069_2015,78612726564_4069_2015,78612728431_4069_2015,78612729278_4069_2015,78612735420_4069_2015,78612737329_4069_2015,78612739349_4069_2015,78612740202_4069_2015,78612743458_4069_2015,78612752640_4069_2015,78612759102_4069_2015,78612759113_4069_2015,78612759702_4069_2015,78612763238_4069_2015,78612768484_4069_2015,78612772142_4069_2015,78612772977_4069_2015,78612774149_4069_2015,78612775821_4069_2015,78612775911_4069_2015,78612775985_4069_2015,78612776102_4069_2015,78612776549_4069_2015,78612779484_4069_2015,78612780849_4069_2015,78612789925_4069_2015,78612790099_4069_2015,78612792649_4069_2015,78612796349_4069_2015,78612799602_4069_2015,78612803258_4069_2015,78612805178_4069_2015,78612811085_4069_2015,78612826087_4069_2015,78612834549_4069_2015,78612834802_4069_2015,78612836038_4069_2015,78612842849_4069_2015,78612850449_4069_2015,78612850771_4069_2015,78612852717_4069_2015,78612857485_4069_2015,78612857581_4069_2015,78612859785_4069_2015,78612863385_4069_2015,78612872697_4069_2015,78612880410_4069_2015,78612880449_4069_2015,78612881049_4069_2015,78612883579_4069_2015,78612893077_4069_2015,78612895262_4069_2015,78612896202_4069_2015,78612911602_4069_2015,78612941221_4069_2015,78612947902_4069_2015,78612956653_4069_2015,78612964002_4069_2015,78612965532_4069_2015,78612967607_4069_2015,78612978949_4069_2015,78612999221_4069_2015}'::character varying[])
  • Filter: ((created_at >= '2019-05-05 15:16:49'::timestamp without time zone) AND (id <> 63908383))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=3
10. 1,103.815 1,103.815 ↓ 3.0 3 1

Bitmap Index Scan on offers_2019_8_hashes (cost=0.00..2,904.00 rows=1 width=0) (actual time=1,103.815..1,103.815 rows=3 loops=1)

  • Index Cond: (hashes @> '{78612031749_4069_2015,78612002687_4069_2015,78612012480_4069_2015,78612014849_4069_2015,78612014949_4069_2015,78612023917_4069_2015,78612027187_4069_2015,78612030037_4069_2015,78612030056_4069_2015,78612030088_4069_2015,78612030136_4069_2015,78612030151_4069_2015,78612030217_4069_2015,78612030285_4069_2015,78612030310_4069_2015,78612030316_4069_2015,78612030332_4069_2015,78612030335_4069_2015,78612030350_4069_2015,78612030354_4069_2015,78612030359_4069_2015,78612030382_4069_2015,78612030410_4069_2015,78612030437_4069_2015,78612030481_4069_2015,78612030482_4069_2015,78612030492_4069_2015,78612030582_4069_2015,78612030612_4069_2015,78612030645_4069_2015,78612030667_4069_2015,78612030676_4069_2015,78612030677_4069_2015,78612030755_4069_2015,78612030860_4069_2015,78612030979_4069_2015,78612031011_4069_2015,78612031051_4069_2015,78612031056_4069_2015,78612031290_4069_2015,78612031412_4069_2015,78612031468_4069_2015,78612031619_4069_2015,78612031702_4069_2015,78612031711_4069_2015,78612031733_4069_2015,78612031734_4069_2015,78612031766_4069_2015,78612031786_4069_2015,78612031806_4069_2015,78612031874_4069_2015,78612031900_4069_2015,78612031983_4069_2015,78612031985_4069_2015,78612032014_4069_2015,78612032020_4069_2015,78612032121_4069_2015,78612032196_4069_2015,78612032199_4069_2015,78612032212_4069_2015,78612032366_4069_2015,78612032402_4069_2015,78612032436_4069_2015,78612032503_4069_2015,78612032536_4069_2015,78612032631_4069_2015,78612032649_4069_2015,78612032741_4069_2015,78612032815_4069_2015,78612032831_4069_2015,78612032903_4069_2015,78612032906_4069_2015,78612032999_4069_2015,78612033028_4069_2015,78612033033_4069_2015,78612033057_4069_2015,78612033086_4069_2015,78612033187_4069_2015,78612033193_4069_2015,78612033199_4069_2015,78612033233_4069_2015,78612033287_4069_2015,78612033295_4069_2015,78612033299_4069_2015,78612033300_4069_2015,78612033301_4069_2015,78612033310_4069_2015,78612033412_4069_2015,78612033435_4069_2015,78612033477_4069_2015,78612033537_4069_2015,78612033691_4069_2015,78612033750_4069_2015,78612033768_4069_2015,78612033852_4069_2015,78612034194_4069_2015,78612034214_4069_2015,78612034232_4069_2015,78612034242_4069_2015,78612034537_4069_2015,78612034559_4069_2015,78612034599_4069_2015,78612034651_4069_2015,78612034680_4069_2015,78612034699_4069_2015,78612034735_4069_2015,78612034848_4069_2015,78612034855_4069_2015,78612034861_4069_2015,78612034954_4069_2015,78612034969_4069_2015,78612035072_4069_2015,78612035183_4069_2015,78612035229_4069_2015,78612035239_4069_2015,78612035251_4069_2015,78612035282_4069_2015,78612035336_4069_2015,78612035339_4069_2015,78612035389_4069_2015,78612035399_4069_2015,78612035497_4069_2015,78612035511_4069_2015,78612035523_4069_2015,78612035532_4069_2015,78612035575_4069_2015,78612035612_4069_2015,78612035680_4069_2015,78612035724_4069_2015,78612035802_4069_2015,78612036099_4069_2015,78612036131_4069_2015,78612036136_4069_2015,78612036183_4069_2015,78612036190_4069_2015,78612036195_4069_2015,78612036231_4069_2015,78612036252_4069_2015,78612036281_4069_2015,78612036283_4069_2015,78612036430_4069_2015,78612036510_4069_2015,78612036554_4069_2015,78612036599_4069_2015,78612036695_4069_2015,78612036810_4069_2015,78612036823_4069_2015,78612036880_4069_2015,78612036889_4069_2015,78612036936_4069_2015,78612036937_4069_2015,78612036969_4069_2015,78612037075_4069_2015,78612037077_4069_2015,78612037145_4069_2015,78612037193_4069_2015,78612037325_4069_2015,78612037329_4069_2015,78612037352_4069_2015,78612037368_4069_2015,78612037373_4069_2015,78612037457_4069_2015,78612037507_4069_2015,78612037616_4069_2015,78612037659_4069_2015,78612037668_4069_2015,78612037707_4069_2015,78612037774_4069_2015,78612037868_4069_2015,78612037900_4069_2015,78612037903_4069_2015,78612037940_4069_2015,78612037982_4069_2015,78612037996_4069_2015,78612038056_4069_2015,78612038085_4069_2015,78612038112_4069_2015,78612038113_4069_2015,78612038119_4069_2015,78612038166_4069_2015,78612038210_4069_2015,78612038246_4069_2015,78612038305_4069_2015,78612038343_4069_2015,78612038382_4069_2015,78612038405_4069_2015,78612038411_4069_2015,78612038450_4069_2015,78612038471_4069_2015,78612038488_4069_2015,78612038509_4069_2015,78612038511_4069_2015,78612038546_4069_2015,78612038594_4069_2015,78612038785_4069_2015,78612038856_4069_2015,78612038924_4069_2015,78612039122_4069_2015,78612039148_4069_2015,78612039173_4069_2015,78612039366_4069_2015,78612039395_4069_2015,78612039495_4069_2015,78612039602_4069_2015,78612039612_4069_2015,78612039629_4069_2015,78612039675_4069_2015,78612039730_4069_2015,78612039791_4069_2015,78612039837_4069_2015,78612039853_4069_2015,78612039862_4069_2015,78612039913_4069_2015,78612039929_4069_2015,78612039945_4069_2015,78612039977_4069_2015,78612040649_4069_2015,78612045184_4069_2015,78612046700_4069_2015,78612046944_4069_2015,78612050349_4069_2015,78612051971_4069_2015,78612057686_4069_2015,78612058164_4069_2015,78612061274_4069_2015,78612066111_4069_2015,78612067349_4069_2015,78612074764_4069_2015,78612075802_4069_2015,78612086285_4069_2015,78612087125_4069_2015,78612087216_4069_2015,78612090902_4069_2015,78612094163_4069_2015,78612097802_4069_2015,78612101044_4069_2015,78612103149_4069_2015,78612105393_4069_2015,78612106566_4069_2015,78612112390_4069_2015,78612112424_4069_2015,78612112449_4069_2015,78612113198_4069_2015,78612122412_4069_2015,78612122649_4069_2015,78612123749_4069_2015,78612123874_4069_2015,78612125339_4069_2015,78612128038_4069_2015,78612131529_4069_2015,78612136049_4069_2015,78612137666_4069_2015,78612143853_4069_2015,78612145105_4069_2015,78612145649_4069_2015,78612148142_4069_2015,78612152547_4069_2015,78612157349_4069_2015,78612159785_4069_2015,78612159865_4069_2015,78612159880_4069_2015,78612160302_4069_2015,78612164394_4069_2015,78612164532_4069_2015,78612167502_4069_2015,78612169994_4069_2015,78612170138_4069_2015,78612172384_4069_2015,78612174102_4069_2015,78612174714_4069_2015,78612176633_4069_2015,78612180535_4069_2015,78612182452_4069_2015,78612182772_4069_2015,78612184002_4069_2015,78612186117_4069_2015,78612187149_4069_2015,78612188415_4069_2015,78612188722_4069_2015,78612195628_4069_2015,78612199629_4069_2015,78612208102_4069_2015,78612224849_4069_2015,78612227888_4069_2015,78612231102_4069_2015,78612237649_4069_2015,78612251749_4069_2015,78612262802_4069_2015,78612263449_4069_2015,78612264149_4069_2015,78612306166_4069_2015,78612306901_4069_2015,78612311976_4069_2015,78612317619_4069_2015,78612318924_4069_2015,78612322490_4069_2015,78612329205_4069_2015,78612330349_4069_2015,78612337064_4069_2015,78612342355_4069_2015,78612350103_4069_2015,78612357553_4069_2015,78612360975_4069_2015,78612364400_4069_2015,78612374549_4069_2015,78612374558_4069_2015,78612376814_4069_2015,78612389345_4069_2015,78612399010_4069_2015,78612399499_4069_2015,78612413187_4069_2015,78612420034_4069_2015,78612429675_4069_2015,78612436325_4069_2015,78612436365_4069_2015,78612441277_4069_2015,78612444001_4069_2015,78612445149_4069_2015,78612450841_4069_2015,78612456150_4069_2015,78612466150_4069_2015,78612472995_4069_2015,78612473702_4069_2015,78612480405_4069_2015,78612480588_4069_2015,78612482020_4069_2015,78612489186_4069_2015,78612499697_4069_2015,78612504832_4069_2015,78612504881_4069_2015,78612507441_4069_2015,78612507449_4069_2015,78612520485_4069_2015,78612522654_4069_2015,78612524892_4069_2015,78612529596_4069_2015,78612539649_4069_2015,78612540303_4069_2015,78612543928_4069_2015,78612544464_4069_2015,78612551318_4069_2015,78612551964_4069_2015,78612559699_4069_2015,78612567601_4069_2015,78612572265_4069_2015,78612572360_4069_2015,78612574749_4069_2015,78612580415_4069_2015,78612582370_4069_2015,78612583010_4069_2015,78612597382_4069_2015,78612606834_4069_2015,78612611085_4069_2015,78612616549_4069_2015,78612620234_4069_2015,78612623085_4069_2015,78612627081_4069_2015,78612627085_4069_2015,78612637549_4069_2015,78612642749_4069_2015,78612646197_4069_2015,78612652002_4069_2015,78612652087_4069_2015,78612664485_4069_2015,78612668485_4069_2015,78612682020_4069_2015,78612704702_4069_2015,78612704749_4069_2015,78612706449_4069_2015,78612709024_4069_2015,78612709714_4069_2015,78612712631_4069_2015,78612712636_4069_2015,78612714849_4069_2015,78612720239_4069_2015,78612722321_4069_2015,78612726564_4069_2015,78612728431_4069_2015,78612729278_4069_2015,78612735420_4069_2015,78612737329_4069_2015,78612739349_4069_2015,78612740202_4069_2015,78612743458_4069_2015,78612752640_4069_2015,78612759102_4069_2015,78612759113_4069_2015,78612759702_4069_2015,78612763238_4069_2015,78612768484_4069_2015,78612772142_4069_2015,78612772977_4069_2015,78612774149_4069_2015,78612775821_4069_2015,78612775911_4069_2015,78612775985_4069_2015,78612776102_4069_2015,78612776549_4069_2015,78612779484_4069_2015,78612780849_4069_2015,78612789925_4069_2015,78612790099_4069_2015,78612792649_4069_2015,78612796349_4069_2015,78612799602_4069_2015,78612803258_4069_2015,78612805178_4069_2015,78612811085_4069_2015,78612826087_4069_2015,78612834549_4069_2015,78612834802_4069_2015,78612836038_4069_2015,78612842849_4069_2015,78612850449_4069_2015,78612850771_4069_2015,78612852717_4069_2015,78612857485_4069_2015,78612857581_4069_2015,78612859785_4069_2015,78612863385_4069_2015,78612872697_4069_2015,78612880410_4069_2015,78612880449_4069_2015,78612881049_4069_2015,78612883579_4069_2015,78612893077_4069_2015,78612895262_4069_2015,78612896202_4069_2015,78612911602_4069_2015,78612941221_4069_2015,78612947902_4069_2015,78612956653_4069_2015,78612964002_4069_2015,78612965532_4069_2015,78612967607_4069_2015,78612978949_4069_2015,78612999221_4069_2015}'::character varying[])
11. 0.003 310.460 ↓ 0.0 0 1

Bitmap Heap Scan on offers_2019_9 (cost=1,498.20..1,499.32 rows=1 width=141) (actual time=310.460..310.460 rows=0 loops=1)

  • Recheck Cond: (hashes @> '{78612031749_4069_2015,78612002687_4069_2015,78612012480_4069_2015,78612014849_4069_2015,78612014949_4069_2015,78612023917_4069_2015,78612027187_4069_2015,78612030037_4069_2015,78612030056_4069_2015,78612030088_4069_2015,78612030136_4069_2015,78612030151_4069_2015,78612030217_4069_2015,78612030285_4069_2015,78612030310_4069_2015,78612030316_4069_2015,78612030332_4069_2015,78612030335_4069_2015,78612030350_4069_2015,78612030354_4069_2015,78612030359_4069_2015,78612030382_4069_2015,78612030410_4069_2015,78612030437_4069_2015,78612030481_4069_2015,78612030482_4069_2015,78612030492_4069_2015,78612030582_4069_2015,78612030612_4069_2015,78612030645_4069_2015,78612030667_4069_2015,78612030676_4069_2015,78612030677_4069_2015,78612030755_4069_2015,78612030860_4069_2015,78612030979_4069_2015,78612031011_4069_2015,78612031051_4069_2015,78612031056_4069_2015,78612031290_4069_2015,78612031412_4069_2015,78612031468_4069_2015,78612031619_4069_2015,78612031702_4069_2015,78612031711_4069_2015,78612031733_4069_2015,78612031734_4069_2015,78612031766_4069_2015,78612031786_4069_2015,78612031806_4069_2015,78612031874_4069_2015,78612031900_4069_2015,78612031983_4069_2015,78612031985_4069_2015,78612032014_4069_2015,78612032020_4069_2015,78612032121_4069_2015,78612032196_4069_2015,78612032199_4069_2015,78612032212_4069_2015,78612032366_4069_2015,78612032402_4069_2015,78612032436_4069_2015,78612032503_4069_2015,78612032536_4069_2015,78612032631_4069_2015,78612032649_4069_2015,78612032741_4069_2015,78612032815_4069_2015,78612032831_4069_2015,78612032903_4069_2015,78612032906_4069_2015,78612032999_4069_2015,78612033028_4069_2015,78612033033_4069_2015,78612033057_4069_2015,78612033086_4069_2015,78612033187_4069_2015,78612033193_4069_2015,78612033199_4069_2015,78612033233_4069_2015,78612033287_4069_2015,78612033295_4069_2015,78612033299_4069_2015,78612033300_4069_2015,78612033301_4069_2015,78612033310_4069_2015,78612033412_4069_2015,78612033435_4069_2015,78612033477_4069_2015,78612033537_4069_2015,78612033691_4069_2015,78612033750_4069_2015,78612033768_4069_2015,78612033852_4069_2015,78612034194_4069_2015,78612034214_4069_2015,78612034232_4069_2015,78612034242_4069_2015,78612034537_4069_2015,78612034559_4069_2015,78612034599_4069_2015,78612034651_4069_2015,78612034680_4069_2015,78612034699_4069_2015,78612034735_4069_2015,78612034848_4069_2015,78612034855_4069_2015,78612034861_4069_2015,78612034954_4069_2015,78612034969_4069_2015,78612035072_4069_2015,78612035183_4069_2015,78612035229_4069_2015,78612035239_4069_2015,78612035251_4069_2015,78612035282_4069_2015,78612035336_4069_2015,78612035339_4069_2015,78612035389_4069_2015,78612035399_4069_2015,78612035497_4069_2015,78612035511_4069_2015,78612035523_4069_2015,78612035532_4069_2015,78612035575_4069_2015,78612035612_4069_2015,78612035680_4069_2015,78612035724_4069_2015,78612035802_4069_2015,78612036099_4069_2015,78612036131_4069_2015,78612036136_4069_2015,78612036183_4069_2015,78612036190_4069_2015,78612036195_4069_2015,78612036231_4069_2015,78612036252_4069_2015,78612036281_4069_2015,78612036283_4069_2015,78612036430_4069_2015,78612036510_4069_2015,78612036554_4069_2015,78612036599_4069_2015,78612036695_4069_2015,78612036810_4069_2015,78612036823_4069_2015,78612036880_4069_2015,78612036889_4069_2015,78612036936_4069_2015,78612036937_4069_2015,78612036969_4069_2015,78612037075_4069_2015,78612037077_4069_2015,78612037145_4069_2015,78612037193_4069_2015,78612037325_4069_2015,78612037329_4069_2015,78612037352_4069_2015,78612037368_4069_2015,78612037373_4069_2015,78612037457_4069_2015,78612037507_4069_2015,78612037616_4069_2015,78612037659_4069_2015,78612037668_4069_2015,78612037707_4069_2015,78612037774_4069_2015,78612037868_4069_2015,78612037900_4069_2015,78612037903_4069_2015,78612037940_4069_2015,78612037982_4069_2015,78612037996_4069_2015,78612038056_4069_2015,78612038085_4069_2015,78612038112_4069_2015,78612038113_4069_2015,78612038119_4069_2015,78612038166_4069_2015,78612038210_4069_2015,78612038246_4069_2015,78612038305_4069_2015,78612038343_4069_2015,78612038382_4069_2015,78612038405_4069_2015,78612038411_4069_2015,78612038450_4069_2015,78612038471_4069_2015,78612038488_4069_2015,78612038509_4069_2015,78612038511_4069_2015,78612038546_4069_2015,78612038594_4069_2015,78612038785_4069_2015,78612038856_4069_2015,78612038924_4069_2015,78612039122_4069_2015,78612039148_4069_2015,78612039173_4069_2015,78612039366_4069_2015,78612039395_4069_2015,78612039495_4069_2015,78612039602_4069_2015,78612039612_4069_2015,78612039629_4069_2015,78612039675_4069_2015,78612039730_4069_2015,78612039791_4069_2015,78612039837_4069_2015,78612039853_4069_2015,78612039862_4069_2015,78612039913_4069_2015,78612039929_4069_2015,78612039945_4069_2015,78612039977_4069_2015,78612040649_4069_2015,78612045184_4069_2015,78612046700_4069_2015,78612046944_4069_2015,78612050349_4069_2015,78612051971_4069_2015,78612057686_4069_2015,78612058164_4069_2015,78612061274_4069_2015,78612066111_4069_2015,78612067349_4069_2015,78612074764_4069_2015,78612075802_4069_2015,78612086285_4069_2015,78612087125_4069_2015,78612087216_4069_2015,78612090902_4069_2015,78612094163_4069_2015,78612097802_4069_2015,78612101044_4069_2015,78612103149_4069_2015,78612105393_4069_2015,78612106566_4069_2015,78612112390_4069_2015,78612112424_4069_2015,78612112449_4069_2015,78612113198_4069_2015,78612122412_4069_2015,78612122649_4069_2015,78612123749_4069_2015,78612123874_4069_2015,78612125339_4069_2015,78612128038_4069_2015,78612131529_4069_2015,78612136049_4069_2015,78612137666_4069_2015,78612143853_4069_2015,78612145105_4069_2015,78612145649_4069_2015,78612148142_4069_2015,78612152547_4069_2015,78612157349_4069_2015,78612159785_4069_2015,78612159865_4069_2015,78612159880_4069_2015,78612160302_4069_2015,78612164394_4069_2015,78612164532_4069_2015,78612167502_4069_2015,78612169994_4069_2015,78612170138_4069_2015,78612172384_4069_2015,78612174102_4069_2015,78612174714_4069_2015,78612176633_4069_2015,78612180535_4069_2015,78612182452_4069_2015,78612182772_4069_2015,78612184002_4069_2015,78612186117_4069_2015,78612187149_4069_2015,78612188415_4069_2015,78612188722_4069_2015,78612195628_4069_2015,78612199629_4069_2015,78612208102_4069_2015,78612224849_4069_2015,78612227888_4069_2015,78612231102_4069_2015,78612237649_4069_2015,78612251749_4069_2015,78612262802_4069_2015,78612263449_4069_2015,78612264149_4069_2015,78612306166_4069_2015,78612306901_4069_2015,78612311976_4069_2015,78612317619_4069_2015,78612318924_4069_2015,78612322490_4069_2015,78612329205_4069_2015,78612330349_4069_2015,78612337064_4069_2015,78612342355_4069_2015,78612350103_4069_2015,78612357553_4069_2015,78612360975_4069_2015,78612364400_4069_2015,78612374549_4069_2015,78612374558_4069_2015,78612376814_4069_2015,78612389345_4069_2015,78612399010_4069_2015,78612399499_4069_2015,78612413187_4069_2015,78612420034_4069_2015,78612429675_4069_2015,78612436325_4069_2015,78612436365_4069_2015,78612441277_4069_2015,78612444001_4069_2015,78612445149_4069_2015,78612450841_4069_2015,78612456150_4069_2015,78612466150_4069_2015,78612472995_4069_2015,78612473702_4069_2015,78612480405_4069_2015,78612480588_4069_2015,78612482020_4069_2015,78612489186_4069_2015,78612499697_4069_2015,78612504832_4069_2015,78612504881_4069_2015,78612507441_4069_2015,78612507449_4069_2015,78612520485_4069_2015,78612522654_4069_2015,78612524892_4069_2015,78612529596_4069_2015,78612539649_4069_2015,78612540303_4069_2015,78612543928_4069_2015,78612544464_4069_2015,78612551318_4069_2015,78612551964_4069_2015,78612559699_4069_2015,78612567601_4069_2015,78612572265_4069_2015,78612572360_4069_2015,78612574749_4069_2015,78612580415_4069_2015,78612582370_4069_2015,78612583010_4069_2015,78612597382_4069_2015,78612606834_4069_2015,78612611085_4069_2015,78612616549_4069_2015,78612620234_4069_2015,78612623085_4069_2015,78612627081_4069_2015,78612627085_4069_2015,78612637549_4069_2015,78612642749_4069_2015,78612646197_4069_2015,78612652002_4069_2015,78612652087_4069_2015,78612664485_4069_2015,78612668485_4069_2015,78612682020_4069_2015,78612704702_4069_2015,78612704749_4069_2015,78612706449_4069_2015,78612709024_4069_2015,78612709714_4069_2015,78612712631_4069_2015,78612712636_4069_2015,78612714849_4069_2015,78612720239_4069_2015,78612722321_4069_2015,78612726564_4069_2015,78612728431_4069_2015,78612729278_4069_2015,78612735420_4069_2015,78612737329_4069_2015,78612739349_4069_2015,78612740202_4069_2015,78612743458_4069_2015,78612752640_4069_2015,78612759102_4069_2015,78612759113_4069_2015,78612759702_4069_2015,78612763238_4069_2015,78612768484_4069_2015,78612772142_4069_2015,78612772977_4069_2015,78612774149_4069_2015,78612775821_4069_2015,78612775911_4069_2015,78612775985_4069_2015,78612776102_4069_2015,78612776549_4069_2015,78612779484_4069_2015,78612780849_4069_2015,78612789925_4069_2015,78612790099_4069_2015,78612792649_4069_2015,78612796349_4069_2015,78612799602_4069_2015,78612803258_4069_2015,78612805178_4069_2015,78612811085_4069_2015,78612826087_4069_2015,78612834549_4069_2015,78612834802_4069_2015,78612836038_4069_2015,78612842849_4069_2015,78612850449_4069_2015,78612850771_4069_2015,78612852717_4069_2015,78612857485_4069_2015,78612857581_4069_2015,78612859785_4069_2015,78612863385_4069_2015,78612872697_4069_2015,78612880410_4069_2015,78612880449_4069_2015,78612881049_4069_2015,78612883579_4069_2015,78612893077_4069_2015,78612895262_4069_2015,78612896202_4069_2015,78612911602_4069_2015,78612941221_4069_2015,78612947902_4069_2015,78612956653_4069_2015,78612964002_4069_2015,78612965532_4069_2015,78612967607_4069_2015,78612978949_4069_2015,78612999221_4069_2015}'::character varying[])
  • Filter: ((created_at >= '2019-05-05 15:16:49'::timestamp without time zone) AND (id <> 63908383))
12. 310.457 310.457 ↓ 0.0 0 1

Bitmap Index Scan on offers_2019_9_hashes (cost=0.00..1,498.20 rows=1 width=0) (actual time=310.457..310.457 rows=0 loops=1)

  • Index Cond: (hashes @> '{78612031749_4069_2015,78612002687_4069_2015,78612012480_4069_2015,78612014849_4069_2015,78612014949_4069_2015,78612023917_4069_2015,78612027187_4069_2015,78612030037_4069_2015,78612030056_4069_2015,78612030088_4069_2015,78612030136_4069_2015,78612030151_4069_2015,78612030217_4069_2015,78612030285_4069_2015,78612030310_4069_2015,78612030316_4069_2015,78612030332_4069_2015,78612030335_4069_2015,78612030350_4069_2015,78612030354_4069_2015,78612030359_4069_2015,78612030382_4069_2015,78612030410_4069_2015,78612030437_4069_2015,78612030481_4069_2015,78612030482_4069_2015,78612030492_4069_2015,78612030582_4069_2015,78612030612_4069_2015,78612030645_4069_2015,78612030667_4069_2015,78612030676_4069_2015,78612030677_4069_2015,78612030755_4069_2015,78612030860_4069_2015,78612030979_4069_2015,78612031011_4069_2015,78612031051_4069_2015,78612031056_4069_2015,78612031290_4069_2015,78612031412_4069_2015,78612031468_4069_2015,78612031619_4069_2015,78612031702_4069_2015,78612031711_4069_2015,78612031733_4069_2015,78612031734_4069_2015,78612031766_4069_2015,78612031786_4069_2015,78612031806_4069_2015,78612031874_4069_2015,78612031900_4069_2015,78612031983_4069_2015,78612031985_4069_2015,78612032014_4069_2015,78612032020_4069_2015,78612032121_4069_2015,78612032196_4069_2015,78612032199_4069_2015,78612032212_4069_2015,78612032366_4069_2015,78612032402_4069_2015,78612032436_4069_2015,78612032503_4069_2015,78612032536_4069_2015,78612032631_4069_2015,78612032649_4069_2015,78612032741_4069_2015,78612032815_4069_2015,78612032831_4069_2015,78612032903_4069_2015,78612032906_4069_2015,78612032999_4069_2015,78612033028_4069_2015,78612033033_4069_2015,78612033057_4069_2015,78612033086_4069_2015,78612033187_4069_2015,78612033193_4069_2015,78612033199_4069_2015,78612033233_4069_2015,78612033287_4069_2015,78612033295_4069_2015,78612033299_4069_2015,78612033300_4069_2015,78612033301_4069_2015,78612033310_4069_2015,78612033412_4069_2015,78612033435_4069_2015,78612033477_4069_2015,78612033537_4069_2015,78612033691_4069_2015,78612033750_4069_2015,78612033768_4069_2015,78612033852_4069_2015,78612034194_4069_2015,78612034214_4069_2015,78612034232_4069_2015,78612034242_4069_2015,78612034537_4069_2015,78612034559_4069_2015,78612034599_4069_2015,78612034651_4069_2015,78612034680_4069_2015,78612034699_4069_2015,78612034735_4069_2015,78612034848_4069_2015,78612034855_4069_2015,78612034861_4069_2015,78612034954_4069_2015,78612034969_4069_2015,78612035072_4069_2015,78612035183_4069_2015,78612035229_4069_2015,78612035239_4069_2015,78612035251_4069_2015,78612035282_4069_2015,78612035336_4069_2015,78612035339_4069_2015,78612035389_4069_2015,78612035399_4069_2015,78612035497_4069_2015,78612035511_4069_2015,78612035523_4069_2015,78612035532_4069_2015,78612035575_4069_2015,78612035612_4069_2015,78612035680_4069_2015,78612035724_4069_2015,78612035802_4069_2015,78612036099_4069_2015,78612036131_4069_2015,78612036136_4069_2015,78612036183_4069_2015,78612036190_4069_2015,78612036195_4069_2015,78612036231_4069_2015,78612036252_4069_2015,78612036281_4069_2015,78612036283_4069_2015,78612036430_4069_2015,78612036510_4069_2015,78612036554_4069_2015,78612036599_4069_2015,78612036695_4069_2015,78612036810_4069_2015,78612036823_4069_2015,78612036880_4069_2015,78612036889_4069_2015,78612036936_4069_2015,78612036937_4069_2015,78612036969_4069_2015,78612037075_4069_2015,78612037077_4069_2015,78612037145_4069_2015,78612037193_4069_2015,78612037325_4069_2015,78612037329_4069_2015,78612037352_4069_2015,78612037368_4069_2015,78612037373_4069_2015,78612037457_4069_2015,78612037507_4069_2015,78612037616_4069_2015,78612037659_4069_2015,78612037668_4069_2015,78612037707_4069_2015,78612037774_4069_2015,78612037868_4069_2015,78612037900_4069_2015,78612037903_4069_2015,78612037940_4069_2015,78612037982_4069_2015,78612037996_4069_2015,78612038056_4069_2015,78612038085_4069_2015,78612038112_4069_2015,78612038113_4069_2015,78612038119_4069_2015,78612038166_4069_2015,78612038210_4069_2015,78612038246_4069_2015,78612038305_4069_2015,78612038343_4069_2015,78612038382_4069_2015,78612038405_4069_2015,78612038411_4069_2015,78612038450_4069_2015,78612038471_4069_2015,78612038488_4069_2015,78612038509_4069_2015,78612038511_4069_2015,78612038546_4069_2015,78612038594_4069_2015,78612038785_4069_2015,78612038856_4069_2015,78612038924_4069_2015,78612039122_4069_2015,78612039148_4069_2015,78612039173_4069_2015,78612039366_4069_2015,78612039395_4069_2015,78612039495_4069_2015,78612039602_4069_2015,78612039612_4069_2015,78612039629_4069_2015,78612039675_4069_2015,78612039730_4069_2015,78612039791_4069_2015,78612039837_4069_2015,78612039853_4069_2015,78612039862_4069_2015,78612039913_4069_2015,78612039929_4069_2015,78612039945_4069_2015,78612039977_4069_2015,78612040649_4069_2015,78612045184_4069_2015,78612046700_4069_2015,78612046944_4069_2015,78612050349_4069_2015,78612051971_4069_2015,78612057686_4069_2015,78612058164_4069_2015,78612061274_4069_2015,78612066111_4069_2015,78612067349_4069_2015,78612074764_4069_2015,78612075802_4069_2015,78612086285_4069_2015,78612087125_4069_2015,78612087216_4069_2015,78612090902_4069_2015,78612094163_4069_2015,78612097802_4069_2015,78612101044_4069_2015,78612103149_4069_2015,78612105393_4069_2015,78612106566_4069_2015,78612112390_4069_2015,78612112424_4069_2015,78612112449_4069_2015,78612113198_4069_2015,78612122412_4069_2015,78612122649_4069_2015,78612123749_4069_2015,78612123874_4069_2015,78612125339_4069_2015,78612128038_4069_2015,78612131529_4069_2015,78612136049_4069_2015,78612137666_4069_2015,78612143853_4069_2015,78612145105_4069_2015,78612145649_4069_2015,78612148142_4069_2015,78612152547_4069_2015,78612157349_4069_2015,78612159785_4069_2015,78612159865_4069_2015,78612159880_4069_2015,78612160302_4069_2015,78612164394_4069_2015,78612164532_4069_2015,78612167502_4069_2015,78612169994_4069_2015,78612170138_4069_2015,78612172384_4069_2015,78612174102_4069_2015,78612174714_4069_2015,78612176633_4069_2015,78612180535_4069_2015,78612182452_4069_2015,78612182772_4069_2015,78612184002_4069_2015,78612186117_4069_2015,78612187149_4069_2015,78612188415_4069_2015,78612188722_4069_2015,78612195628_4069_2015,78612199629_4069_2015,78612208102_4069_2015,78612224849_4069_2015,78612227888_4069_2015,78612231102_4069_2015,78612237649_4069_2015,78612251749_4069_2015,78612262802_4069_2015,78612263449_4069_2015,78612264149_4069_2015,78612306166_4069_2015,78612306901_4069_2015,78612311976_4069_2015,78612317619_4069_2015,78612318924_4069_2015,78612322490_4069_2015,78612329205_4069_2015,78612330349_4069_2015,78612337064_4069_2015,78612342355_4069_2015,78612350103_4069_2015,78612357553_4069_2015,78612360975_4069_2015,78612364400_4069_2015,78612374549_4069_2015,78612374558_4069_2015,78612376814_4069_2015,78612389345_4069_2015,78612399010_4069_2015,78612399499_4069_2015,78612413187_4069_2015,78612420034_4069_2015,78612429675_4069_2015,78612436325_4069_2015,78612436365_4069_2015,78612441277_4069_2015,78612444001_4069_2015,78612445149_4069_2015,78612450841_4069_2015,78612456150_4069_2015,78612466150_4069_2015,78612472995_4069_2015,78612473702_4069_2015,78612480405_4069_2015,78612480588_4069_2015,78612482020_4069_2015,78612489186_4069_2015,78612499697_4069_2015,78612504832_4069_2015,78612504881_4069_2015,78612507441_4069_2015,78612507449_4069_2015,78612520485_4069_2015,78612522654_4069_2015,78612524892_4069_2015,78612529596_4069_2015,78612539649_4069_2015,78612540303_4069_2015,78612543928_4069_2015,78612544464_4069_2015,78612551318_4069_2015,78612551964_4069_2015,78612559699_4069_2015,78612567601_4069_2015,78612572265_4069_2015,78612572360_4069_2015,78612574749_4069_2015,78612580415_4069_2015,78612582370_4069_2015,78612583010_4069_2015,78612597382_4069_2015,78612606834_4069_2015,78612611085_4069_2015,78612616549_4069_2015,78612620234_4069_2015,78612623085_4069_2015,78612627081_4069_2015,78612627085_4069_2015,78612637549_4069_2015,78612642749_4069_2015,78612646197_4069_2015,78612652002_4069_2015,78612652087_4069_2015,78612664485_4069_2015,78612668485_4069_2015,78612682020_4069_2015,78612704702_4069_2015,78612704749_4069_2015,78612706449_4069_2015,78612709024_4069_2015,78612709714_4069_2015,78612712631_4069_2015,78612712636_4069_2015,78612714849_4069_2015,78612720239_4069_2015,78612722321_4069_2015,78612726564_4069_2015,78612728431_4069_2015,78612729278_4069_2015,78612735420_4069_2015,78612737329_4069_2015,78612739349_4069_2015,78612740202_4069_2015,78612743458_4069_2015,78612752640_4069_2015,78612759102_4069_2015,78612759113_4069_2015,78612759702_4069_2015,78612763238_4069_2015,78612768484_4069_2015,78612772142_4069_2015,78612772977_4069_2015,78612774149_4069_2015,78612775821_4069_2015,78612775911_4069_2015,78612775985_4069_2015,78612776102_4069_2015,78612776549_4069_2015,78612779484_4069_2015,78612780849_4069_2015,78612789925_4069_2015,78612790099_4069_2015,78612792649_4069_2015,78612796349_4069_2015,78612799602_4069_2015,78612803258_4069_2015,78612805178_4069_2015,78612811085_4069_2015,78612826087_4069_2015,78612834549_4069_2015,78612834802_4069_2015,78612836038_4069_2015,78612842849_4069_2015,78612850449_4069_2015,78612850771_4069_2015,78612852717_4069_2015,78612857485_4069_2015,78612857581_4069_2015,78612859785_4069_2015,78612863385_4069_2015,78612872697_4069_2015,78612880410_4069_2015,78612880449_4069_2015,78612881049_4069_2015,78612883579_4069_2015,78612893077_4069_2015,78612895262_4069_2015,78612896202_4069_2015,78612911602_4069_2015,78612941221_4069_2015,78612947902_4069_2015,78612956653_4069_2015,78612964002_4069_2015,78612965532_4069_2015,78612967607_4069_2015,78612978949_4069_2015,78612999221_4069_2015}'::character varying[])
Planning time : 12.332 ms
Execution time : 2,875.709 ms