explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6N6Z : Optimization for: plan #mBXL

Settings

Optimization path:

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

HashAggregate (cost=740.06..1025.11 rows=19003 width=64)Group Key: (doc_pt -> 'county_id'::text), (doc_pt -> 'zone_id'::text)-> Seq Scan on pforce_product (cost=0.00..645.04 rows=19,003 width=64) (actual rows= loops=)