explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4ltH

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

Limit (cost=26,511.12..26,511.32 rows=80 width=24) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=26,511.12..26,903.82 rows=157,079 width=24) (actual rows= loops=)

  • Sort Key: student_status, name
3. 0.000 0.000 ↓ 0.0

Seq Scan on profile (cost=0.00..20,760.52 rows=157,079 width=24) (actual rows= loops=)

  • Filter: (((email)::text !~~ '%@melodiak.hu%'::text) AND ((site_ids_text ~~* '%3%'::text) OR (applied_site_ids_text ~~* '%s(3)%'::text)))