explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nLvj

Settings
# exclusive inclusive rows x rows loops node
1. 0.089 50,184.957 ↑ 1.0 1 1

Aggregate (cost=3,436.37..3,436.38 rows=1 width=8) (actual time=50,184.957..50,184.957 rows=1 loops=1)

2. 0.010 50,184.868 ↓ 6.0 6 1

Nested Loop (cost=2,055.99..3,436.37 rows=1 width=4) (actual time=48,383.609..50,184.868 rows=6 loops=1)

3. 39.823 50,184.804 ↓ 6.0 6 1

Nested Loop (cost=2,055.71..3,436.02 rows=1 width=8) (actual time=48,383.590..50,184.804 rows=6 loops=1)

4. 7.752 464.621 ↓ 10,620.0 21,240 1

Nested Loop (cost=973.14..1,109.53 rows=2 width=4) (actual time=242.203..464.621 rows=21,240 loops=1)

5. 0.119 0.140 ↓ 39.0 39 1

Bitmap Heap Scan on celula_atendimento cel3_ (cost=3.39..4.41 rows=1 width=4) (actual time=0.025..0.140 rows=39 loops=1)

  • Recheck Cond: ((id_ponto_venda = 96) AND (id_cliente_agencia = 641))
  • Heap Blocks: exact=16
6. 0.002 0.021 ↓ 0.0 0 1

BitmapAnd (cost=3.39..3.39 rows=1 width=0) (actual time=0.021..0.021 rows=0 loops=1)

7. 0.011 0.011 ↑ 1.0 39 1

Bitmap Index Scan on ix1_ponto_venda__agencia (cost=0.00..1.57 rows=39 width=0) (actual time=0.011..0.011 rows=39 loops=1)

  • Index Cond: (id_ponto_venda = 96)
8. 0.008 0.008 ↑ 1.0 39 1

Bitmap Index Scan on id_cliente_agencia_idx (cost=0.00..1.57 rows=39 width=0) (actual time=0.008..0.008 rows=39 loops=1)

  • Index Cond: (id_cliente_agencia = 641)
9. 74.334 456.729 ↓ 109.0 545 39

Bitmap Heap Scan on solicitacao soli2_ (cost=969.75..1,105.07 rows=5 width=8) (actual time=9.882..11.711 rows=545 loops=39)

  • Recheck Cond: ((id_celula_atendimento = cel3_.id) AND (idcliente = 2214))
  • Filter: (id_agencia = 641)
  • Heap Blocks: exact=17626
10. 25.350 382.395 ↓ 0.0 0 39

BitmapAnd (cost=969.75..969.75 rows=133 width=0) (actual time=9.805..9.805 rows=0 loops=39)

11. 104.364 104.364 ↑ 2.1 7,448 39

Bitmap Index Scan on ix1_id_celula_atendimento__solicitacao (cost=0.00..207.24 rows=15,974 width=0) (actual time=2.676..2.676 rows=7,448 loops=39)

  • Index Cond: (id_celula_atendimento = cel3_.id)
12. 252.681 252.681 ↓ 1.1 67,237 31

Bitmap Index Scan on solicitacao_idx2 (cost=0.00..761.67 rows=63,765 width=0) (actual time=8.151..8.151 rows=67,237 loops=31)

  • Index Cond: (idcliente = 2214)
13. 63.720 49,680.360 ↓ 0.0 0 21,240

Bitmap Heap Scan on log_integracao this_ (cost=1,082.58..1,163.16 rows=8 width=12) (actual time=2.339..2.339 rows=0 loops=21,240)

  • Recheck Cond: ((id_solicitacao = soli2_.id) AND (data_criacao >= '2019-11-01 00:00:00'::timestamp without time zone) AND (data_criacao <= '2019-11-04 23:59:59'::timestamp without time zone))
  • Filter: ((NOT sucesso) AND (NOT ic_processado_manual) AND (NOT reprocessado))
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=349
14. 15.075 49,616.640 ↓ 0.0 0 21,240

BitmapAnd (cost=1,082.58..1,082.58 rows=205 width=0) (actual time=2.336..2.336 rows=0 loops=21,240)

15. 212.400 212.400 ↑ 30,619.5 2 21,240

Bitmap Index Scan on ix1_log_integracao__solicitacao (cost=0.00..477.80 rows=61,239 width=0) (actual time=0.010..0.010 rows=2 loops=21,240)

  • Index Cond: (id_solicitacao = soli2_.id)
16. 49,389.165 49,389.165 ↑ 1.1 36,078 18,045

Bitmap Index Scan on ix1_log_integracao__data_criacao (cost=0.00..604.11 rows=40,967 width=0) (actual time=2.737..2.737 rows=36,078 loops=18,045)

  • Index Cond: ((data_criacao >= '2019-11-01 00:00:00'::timestamp without time zone) AND (data_criacao <= '2019-11-04 23:59:59'::timestamp without time zone))
17. 0.054 0.054 ↑ 1.0 1 6

Index Scan using pk_configuracao_connector on configuracao_connector configcone1_ (cost=0.28..0.34 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=6)

  • Index Cond: (id = this_.id_configuracao_connector)
  • Filter: (ativo AND (id_contexto_exibicao_log_integracao <> 2) AND ((id_contexto_exibicao_log_integracao = 3) OR (id_contexto_exibicao_log_integracao = 0)))
Planning time : 0.851 ms
Execution time : 50,185.048 ms