explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HFCi

Settings

Optimization(s) for this plan:

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

Sort (cost=290,930.50..292,548.23 rows=647,090 width=32) (actual rows= loops=)

  • Sort Key: (period(creation_date))
2. 0.000 0.000 ↓ 0.0

Index Scan using ref_mandat_xperf5 on ref_mandat (cost=0.42..212,990.65 rows=647,090 width=32) (actual rows= loops=)