explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7vT6i

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 444.501 ↑ 1.0 80 1

Limit (cost=25,462.21..25,462.41 rows=80 width=24) (actual time=444.493..444.501 rows=80 loops=1)

2. 37.199 444.492 ↑ 1,963.7 80 1

Sort (cost=25,462.21..25,854.94 rows=157,095 width=24) (actual time=444.490..444.492 rows=80 loops=1)

  • Sort Key: student_status, name
  • Sort Method: top-N heapsort Memory: 31kB
3. 407.293 407.293 ↑ 1.0 151,039 1

Seq Scan on profile (cost=0.00..19,711.01 rows=157,095 width=24) (actual time=0.039..407.293 rows=151,039 loops=1)

  • Filter: ((site_ids_text ~~* '%3%'::text) OR (applied_site_ids_text ~~* '%s(3)%'::text))
  • Rows Removed by Filter: 268762
Planning time : 0.743 ms
Execution time : 444.583 ms