explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NGDW

Settings
# exclusive inclusive rows x rows loops node
1. 0.323 1.199 ↑ 1.0 5 1

GroupAggregate (cost=31.81..31.93 rows=5 width=48) (actual time=0.858..1.199 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=67
2. 0.370 0.876 ↓ 71.4 500 1

Sort (cost=31.81..31.83 rows=7 width=61) (actual time=0.833..0.876 rows=500 loops=1)

  • Output: source, tld, domain_name, subdomain, subsubdomain, category, client, web, app
  • Sort Key: domain_category.source
  • Sort Method: quicksort Memory: 83kB
  • Buffers: shared hit=67
3. 0.435 0.506 ↓ 71.4 500 1

Bitmap Heap Scan on public.domain_category (cost=4.05..31.71 rows=7 width=61) (actual time=0.095..0.506 rows=500 loops=1)

  • Output: source, tld, domain_name, subdomain, subsubdomain, category, client, web, app
  • Recheck Cond: (domain_category.domain_name = 'GOOGLE'::text)
  • Heap Blocks: exact=64
  • Buffers: shared hit=67
4. 0.071 0.071 ↓ 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.071..0.071 rows=500 loops=1)

  • Index Cond: (domain_category.domain_name = 'GOOGLE'::text)
  • Buffers: shared hit=3
Planning time : 0.230 ms
Execution time : 1.263 ms