explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RumG

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=2,211,368.14..2,211,368.64 rows=200 width=41) (actual rows= loops=)

  • Sort Key: (count(*)) DESC
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,211,358.49..2,211,360.49 rows=200 width=41) (actual rows= loops=)

  • Group Key: redirects.link_hash
  • Filter: (count(*) > 1)
3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,149,606.03..2,172,061.47 rows=2,245,544 width=48) (actual rows= loops=)

  • Group Key: redirects.link_hash, redirects.redirector_domain
4. 0.000 0.000 ↓ 0.0

Index Scan using redirects_redirector_domain on redirects (cost=0.57..2,136,806.45 rows=2,559,917 width=48) (actual rows= loops=)

  • Index Cond: (redirector_domain IS NOT NULL)
  • Filter: ((redirector_domain)::text <> ALL ('{citycredits.pl,vigiadepreco.com.br,googieadservices.com,selfzone.ru,travelbelka.ru,author24.expert,kreditpro24.ru,actualtraffic.ru,couponchief.ru,promokodi.ru,cartainfo.ru,zaym.pro,promokod.shopokod.ru,kuponinaskidku.ru,yabs.yandex.ru,praktikum.yandex.ru,money.yandex.ru,praktikum.yandex.ru,music.yandex.ru,telephony.yandex.ru,praktikum.yandex.ru,plus.yandex.ru,zen.yandex.ru,taxi.yandex.ru,sso.passport.yandex.ru,googleadservices.com,google.com,market.yandex.ru,radar.yandex.ru,pass.yandex.ru,realty.yandex.ru,talents.yandex.ru,m.market.yandex.ru}'::text[]))