explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uhQO

Settings
# exclusive inclusive rows x rows loops node
1. 666.326 40,033.740 ↑ 44.1 1,558 1

GroupAggregate (cost=95,954.29..117,514.80 rows=68,764 width=60) (actual time=31,685.095..40,033.740 rows=1,558 loops=1)

  • Group Key: family, (date_part('year'::text, creation_date)), domain, lib_category, (date_part('month'::text, creation_date)), id_filiale, type
2. 37,352.675 39,367.414 ↓ 1.0 623,431 1

Sort (cost=95,954.29..97,480.55 rows=610,505 width=60) (actual time=31,685.055..39,367.414 rows=623,431 loops=1)

  • Sort Key: family, (date_part('year'::text, creation_date)), domain, lib_category, (date_part('month'::text, creation_date)), id_filiale, type
  • Sort Method: external merge Disk: 52016kB
3. 2,014.739 2,014.739 ↓ 1.0 623,431 1

Index Scan using ref_mandat_xperf5 on ref_mandat (cost=0.42..14,329.34 rows=610,505 width=60) (actual time=0.335..2,014.739 rows=623,431 loops=1)

  • Index Cond: (is_active = true)