explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OUyS

Settings
# exclusive inclusive rows x rows loops node
1. 1.911 140,342.692 ↓ 145.0 145 1

Nested Loop Left Join (cost=0.00..158,176.60 rows=1 width=254) (actual time=5,855.219..140,342.692 rows=145 loops=1)

  • Join Filter: (buques."iFkTipoBuque" = tiposbuque."iIdTipoBuque")
  • Rows Removed by Join Filter: 37555
2. 0.537 140,339.331 ↓ 145.0 145 1

Nested Loop Left Join (cost=0.00..158,167.74 rows=1 width=236) (actual time=5,855.200..140,339.331 rows=145 loops=1)

  • Join Filter: ((tci."TrackNumber")::text = (pcb."TrackNumber")::text)
  • Rows Removed by Join Filter: 3768
3. 95.274 140,338.359 ↓ 145.0 145 1

Nested Loop Left Join (cost=0.00..158,166.20 rows=1 width=165) (actual time=5,855.187..140,338.359 rows=145 loops=1)

  • Join Filter: (pcb."iFkHistoricoBuque" = histbuques."iIdHistoricoBuque")
  • Rows Removed by Join Filter: 2313408
  • Filter: ((pcb."ID" > 748462050) OR (histbuques."iIdHistoricoBuque" > 2870031))
  • Rows Removed by Filter: 47
4. 73.639 138,674.445 ↓ 192.0 192 1

Nested Loop (cost=0.00..157,484.75 rows=1 width=142) (actual time=5,854.383..138,674.445 rows=192 loops=1)

  • Join Filter: (pcb."iFkBuque" = buques."iIdBuque")
  • Rows Removed by Join Filter: 2313408
5. 138,310.118 138,310.118 ↓ 192.0 192 1

Seq Scan on "LastPositions" pcb (cost=0.00..156,776.88 rows=1 width=98) (actual time=5,853.062..138,310.118 rows=192 loops=1)

  • Filter: (("iFkBuque" IS NOT NULL) AND ("UTCDate" > '2019-09-06 08:13:34.554981'::timestamp without time zone))
  • Rows Removed by Filter: 96626
6. 290.688 290.688 ↓ 1.0 12,050 192

Seq Scan on "Buques" buques (cost=0.00..557.39 rows=12,039 width=48) (actual time=0.003..1.514 rows=12,050 loops=192)

  • Filter: (NOT "bEliminado")
7. 1,568.640 1,568.640 ↑ 1.4 12,050 192

Seq Scan on "UltimoHistoricoBuque" histbuques (cost=0.00..396.71 rows=16,271 width=27) (actual time=0.002..8.170 rows=12,050 loops=192)

8. 0.435 0.435 ↓ 1.1 26 145

Seq Scan on "TargetCustomInformations" tci (cost=0.00..1.24 rows=24 width=80) (actual time=0.002..0.003 rows=26 loops=145)

9. 1.450 1.450 ↑ 1.0 260 145

Seq Scan on "TiposBuque" tiposbuque (cost=0.00..5.60 rows=260 width=37) (actual time=0.001..0.010 rows=260 loops=145)

Planning time : 0.863 ms
Execution time : 140,342.768 ms