explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8uR

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

Limit (cost=199,385.58..199,385.59 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=199,385.58..199,385.59 rows=1 width=8) (actual rows= loops=)

  • Sort Key: r53_quant DESC
3. 0.000 0.000 ↓ 0.0

Index Scan using gerffx_ae_me_rub_reg_in on gerffx (cost=0.56..199,385.57 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((r53_rubric = '0010'::bpchar) AND (r53_regist = 694798))
  • Filter: ((r53_instit = (fc_getsession('DB_instit'::text))::integer) AND (r53_anousu = fc_anofolha((fc_getsession('DB_instit'::text))::integer)) AND (r53_mesusu = fc_mesfolha((fc_getsession('DB_instit'::text))::integer)))