explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Km1S

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.163 ↑ 1.0 1 1

Sort (cost=69.07..69.08 rows=1 width=4,402) (actual time=0.163..0.163 rows=1 loops=1)

  • Sort Key: "Remessa".order_arq
  • Sort Method: quicksort Memory: 29kB
2. 0.002 0.148 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.37..69.06 rows=1 width=4,402) (actual time=0.145..0.148 rows=1 loops=1)

3. 0.002 0.134 ↑ 1.0 1 1

Nested Loop (cost=3.10..60.75 rows=1 width=4,395) (actual time=0.131..0.134 rows=1 loops=1)

4. 0.001 0.126 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.95..52.53 rows=1 width=4,350) (actual time=0.124..0.126 rows=1 loops=1)

5. 0.002 0.123 ↑ 1.0 1 1

Nested Loop (cost=2.80..44.30 rows=1 width=4,305) (actual time=0.121..0.123 rows=1 loops=1)

6. 0.001 0.115 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.65..36.08 rows=1 width=4,260) (actual time=0.113..0.115 rows=1 loops=1)

7. 0.000 0.109 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.52..35.85 rows=1 width=4,255) (actual time=0.107..0.109 rows=1 loops=1)

8. 0.002 0.105 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.38..35.54 rows=1 width=3,614) (actual time=0.103..0.105 rows=1 loops=1)

9. 0.001 0.101 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.24..35.22 rows=1 width=2,973) (actual time=0.099..0.101 rows=1 loops=1)

10. 0.002 0.098 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.10..34.90 rows=1 width=2,332) (actual time=0.096..0.098 rows=1 loops=1)

11. 0.002 0.091 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.96..34.58 rows=1 width=1,691) (actual time=0.089..0.091 rows=1 loops=1)

12. 0.002 0.085 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.82..34.26 rows=1 width=1,050) (actual time=0.084..0.085 rows=1 loops=1)

13. 0.001 0.076 ↑ 1.0 1 1

Nested Loop (cost=1.68..33.94 rows=1 width=1,018) (actual time=0.075..0.076 rows=1 loops=1)

14. 0.005 0.068 ↑ 1.0 1 1

Nested Loop (cost=1.54..33.70 rows=1 width=1,007) (actual time=0.067..0.068 rows=1 loops=1)

15. 0.002 0.055 ↑ 1.0 1 1

Nested Loop (cost=1.27..25.33 rows=1 width=927) (actual time=0.054..0.055 rows=1 loops=1)

16. 0.005 0.045 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.98..17.03 rows=1 width=915) (actual time=0.044..0.045 rows=1 loops=1)

  • Join Filter: (("Remessa".codigo)::text = ("Coleta".fk_remessa)::text)
17. 0.028 0.028 ↑ 1.0 1 1

Index Scan using "Remessa_pkey" on "Remessa" (cost=0.56..8.58 rows=1 width=872) (actual time=0.027..0.028 rows=1 loops=1)

  • Index Cond: ((codigo)::text = 'IC20011275668'::text)
18. 0.012 0.012 ↓ 0.0 0 1

Index Scan using "Coleta_fk_remessa_idx" on "Coleta" (cost=0.42..8.44 rows=1 width=55) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((fk_remessa)::text = 'IC20011275668'::text)
19. 0.008 0.008 ↑ 1.0 1 1

Index Scan using "Localidade_pkey" on "Localidade" (cost=0.29..8.30 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (codigo = "Remessa".fk_localidade)
20. 0.008 0.008 ↑ 1.0 1 1

Index Scan using "Servico_pkey" on "Servico" (cost=0.27..8.29 rows=1 width=84) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (codigo = "Remessa".fk_servico)
21. 0.007 0.007 ↑ 1.0 1 1

Index Scan using "Cliente_pkey" on "Cliente" "Servico.Cliente" (cost=0.14..0.24 rows=1 width=15) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (codigo = "Servico".fk_cliente)
22. 0.007 0.007 ↑ 1.0 1 1

Index Scan using "TipoEtiquetaFormulario_pkey" on "TipoEtiquetaFormulario" "Servico.ProtocoloRecebimento" (cost=0.14..0.31 rows=1 width=36) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: ("Servico".fk_protocolo_recebimento = codigo)
23. 0.004 0.004 ↑ 1.0 1 1

Index Scan using "TipoEtiquetaFormulario_pkey" on "TipoEtiquetaFormulario" "Servico.EtiquetaTermica" (cost=0.14..0.31 rows=1 width=645) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: ("Servico".fk_etiqueta_termica = codigo)
24. 0.005 0.005 ↑ 1.0 1 1

Index Scan using "TipoEtiquetaFormulario_pkey" on "TipoEtiquetaFormulario" "Servico.EtiquetaTermicaCorreios" (cost=0.14..0.31 rows=1 width=645) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: ("Servico".fk_etiqueta_termica_correios = codigo)
25. 0.002 0.002 ↓ 0.0 0 1

Index Scan using "TipoEtiquetaFormulario_pkey" on "TipoEtiquetaFormulario" "Servico.EtiquetaTermicaCorreiosAR" (cost=0.14..0.31 rows=1 width=645) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ("Servico".fk_etiqueta_termica_correios_ar = codigo)
26. 0.002 0.002 ↓ 0.0 0 1

Index Scan using "TipoEtiquetaFormulario_pkey" on "TipoEtiquetaFormulario" "Servico.EtiquetaTermicaRemessaExpressa" (cost=0.14..0.31 rows=1 width=645) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ("Servico".fk_etiqueta_termica_expressa = codigo)
27. 0.004 0.004 ↓ 0.0 0 1

Index Scan using "TipoEtiquetaFormulario_pkey" on "TipoEtiquetaFormulario" "Servico.EtiquetaTermicaRemessaEconomica" (cost=0.14..0.31 rows=1 width=645) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: ("Servico".fk_etiqueta_termica_economica = codigo)
28. 0.005 0.005 ↑ 1.0 1 1

Index Scan using "ServicoCorreio_pkey" on "ServicoCorreio" "Servico.ServicoCorreio" (cost=0.14..0.21 rows=1 width=9) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: ("Servico".fk_servico_correio = codigo)
29. 0.006 0.006 ↑ 1.0 1 1

Index Scan using "Courier_pkey" on "Courier" "CourierDestino" (cost=0.15..8.17 rows=1 width=49) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (codigo = "Remessa".fk_courier_destino)
30. 0.002 0.002 ↓ 0.0 0 1

Index Scan using "Courier_pkey" on "Courier" "CourierColeta" (cost=0.15..8.17 rows=1 width=49) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ("Remessa".fk_courier_coleta = codigo)
31. 0.006 0.006 ↑ 1.0 1 1

Index Scan using "Courier_pkey" on "Courier" "CourierOrigem" (cost=0.15..8.17 rows=1 width=49) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (codigo = "Remessa".fk_courier_origem)
32. 0.012 0.012 ↑ 1.0 1 1

Index Scan using "RotaColetaEntrega_pkey" on "RotaColetaEntrega" (cost=0.28..8.29 rows=1 width=11) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: ("Remessa".fk_rota_coleta_entrega = codigo)