explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZH1w

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

GroupAggregate (cost=148.28..148.63 rows=14 width=20) (actual rows= loops=)

  • Group Key: lease_fact."ACCOUNT", lease_fact."CLOSING_DATE_DEBUT", lease_fact."CLOSING_DATE_FIN", lease_fact."FLOW
2. 0.000 0.000 ↓ 0.0

Sort (cost=148.28..148.32 rows=14 width=20) (actual rows= loops=)

  • Sort Key: lease_fact."ACCOUNT", lease_fact."CLOSING_DATE_DEBUT", lease_fact."CLOSING_DATE_FIN", lease_fact."FLOW
3. 0.000 0.000 ↓ 0.0

Index Scan using idx_lease_fact_account_no_month_flow_no_currency on lease_fact (cost=0.43..148.02 rows=14 width=20) (actual rows= loops=)

  • Index Cond: (("CLOSING_DATE_DEBUT" <= '2018-12-31'::date) AND ("CLOSING_DATE_FIN" >= '2018-12-31'::date) AND ("ACCOUNT" = ANY ('{4,3,14,18,5,13,15}'::integer[])))
  • Filter: (("TRANSITION_OPTION" IS NULL) OR ("TRANSITION_OPTION" = 2))