explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oqCr

Settings
# exclusive inclusive rows x rows loops node
1. 0.816 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)

  • -> Index Scan using projects_last_activity_at_id_idx1 on projects (cost=0.56..1240188.09 rows=1519152 width=737) (actual time=0.106..0.81
  • Filter: ((NOT pending_delete) AND (visibility_level = 20))
  • Rows Removed by Filter: 368
Planning time : 0.590 ms
Execution time : 0.870 ms