explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tvgF

Settings

Optimization(s) for this plan:

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

Sort (cost=1.07..1.08 rows=1 width=4,743) (actual rows= loops=)

  • Sort Key: created_at DESC, id DESC
2. 0.000 0.000 ↓ 0.0

Seq Scan on clients (cost=0.00..1.06 rows=1 width=4,743) (actual rows= loops=)

  • Filter: ((firstname)::text ~~* '%foo%'::text)