explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mt7E

Settings
# exclusive inclusive rows x rows loops node
1. 4.161 5.745 ↓ 0.0 19 1

HashAggregate (cost=0..0 rows=0 width=0) (actual time=5.706..5.745 rows=19 loops=1)

  • Group Key: idaccount, ideventtype, source, idequipment, auto_close_on_event_defined, enable_auto_close_on_event_defined, source_required_to_restore
2. 1.584 1.584 ↓ 0.0 4,792 1

Seq Scan on viewm_datas_details_open v (cost=0..0 rows=0 width=0) (actual time=0.066..1.584 rows=4,792 loops=1)