explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sOQv

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.763 ↑ 447,486.7 15 1

Unique (cost=1,215,560.14..1,265,902.39 rows=6,712,300 width=12) (actual time=0.759..0.763 rows=15 loops=1)

2. 0.019 0.759 ↑ 231,458.6 29 1

Sort (cost=1,215,560.14..1,232,340.89 rows=6,712,300 width=12) (actual time=0.758..0.759 rows=29 loops=1)

  • Sort Key: agent_event.id, (unnest(array_remove(ARRAY[CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'anonim.pro'::text) OR (agent_web.site = 'anonimizing.com'::text) OR (agent_web.site = 'hideme.ru'::text) OR (agent_web.site = '2ip.ru'::text) OR (agent_web.site = 'pingway.ru'::text) OR (agent_web.site = 'cameleo.ru'::text) OR (agent_web.site = 'unlumen.ru'::text) OR (agent_web.site = 'anonymizer.com.ua'::text) OR (agent_web.site = 'anonymizer.ru'::text))) THEN 107 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'company_site.ru'::text) OR (agent_web.site = 'company_crm.ru'::text) OR (agent_web.site = 'company_forum.ru'::text))) THEN 106 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND (agent_web.site = 'gosuslugi.ru'::text)) THEN 346 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'russianfood.com'::text) OR (agent_web.site = 'povarenok.ru'::text) OR (agent_web.site = 'edimdoma.ru'::text) OR (agent_web.site = '1000.menu'::text) OR (agent_web.site = 'gastronom.ru'::text))) THEN 122 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'muz-tv.ru'::text) OR (agent_web.site = 'best-muzon.me'::text) OR (agent_web.site = '101.ru'::text) OR (agent_web.site = 'zaycev.net'::text) OR (agent_web.site = 'pesni-tut.com'::text) OR (agent_web.site = 'tidido.com'::text) OR (agent_web.site = 'realmusic.ru'::text))) THEN 115 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'rt.com'::text) OR (agent_web.site = 'kp.ru'::text) OR (agent_web.site = 'rbc.ru'::text) OR (agent_web.site = 'ria.ru'::text) OR (agent_web.site = 'lenta.ru'::text) OR (agent_web.site = 'gazeta.ru'::text) OR (agent_web.site = 'kp.ru'::text) OR (agent_web.site = 'vesti.ru'::text) OR (agent_web.site = 'life.ru'::text) OR (agent_web.site = 'smi2.ru'::text) OR (agent_web.site = 'kommersant.ru'::text) OR (agent_web.site = 'ngs.ru'::text) OR (agent_web.site = 'regnum.ru'::text) OR (agent_web.site = 'izvestia.ru'::text) OR (agent_web.site = 'fontanka.ru'::text) OR (agent_web.site = 'topwar.ru'::text))) THEN 104 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'google.com'::text) OR (agent_web.site = 'google.ru'::text) OR (agent_web.site = 'yandex.ru'::text) OR (agent_web.site = 'yandex.com'::text) OR (agent_web.site = 'yandex.kz'::text) OR (agent_web.site = 'ya.ru'::text))) THEN 429 ELSE 0 END, CASE WHEN (((agent_web.domain = 'www.yandex.ru'::text) OR (agent_web.domain = 'www.google.ru'::text) OR (agent_web.domain = 'www.rambler.ru'::text) OR (agent_web.domain = 'go.mail.ru'::text) OR (agent_web.domain = 'www.bing.com'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 116 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'github.com'::text) OR (agent_web.site = 'geektimes.ru'::text) OR (agent_web.site = 'habrahabr.ru'::text) OR (agent_web.site = 'stackowerflow.com'::text))) THEN 108 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'dojki.com'::text) OR (agent_web.site = 'porno365.net'::text) OR (agent_web.site = '24xxx.org'::text) OR (agent_web.site = 'pornoonlain.tv'::text) OR (agent_web.site = 'pornoxyu.net'::text) OR (agent_web.site = 'pornotut.net'::text) OR (agent_web.site = 'rupornotube.info'::text) OR (agent_web.site = 'pornodiesel.com'::text) OR (agent_web.site = 'porno-mm.com'::text) OR (agent_web.site = 'eroxvideos.info'::text))) THEN 109 ELSE 0 END, CASE WHEN (((agent_web.domain = 'www.gismeteo.ru'::text) OR (agent_web.domain = 'pogoda.ngs.ru'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 113 ELSE 0 END, CASE WHEN (((agent_web.domain = 'e.mail.ru'::text) OR (agent_web.domain = 'mail.yandex.ru'::text) OR (agent_web.domain = 'mail.google.com'::text) OR (agent_web.domain = 'mail.ramler.ru'::text) OR (agent_web.domain = 'mail.list.ru'::text) OR (agent_web.domain = 'login.live.com'::text) OR (agent_web.domain = 'outlook.live.com'::text) OR (agent_web.domain = 'mail.ngs.ru'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 110 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'sportrezult.ru'::text) OR (agent_web.site = 'sports.ru'::text) OR (agent_web.site = 'sportsdaily.ru'::text) OR (agent_web.site = 'sportvokrug.ru'::text) OR (agent_web.site = 'ssyoutube.com'::text) OR (agent_web.site = 'stavropolye.tv'::text) OR (agent_web.site = 'stoloto.ru'::text) OR (agent_web.site = 'stormo.tv'::text) OR (agent_web.site = 'stranamasterov.ru'::text) OR (agent_web.site = 'tabsgame.ru'::text) OR (agent_web.site = 'tabulagames.ru'::text) OR (agent_web.site = 'takegame.com'::text) OR (agent_web.site = 'tapochek.net'::text) OR (agent_web.site = 'techno24.tv'::text) OR (agent_web.site = 'tegames.ru'::text) OR (agent_web.site = 'the-cinema.tv'::text) OR (agent_web.site = 'tigame.org'::text) OR (agent_web.site = 'top5cashgames.com'::text) OR (agent_web.site = 'topcinema.tv'::text) OR (agent_web.site = 'topkino.info'::text) OR (agent_web.site = 'topspb.tv'::text) OR (agent_web.site = 'trailerstube.ru'::text) OR (agent_web.site = 'transformers-film.ru'::text) OR (agent_web.site = 'trendymen.ru'::text) OR (agent_web.site = 'tricolor.tv'::text) OR (agent_web.site = 'tricolor-msk.tv'::text) OR (agent_web.site = 'trinixy.ru'::text) OR (agent_web.site = 'tsargrad.tv'::text) OR (agent_web.site = 'tubethe.com'::text) OR (agent_web.site = 'turkcinema.tv'::text) OR (agent_web.site = 'tviz.tv'::text) OR (agent_web.site = 'twitch.tv'::text) OR (agent_web.site = 'uapoker.info'::text) OR (agent_web.site = 'unikino.ru'::text) OR (agent_web.site = 'ustream.tv'::text) OR (agent_web.site = 'vesjoloevideo.ru'::text) OR (agent_web.site = 'video-bloger.ru'::text) OR (agent_web.site = 'videoboom.cc'::text) OR (agent_web.site = 'videocore.tv'::text) OR (agent_web.site = 'videolike.de'::text) OR (agent_web.site = 'videomore.ru'::text) OR (agent_web.site = 'video-play.ru'::text) OR (agent_web.site = 'videoroi.ru'::text) OR (agent_web.site = 'videosaver.ru'::text) OR (agent_web.site = 'videosik.com'::text) OR (agent_web.site = 'videosthatsuck.com'::text) OR (agent_web.site = 'videozal.club'::text) OR (agent_web.site = 'videozdes.ru'::text) OR (agent_web.site = 'vkinos.com'::text) OR (agent_web.site = 'vkino-tv.ru'::text) OR (agent_web.site = 'vkmp3.pro'::text) OR (agent_web.site = 'vlk2game.com'::text) OR (agent_web.site = 'vokrug.tv'::text) OR (agent_web.site = 'vseanekdotu.ru'::text) OR (agent_web.site = 'vseokino.com'::text) OR (agent_web.site = 'vse-pro-kino.ru'::text) OR (agent_web.site = 'vseprosport.ru'::text) OR (agent_web.site = 'vulcanclubplay.com'::text) OR (agent_web.site = 'vulcanklubzz.com'::text) OR (agent_web.site = 'vulcanklubzz.org'::text) OR (agent_web.site = 'vulkan-bigmoney.com'::text) OR (agent_web.site = 'vulkanclubss.net'::text) OR (agent_web.site = 'vulkanclubzz.com'::text) OR (agent_web.site = 'vulkanclubzz.org'::text) OR (agent_web.site = 'vulkanklubzz.net'::text) OR (agent_web.site = 'vulkanklubzz.org'::text) OR (agent_web.site = 'warchechnya.ru'::text) OR (agent_web.site = 'waxfilm.net'::text) OR (agent_web.site = 'westernfilm.ru'::text) OR (agent_web.site = 'winvideo.tv'::text) OR (agent_web.site = 'withyoutube.com'::text) OR (agent_web.site = 'wkino.net'::text) OR (agent_web.site = 'wot-game.com'::text) OR (agent_web.site = 'wot-news.com'::text) OR (agent_web.site = 'wot-planet.com'::text) OR (agent_web.site = 'wowcircle.com'::text) OR (agent_web.site = 'wowdiets.ru'::text) OR (agent_web.site = 'xcsport.ru'::text) OR (agent_web.site = 'xsport.ua'::text) OR (agent_web.site = 'yaplakal.com'::text) OR (agent_web.site = 'youtube-nocookie.com'::text) OR (agent_web.site = 'zabavnie-igrushki.ru'::text) OR (agent_web.site = 'zagony.ru'::text) OR (agent_web.site = 'zakupka.tv'::text) OR (agent_web.site = 'zerkaloxbet.info'::text) OR (agent_web.site = 'zfilm-hd.club'::text))) THEN 432 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'likefilmdb.ru'::text) OR (agent_web.site = 'livefilm.info'::text) OR (agent_web.site = 'livejournal.com'::text) OR (agent_web.site = 'livesport.ru'::text) OR (agent_web.site = 'lordfilm.tv'::text) OR (agent_web.site = 'lostfilm.tv'::text) OR (agent_web.site = 'lotoru.net'::text) OR (agent_web.site = 'lotorupro.com'::text) OR (agent_web.site = 'lotosite.ru'::text) OR (agent_web.site = 'loveplanet.ru'::text) OR (agent_web.site = 'lucky-games.space'::text) OR (agent_web.site = 'luxorfilm.ru'::text) OR (agent_web.site = 'mainfun.ru'::text) OR (agent_web.site = 'mbdevgame.ru'::text) OR (agent_web.site = 'megamedportal.ru'::text) OR (agent_web.site = 'megogo.net'::text) OR (agent_web.site = 'mensweekly.ru'::text) OR (agent_web.site = 'mirpokera.com'::text) OR (agent_web.site = 'mirtesen.ru'::text) OR (agent_web.site = 'miytvideo.ru'::text) OR (agent_web.site = 'mki-igrushki.ru'::text) OR (agent_web.site = 'mmo13.ru'::text) OR (agent_web.site = 'mobile-games-box.com'::text) OR (agent_web.site = 'moe.video'::text) OR (agent_web.site = 'moevideo.biz'::text) OR (agent_web.site = 'moevideo.net'::text) OR (agent_web.site = 'mosfilm.ru'::text) OR (agent_web.site = 'mosigra.ru'::text) OR (agent_web.site = 'mosigrushka.ru'::text) OR (agent_web.site = 'mos-kino.ru'::text) OR (agent_web.site = 'motorsport.com'::text) OR (agent_web.site = 'mp3fishki.net'::text) OR (agent_web.site = 'mur.tv'::text) OR (agent_web.site = 'mwgame.ru'::text) OR (agent_web.site = 'my888poker.ru'::text) OR (agent_web.site = 'mygame-life.ru'::text) OR (agent_web.site = 'mysagagame.com'::text) OR (agent_web.site = 'nakanune.tv'::text) OR (agent_web.site = 'nashaplaneta.net'::text) OR (agent_web.site = 'nashaplaneta.su'::text) OR (agent_web.site = 'nastroenie.tv'::text) OR (agent_web.site = 'newfilms.online'::text) OR (agent_web.site = 'newstube.ru'::text) OR (agent_web.site = 'nextgame.net'::text) OR (agent_web.site = 'nonograms.ru'::text) OR (agent_web.site = 'novate.ru'::text) OR (agent_web.site = 'nove-kino.com'::text) OR (agent_web.site = 'novinka.tv'::text) OR (agent_web.site = 'noviyfilm.me'::text) OR (agent_web.site = 'obzorpoker.com'::text) OR (agent_web.site = 'odezkino.ru'::text) OR (agent_web.site = 'ohotnik.com'::text) OR (agent_web.site = 'ohotniki.ru'::text) OR (agent_web.site = 'ohotnik-kolomna.ru'::text) OR (agent_web.site = 'on-bet.ru'::text) OR (agent_web.site = 'onlainfilm.me'::text) OR (agent_web.site = 'onlinefilm-hd.com'::text) OR (agent_web.site = 'onlineguru.ru'::text) OR (agent_web.site = 'otdelkino.ru'::text) OR (agent_web.site = 'otvetkino.ru'::text) OR (agent_web.site = 'overbetting.net'::text) OR (agent_web.site = 'pandora.tv'::text) OR (agent_web.site = 'panoidl.ru'::text) OR (agent_web.site = 'parimatchbetting7.com'::text) OR (agent_web.site = 'parimatch-betting8.com'::text) OR (agent_web.site = 'peers.tv'::text) OR (agent_web.site = 'peredelka.tv'::text) OR (agent_web.site = 'pesni-film.ru'::text) OR (agent_web.site = 'photorama.tv'::text) OR (agent_web.site = 'picabu.ru'::text) OR (agent_web.site = 'planetabelarus.by'::text) OR (agent_web.site = 'planetadorog.ru'::text) OR (agent_web.site = 'planeta-online.tv'::text) OR (agent_web.site = 'play4game.ru'::text) OR (agent_web.site = 'playground.ru'::text) OR (agent_web.site = 'playreplay.me'::text) OR (agent_web.site = 'plistingsrussia.com'::text) OR (agent_web.site = 'poigraem-rc.ru'::text) OR (agent_web.site = 'poker.ua'::text) OR (agent_web.site = 'poker1.ru'::text) OR (agent_web.site = 'pokerart.com'::text) OR (agent_web.site = 'poker-besplatno.ru'::text) OR (agent_web.site = 'pokerbestroom.ru'::text) OR (agent_web.site = 'pokerbooks.lt'::text) OR (agent_web.site = 'pokercash.ru'::text) OR (agent_web.site = 'poker-casher.com'::text) OR (agent_web.site = 'pokerdo.ru'::text) OR (agent_web.site = 'pokerdope.com'::text) OR (agent_web.site = 'poker-expert.org'::text) OR (agent_web.site = 'pokerfest.ru'::text) OR (agent_web.site = 'pokerinrussia.ru'::text) OR (agent_web.site = 'pokeristby.ru'::text) OR (agent_web.site = 'pokerlaws.ru'::text) OR (agent_web.site = 'pokermaestro.ru'::text) OR (agent_web.site = 'pokermaster-1a.com'::text) OR (agent_web.site = 'pokermoney.tv'::text) OR (agent_web.site = 'pokeroff.ru'::text) OR (agent_web.site = 'pokerpapa.com'::text) OR (agent_web.site = 'pokerplan.ru'::text) OR (agent_web.site = 'poker-profit.com'::text) OR (agent_web.site = 'pokerprolabs.com'::text) OR (agent_web.site = 'pokerrus.net'::text) OR (agent_web.site = 'poker-shkola.ru'::text) OR (agent_web.site = 'pokershopspb.ru'::text) OR (agent_web.site = 'poker-soft.net'::text) OR (agent_web.site = 'pokerstars.uk'::text) OR (agent_web.site = 'pokerstarter.life'::text) OR (agent_web.site = 'pokerstrategy.com'::text) OR (agent_web.site = 'pokerstrategy.net'::text) OR (agent_web.site = 'pokerstrategy.org'::text) OR (agent_web.site = 'poker-wiki.ru'::text) OR (agent_web.site = 'poki.by'::text) OR (agent_web.site = 'pressa.tv'::text) OR (agent_web.site = 'protvoysport.ru'::text) OR (agent_web.site = 'pscp.tv'::text) OR (agent_web.site = 'qostanay.tv'::text) OR (agent_web.site = 'razborkino.ru'::text) OR (agent_web.site = 'razlozhi.ru'::text) OR (agent_web.site = 'redmediatv.ru'::text) OR (agent_web.site = 'ren.tv'::text) OR (agent_web.site = 'rline.tv'::text) OR (agent_web.site = 'rp-crimegta.ru'::text) OR (agent_web.site = 'rtr-planeta.com'::text) OR (agent_web.site = 'rus24.tv'::text) OR (agent_web.site = 'russia.tv'::text) OR (agent_web.site = 'rustars.tv'::text) OR (agent_web.site = 'rusvesna.tv'::text) OR (agent_web.site = 'rutube.ru'::text) OR (agent_web.site = 'rzona.ru'::text) OR (agent_web.site = 'sagamet.ru'::text) OR (agent_web.site = 'saitigr.ru'::text) OR (agent_web.site = 'savelagame.ru'::text) OR (agent_web.site = 'shara-games.ru'::text) OR (agent_web.site = 'smart-planets.ru'::text) OR (agent_web.site = 'smart-poker.ru'::text) OR (agent_web.site = 'smotretsport.tv'::text) OR (agent_web.site = 'smotrisport.tv'::text) OR (agent_web.site = 'smotriufilm.ru'::text) OR (agent_web.site = 'sovetskiefilmy.net'::text) OR (agent_web.site = 'sovkinofilm.ru'::text) OR (agent_web.site = 'sovsport.ru'::text) OR (agent_web.site = 'sport.ru'::text) OR (agent_web.site = 'sport-express.ru'::text) OR (agent_web.site = 'sportfm.ru'::text) OR (agent_web.site = 'sportholdem.ru'::text) OR (agent_web.site = 'sport-i-fitness.ru'::text) OR (agent_web.site = 'sportivnye-prognozy.ru'::text) OR (agent_web.site = 'sportmo.ru'::text) OR (agent_web.site = 'sportobzor.ru'::text) OR (agent_web.site = 'sportrbc.ru'::text))) THEN 431 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'guildwars.com'::text) OR (agent_web.site = 'guildwars2.com'::text) OR (agent_web.site = 'hddfilm-film3d.ru'::text) OR (agent_web.site = 'hd-films.biz'::text) OR (agent_web.site = 'hd-kinomax.biz'::text) OR (agent_web.site = 'hd-kinomax.org'::text) OR (agent_web.site = 'hdkinomax.tv'::text) OR (agent_web.site = 'hdkinorip.ru'::text) OR (agent_web.site = 'hdkinoteka.com'::text) OR (agent_web.site = 'hdserial.tv'::text) OR (agent_web.site = 'hdvideo24.ru'::text) OR (agent_web.site = 'hearthstone-wow.ru'::text) OR (agent_web.site = 'heroeswm.ru'::text) OR (agent_web.site = 'horoshie-igri.ru'::text) OR (agent_web.site = 'howtogame.ru'::text) OR (agent_web.site = 'igamer.biz'::text) OR (agent_web.site = 'igra74.ru'::text) OR (agent_web.site = 'igra-prestoloff.cx'::text) OR (agent_web.site = 'igra-razuma.ru'::text) OR (agent_web.site = 'igra-v-poker.com'::text) OR (agent_web.site = 'igrocity.ru'::text) OR (agent_web.site = 'igromagazin.ru'::text) OR (agent_web.site = 'igromania.ru'::text) OR (agent_web.site = 'igroray.ru'::text) OR (agent_web.site = 'igroshop.com'::text) OR (agent_web.site = 'igroved.ru'::text) OR (agent_web.site = 'igr-sale.ru'::text) OR (agent_web.site = 'igrucki.ru'::text) OR (agent_web.site = 'igrutoy.ru'::text) OR (agent_web.site = 'igry.ru'::text) OR (agent_web.site = 'igry-pro.ru'::text) OR (agent_web.site = 'imaxkinosfera.ru'::text) OR (agent_web.site = 'infosport.ru'::text) OR (agent_web.site = 'infox.tv'::text) OR (agent_web.site = 'innogames.com'::text) OR (agent_web.site = 'jurassicworldfilm.ru'::text) OR (agent_web.site = 'kaifolog.ru'::text) OR (agent_web.site = 'kartabita.ru'::text) OR (agent_web.site = 'katushka.tv'::text) OR (agent_web.site = 'kino-24.club'::text) OR (agent_web.site = 'kino2go.net'::text) OR (agent_web.site = 'kino-720.biz'::text) OR (agent_web.site = 'kinoafisha.info'::text) OR (agent_web.site = 'kinoafisha.ua'::text) OR (agent_web.site = 'kino-baltika.ru'::text) OR (agent_web.site = 'kinobar.su'::text) OR (agent_web.site = 'kinobars.net'::text) OR (agent_web.site = 'kinobb.club'::text) OR (agent_web.site = 'kinobes.ru'::text) OR (agent_web.site = 'kinobomber.com'::text) OR (agent_web.site = 'kinobos.net'::text) OR (agent_web.site = 'kinoboss.me'::text) OR (agent_web.site = 'kinobublik.net'::text) OR (agent_web.site = 'kinobunt.ru'::text) OR (agent_web.site = 'kinocenter.ru'::text) OR (agent_web.site = 'kino-city.net'::text) OR (agent_web.site = 'kinoclips.tv'::text) OR (agent_web.site = 'kinoclips1.net'::text) OR (agent_web.site = 'kinoclub.tv'::text) OR (agent_web.site = 'kinodacha.biz'::text) OR (agent_web.site = 'kinodacha.info'::text) OR (agent_web.site = 'kinodacha.org'::text) OR (agent_web.site = 'kinodom7.ru'::text) OR (agent_web.site = 'kinodrevo.ru'::text) OR (agent_web.site = 'kinoelka.ru'::text) OR (agent_web.site = 'kinoezhik.ru'::text) OR (agent_web.site = 'kinoface.ru'::text) OR (agent_web.site = 'kinofor.net'::text) OR (agent_web.site = 'kinogid.me'::text) OR (agent_web.site = 'kinoglobe.ru'::text) OR (agent_web.site = 'kinoglym.ru'::text) OR (agent_web.site = 'kinogo.club'::text) OR (agent_web.site = 'kinogo.faith'::text) OR (agent_web.site = 'kinogo.movie'::text) OR (agent_web.site = 'kinogo1.club'::text) OR (agent_web.site = 'kinogo2.net'::text) OR (agent_web.site = 'kinogo-2016.net'::text) OR (agent_web.site = 'kinogo-720.co'::text) OR (agent_web.site = 'kinogo720hd.ru'::text) OR (agent_web.site = 'kinogo-club.co'::text) OR (agent_web.site = 'kinogo-co-2016.ru'::text) OR (agent_web.site = 'kino-goda.net'::text) OR (agent_web.site = 'kinogohd.net'::text) OR (agent_web.site = 'kinogon.co'::text) OR (agent_web.site = 'kinogonet.me'::text) OR (agent_web.site = 'kinogo-new.co'::text) OR (agent_web.site = 'kinogoo.club'::text) OR (agent_web.site = 'kinogo-one.ru'::text) OR (agent_web.site = 'kinogo-onlain.club'::text) OR (agent_web.site = 'kinogoonline.club'::text) OR (agent_web.site = 'kinogo-online.com'::text) OR (agent_web.site = 'kinogo-smotret.com'::text) OR (agent_web.site = 'kinogo-smotret.net'::text) OR (agent_web.site = 'kinogot.tv'::text) OR (agent_web.site = 'kinogo-zz.ru'::text) OR (agent_web.site = 'kino-grad.ru'::text) OR (agent_web.site = 'kinogyd.tv'::text) OR (agent_web.site = 'kinohabr.net'::text) OR (agent_web.site = 'kinohard.co'::text) OR (agent_web.site = 'kino-hd1080.ru'::text) OR (agent_web.site = 'kino-hd720.net'::text) OR (agent_web.site = 'kinohod.ru'::text) OR (agent_web.site = 'kinohome.net'::text) OR (agent_web.site = 'kinoimperia.net'::text) OR (agent_web.site = 'kinoistoria.ru'::text) OR (agent_web.site = 'kinokadr.ru'::text) OR (agent_web.site = 'kinoklad.ru'::text) OR (agent_web.site = 'kinokrad.co'::text) OR (agent_web.site = 'kinolog-centr.ru'::text) OR (agent_web.site = 'kinoly.ru'::text) OR (agent_web.site = 'kinoman.online'::text) OR (agent_web.site = 'kinomania.ru'::text) OR (agent_web.site = 'kinomasss.ru'::text) OR (agent_web.site = 'kino-max.com'::text) OR (agent_web.site = 'kinomax.ru'::text) OR (agent_web.site = 'kinomego.net'::text) OR (agent_web.site = 'kinomotor.ru'::text) OR (agent_web.site = 'kinonix.net'::text) OR (agent_web.site = 'kinoo.su'::text) OR (agent_web.site = 'kino-online.tv'::text) OR (agent_web.site = 'kinoplen.ru'::text) OR (agent_web.site = 'kinopod.org'::text) OR (agent_web.site = 'kinopod.ru'::text) OR (agent_web.site = 'kinopoisk.ru'::text) OR (agent_web.site = 'kinoprofi.org'::text) OR (agent_web.site = 'kinoprovod.ru'::text) OR (agent_web.site = 'kinoradiomagia.tv'::text) OR (agent_web.site = 'kinorole.ru'::text) OR (agent_web.site = 'kinoserv.net'::text) OR (agent_web.site = 'kinosezon.tv'::text) OR (agent_web.site = 'kinosweet.net'::text) OR (agent_web.site = 'kino-teatr.ru'::text) OR (agent_web.site = 'kinotochka.pro'::text) OR (agent_web.site = 'kinotut.org'::text) OR (agent_web.site = 'kinotv1.ru'::text) OR (agent_web.site = 'kino-tv-forum.ru'::text) OR (agent_web.site = 'kinovdom.ru'::text) OR (agent_web.site = 'kino-v-dome.net'::text) OR (agent_web.site = 'kino-v-hd.net'::text) OR (agent_web.site = 'kinovu.ru'::text) OR (agent_web.site = 'kinozip.online'::text) OR (agent_web.site = 'knitweek.ru'::text) OR (agent_web.site = 'kordonivkakino.club'::text) OR (agent_web.site = 'kost.tv'::text) OR (agent_web.site = 'kttc.ru'::text) OR (agent_web.site = 'kuban24.tv'::text) OR (agent_web.site = 'ladywow.ru'::text) OR (agent_web.site = 'laim.tv'::text) OR (agent_web.site = 'legalkino.ru'::text) OR (agent_web.site = 'lentaigr.ru'::text))) THEN 430 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = '1xbet.com'::text) OR (agent_web.site = '247-video.net'::text) OR (agent_web.site = '24azino777.org'::text) OR (agent_web.site = '24video.adult'::text) OR (agent_web.site = '2do2go.ru'::text) OR (agent_web.site = '4azino888.win'::text) OR (agent_web.site = '7days.ru'::text) OR (agent_web.site = '7youtube.ru'::text) OR (agent_web.site = '900igr.net'::text) OR (agent_web.site = 'academypoker.ru'::text) OR (agent_web.site = 'adleongame.com'::text) OR (agent_web.site = 'adme.ru'::text) OR (agent_web.site = 'adwfilms.com'::text) OR (agent_web.site = 'afisha.ru'::text) OR (agent_web.site = 'aivis.tv'::text) OR (agent_web.site = 'allanekdot.ru'::text) OR (agent_web.site = 'allpokernews.ru'::text) OR (agent_web.site = 'allsportinfo.ru'::text) OR (agent_web.site = 'anekdot.ru'::text) OR (agent_web.site = 'anekdotix.ru'::text) OR (agent_web.site = 'anekdotov.net'::text) OR (agent_web.site = 'anekdotovmir.ru'::text) OR (agent_web.site = 'anekdoty.ru'::text) OR (agent_web.site = 'anekdotytoday.net'::text) OR (agent_web.site = 'apygame.com'::text) OR (agent_web.site = 'armedforcesweekly.com'::text) OR (agent_web.site = 'armorgame.ru'::text) OR (agent_web.site = 'artkino.net'::text) OR (agent_web.site = 'autorambler.ru'::text) OR (agent_web.site = 'avtovodeo-tube.ru'::text) OR (agent_web.site = 'azino7777.win'::text) OR (agent_web.site = 'azino888-11.com'::text) OR (agent_web.site = 'azino888-12.com'::text) OR (agent_web.site = 'azinogo.com'::text) OR (agent_web.site = 'baskino.co'::text) OR (agent_web.site = 'beltube.by'::text) OR (agent_web.site = 'bestgamer.net'::text) OR (agent_web.site = 'best-games.today'::text) OR (agent_web.site = 'bet-booom.ru'::text) OR (agent_web.site = 'bigcinema-films.net'::text) OR (agent_web.site = 'biggestgame.ru'::text) OR (agent_web.site = 'bkfon-bet.tk'::text) OR (agent_web.site = 'bk-fonbet.tv'::text) OR (agent_web.site = 'bobfilm1.co'::text) OR (agent_web.site = 'brizbe.com'::text) OR (agent_web.site = 'bublik.tv'::text) OR (agent_web.site = 'bugaga.ru'::text) OR (agent_web.site = 'cadelta.ru'::text) OR (agent_web.site = 'casinogames.ru'::text) OR (agent_web.site = 'celebtube.ru'::text) OR (agent_web.site = 'chaskino.ru'::text) OR (agent_web.site = 'cinema-hd.tv'::text) OR (agent_web.site = 'coldfilm.ru'::text) OR (agent_web.site = 'columbgame.club'::text) OR (agent_web.site = 'crashkino.net'::text) OR (agent_web.site = 'crimerussia.tv'::text) OR (agent_web.site = 'currenttime.tv'::text) OR (agent_web.site = 'debilizator.tv'::text) OR (agent_web.site = 'delfilm.ru'::text) OR (agent_web.site = 'digimon-heroes.com'::text) OR (agent_web.site = 'dimonvideo.ru'::text) OR (agent_web.site = 'dnpmag.com'::text) OR (agent_web.site = 'dom2news.su'::text) OR (agent_web.site = 'dom2reality.ru'::text) OR (agent_web.site = 'domavideo.ru'::text) OR (agent_web.site = 'dota2.com'::text) OR (agent_web.site = 'dota2.ru'::text) OR (agent_web.site = 'dota2plus2.ru'::text) OR (agent_web.site = 'durbetsel.ru'::text) OR (agent_web.site = 'ekabu.ru'::text) OR (agent_web.site = 'ekranka.tv'::text) OR (agent_web.site = 'emigrantka.com'::text) OR (agent_web.site = 'enisey.tv'::text) OR (agent_web.site = 'eurosport.ru'::text) OR (agent_web.site = 'exitgames.ru'::text) OR (agent_web.site = 'extensionrutube.ru'::text) OR (agent_web.site = 'fanserials.tv'::text) OR (agent_web.site = 'fastumgame.ru'::text) OR (agent_web.site = 'fatalgame.com'::text) OR (agent_web.site = 'fifaxa-game.com'::text) OR (agent_web.site = 'f-igri.ru'::text) OR (agent_web.site = 'film.ru'::text) OR (agent_web.site = 'film2u.ru'::text) OR (agent_web.site = 'film720.ru'::text) OR (agent_web.site = 'filmanias.com'::text) OR (agent_web.site = 'filmio.tv'::text) OR (agent_web.site = 'filmonline.online'::text) OR (agent_web.site = 'filmpro.ru'::text) OR (agent_web.site = 'films2you.ru'::text) OR (agent_web.site = 'films-online.cc'::text) OR (agent_web.site = 'films-online.tv'::text) OR (agent_web.site = 'filmstart.ru'::text) OR (agent_web.site = 'filmz.ru'::text) OR (agent_web.site = 'findfilms.ru'::text) OR (agent_web.site = 'fishki.net'::text) OR (agent_web.site = 'flash-igry.com'::text) OR (agent_web.site = 'fonbet.ru'::text) OR (agent_web.site = 'fonbet-02db1.tk'::text) OR (agent_web.site = 'fonbet2.com'::text) OR (agent_web.site = 'fonbet-31c88.tk'::text) OR (agent_web.site = 'fonbet-7f02c.tk'::text) OR (agent_web.site = 'fonbet-9e5b6.tk'::text) OR (agent_web.site = 'fonbet-ec3f7.tk'::text) OR (agent_web.site = 'football-russia.tv'::text) OR (agent_web.site = 'formulakino.ru'::text) OR (agent_web.site = 'forum-dollplanet.ru'::text) OR (agent_web.site = 'forumhouse.tv'::text) OR (agent_web.site = 'foto-planeta.com'::text) OR (agent_web.site = 'frankmoneyslots.club'::text) OR (agent_web.site = 'fresh-films.ru'::text) OR (agent_web.site = 'funnycat.tv'::text) OR (agent_web.site = 'game01.ru'::text) OR (agent_web.site = 'game2day.org'::text) OR (agent_web.site = 'game-bonuses.club'::text) OR (agent_web.site = 'gamebuka.ru'::text) OR (agent_web.site = 'gamedesire.com'::text) OR (agent_web.site = 'gamefaqs.com'::text) OR (agent_web.site = 'gamegpu.com'::text) OR (agent_web.site = 'gamegula.org'::text) OR (agent_web.site = 'gamelabel.ru'::text) OR (agent_web.site = 'gameleads.ru'::text) OR (agent_web.site = 'gamenet.ru'::text) OR (agent_web.site = 'game-onlaine.ru'::text) OR (agent_web.site = 'gamepark.ru'::text) OR (agent_web.site = 'gamepitstop.ru'::text) OR (agent_web.site = 'gamer.ru'::text) OR (agent_web.site = 'gamerguru.ru'::text) OR (agent_web.site = 'gamerlead.ru'::text) OR (agent_web.site = 'gamerulez.net'::text) OR (agent_web.site = 'games-dendy.com'::text) OR (agent_web.site = 'gamesdraw.ru'::text) OR (agent_web.site = 'gamesindustry.biz'::text) OR (agent_web.site = 'gamesisart.ru'::text) OR (agent_web.site = 'games-of-thrones.ru'::text) OR (agent_web.site = 'games-vip.ru'::text) OR (agent_web.site = 'game-wiki.guru'::text) OR (agent_web.site = 'gav.tv'::text) OR (agent_web.site = 'gazetaosporte.ru'::text) OR (agent_web.site = 'gif-kartinki.ru'::text) OR (agent_web.site = 'gipsyteam.ru'::text) OR (agent_web.site = 'glas.tv'::text) OR (agent_web.site = 'glavny.tv'::text) OR (agent_web.site = 'glaz.tv'::text) OR (agent_web.site = 'gmbox.ru'::text) OR (agent_web.site = 'godgames.ru'::text) OR (agent_web.site = 'gold-films.ru'::text) OR (agent_web.site = 'goodgamefun.ru'::text) OR (agent_web.site = 'goodkino.net'::text) OR (agent_web.site = 'grandgames.net'::text) OR (agent_web.site = 'greenheartgames.com'::text))) THEN 105 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'vk.com'::text) OR (agent_web.site = 'facebook.com'::text) OR (agent_web.site = 'topface.com'::text) OR (agent_web.site = 'twitter.org'::text) OR (agent_web.site = 'fotostrana.ru'::text) OR (agent_web.site = 'linkedin.com'::text) OR (agent_web.site = 'ok.ru'::text))) THEN 103 ELSE 0 END, CASE WHEN (((agent_web.domain = 'technet.microsoft.com'::text) OR (agent_web.domain = 'rasp.yandex.ru'::text) OR (agent_web.domain = 'otvet.mail.ru'::text) OR (agent_web.domain = 'org.rambler.ru'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 350 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'wikipedia.org'::text) OR (agent_web.site = 'slovari.ru'::text) OR (agent_web.site = 'wikiznanie.ru'::text) OR (agent_web.site = 'academic.ru'::text) OR (agent_web.site = 'abc-people.com'::text) OR (agent_web.site = 'spravki.ne'::text) OR (agent_web.site = 'thesaurus.com'::text) OR (agent_web.site = 'merriam-webster.com'::text) OR (agent_web.site = 'multitran.ru'::text) OR (agent_web.site = 'britannica.com'::text) OR (agent_web.site = 'megabook.ru'::text) OR (agent_web.site = 'krugosvet.ru'::text) OR (agent_web.site = 'rubricon.com'::text) OR (agent_web.site = 'consultant.ru'::text) OR (agent_web.site = 'regionoperator.ru'::text) OR (agent_web.site = 'serverfault.com'::text))) THEN 111 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND (agent_web.site = 'credits.ru'::text)) THEN 347 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'indacoin.com'::text) OR (agent_web.site = 'bitkonan.com'::text) OR (agent_web.site = 'kuna.io'::text) OR (agent_web.site = 'bleutrade.com'::text) OR (agent_web.site = 'c-cex.com'::text) OR (agent_web.site = 'binarium.com'::text) OR (agent_web.site = 'btcchina.com'::text) OR (agent_web.site = 'okcoin.com'::text) OR (agent_web.site = 'wex.nz'::text) OR (agent_web.site = 'binance.com'::text) OR (agent_web.site = 'hitbtc.com'::text) OR (agent_web.site = 'livecoin.net'::text) OR (agent_web.site = 'yobit.io'::text) OR (agent_web.site = 'exmo.me'::text) OR (agent_web.site = 'poloniex.com'::text) OR (agent_web.site = 'kraken.com'::text) OR (agent_web.site = 'bitfinex.com'::text) OR (agent_web.site = 'iqmining.com'::text) OR (agent_web.site = 'hashflare.io'::text) OR (agent_web.site = 'genesis-mining.com'::text) OR (agent_web.site = 'world-mining.net'::text) OR (agent_web.site = 'nuvoo.io'::text) OR (agent_web.site = 'ccgmining.com'::text) OR (agent_web.site = 'aliencloud.xyz'::text) OR (agent_web.site = 'eobot.com'::text) OR (agent_web.site = 'f2pool.com'::text) OR (agent_web.site = 'miningrigrentals.com'::text) OR (agent_web.site = 'minergate.com'::text) OR (agent_web.site = 'zpool.ca'::text) OR (agent_web.site = 'bitclubnetwork.tilda.ws'::text) OR (agent_web.site = 'btcchina.com'::text) OR (agent_web.site = 'antpool.com'::text) OR (agent_web.site = 'antminertechnology.com'::text) OR (agent_web.site = 'bw.com'::text) OR (agent_web.site = 'bitfury.com'::text) OR (agent_web.site = 'blockchain.info'::text) OR (agent_web.site = 'btc.com'::text) OR (agent_web.site = 'viabtc.com'::text) OR (agent_web.site = 'btc.top'::text) OR (agent_web.site = 'dpool.top'::text) OR (agent_web.site = 'haopool.com'::text) OR (agent_web.site = 'pool.btcc.com'::text) OR (agent_web.site = 'bitclubnetwork.com'::text) OR (agent_web.site = '58coin.com'::text) OR (agent_web.site = 'canoepool.com'::text) OR (agent_web.site = 'bitcoin.com'::text) OR (agent_web.site = 'connectbtc.com'::text) OR (agent_web.site = 'bitcoin-russia.ru'::text) OR (agent_web.site = 'poolhb.com'::text) OR (agent_web.site = 'btc.com'::text) OR (agent_web.site = 'ethpool.org'::text) OR (agent_web.site = 'eth.nanopool.org'::text) OR (agent_web.site = 'ethereumpool.co'::text) OR (agent_web.site = 'mining-cryptocurrency.ru'::text) OR (agent_web.site = 'whattomine.com'::text) OR (agent_web.site = 'cryptocompare.com'::text) OR (agent_web.site = 'profit-mine.com'::text) OR (agent_web.site = 'bitmakler.com'::text) OR (agent_web.site = 'bits.media'::text) OR (agent_web.site = 'nicehash.com'::text) OR (agent_web.site = 'ethermine.org'::text))) THEN 358 ELSE 0 END, CASE WHEN ((agent_web.domain = 'msdn.microsoft.com'::text) AND (agent_eventtype.id = '100500'::bigint)) THEN 349 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'hh.ru'::text) OR (agent_web.site = 'zarplata.ru'::text) OR (agent_web.site = 'superjob.ru'::text) OR (agent_web.site = 'gorjob.ru'::text) OR (agent_web.site = 'erabota.ru'::text) OR (agent_web.site = 'rabota.ru'::text) OR (agent_web.site = 'rosrabota.ru'::text) OR (agent_web.site = 'job.ru'::text) OR (agent_web.site = 'job-mo.ru'::text) OR (agent_web.site = 'neuvoo.ru'::text) OR (agent_web.site = 'gorodrabot.ru'::text) OR (agent_web.site = 'rabota.uz'::text))) THEN 121 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND (agent_web.site = 'studwork.org'::text)) THEN 353 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND (agent_web.site = 'mediator.media'::text)) THEN 363 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND (agent_web.site = 'megaplan.ru'::text)) THEN 354 ELSE 0 END, CASE WHEN (((agent_web.domain = 'news.yandex.ru'::text) OR (agent_web.domain = 'news.mail.ru'::text) OR (agent_web.domain = 'sport.mail.ru'::text) OR (agent_web.domain = 'hi-tech.mail.ru'::text) OR (agent_web.domain = 'news.google.com'::text) OR (agent_web.domain = 'news.rambler.ru'::text) OR (agent_web.domain = 'sport.rambler.ru'::text) OR (agent_web.domain = 'news.ngs.ru'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 366 ELSE 0 END, CASE WHEN (((agent_web.domain = 'afisha.yandex.ru'::text) OR (agent_web.domain = 'tv.yandex.ru'::text) OR (agent_web.domain = 'horo.mail.ru'::text) OR (agent_web.domain = 'kino.mail.ru'::text) OR (agent_web.domain = 'tv.mail.ru'::text) OR (agent_web.domain = 'play.google.com'::text) OR (agent_web.domain = 'afisha.rambler.ru'::text) OR (agent_web.domain = 'nevsedoma.com.ua'::text) OR (agent_web.domain = 'top.24smile.net'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 367 ELSE 0 END, CASE WHEN ((agent_web.domain = 'rabota.yandex.ru'::text) AND (agent_eventtype.id = '100500'::bigint)) THEN 375 ELSE 0 END, CASE WHEN (((agent_web.domain = 'realty.yandex.ru'::text) OR (agent_web.domain = 'realty.mail.ru'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 372 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'avito.ru'::text) OR (agent_web.site = 'irr.ru'::text) OR (agent_web.site = 'tiu.ru'::text) OR (agent_web.site = 'pulscen.ru'::text) OR (agent_web.site = 'youla.io'::text) OR (agent_web.site = 'au.ru'::text) OR (agent_web.site = 'youla.ru'::text) OR (agent_web.site = 'aliexpress.com'::text) OR (agent_web.site = 'aliexpress.ru'::text))) THEN 112 ELSE 0 END, CASE WHEN (((agent_web.domain = 'kassa.yandex.ru'::text) OR (agent_web.domain = 'toloka.yandex.ru'::text) OR (agent_web.domain = 'telephony.yandex.ru'::text) OR (agent_web.domain = 'money.yandex.ru'::text) OR (agent_web.domain = 'finance.rambler.ru'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 377 ELSE 0 END, CASE WHEN (((agent_web.domain = 'radio.yandex.ru'::text) OR (agent_web.domain = 'music.yandex.ru'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 380 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND (agent_web.site = 'delivery-club.ru'::text)) THEN 385 ELSE 0 END, CASE WHEN (((agent_web.domain = 'auto.rambler.ru'::text) OR (agent_web.domain = 'auto.mail.ru'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 373 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND (agent_web.site = 'rp5.ru'::text)) THEN 361 ELSE 0 END, CASE WHEN (((agent_web.domain = 'games.mail.ru'::text) OR (agent_web.domain = 'gaming.youtube.com'::text) OR (agent_web.domain = 'games.rambler.ru'::text) OR (agent_web.domain = 'www.twitch.tv'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 388 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '18'::bigint) AND ((agent_web.site = 'auto.ru'::text) OR (agent_web.site = 'drom.ru'::text) OR (agent_web.site = 'am.ru'::text) OR (agent_web.site = 'beepcar.ru'::text))) THEN 391 ELSE 0 END, CASE WHEN (((agent_web.domain = 'taxi.yandex.ru'::text) OR (agent_web.domain = 'www.uber.com'::text) OR (agent_web.domain = 'www.car5.ru'::text) OR (agent_web.domain = 'www.easyride.ru'::text) OR (agent_web.domain = 'www.rentmee.club'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 395 ELSE 0 END, CASE WHEN (((agent_web.domain = 'disk.yandex.ru'::text) OR (agent_web.domain = 'cloud.mail.ru'::text) OR (agent_web.domain = 'photos.google.com'::text) OR (agent_web.domain = 'drive.google.com'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 398 ELSE 0 END, CASE WHEN ((agent_web.domain = 'money.yandex.ru'::text) AND (agent_eventtype.id = '100500'::bigint)) THEN 397 ELSE 0 END, CASE WHEN (((agent_web.domain = 'partner.yandex.ru'::text) OR (agent_web.domain = 'direct.yandex.ru'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 403 ELSE 0 END, CASE WHEN (((agent_web.domain = 'avia.yandex.ru'::text) OR (agent_web.domain = 'travel.yandex.ru'::text) OR (agent_web.domain = 'travel.rambler.ru'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 401 ELSE 0 END, CASE WHEN (((agent_web.domain = 'stat.yandex.ru'::text) OR (agent_web.domain = 'webmaster.yandex.ru'::text) OR (agent_web.domain = 'metrika.yandex.ru'::text) OR (agent_web.domain = 'display.yandex.ru'::text) OR (agent_web.domain = 'top.mail.ru'::text) OR (agent_web.domain = 'widget.my.com'::text) OR (agent_web.domain = 'tech.yandex.ru'::text) OR (agent_web.domain = 'adwords.google.com'::text) OR (agent_web.domain = 'scholar.google.com'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 405 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'delimobil.ru'::text) OR (agent_web.site = 'cars7.ru'::text) OR (agent_web.site = 'anytimecar.ru'::text) OR (agent_web.site = 'youdrive.today'::text) OR (agent_web.site = 'belkacar.ru'::text) OR (agent_web.site = 'carenda.ru'::text) OR (agent_web.site = 'car4you.ru'::text) OR (agent_web.site = 'lifcar.ru'::text) OR (agent_web.site = 'carlion.com'::text) OR (agent_web.site = 'carusel.club'::text))) THEN 396 ELSE 0 END, CASE WHEN (((agent_web.domain = 'market.yandex.ru'::text) OR (agent_web.domain = 'ru.aliexpress.com'::text) OR (agent_web.domain = 'torg.mail.ru'::text) OR (agent_web.domain = 'express.google.com'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 392 ELSE 0 END, CASE WHEN (((agent_web.domain = 'calendar.yandex.ru'::text) OR (agent_web.domain = 'calendar.mail.ru'::text) OR (agent_web.domain = 'calendar.google.com'::text) OR (agent_web.domain = 'keep.google.com'::text) OR (agent_web.domain = 'docs.google.com'::text) OR (agent_web.domain = 'sites.google.com'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 409 ELSE 0 END, CASE WHEN (((agent_web.domain = 'deti.mail.ru'::text) OR (agent_web.domain = 'health.mail.ru'::text) OR (agent_web.domain = 'lady.mail.ru'::text) OR (agent_web.domain = 'pets.mail.ru'::text) OR (agent_web.domain = 'health.yandex.ru'::text) OR (agent_web.domain = 'woman.rambler.ru'::text) OR (agent_web.domain = 'doctor.rambler.ru'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 411 ELSE 0 END, CASE WHEN (((agent_web.domain = 'dobro.mail.ru'::text) OR (agent_web.domain = 'love.mail.ru'::text) OR (agent_web.domain = 'plus.google.com'::text) OR (agent_web.domain = 'dating.rambler.ru'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 410 ELSE 0 END, CASE WHEN (((agent_web.domain = 'ru.maps.me'::text) OR (agent_web.domain = 'www.openstreetmap.org'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 414 ELSE 0 END, CASE WHEN (((agent_web.domain = 'webagent.mail.ru'::text) OR (agent_web.domain = 'agent.mail.ru'::text) OR (agent_web.domain = 'web.icq.com'::text) OR (agent_web.domain = 'groups.google.com'::text) OR (agent_web.domain = 'web.whatsapp.com'::text) OR (agent_web.domain = 'web.telegram.org'::text) OR (agent_web.domain = 'web.skype.com'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 413 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '18'::bigint) AND ((agent_web.site = 'seosan.io'::text) OR (agent_web.site = 'webinar.ru'::text))) THEN 389 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND (agent_web.site = 'rp5.ru'::text)) THEN 416 ELSE 0 END, CASE WHEN (((agent_web.domain = 'translate.yandex.ru'::text) OR (agent_web.domain = 'translate.google.com'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 406 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND (agent_web.site = 'delivery-club.ru'::text)) THEN 412 ELSE 0 END, CASE WHEN (((agent_web.domain = 'ege.yandex.ru'::text) OR (agent_web.domain = 'edu.google.com'::text) OR (agent_web.domain = 'classroom.google.com'::text) OR (agent_web.domain = 'class.rambler.ru'::text)) AND (agent_eventtype.id = '100500'::bigint)) THEN 408 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND (agent_web.site = '24-ok.ru'::text)) THEN 355 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_web.site = 'staffcop.ru'::text) OR (agent_web.site = 'searchinform.ru'::text))) THEN 356 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = 'winrar.exe'::text) OR (agent_application.app_name = '7zfm.exe'::text) OR (agent_application.app_name = 'zip'::text) OR (agent_application.app_name = 'unzip'::text) OR (agent_application.app_name = 'rar'::text) OR (agent_application.app_name = 'unrar'::text) OR (agent_application.app_name = 'tar'::text) OR (agent_application.app_name = 'gzip'::text) OR (agent_application.app_name = 'gunzip'::text) OR (agent_application.app_name = 'p7zip'::text) OR (agent_application.app_name = '7zg.exe'::text))) THEN 340 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND (agent_application.app_name = 'tor.exe'::text)) THEN 342 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = '1Cv7s.exe'::text) OR (agent_application.app_name = '1cv8.exe'::text) OR (agent_application.app_name = '1cv8s.exe'::text) OR (agent_application.app_name = '1cv8c.exe'::text))) THEN 99 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = 'mintty.exe'::text) OR (agent_application.app_name = 'devenv.exe'::text) OR (agent_application.app_name = 'hlpviewer.exe'::text) OR (agent_application.app_name = 'phpstorm64.exe'::text))) THEN 345 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = 'mspaint.exe'::text) OR (agent_application.app_name = 'coreldrw.exe'::text) OR (agent_application.app_name = 'photoshop.exe'::text) OR (agent_application.app_name = 'acdsee9.exe'::text) OR (agent_application.app_name = 'geology.exe'::text) OR (agent_application.app_name = 'geobore.exe'::text) OR (agent_application.app_name = 'liniz.exe'::text) OR (agent_application.app_name = 'roads.exe'::text) OR (agent_application.app_name = 'acad.exe'::text) OR (agent_application.app_name = 'microsoft.photos.exe'::text) OR (agent_application.app_name = 'fsviewer.exe'::text) OR (agent_application.app_name = 'gimp'::text) OR (agent_application.app_name = 'inkscape'::text) OR (agent_application.app_name = 'gwenview'::text) OR (agent_application.app_name = 'xsane'::text) OR (agent_application.app_name = 'sdraw'::text) OR (agent_application.app_name = '3dsmax.exe'::text) OR (agent_application.app_name = 'acwebbrowser.exe'::text) OR (agent_application.app_name = 'scad.exe'::text) OR (agent_application.app_name = 'revit.exe'::text) OR (agent_application.app_name = 'gredi_co.exe'::text) OR (agent_application.app_name = 'ozc.exe'::text) OR (agent_application.app_name = 'cvm_selection.exe'::text) OR (agent_application.app_name = 'cvm_smoke.exe'::text) OR (agent_application.app_name = 'vezafan.exe'::text) OR (agent_application.app_name = 'revizto.exe'::text) OR (agent_application.app_name = 'revitworker.exe'::text) OR (agent_application.app_name = 'reviztoservice.exe'::text) OR (agent_application.app_name = 'reviztoservicegui.exe'::text) OR (agent_application.app_name = 'aerocad.exe'::text) OR (agent_application.app_name = 'sketchup.exe'::text) OR (agent_application.app_name = 'gredi_co.exe'::text))) THEN 101 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = 'icq_rfrset.exe'::text) OR (agent_application.app_name = 'icq.exe'::text) OR (agent_application.app_name = 'qip.exe'::text) OR (agent_application.app_name = 'qip2010.exe'::text) OR (agent_application.app_name = 'qip2012.exe'::text) OR (agent_application.app_name = 'magent.exe'::text) OR (agent_application.app_name = 'skype.exe'::text) OR (agent_application.app_name = 'miranda32.exe'::text) OR (agent_application.app_name = 'jabber.exe'::text) OR (agent_application.app_name = 'lync.exe'::text) OR (agent_application.app_name = 'skypebrowserhost.exe'::text) OR (agent_application.app_name = 'skypeforlinux'::text) OR (agent_application.app_name = 'skype'::text) OR (agent_application.app_name = 'telegram-desktop'::text) OR (agent_application.app_name = 'Telegram.exe'::text) OR (agent_application.app_name = 'WhatsApp.exe'::text) OR (agent_application.app_name = 'pidgin'::text) OR (agent_application.app_name = 'skypeapp.exe'::text))) THEN 96 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = 'wotlauncher.exe'::text) OR (agent_application.app_name = 'worldoftanks.exe'::text) OR (agent_application.app_name = 'worldofwarplanes.exe'::text) OR (agent_application.app_name = 'worldofwarships.exe'::text) OR (agent_application.app_name = 'doom.exe'::text) OR (agent_application.app_name = 'Cstrike.exe'::text) OR (agent_application.app_name = 'Steam.exe'::text) OR (agent_application.app_name = 'iw4sp.exe'::text) OR (agent_application.app_name = 'iw5sp.exe'::text) OR (agent_application.app_name = 'mp.exe'::text) OR (agent_application.app_name = 'minesweeper.exe'::text) OR (agent_application.app_name = 'solitaire.exe'::text) OR (agent_application.app_name = 'spider.exe'::text) OR (agent_application.app_name = 'civilizationvi.exe'::text) OR (agent_application.app_name = 'MAFIA3.EXE'::text))) THEN 98 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = 'EthDcrMiner64.exe'::text) OR (agent_application.app_name = 'ZecMiner64.exe'::text) OR (agent_application.app_name = 'cudaminer.exe'::text) OR (agent_application.app_name = 'guiminer.exe'::text) OR (agent_application.app_name = 'cgminer.exe'::text) OR (agent_application.app_name = 'nheqminer.exe '::text) OR (agent_application.app_name = 'ccminer.exe'::text))) THEN 359 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = 'wmplayer.exe'::text) OR (agent_application.app_name = 'kmplayer.exe'::text) OR (agent_application.app_name = 'aimp3.exe'::text) OR (agent_application.app_name = 'aimp.exe'::text) OR (agent_application.app_name = 'winamp.exe'::text) OR (agent_application.app_name = 'mplayer.exe'::text) OR (agent_application.app_name = 'vlc.exe'::text) OR (agent_application.app_name = 'mpc-hc64.exe'::text) OR (agent_application.app_name = 'mpc-hc32.exe'::text) OR (agent_application.app_name = 'vlc'::text) OR (agent_application.app_name = 'clementine'::text))) THEN 102 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = 'winword.exe'::text) OR (agent_application.app_name = 'excel.exe'::text) OR (agent_application.app_name = 'powerpnt.exe'::text) OR (agent_application.app_name = 'notepad+.exe'::text) OR (agent_application.app_name = 'wordpad.exe'::text) OR (agent_application.app_name = 'acrord32.exe'::text) OR (agent_application.app_name = 'mspaint.exe'::text) OR (agent_application.app_name = 'calc.exe'::text) OR (agent_application.app_name = 'soffice.bin'::text) OR (agent_application.app_name = 'mftbox.exe'::text) OR (agent_application.app_name = 'snippingtool.exe'::text) OR (agent_application.app_name = 'DATABASECOMPARE.EXE'::text) OR (agent_application.app_name = 'notepad.exe'::text) OR (agent_application.app_name = 'StikyNot.exe'::text) OR (agent_application.app_name = 'docxviewer.exe'::text) OR (agent_application.app_name = 'geany'::text) OR (agent_application.app_name = 'foxitreader.exe'::text) OR (agent_application.app_name = 'win32calc.exe'::text) OR (agent_application.app_name = 'soffice'::text) OR (agent_application.app_name = 'libreoffice'::text) OR (agent_application.app_name = 'qpdfview'::text) OR (agent_application.app_name = 'okular'::text) OR (agent_application.app_name = 'calculator.exe'::text) OR (agent_application.app_name = 'win32calc.exe'::text) OR (agent_application.app_name = 'libreoffice-calc'::text) OR (agent_application.app_name = 'atlexec.exe'::text) OR (agent_application.app_name = 'sublime_text.exe'::text) OR (agent_application.app_name = 'notepad+.exe'::text))) THEN 93 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = 'onedrive.exe'::text) OR (agent_application.app_name = 'cloud.exe'::text) OR (agent_application.app_name = 'megasync.exe'::text) OR (agent_application.app_name = 'yandexdisk.exe'::text) OR (agent_application.app_name = 'syncappw.exe'::text))) THEN 343 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = 'x-lite.exe'::text) OR (agent_application.app_name = '3cxphone.exe'::text) OR (agent_application.app_name = '3cxwin8phone.exe'::text) OR (agent_application.app_name = 'microsip.exe'::text) OR (agent_application.app_name = 'microsip-3.12.1.exe'::text) OR (agent_application.app_name = 'linphone.exe'::text) OR (agent_application.app_name = 'portgo.exe'::text) OR (agent_application.app_name = 'phonerlite.exe'::text) OR (agent_application.app_name = 'mango-talker.exe'::text))) THEN 94 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = 'putty.exe'::text) OR (agent_application.app_name = 'teamviewer.exe'::text) OR (agent_application.app_name = 'teamviewer_.exe'::text) OR (agent_application.app_name = 'teamviewer_portable.exe'::text) OR (agent_application.app_name = 'teamviewer_desktop.exe'::text) OR (agent_application.app_name = 'anydesk.exe'::text) OR (agent_application.app_name = 'winscp.exe'::text) OR (agent_application.app_name = 'totermw.exe'::text) OR (agent_application.app_name = 'bvssh.exe'::text) OR (agent_application.app_name = 'mstsc.exe'::text) OR (agent_application.app_name = 'aa_v3.1.exe'::text) OR (agent_application.app_name = 'aa_v3.2.exe'::text) OR (agent_application.app_name = 'aa_v3.3.exe'::text) OR (agent_application.app_name = 'aa_v3.4.exe'::text) OR (agent_application.app_name = 'aa_v3.5.exe'::text) OR (agent_application.app_name = 'aa_v3.6.exe'::text) OR (agent_application.app_name = 'aa_v3.exe'::text) OR (agent_application.app_name = 'remmina'::text) OR (agent_application.app_name = 'ssh'::text))) THEN 97 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = 'thunderbird.exe'::text) OR (agent_application.app_name = 'thebat.exe'::text) OR (agent_application.app_name = 'outlook.exe'::text) OR (agent_application.app_name = 'wmail.exe'::text) OR (agent_application.app_name = 'thebat.exe'::text) OR (agent_application.app_name = 'kmail'::text) OR (agent_application.app_name = 'thebat64.exe'::text))) THEN 95 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = 'systemsettings.exe'::text) OR (agent_application.app_name = 'systempropertiesadvanced.exe'::text) OR (agent_application.app_name = 'systempropertiescomputername.exe'::text) OR (agent_application.app_name = ' systemsettingsadminflows.exe'::text) OR (agent_application.app_name = 'cmd.exe'::text) OR (agent_application.app_name = 'vboxsvc.exe'::text) OR (agent_application.app_name = 'winscp.exe'::text) OR (agent_application.app_name = 'vmplayer.exe'::text) OR (agent_application.app_name = 'virtualbox.exe'::text) OR (agent_application.app_name = 'vmware-vmx.exe'::text) OR (agent_application.app_name = 'poweriso.exe'::text) OR (agent_application.app_name = 'bash.exe'::text) OR (agent_application.app_name = 'mmc.exe'::text) OR (agent_application.app_name = 'regedit.exe'::text) OR (agent_application.app_name = 'putty.exe'::text) OR (agent_application.app_name = 'konsole'::text) OR (agent_application.app_name = 'terminator'::text) OR (agent_application.app_name = 'xterm'::text) OR (agent_application.app_name = 'lxterminal'::text) OR (agent_application.app_name = 'powershell.exe'::text) OR (agent_application.app_name = 'powershell_ise.exe'::text) OR (agent_application.app_name = 'wireshark-gtk.exe'::text) OR (agent_application.app_name = 'wireshark.exe'::text))) THEN 100 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = 'lockapp.exe'::text) OR (agent_application.app_name = 'lockapphost.exe'::text))) THEN 352 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '100500'::bigint) AND ((agent_application.app_name = 'totalcmd64.exe'::text) OR (agent_application.app_name = 'far.exe'::text) OR (agent_application.app_name = 'freecommander.exe'::text) OR (agent_application.app_name = 'totalcmd.exe'::text) OR (agent_application.app_name = 'explorer.exe'::text) OR (agent_application.app_name = 'filezilla.exe'::text) OR (agent_application.app_name = 'dolphin'::text) OR (agent_application.app_name = 'nautilus'::text))) THEN 91 ELSE 0 END, CASE WHEN ((agent_filepath.name = 'Clipboard.png'::text) AND (agent_eventtype.id = '0'::bigint)) THEN 360 ELSE 0 END, CASE WHEN (((agent_eventtype.id = '1'::bigint) OR (agent_eventtype.id = '13'::bigint) OR (agent_eventtype.id = '25'::bigint)) AND (agent_event.text_search @@ '''vmnetdrv'''::tsquery)) THEN 417 ELSE 0 END, CASE WHEN (((agent_attachedfile.mime = 'application/zip_encrypted'::text) OR (agent_attachedfile.mime = 'application/x-rar_encrypted'::text)) AND (agent_eventtype.id = '0'::bigint)) THEN 419 ELSE 0 END, CASE WHEN ((agent_eventtype.id = '27'::bigint) AND ((agent_event.window_title ~ 'pass|password|passwd'::text) OR (agent_event.text_data ~ 'pass|password|passwd'::text))) THEN 418 ELSE 0 END, CASE WHEN (agent_eventtype.id = '100500'::bigint) THEN 1117 ELSE 0 END], 0)))
  • Sort Method: quicksort Memory: 26kB
