explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vr11

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

GroupAggregate (cost=1,001.00..92,771.43 rows=4,622 width=12) (actual time=289.832..289.832 rows=0 loops=1)

  • Output: card_latenesses.phase_id, count(*)
  • Group Key: card_latenesses.phase_id
  • Buffers: shared hit=18875
2. 0.553 289.953 ↓ 0.0 0 1

Gather (cost=1,001.00..92,702.10 rows=4,622 width=4) (actual time=289.831..289.953 rows=0 loops=1)

  • Output: card_latenesses.phase_id
  • Workers Planned: 5
  • Workers Launched: 0
  • Buffers: shared hit=18875
3. 0.000 289.400 ↓ 0.0 0 1

Nested Loop (cost=1.00..91,239.90 rows=924 width=4) (actual time=289.400..289.400 rows=0 loops=1)

  • Output: card_latenesses.phase_id
  • Inner Unique: true
  • Buffers: shared hit=18875
4. 289.400 289.400 ↓ 0.0 0 1

Parallel Index Only Scan using idx_cl_on_card_id_phase_id_deleted_at_late_at_card_in_phase on public.card_latenesses (cost=0.43..32,932.13 rows=21,779 width=8) (actual time=289.399..289.400 rows=0 loops=1)

  • Output: card_latenesses.card_id, card_latenesses.phase_id
  • Index Cond: (card_latenesses.phase_id = 4235366)
  • Heap Fetches: 0
  • Buffers: shared hit=18875
5. 0.000 0.000 ↓ 0.0 0

Index Scan using cards_pkey on public.cards (cost=0.56..2.68 rows=1 width=8) (never executed)

  • 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, cards.uuid
  • Index Cond: (cards.id = card_latenesses.card_id)
  • Filter: ((cards.deleted_at IS NULL) AND (cards.current_phase_id = 4235366))
Planning time : 0.481 ms
Execution time : 290.000 ms