explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rfUw

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

Limit (cost=1.00..12,993.43 rows=50 width=93) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.00..589,857.40 rows=2,270 width=93) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.72..588,011.63 rows=6,045 width=101) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using pk_requisicao_id on solicitacao this_ (cost=0.43..582,252.36 rows=17,730 width=97) (actual rows= loops=)

  • Filter: ((id_agencia = 1) AND (idstatus = 2) AND ((NOT ic_pendente_escolha_aprovador) OR (ic_pendente_escolha_aprovador AND ((idstatus = 2) OR (idstatus = 8)))))
5. 0.000 0.000 ↓ 0.0

Index Only Scan using uk_portal_emissores_agencia_idx on emissores_agencia emi2_ (cost=0.29..0.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((id_celula_atendimento = this_.id_celula_atendimento) AND (idusuariorequisicao = 37497))
6. 0.000 0.000 ↓ 0.0

Index Only Scan using id_idx_pk on celula_atendimento cel1_ (cost=0.28..0.30 rows=1 width=4) (actual rows= loops=)