explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XUVk

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 9,083.707 ↑ 50.0 1 1

Limit (cost=1.00..12,993.43 rows=50 width=93) (actual time=8,765.347..9,083.707 rows=1 loops=1)

2. 0.009 9,083.702 ↑ 2,270.0 1 1

Nested Loop (cost=1.00..589,857.40 rows=2,270 width=93) (actual time=8,765.344..9,083.702 rows=1 loops=1)

3. 11.108 9,083.672 ↑ 6,045.0 1 1

Nested Loop (cost=0.72..588,011.63 rows=6,045 width=101) (actual time=8,765.316..9,083.672 rows=1 loops=1)

4. 9,031.758 9,031.758 ↑ 1.3 13,602 1

Index Scan using pk_requisicao_id on solicitacao this_ (cost=0.43..582,252.36 rows=17,730 width=97) (actual time=12.876..9,031.758 rows=13,602 loops=1)

  • Filter: ((id_agencia = 1) AND (idstatus = 2) AND ((NOT ic_pendente_escolha_aprovador) OR (ic_pendente_escolha_aprovador AND ((idstatus = 2) OR (idstatus = 8)))))
  • Rows Removed by Filter: 7645694
5. 40.806 40.806 ↓ 0.0 0 13,602

Index Only Scan using uk_portal_emissores_agencia_idx on emissores_agencia emi2_ (cost=0.29..0.31 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=13,602)

  • Index Cond: ((id_celula_atendimento = this_.id_celula_atendimento) AND (idusuariorequisicao = 37497))
  • Heap Fetches: 0
6. 0.021 0.021 ↑ 1.0 1 1

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

  • Index Cond: (id = this_.id_celula_atendimento)
  • Heap Fetches: 0
Planning time : 9.059 ms
Execution time : 9,083.856 ms