explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VfbfS

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 200.108 ↓ 0.0 0 1

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

2. 0.034 200.107 ↓ 0.0 0 1

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

  • Sort Key: r53_quant DESC
  • Sort Method: quicksort Memory: 25kB
3. 200.073 200.073 ↓ 0.0 0 1

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

  • 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)))
Planning time : 0.181 ms
Execution time : 200.132 ms