explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MlaZ

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

Limit (cost=199,384.56..199,384.57 rows=1 width=8) (actual time=128.668..128.668 rows=0 loops=1)

2. 0.004 128.668 ↓ 0.0 0 1

Sort (cost=199,384.56..199,384.57 rows=1 width=8) (actual time=128.667..128.668 rows=0 loops=1)

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

Index Scan using gerffx_ae_me_reg_rub_pk on gerffx (cost=0.56..199,384.55 rows=1 width=8) (actual time=128.664..128.664 rows=0 loops=1)

  • Index Cond: ((r53_regist = 694798) AND (r53_rubric = '0010'::bpchar))
  • 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.262 ms
Execution time : 128.687 ms