explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sTAa

Settings
# exclusive inclusive rows x rows loops node
1. 0.507 1.919 ↑ 1.0 5 1

GroupAggregate (cost=31.81..31.93 rows=5 width=48) (actual time=1.415..1.919 rows=5 loops=1)

  • Output: source, array_agg(ROW(tld, domain_name, subdomain, subsubdomain, category, client, web, app))
  • Group Key: domain_category.source
  • Buffers: shared hit=71
2. 0.414 1.412 ↓ 59.9 419 1

Sort (cost=31.81..31.83 rows=7 width=61) (actual time=1.373..1.412 rows=419 loops=1)

  • Output: source, tld, domain_name, subdomain, subsubdomain, category, client, web, app
  • Sort Key: domain_category.source
  • Sort Method: quicksort Memory: 74kB
  • Buffers: shared hit=71
3. 0.757 0.998 ↓ 59.9 419 1

Bitmap Heap Scan on public.domain_category (cost=4.05..31.71 rows=7 width=61) (actual time=0.268..0.998 rows=419 loops=1)

  • Output: source, tld, domain_name, subdomain, subsubdomain, category, client, web, app
  • Recheck Cond: (domain_category.domain_name = 'GOOGLE'::text)
  • Filter: (domain_category.subsubdomain IS NULL)
  • Rows Removed by Filter: 81
  • Heap Blocks: exact=64
  • Buffers: shared hit=68
4. 0.241 0.241 ↓ 71.4 500 1

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

  • Index Cond: (domain_category.domain_name = 'GOOGLE'::text)
  • Buffers: shared hit=4
Planning time : 2.345 ms
Execution time : 2.222 ms