explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RRX8

Settings
# exclusive inclusive rows x rows loops node
1. 104.268 1,796.881 ↑ 13,229.0 1 1

GroupAggregate (cost=0.56..226,582.55 rows=13,229 width=12) (actual time=1,796.881..1,796.881 rows=1 loops=1)

  • Output: count(*), current_phase_id
  • Group Key: cards.current_phase_id
  • Buffers: shared hit=243209
2. 1,692.613 1,692.613 ↓ 1.4 949,301 1

Index Only Scan using idx_c_on_current_phase_id_due_date_deleted_at on public.cards (cost=0.56..223,131.20 rows=663,813 width=4) (actual time=0.097..1,692.613 rows=949,301 loops=1)

  • Output: current_phase_id, due_date
  • Index Cond: (cards.current_phase_id = ANY ('{8076265,8076266}'::integer[]))
  • Heap Fetches: 841257
  • Buffers: shared hit=243209
Planning time : 0.180 ms
Execution time : 1,796.912 ms