explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bTnX

Settings
# exclusive inclusive rows x rows loops node
1. 54.704 54.704 ↓ 0.0 0 1

Index Scan using index_issue_on_project_id_state_id_and_blocking_issues_count on issues (cost=0.56..53,313.23 rows=1 width=1,257) (actual time=54.704..54.704 rows=0 loops=1)

  • Index Cond: ((project_id = 278,964) AND (state_id = 1))
  • Filter: (issue_type = 6)
  • Rows Removed by Filter: 34,057
Planning time : 0.468 ms
Execution time : 54.746 ms