explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LkSX

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 1.947 ↑ 1.0 1 1

Aggregate (cost=3,473.95..3,473.96 rows=1 width=8) (actual time=1.947..1.947 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=1655
2. 0.007 1.942 ↓ 23.0 23 1

Nested Loop (cost=1.98..3,473.95 rows=1 width=0) (actual time=0.057..1.942 rows=23 loops=1)

  • Buffers: shared hit=1655
3. 0.111 1.843 ↑ 12.6 23 1

Nested Loop (cost=1.56..3,337.38 rows=290 width=4) (actual time=0.046..1.843 rows=23 loops=1)

  • Output: phases.repo_id
  • Buffers: shared hit=1540
4. 0.113 1.225 ↑ 3.8 169 1

Nested Loop (cost=1.12..3,037.83 rows=640 width=4) (actual time=0.036..1.225 rows=169 loops=1)

  • Output: cards.current_phase_id
  • Buffers: shared hit=864
5. 0.267 0.267 ↑ 4.9 169 1

Index Scan using idx_ca_on_assignee_id_deleted_at on public.card_assignees (cost=0.56..724.92 rows=829 width=4) (actual time=0.028..0.267 rows=169 loops=1)

  • Output: card_assignees.id, card_assignees.card_id, card_assignees.assignee_id, card_assignees.created_at, card_assignees.updated_at, card_assignees.deleted_at
  • Index Cond: ((card_assignees.assignee_id = 849860) AND (card_assignees.deleted_at IS NULL))
  • Buffers: shared hit=9
6. 0.845 0.845 ↑ 1.0 1 169

Index Scan using cards_pkey on public.cards (cost=0.56..2.78 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=169)

  • Output: cards.id, cards.current_phase_id, cards.title, cards.created_at, cards.updated_at, cards.due_date, cards.deleted_at, cards.started_at, cards.created_by_id, cards.index, cards.finished_at, cards.comments_count, cards.attachments_count, cards.suid, cards.default_to_email, cards.repo_items_importation_id, cards.tmp_import_id, cards.public_form_submitter_email
  • Index Cond: (cards.id = card_assignees.card_id)
  • Filter: (cards.deleted_at IS NULL)
  • Buffers: shared hit=855
7. 0.507 0.507 ↓ 0.0 0 169

Index Scan using phases_pkey on public.phases (cost=0.43..0.46 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=169)

  • Output: phases.id, phases.repo_id
  • Index Cond: (phases.id = cards.current_phase_id)
  • Filter: ((phases.deleted_at IS NULL) AND (NOT phases.done) AND (phases.index > '0'::numeric))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=676
8. 0.092 0.092 ↑ 1.0 1 23

Index Scan using repos_pkey on public.repos (cost=0.42..0.46 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=23)

  • Output: repos.id
  • Index Cond: (repos.id = phases.repo_id)
  • Filter: ((repos.deleted_at IS NULL) AND ((repos.type)::text = 'Pipe'::text) AND (repos.organization_id = 64103))
  • Buffers: shared hit=115
Planning time : 0.699 ms
Execution time : 1.999 ms