explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 760Tc

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.459 ↑ 1.0 20 1

Limit (cost=0.56..7.53 rows=20 width=743) (actual time=0.082..0.459 rows=20 loops=1)

2. 0.457 0.457 ↑ 76,746.6 20 1

Index Scan Backward using index_projects_on_visibility_level_and_created_at_and_id on projects (cost=0.56..534,581.81 rows=1,534,932 width=743) (actual time=0.081..0.457 rows=20 loops=1)

  • Index Cond: (visibility_level = 20)
  • Filter: (NOT pending_delete)
Planning time : 0.402 ms
Execution time : 0.529 ms