explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zX3y

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 11,708.058 ↑ 1.0 1 1

Aggregate (cost=1,067.24..1,067.25 rows=1 width=8) (actual time=11,708.058..11,708.058 rows=1 loops=1)

2. 0.002 11,708.053 ↓ 6.0 6 1

Nested Loop (cost=2.27..1,067.24 rows=1 width=0) (actual time=6,232.700..11,708.053 rows=6 loops=1)

3. 0.000 11,708.027 ↓ 6.0 6 1

Nested Loop (cost=1.85..1,064.59 rows=1 width=4) (actual time=6,232.693..11,708.027 rows=6 loops=1)

4. 605.198 2,909.631 ↓ 49,301.0 4,634,297 1

Nested Loop (cost=1.42..1,020.98 rows=94 width=8) (actual time=0.051..2,909.631 rows=4,634,297 loops=1)

5. 0.328 7.111 ↓ 69.9 1,467 1

Nested Loop (cost=0.85..107.15 rows=21 width=8) (actual time=0.035..7.111 rows=1,467 loops=1)

6. 4.462 4.462 ↓ 30.1 211 1

Index Scan using idx_r_on_organization_id_deleted_at on repos (cost=0.42..8.37 rows=7 width=8) (actual time=0.021..4.462 rows=211 loops=1)

  • Index Cond: ((organization_id = 64103) AND (deleted_at IS NULL))
  • Filter: ((type)::text = 'Pipe'::text)
  • Rows Removed by Filter: 43
7. 2.321 2.321 ↑ 1.3 7 211

Index Scan using index_phases_on_repo_id_and_index on phases (cost=0.43..14.02 rows=9 width=8) (actual time=0.005..0.011 rows=7 loops=211)

  • Index Cond: (repo_id = repos.id)
  • Filter: ((NOT done) AND (index <> '0'::numeric))
  • Rows Removed by Filter: 3
8. 2,297.322 2,297.322 ↓ 2.0 3,159 1,467

Index Scan using idx_c_on_current_phase_id_due_date_deleted_at on cards (cost=0.56..28.03 rows=1,549 width=8) (actual time=0.006..1.566 rows=3,159 loops=1,467)

  • Index Cond: (current_phase_id = phases.id)
9. 9,268.594 9,268.594 ↓ 0.0 0 4,634,297

Index Only Scan using index_card_assignees_on_card_id_and_assignee_id on card_assignees (cost=0.43..0.45 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,634,297)

  • Index Cond: ((card_id = cards.id) AND (assignee_id = 354060))
  • Heap Fetches: 6
10. 0.024 0.024 ↑ 1.0 1 6

Index Scan using organizations_pkey on organizations (cost=0.42..2.64 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=6)

  • Index Cond: (id = 64103)
  • Filter: (deleted_at IS NULL)