explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b0S2

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.127 ↓ 0.0 0 1

GroupAggregate (cost=148.28..148.63 rows=14 width=20) (actual time=0.126..0.127 rows=0 loops=1)

  • Group Key: lease_fact."ACCOUNT", lease_fact."CLOSING_DATE_DEBUT", lease_fact."CLOSING_DATE_FIN", lease_fact."FLOW
2. 0.011 0.124 ↓ 0.0 0 1

Sort (cost=148.28..148.32 rows=14 width=20) (actual time=0.123..0.124 rows=0 loops=1)

  • Sort Key: lease_fact."ACCOUNT", lease_fact."CLOSING_DATE_DEBUT", lease_fact."CLOSING_DATE_FIN", lease_fact."FLOW
  • Sort Method: quicksort Memory: 25kB
3. 0.113 0.113 ↓ 0.0 0 1

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 time=0.112..0.113 rows=0 loops=1)

  • 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))