explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hdQO

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 51.394 ↑ 1.0 15 1

Limit (cost=1.70..70.09 rows=15 width=1,890) (actual time=34.486..51.394 rows=15 loops=1)

2. 0.022 51.374 ↑ 458,098.5 15 1

Nested Loop Left Join (cost=1.70..31,327,509.78 rows=6,871,478 width=1,890) (actual time=34.484..51.374 rows=15 loops=1)

  • Join Filter: ("Servico".fk_tipo_de_remessa = "Servico.TipoRemessa".codigo)
3. 0.034 51.337 ↑ 458,098.5 15 1

Nested Loop Left Join (cost=1.70..30,880,862.67 rows=6,871,478 width=1,883) (actual time=34.475..51.337 rows=15 loops=1)

  • Join Filter: ("Servico".fk_negocio = "Servico.Negocio".codigo)
  • Rows Removed by Join Filter: 15
4. 0.051 51.273 ↑ 458,098.5 15 1

Nested Loop Left Join (cost=1.70..30,434,215.55 rows=6,871,478 width=1,878) (actual time=34.447..51.273 rows=15 loops=1)

5. 0.060 51.177 ↑ 458,098.5 15 1

Nested Loop Left Join (cost=1.56..28,097,193.49 rows=6,871,478 width=1,846) (actual time=34.433..51.177 rows=15 loops=1)

6. 0.037 51.057 ↑ 458,098.5 15 1

Nested Loop Left Join (cost=1.42..26,981,197.13 rows=6,871,478 width=1,812) (actual time=34.414..51.057 rows=15 loops=1)

  • Join Filter: ("Remessa".fk_tipo_remessa = "TipoRemessa".codigo)
7. 0.128 51.005 ↑ 458,098.5 15 1

Nested Loop Left Join (cost=1.42..26,534,550.02 rows=6,871,478 width=1,805) (actual time=34.392..51.005 rows=15 loops=1)

8. 0.052 50.832 ↑ 458,098.5 15 1

Nested Loop Left Join (cost=1.28..24,824,242.96 rows=6,871,478 width=1,788) (actual time=34.297..50.832 rows=15 loops=1)

9. 0.028 50.720 ↑ 458,098.5 15 1

Nested Loop Left Join (cost=1.14..23,725,710.24 rows=6,871,478 width=1,748) (actual time=34.283..50.720 rows=15 loops=1)

  • Join Filter: ("Remessa".fk_prioridade = "PrioridadeRemessa".codigo)
10. 0.042 50.662 ↑ 458,098.5 15 1

Nested Loop Left Join (cost=1.14..23,553,922.26 rows=6,871,478 width=1,738) (actual time=34.258..50.662 rows=15 loops=1)

11. 0.053 34.765 ↑ 458,098.5 15 1

Nested Loop Left Join (cost=0.86..21,544,020.50 rows=6,871,478 width=1,731) (actual time=34.252..34.765 rows=15 loops=1)

12. 0.049 34.637 ↑ 458,098.5 15 1

Nested Loop Left Join (cost=0.58..5,224,273.68 rows=6,871,478 width=1,673) (actual time=34.235..34.637 rows=15 loops=1)

13. 0.041 34.528 ↑ 458,098.5 15 1

Nested Loop Left Join (cost=0.43..4,108,082.65 rows=6,871,478 width=1,624) (actual time=34.218..34.528 rows=15 loops=1)

14. 0.133 34.472 ↑ 458,098.5 15 1

Nested Loop Left Join (cost=0.29..2,991,434.88 rows=6,871,478 width=1,579) (actual time=34.198..34.472 rows=15 loops=1)

15. 19.324 19.324 ↑ 458,098.5 15 1

Seq Scan on "Remessa" (cost=0.00..875,005.50 rows=6,871,478 width=1,543) (actual time=19.244..19.324 rows=15 loops=1)

  • Filter: (("pedido_II")::text ~~* '%gold%'::text)
16. 15.015 15.015 ↑ 1.0 1 15

Index Scan using "ArquivoProcessado_pkey" on "ArquivoProcessado" (cost=0.29..0.31 rows=1 width=40) (actual time=1.001..1.001 rows=1 loops=15)

  • Index Cond: ("Remessa".fk_arquivo_processado = codigo)
17. 0.015 0.015 ↓ 0.0 0 15

