explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oqCr

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.816 ↑ 1.0 20 1

Limit (cost=0.56..16.89 rows=20 width=737) (actual time=0.107..0.816 rows=20 loops=1)

2. 0.813 0.813 ↑ 75,957.6 20 1

Index Scan using projects_last_activity_at_id_idx1 on projects (cost=0.56..1,240,188.09 rows=1,519,152 width=737) (actual time=0.106..0.813 rows=20 loops=1)

  • Filter: ((NOT pending_delete) AND (visibility_level = 20))
  • Rows Removed by Filter: 368
Planning time : 0.590 ms
Execution time : 0.870 ms