- Insert on "Iml_Alex" (cost=93666763.69..562005567.10 rows=500000 width=28) (actual time=1591967.759..1591967.759 rows=0 loops=1)
- -> Subquery Scan on "*SELECT*" (cost=93666763.69..562005567.10 rows=500000 width=28) (actual time=249417.533..1589517.552 rows=500000 loops=1)
- -> Limit (cost=93666763.69..562000567.10 rows=500000 width=28) (actual time=249417.530..1588880.330 rows=500000 loops=1)
- -> GroupAggregate (cost=3.01..579476593582.24 rows=618657664 width=28) (actual time=3.488..1588237.083 rows=600000 loops=1)
- -> Nested Loop Left Join (cost=3.01..579467313717.28 rows=618657664 width=28) (actual time=3.271..1586737.513 rows=1322861 loops=1)
- -> Nested Loop Left Join (cost=2.44..574145856182.56 rows=618657664 width=28) (actual time=3.235..1567144.567 rows=1322861 loops=1)
- Join Filter: ("DimStopPoint"."StopAreaNumber" = t2."StopAreaNumber")
- Rows Removed by Join Filter: 213599279
- -> Nested Loop Left Join (cost=1.44..12911071331.05 rows=618657664 width=40) (actual time=0.131..46894.358 rows=600001 loops=1)
- -> Nested Loop Left Join (cost=0.86..7589613796.33 rows=618657664 width=28) (actual time=0.064..7084.816 rows=600001 loops=1)
- -> Index Scan using "PK2_tapin_oid" on "Iml_trips_with_tapouts2" t1 (cost=0.57..2495918660.17 rows=618657664 width=24) (actual time=0.057..3930.349 rows=600001 loops=1)
- -> Index Scan using "PK_StopAreaNumber_id" on "ImlStopArea" t2 (cost=0.29..8.22 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=600001)
- Index Cond: (t1."StopAreaNumber_id" = id)
- -> Index Scan using factvalidatedtickets_2017_oid_index on "FactValidatedTickets_2017" t3 (cost=0.58..8.59 rows=1 width=16) (actual time=0.063..0.064 rows=1 loops=600001)
- Index Cond: (oid = (t1.tapin_oid)::oid)
- -> Nested Loop (cost=1.00..906.26 rows=74 width=16) (actual time=0.010..2.310 rows=357 loops=600001)
- -> Index Scan using factobsrvation_datevehicletime_index on "FactObservation" (cost=0.57..280.98 rows=74 width=16) (actual time=0.007..0.339 rows=357 loops=600001)
- Index Cond: (("CalendarDateKey" = t3."CalendarDateKey") AND ("VehicleKey" = t3."VehicleKey") AND ("ObservedArrivalCalendarTimeKey" > t3."ValidationCalendarTimeKey"))
- -> Index Scan using "PK_DimStopPoint" on "DimStopPoint" (cost=0.42..8.44 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=214466300)
- Index Cond: ("StopPointKey" = "FactObservation"."ObservedStopPointKey")
- -> Index Only Scan using factvalidatedtickets_2017_oid_index on "FactValidatedTickets_2017" t4 (cost=0.58..8.59 rows=1 width=4) (actual time=0.012..0.012 rows=1 loops=1322861)
- Index Cond: (oid = (t1.next_tapin)::oid)
- Heap Fetches: 1317025
- Trigger for constraint FKA_date: time=653.066 calls=500000
- Trigger for constraint FKA_time: time=1334.542 calls=500000
- Trigger for constraint FKA_to_stoparea_id: time=2547.736 calls=500000
- Total runtime: 1597365.296 ms