explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UI4z

Settings
# exclusive inclusive rows x rows loops node
1. 75.377 74,399.063 ↑ 4.4 61,535 1

GroupAggregate (cost=0.56..265,975.81 rows=270,350 width=12) (actual time=81.040..74,399.063 rows=61,535 loops=1)

  • Group Key: femea_id
2. 74,323.686 74,323.686 ↓ 1.0 293,627 1

Index Only Scan using vw_modelo_reprodutivo_data_hora_cobertura_idx_order on vw_modelo_reprodutivo v (cost=0.56..261,811.11 rows=292,240 width=12) (actual time=81.018..74,323.686 rows=293,627 loops=1)

  • Index Cond: ((data_hora_cobertura <= '2020-06-24'::date) AND (contrato_id = 16))
  • Heap Fetches: 0
Planning time : 0.239 ms
Execution time : 74,403.774 ms