explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5x4I : After index

Settings

Optimization path:

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

Nested Loop Left Join (cost=18.95..52.73 rows=1 width=778) (actual time=0.874..0.874 rows=0 loops=1)

2. 0.001 0.873 ↓ 0.0 0 1

Nested Loop Left Join (cost=18.80..52.42 rows=1 width=760) (actual time=0.873..0.873 rows=0 loops=1)

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

Hash Left Join (cost=18.80..51.38 rows=1 width=159) (actual time=0.872..0.872 rows=0 loops=1)

  • Hash Cond: (posiciones."iFkHistoricoBuque" = histbuques."iIdHistoricoBuque")
  • Filter: ((posiciones."ID" > 748462050) OR (histbuques."iIdHistoricoBuque" > 2870031))
  • Rows Removed by Filter: 163
4. 0.189 0.637 ↑ 7.8 163 1

Merge Join (cost=12.36..37.86 rows=1,272 width=138) (actual time=0.238..0.637 rows=163 loops=1)

  • Merge Cond: (posiciones."iFkBuque" = buques."iIdBuque")
5. 0.193 0.193 ↑ 7.8 164 1

Index Scan using lastpositions_ifkbuque_idx on "LastPositions" posiciones (cost=0.28..189.98 rows=1,272 width=97) (actual time=0.009..0.193 rows=164 loops=1)

  • Index Cond: ("UTCDate" > '2019-09-06 08:13:34.554981'::timestamp without time zone)
6. 0.131 0.255 ↓ 1.1 163 1

Sort (cost=12.08..12.46 rows=153 width=45) (actual time=0.222..0.255 rows=163 loops=1)

  • Sort Key: buques."iIdBuque
  • Sort Method: quicksort Memory: 41kB
7. 0.124 0.124 ↓ 1.1 163 1

Seq Scan on "Buques" buques (cost=0.00..6.53 rows=153 width=45) (actual time=0.027..0.124 rows=163 loops=1)

  • Filter: (NOT "bEliminado")
8. 0.046 0.106 ↓ 1.1 163 1

Hash (cost=4.53..4.53 rows=153 width=25) (actual time=0.106..0.106 rows=163 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
9. 0.060 0.060 ↓ 1.1 163 1

Seq Scan on "UltimoHistoricoBuque" histbuques (cost=0.00..4.53 rows=153 width=25) (actual time=0.028..0.060 rows=163 loops=1)

10. 0.000 0.000 ↓ 0.0 0

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

11. 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 : 3.677 ms
Execution time : 1.039 ms