Index Scan using "Courier_pkey" on "Courier" "CourierColeta" (cost=0.14..0.16 rows=1 width=49) (actual time=0.001..0.001 rows=0 loops=15)

  • Index Cond: ("Remessa".fk_courier_coleta = codigo)
18. 0.060 0.060 ↑ 1.0 1 15

Index Scan using "Courier_pkey" on "Courier" "CourierDestino" (cost=0.14..0.16 rows=1 width=53) (actual time=0.004..0.004 rows=1 loops=15)

  • Index Cond: ("Remessa".fk_courier_destino = codigo)
19. 0.075 0.075 ↑ 1.0 1 15

Index Scan using "Fornecedor_pkey" on "Fornecedor" "CourierDestino.Fornecedor" (cost=0.28..2.38 rows=1 width=62) (actual time=0.005..0.005 rows=1 loops=15)

  • Index Cond: ("CourierDestino".fk_fornecedor = codigo)
20. 15.855 15.855 ↓ 0.0 0 15

Index Scan using "RotaColetaEntrega_pkey" on "RotaColetaEntrega" (cost=0.28..0.29 rows=1 width=11) (actual time=1.057..1.057 rows=0 loops=15)

  • Index Cond: ("Remessa".fk_rota_coleta_entrega = codigo)
21. 0.016 0.030 ↑ 2.0 1 15

Materialize (cost=0.00..1.03 rows=2 width=14) (actual time=0.002..0.002 rows=1 loops=15)

22. 0.014 0.014 ↑ 2.0 1 1

Seq Scan on "PrioridadeRemessa" (cost=0.00..1.02 rows=2 width=14) (actual time=0.014..0.014 rows=1 loops=1)

23. 0.060 0.060 ↑ 1.0 1 15

Index Scan using "Ocorrencia_pkey" on "Ocorrencia" "UltimaOcorrenciaRastreamento" (cost=0.14..0.16 rows=1 width=40) (actual time=0.004..0.004 rows=1 loops=15)

  • Index Cond: ("Remessa".fk_ultima_ocorrencia_rastreamento = codigo)
24. 0.045 0.045 ↑ 1.0 1 15

Index Scan using "SituacaoRemessa_pkey" on "SituacaoRemessa" "UltimaOcorrenciaRastreamento.SituacaoRemessa" (cost=0.14..0.25 rows=1 width=21) (actual time=0.003..0.003 rows=1 loops=15)

  • Index Cond: ("UltimaOcorrenciaRastreamento".fk_situacao_remessa = codigo)
25. 0.003 0.015 ↑ 5.0 1 15

Materialize (cost=0.00..1.07 rows=5 width=11) (actual time=0.001..0.001 rows=1 loops=15)

26. 0.012 0.012 ↑ 5.0 1 1

Seq Scan on "TipoRemessa" (cost=0.00..1.05 rows=5 width=11) (actual time=0.012..0.012 rows=1 loops=1)

27. 0.060 0.060 ↑ 1.0 1 15

Index Scan using "Servico_pkey" on "Servico" (cost=0.14..0.16 rows=1 width=38) (actual time=0.004..0.004 rows=1 loops=15)

  • Index Cond: ("Remessa".fk_servico = codigo)
28. 0.045 0.045 ↑ 1.0 1 15

Index Scan using "TipoEtiquetaFormulario_pkey" on "TipoEtiquetaFormulario" "Servico.EtiquetaTermica" (cost=0.14..0.34 rows=1 width=36) (actual time=0.003..0.003 rows=1 loops=15)

  • Index Cond: ("Servico".fk_etiqueta_termica = codigo)
29. 0.009 0.030 ↑ 2.5 2 15

Materialize (cost=0.00..1.07 rows=5 width=9) (actual time=0.002..0.002 rows=2 loops=15)

30. 0.021 0.021 ↑ 2.5 2 1

Seq Scan on "Negocio" "Servico.Negocio" (cost=0.00..1.05 rows=5 width=9) (actual time=0.020..0.021 rows=2 loops=1)

31. 0.011 0.015 ↑ 5.0 1 15

Materialize (cost=0.00..1.07 rows=5 width=11) (actual time=0.001..0.001 rows=1 loops=15)

32. 0.004 0.004 ↑ 5.0 1 1

Seq Scan on "TipoRemessa" "Servico.TipoRemessa" (cost=0.00..1.05 rows=5 width=11) (actual time=0.003..0.004 rows=1 loops=1)

Planning time : 10.671 ms