explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CLHk

Settings
# exclusive inclusive rows x rows loops node
1. 0.040 0.196 ↑ 1.7 3 1

GroupAggregate (cost=31.81..31.93 rows=5 width=48) (actual time=0.177..0.196 rows=3 loops=1)

  • Output: source, array_agg(ROW(tld, domain_name, subdomain, subsubdomain, category, client, web, app))
  • Group Key: domain_category.source
  • Buffers: shared hit=14
2. 0.024 0.156 ↓ 2.7 19 1

Sort (cost=31.81..31.83 rows=7 width=61) (actual time=0.153..0.156 rows=19 loops=1)

  • Output: source, tld, domain_name, subdomain, subsubdomain, category, client, web, app
  • Sort Key: domain_category.source
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=14
3. 0.095 0.132 ↓ 2.7 19 1

Bitmap Heap Scan on public.domain_category (cost=4.05..31.71 rows=7 width=61) (actual time=0.052..0.132 rows=19 loops=1)

  • Output: source, tld, domain_name, subdomain, subsubdomain, category, client, web, app
  • Recheck Cond: (domain_category.domain_name = 'PORNHUB'::text)
  • Heap Blocks: exact=13
  • Buffers: shared hit=14
4. 0.037 0.037 ↓ 2.7 19 1

Bitmap Index Scan on idx_hash_domain_category_domain_name (cost=0.00..4.05 rows=7 width=0) (actual time=0.036..0.037 rows=19 loops=1)

  • Index Cond: (domain_category.domain_name = 'PORNHUB'::text)
  • Buffers: shared hit=1
Planning time : 0.193 ms
Execution time : 0.301 ms