explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nlcv : Optimization for: plan #k4P

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 1.364 ↓ 0.0 0 1

Nested Loop Left Join (cost=6.74..66.75 rows=1 width=778) (actual time=1.364..1.364 rows=0 loops=1)

2. 0.000 1.363 ↓ 0.0 0 1

Nested Loop Left Join (cost=6.59..66.43 rows=1 width=760) (actual time=1.363..1.363 rows=0 loops=1)

  • Join Filter: ((tci."TrackNumber")::text = (posiciones."TrackNumber")::text)
3. 0.002 1.363 ↓ 0.0 0 1

Nested Loop (cost=6.59..65.39 rows=1 width=159) (actual time=1.363..1.363 rows=0 loops=1)

4. 0.352 1.361 ↓ 0.0 0 1

Hash Left Join (cost=6.44..65.20 rows=1 width=118) (actual time=1.361..1.361 rows=0 loops=1)

  • Hash Cond: (posiciones."iFkHistoricoBuque" = histbuques."iIdHistoricoBuque")
  • Filter: ((posiciones."ID" > 748462050) OR (histbuques."iIdHistoricoBuque" > 2870031))
  • Rows Removed by Filter: 1260
5. 0.899 0.899 ↓ 1.0 1,260 1

Seq Scan on "LastPositions" posiciones (cost=0.00..51.73 rows=1,258 width=97) (actual time=0.043..0.899 rows=1,260 loops=1)

  • Filter: ("UTCDate" > '2019-09-06 08:13:34.554981'::timestamp without time zone)
6. 0.051 0.110 ↓ 1.1 161 1

Hash (cost=4.53..4.53 rows=153 width=25) (actual time=0.110..0.110 rows=161 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
7. 0.059 0.059 ↓ 1.1 161 1

Seq Scan on "UltimoHistoricoBuque" histbuques (cost=0.00..4.53 rows=153 width=25) (actual time=0.017..0.059 rows=161 loops=1)

8. 0.000 0.000 ↓ 0.0 0

Index Scan using "Buques_PK" on "Buques" buques (cost=0.14..0.18 rows=1 width=45) (never executed)

  • Index Cond: ("iIdBuque" = posiciones."iFkBuque")
  • Filter: (NOT "bEliminado")
9. 0.000 0.000 ↓ 0.0 0

Seq Scan on "TargetCustomInformations" tci (cost=0.00..1.02 rows=2 width=608) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Index Scan using "TiposBuque_PK" on "TiposBuque" tiposbuque (cost=0.15..0.30 rows=1 width=37) (never executed)

  • Index Cond: (buques."iFkTipoBuque" = "iIdTipoBuque")
Planning time : 12.724 ms
Execution time : 1.500 ms