explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5RVh

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

Sort (cost=4,235.50..4,239.17 rows=1,467 width=36) (actual rows= loops=)

  • Sort Key: (st_numgeometries(f.gc)) DESC
2. 0.000 0.000 ↓ 0.0

Subquery Scan on f (cost=394.63..4,158.35 rows=1,467 width=36) (actual rows= loops=)

  • Filter: (st_numgeometries(f.gc) > 1)
3. 0.000 0.000 ↓ 0.0

ProjectSet (cost=394.63..417.51 rows=4,400 width=35) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=394.63..395.19 rows=44 width=35) (actual rows= loops=)

  • Group Key: for_sale_real_estate.state_fips
5. 0.000 0.000 ↓ 0.0

Seq Scan on for_sale_real_estate (cost=0.00..343.09 rows=10,309 width=35) (actual rows= loops=)