explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j6xw

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 14.596 ↑ 1.2 5 1

Sort (cost=2,585.27..2,585.29 rows=6 width=494) (actual time=14.593..14.596 rows=5 loops=1)

  • Sort Key: "Remessa".data_rota DESC
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=9795
2. 0.020 14.578 ↑ 1.2 5 1

Nested Loop Left Join (cost=1.12..2,585.20 rows=6 width=494) (actual time=14.346..14.578 rows=5 loops=1)

  • Buffers: shared hit=9795
3. 14.543 14.543 ↑ 1.2 5 1

Nested Loop Left Join (cost=0.85..2,571.25 rows=6 width=471) (actual time=14.331..14.543 rows=5 loops=1)

  • Buffers: shared hit=9780
  • -> Index Scan using "Remessa_entregador_final_idx" on "Remessa" (cost=0.43..2555.37 rows=6 width=346) (actual time=14.311..1
  • Index Cond: (entregador_final = 1457)
  • Filter: (fk_ultima_ocorrencia_rastreamento = ANY ('{9,79}'::integer[]))
  • Rows Removed by Filter: 10446
  • Buffers: shared hit=9765
  • -> Index Scan using "Coleta_fk_remessa_idx" on "Coleta" (cost=0.42..2.64 rows=1 width=137) (actual time=0.010..0.010 rows=0
  • Index Cond: (("Remessa".codigo)::text = (fk_remessa)::text)
  • Buffers: shared hit=15
4. 0.015 0.015 ↑ 1.0 1 5

Index Scan using "Servico_pkey" on "Servico" (cost=0.27..2.32 rows=1 width=27) (actual time=0.003..0.003 rows=1 loops=5)

  • Index Cond: ("Remessa".fk_servico = codigo)
  • Buffers: shared hit=15
Planning time : 0.521 ms
Execution time : 14.706 ms