explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Xht

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

Finalize GroupAggregate (cost=99,117.47..99,192.50 rows=541 width=12) (actual time=888.591..888.591 rows=0 loops=1)

  • Output: card_latenesses.phase_id, count(*)
  • Group Key: card_latenesses.phase_id
  • Buffers: shared hit=251821
2. 13.541 892.303 ↓ 0.0 0 1

Gather Merge (cost=99,117.47..99,184.39 rows=540 width=12) (actual time=888.590..892.303 rows=0 loops=1)

  • Output: card_latenesses.phase_id, (PARTIAL count(*))
  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=1742437
3. 0.001 878.762 ↓ 0.0 0 6 / 6

Partial GroupAggregate (cost=98,117.39..98,119.28 rows=108 width=12) (actual time=878.762..878.762 rows=0 loops=6)

  • Output: card_latenesses.phase_id, PARTIAL count(*)
  • Group Key: card_latenesses.phase_id
  • Buffers: shared hit=1742437
  • Worker 0: actual time=876.165..876.165 rows=0 loops=1
  • Buffers: shared hit=330276
  • Worker 1: actual time=875.496..875.496 rows=0 loops=1
  • Buffers: shared hit=294360
  • Worker 2: actual time=876.576..876.577 rows=0 loops=1
  • Buffers: shared hit=282719
  • Worker 3: actual time=877.390..877.390 rows=0 loops=1
  • Buffers: shared hit=283961
  • Worker 4: actual time=879.071..879.071 rows=0 loops=1
  • Buffers: shared hit=299300
4. 0.019 878.761 ↓ 0.0 0 6 / 6

Sort (cost=98,117.39..98,117.66 rows=108 width=4) (actual time=878.761..878.761 rows=0 loops=6)

  • Output: card_latenesses.phase_id
  • Sort Key: card_latenesses.phase_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1742437
  • Worker 0: actual time=876.164..876.164 rows=0 loops=1
  • Buffers: shared hit=330276
  • Worker 1: actual time=875.495..875.495 rows=0 loops=1
  • Buffers: shared hit=294360
  • Worker 2: actual time=876.576..876.576 rows=0 loops=1
  • Buffers: shared hit=282719
  • Worker 3: actual time=877.389..877.390 rows=0 loops=1
  • Buffers: shared hit=283961
  • Worker 4: actual time=879.070..879.070 rows=0 loops=1
  • Buffers: shared hit=299300
5. 0.001 878.742 ↓ 0.0 0 6 / 6

Nested Loop (cost=1.00..98,113.74 rows=108 width=4) (actual time=878.742..878.742 rows=0 loops=6)

  • Output: card_latenesses.phase_id
  • Inner Unique: true
  • Buffers: shared hit=1742402
  • Worker 0: actual time=876.144..876.144 rows=0 loops=1
  • Buffers: shared hit=330269
  • Worker 1: actual time=875.475..875.475 rows=0 loops=1
  • Buffers: shared hit=294353
  • Worker 2: actual time=876.556..876.556 rows=0 loops=1
  • Buffers: shared hit=282712
  • Worker 3: actual time=877.360..877.360 rows=0 loops=1
  • Buffers: shared hit=283954
  • Worker 4: actual time=879.051..879.051 rows=0 loops=1
  • Buffers: shared hit=299293
6. 878.741 878.741 ↓ 0.0 0 6 / 6

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,976.55 rows=24,348 width=8) (actual time=878.741..878.741 rows=0 loops=6)

  • Output: card_latenesses.card_id, card_latenesses.phase_id
  • Filter: (card_latenesses.phase_id = ANY ('{4235366,6849549}'::integer[]))
  • Rows Removed by Filter: 826521
  • Heap Fetches: 149143
  • Buffers: shared hit=1742402
  • Worker 0: actual time=876.143..876.143 rows=0 loops=1
  • Buffers: shared hit=330269
  • Worker 1: actual time=875.474..875.475 rows=0 loops=1
  • Buffers: shared hit=294353
  • Worker 2: actual time=876.555..876.555 rows=0 loops=1
  • Buffers: shared hit=282712
  • Worker 3: actual time=877.360..877.360 rows=0 loops=1
  • Buffers: shared hit=283954
  • Worker 4: actual time=879.050..879.050 rows=0 loops=1
  • Buffers: shared hit=299293
7. 0.000 0.000 ↓ 0.0 0 / 6

Index Scan using cards_pkey on public.cards (cost=0.56..2.67 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 (card_latenesses.phase_id = cards.current_phase_id))
Planning time : 0.872 ms
Execution time : 892.366 ms