explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HKcK

Settings

Optimization(s) for this plan:

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

Limit (cost=24,144.23..24,144.24 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Finalize Aggregate (cost=24,144.23..24,144.24 rows=1 width=8) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Gather (cost=24,144.01..24,144.22 rows=2 width=8) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=23,144.01..23,144.02 rows=1 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on persons (cost=0.00..22,450.33 rows=277,472 width=0) (actual rows= loops=)

  • Filter: ((lastname)::text = ANY ('{Foo,Bar}'::text[]))