explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NGiK

Settings
# exclusive inclusive rows x rows loops node
1. 7,879.684 63,981.182 ↑ 4.4 61,535 1

GroupAggregate (cost=0.56..333,563.31 rows=270,350 width=16) (actual time=5,162.372..63,981.182 rows=61,535 loops=1)

  • Group Key: femea_id
2. 56,101.498 56,101.498 ↓ 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=5,162.170..56,101.498 rows=293,627 loops=1)

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