explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GihZ : Optimization for: plan #dyBS

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.012 0.101 ↑ 1,591.0 4 1

GroupAggregate (cost=0.56..986.04 rows=6,364 width=12) (actual time=0.048..0.101 rows=4 loops=1)

  • Group Key: current_phase_id
2. 0.089 0.089 ↑ 276.1 31 1

Index Only Scan using idx_c_on_current_phase_id_due_date_deleted_at on cards (cost=0.56..879.61 rows=8,559 width=4) (actual time=0.038..0.089 rows=31 loops=1)

  • Index Cond: (current_phase_id = ANY ('{3691109,3691116,3691110,3691111,3691117}'::integer[]))
  • Heap Fetches: 10
Planning time : 1.821 ms
Execution time : 0.152 ms