explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dBNZ : Optimization for: plan #HFCi

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=280,678.18..293,168.28 rows=384,311 width=190) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=280,678.18..281,638.95 rows=384,311 width=190) (actual rows= loops=)

  • Sort Key: id_filiale, (date_part('year'::text, creation_date)), (date_part('month'::text, creation_date)), family, type, domain, lib_category, (sum(nombre)), (sum(fees)), (avg(fees)), (sum(net_price)), (avg(net_price))
3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=143,453.45..174,091.65 rows=384,311 width=190) (actual rows= loops=)

  • Group Key: family, (date_part('year'::text, creation_date)), domain, lib_category, (date_part('month'::text, creation_date)), id_filiale, type
4. 0.000 0.000 ↓ 0.0

Sort (cost=143,453.45..145,071.18 rows=647,090 width=68) (actual rows= loops=)

  • Sort Key: family, (date_part('year'::text, creation_date)), domain, lib_category, (date_part('month'::text, creation_date)), id_filiale, type
5. 0.000 0.000 ↓ 0.0

Index Scan using ref_mandat_xperf5 on ref_mandat (cost=0.42..54,453.60 rows=647,090 width=68) (actual rows= loops=)