explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rMsR

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 4,571.715 ↑ 1.0 1 1

Limit (cost=0.43..101.83 rows=1 width=1,558) (actual time=4,571.714..4,571.715 rows=1 loops=1)

2. 4,571.712 4,571.712 ↑ 2,671.0 1 1

Index Scan using users_pkey on users (cost=0.43..270,840.91 rows=2,671 width=1,558) (actual time=4,571.712..4,571.712 rows=1 loops=1)

  • Filter: (user_ats AND (deleted_at IS NULL) AND (lower((email)::text) = 'silas@99jobs.com'::text))
  • Rows Removed by Filter: 748991
Planning time : 0.371 ms
Execution time : 4,571.793 ms