explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m7TD

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 0.173 ↑ 1.0 1 1

Sort (cost=69.00..69.01 rows=1 width=4,402) (actual time=0.173..0.173 rows=1 loops=1)

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

Nested Loop Left Join (cost=3.37..68.99 rows=1 width=4,402) (actual time=0.133..0.136 rows=1 loops=1)

3. 0.002 0.130 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.10..60.68 rows=1 width=4,395) (actual time=0.127..0.130 rows=1 loops=1)

4. 0.001 0.123 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.95..52.46 rows=1 width=4,350) (actual time=0.121..0.123 rows=1 loops=1)

5. 0.000 0.120 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.80..44.24 rows=1 width=4,305) (actual time=0.118..0.120 rows=1 loops=1)

6. 0.000 0.114 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.65..36.01 rows=1 width=4,260) (actual time=0.112..0.114 rows=1 loops=1)

7. 0.002 0.109 ↑ 1.0 1 1

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

8. 0.000 0.104 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.38..35.47 rows=1 width=3,614) (actual time=0.102..0.104 rows=1 loops=1)

9. 0.001 0.101 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.24..35.15 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.83 rows=1 width=2,332) (actual time=0.096..0.098 rows=1 loops=1)

11. 0.001 0.090 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.96..34.51 rows=1 width=1,691) (actual time=0.088..0.090 rows=1 loops=1)

12. 0.001 0.086 ↑ 1.0 1 1

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

13. 0.000 0.079 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.68..33.87 rows=1 width=1,018) (actual time=0.078..0.079 rows=1 loops=1)

14. 0.001 0.070 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.39..25.57 rows=1 width=1,006) (actual time=0.068..0.070 rows=1 loops=1)

  • Join Filter: (("Remessa".codigo)::text = ("Coleta".fk_remessa)::text)
15. 0.004 0.053 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.97..17.12 rows=1 width=963) (actual time=0.052..0.053 rows=1 loops=1)

16. 0.026 0.026 ↑ 1.0 1 1

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

  • Index Cond: ((codigo)::text = 'IC20011275668'::text)
17. 0.004 0.023 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.41..8.53 rows=1 width=95) (actual time=0.022..0.023 rows=1 loops=1)

18. 0.014 0.014 ↑ 1.0 1 1

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

  • Index Cond: ("Remessa".fk_servico = codigo)
19. 0.005 0.005 ↑ 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.005..0.005 rows=1 loops=1)

  • Index Cond: ("Servico".fk_cliente = codigo)
20. 0.016 0.016 ↓ 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.016..0.016 rows=0 loops=1)

  • Index Cond: ((fk_remessa)::text = 'IC20011275668'::text)
21. 0.009 0.009 ↑ 1.0 1 1

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

  • Index Cond: ("Remessa".fk_localidade = codigo)
22. 0.006 0.006 ↑ 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.006..0.006 rows=1 loops=1)

  • Index Cond: ("Servico".fk_protocolo_recebimento = codigo)
23. 0.003 0.003 ↑ 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.003..0.003 rows=1 loops=1)

  • Index Cond: ("Servico".fk_etiqueta_termica = codigo)
24. 0.006 0.006 ↑ 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.006..0.006 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.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: ("Servico".fk_etiqueta_termica_expressa = codigo)
27. 0.003 0.003 ↓ 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.003 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.005..0.006 rows=1 loops=1)

  • Index Cond: ("Remessa".fk_courier_destino = codigo)
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.005 0.005 ↑ 1.0 1 1

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

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

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

  • Index Cond: ("Remessa".fk_rota_coleta_entrega = codigo)
Planning time : 6.895 ms