explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pIHZ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 2.693 2.693 ↑ 1.0 1,478 1

GroupAggregate (cost=111.29..151.93 rows=1478 width=20) (actual time=6.099..10.194 rows=14 loops=1) -> Sort (cost=111.29..114.98 rows=1478 width=20) (actual time=5.897..6.565 rows=1478 loops=1) Sort Key: ("left"((tract_id)::text, 5)) Sort Method: quicksort Memory: 136kB -> Seq Scan on hisp_pop (cost=0.000..33.480 rows=1,478 width=20) (actual time=0.390..2.693 rows=1,478 loops=1)