explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZUUl

Settings
# exclusive inclusive rows x rows loops node
1. 0.459 1.428 ↑ 1.0 5 1

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

  • Group Key: source
2. 0.407 0.969 ↓ 71.4 500 1

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

  • Sort Key: source
  • Sort Method: quicksort Memory: 83kB
3. 0.490 0.562 ↓ 71.4 500 1

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

  • Recheck Cond: (domain_name = 'GOOGLE'::text)
  • Heap Blocks: exact=64
4. 0.072 0.072 ↓ 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.072..0.072 rows=500 loops=1)

  • Index Cond: (domain_name = 'GOOGLE'::text)
Planning time : 0.268 ms
Execution time : 1.497 ms