explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0w6D

Settings
# exclusive inclusive rows x rows loops node
1. 3.167 54,555.582 ↓ 1.2 5 1

Gather Merge (cost=874,343.98..874,344.45 rows=4 width=494) (actual time=54,555.409..54,555.582 rows=5 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
  • Buffers: shared hit=474587 read=325682
  • I/O Timings: read=2236.190
2. 0.063 54,552.415 ↓ 2.5 5 1

Sort (cost=873,343.96..873,343.96 rows=2 width=494) (actual time=54,552.410..54,552.415 rows=5 loops=1)

  • Sort Key: "Remessa".data_rota DESC
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=474587 read=325682
  • I/O Timings: read=2236.190
3. 0.055 54,552.352 ↓ 2.5 5 1

Nested Loop Left Join (cost=0.69..873,343.95 rows=2 width=494) (actual time=5,993.359..54,552.352 rows=5 loops=1)

  • Buffers: shared hit=474587 read=325682
  • I/O Timings: read=2236.190
4. 0.069 54,552.232 ↓ 2.5 5 1

Nested Loop Left Join (cost=0.42..873,339.28 rows=2 width=471) (actual time=5,993.319..54,552.232 rows=5 loops=1)

  • Buffers: shared hit=474572 read=325682
  • I/O Timings: read=2236.190
5. 54,551.988 54,551.988 ↓ 2.5 5 1

Parallel Seq Scan on "Remessa" (cost=0.00..873,333.99 rows=2 width=346) (actual time=5,993.242..54,551.988 rows=5 loops=1)

  • Filter: ((fk_ultima_ocorrencia_rastreamento = ANY ('{9,79}'::integer[])) AND (entregador_final = 1457))
  • Rows Removed by Filter: 11695235
  • Buffers: shared hit=474557 read=325682
  • I/O Timings: read=2236.190
6. 0.175 0.175 ↓ 0.0 0 5

Index Scan using "Coleta_fk_remessa_idx" on "Coleta" (cost=0.42..2.64 rows=1 width=137) (actual time=0.034..0.035 rows=0 loops=5)

  • Index Cond: (("Remessa".codigo)::text = (fk_remessa)::text)
  • Buffers: shared hit=15
7. 0.065 0.065 ↑ 1.0 1 5

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

  • Index Cond: ("Remessa".fk_servico = codigo)
  • Buffers: shared hit=15
Planning time : 0.919 ms
Execution time : 54,555.889 ms