explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XjAU

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 90.457 ↑ 3.0 2 1

Bitmap Heap Scan on issues (cost=924.44..933.56 rows=6 width=1,257) (actual time=90.454..90.457 rows=2 loops=1)

  • Recheck Cond: ((issue_type = 1) AND (project_id = 278,964) AND (state_id = 1))
  • Heap Blocks: exact=2
2. 0.477 90.422 ↓ 0.0 0 1

BitmapAnd (cost=924.44..924.44 rows=6 width=0) (actual time=90.422..90.422 rows=0 loops=1)

3. 76.857 76.857 ↓ 1.3 9,650 1

Bitmap Index Scan on index_issues_on_incident_issue_type (cost=0.00..137.25 rows=7,593 width=0) (actual time=76.857..76.857 rows=9,650 loops=1)

4. 13.088 13.088 ↑ 1.3 34,057 1

Bitmap Index Scan on index_issue_on_project_id_state_id_and_blocking_issues_count (cost=0.00..786.94 rows=45,337 width=0) (actual time=13.088..13.088 rows=34,057 loops=1)

  • Index Cond: ((project_id = 278,964) AND (state_id = 1))
Planning time : 0.516 ms
Execution time : 90.524 ms