explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A9ZA

Settings
# exclusive inclusive rows x rows loops node
1. 898.237 57,170.400 ↑ 1,119.6 7,234 1

Merge Join (cost=39.41..1,329,686.66 rows=8,099,096 width=629) (actual time=92.720..57,170.400 rows=7,234 loops=1)

  • Merge Cond: (protected_branches.project_id = projects.id)
2. 19,363.549 19,363.549 ↓ 1.0 8,232,088 1

Index Scan using index_protected_branches_on_project_id on protected_branches (cost=0.43..393,994.85 rows=8,227,122 width=31) (actual time=0.009..19,363.549 rows=8,232,088 loops=1)

3. 36,908.614 36,908.614 ↑ 1,356.2 7,473 1

Index Scan using projects_pkey on projects (cost=0.43..809,427.11 rows=10,134,840 width=598) (actual time=90.516..36,908.614 rows=7,473 loops=1)

  • Filter: ((NOT archived) AND (NOT pending_delete) AND (NOT merge_requests_require_code_owner_approval))
  • Rows Removed by Filter: 17548168
Planning time : 0.612 ms
Execution time : 57,171.931 ms