3. 0.517 0.740 ↑ 231,458.6 29 1

ProjectSet (cost=160.67..225,014.83 rows=6,712,300 width=12) (actual time=0.355..0.740 rows=29 loops=1)

4. 0.018 0.223 ↑ 849.7 79 1

Hash Right Join (cost=160.67..488.40 rows=67,123 width=334) (actual time=0.208..0.223 rows=79 loops=1)

  • Hash Cond: (agent_contact_events.event_id = agent_event.id)
5. 0.002 0.002 ↑ 185.5 11 1

Seq Scan on agent_contact_events (cost=0.00..30.40 rows=2,040 width=8) (actual time=0.002..0.002 rows=11 loops=1)

6. 0.017 0.203 ↑ 27.9 73 1

Hash (cost=135.17..135.17 rows=2,040 width=334) (actual time=0.203..0.203 rows=73 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 33kB
7. 0.013 0.186 ↑ 27.9 73 1

Hash Right Join (cost=90.80..135.17 rows=2,040 width=334) (actual time=0.175..0.186 rows=73 loops=1)

  • Hash Cond: (analytics_filter_events.event_id = agent_event.id)
8. 0.011 0.011 ↑ 136.0 15 1

Seq Scan on analytics_filter_events (cost=0.00..30.40 rows=2,040 width=8) (actual time=0.010..0.011 rows=15 loops=1)

9. 0.017 0.162 ↓ 1.1 66 1

Hash (cost=90.02..90.02 rows=62 width=334) (actual time=0.162..0.162 rows=66 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
10. 0.012 0.145 ↓ 1.1 66 1

Hash Left Join (cost=83.25..90.02 rows=62 width=334) (actual time=0.089..0.145 rows=66 loops=1)

  • Hash Cond: (agent_event.attached_file_id = agent_attachedfile.id)
11. 0.013 0.115 ↓ 1.1 66 1

Hash Left Join (cost=68.08..74.68 rows=62 width=310) (actual time=0.065..0.115 rows=66 loops=1)

  • Hash Cond: (agent_event.file_path_id = agent_filepath.id)
12. 0.014 0.085 ↓ 1.1 66 1

Hash Left Join (cost=43.91..50.35 rows=62 width=286) (actual time=0.042..0.085 rows=66 loops=1)

  • Hash Cond: (agent_event.web_data_id = agent_web.id)
13. 0.014 0.065 ↓ 1.1 66 1

Hash Left Join (cost=24.68..30.96 rows=62 width=230) (actual time=0.029..0.065 rows=66 loops=1)

  • Hash Cond: (agent_event.application_id = agent_application.id)
14. 0.019 0.044 ↓ 1.1 66 1

Hash Left Join (cost=1.63..7.75 rows=62 width=206) (actual time=0.016..0.044 rows=66 loops=1)

  • Hash Cond: (agent_event.event_type_id = agent_eventtype.id)
15. 0.016 0.016 ↓ 1.1 66 1

Seq Scan on agent_event (cost=0.00..5.93 rows=62 width=278) (actual time=0.004..0.016 rows=66 loops=1)

  • Filter: ((id > 0) AND (id <= 193))
16. 0.005 0.009 ↑ 1.0 28 1

Hash (cost=1.28..1.28 rows=28 width=8) (actual time=0.009..0.009 rows=28 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
17. 0.004 0.004 ↑ 1.0 28 1

Seq Scan on agent_eventtype (cost=0.00..1.28 rows=28 width=8) (actual time=0.002..0.004 rows=28 loops=1)

18. 0.002 0.007 ↑ 82.9 7 1

Hash (cost=15.80..15.80 rows=580 width=40) (actual time=0.007..0.007 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
19. 0.005 0.005 ↑ 82.9 7 1

Seq Scan on agent_application (cost=0.00..15.80 rows=580 width=40) (actual time=0.005..0.005 rows=7 loops=1)

20. 0.002 0.006 ↑ 205.0 2 1

Hash (cost=14.10..14.10 rows=410 width=72) (actual time=0.006..0.006 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
21. 0.004 0.004 ↑ 205.0 2 1

Seq Scan on agent_web (cost=0.00..14.10 rows=410 width=72) (actual time=0.004..0.004 rows=2 loops=1)

22. 0.008 0.017 ↑ 10.7 59 1

Hash (cost=16.30..16.30 rows=630 width=36) (actual time=0.017..0.017 rows=59 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
23. 0.009 0.009 ↑ 10.7 59 1

Seq Scan on agent_filepath (cost=0.00..16.30 rows=630 width=36) (actual time=0.005..0.009 rows=59 loops=1)

24. 0.007 0.018 ↑ 3.4 68 1

Hash (cost=12.30..12.30 rows=230 width=40) (actual time=0.018..0.018 rows=68 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
25. 0.011 0.011 ↑ 3.4 68 1

Seq Scan on agent_attachedfile (cost=0.00..12.30 rows=230 width=40) (actual time=0.005..0.011 rows=68 loops=1)