1. Insert on "Iml_Alex" (cost=93666763.69..562005567.10 rows=500000 width=28) (actual time=1591967.759..1591967.759 rows=0 loops=1)
  2. -> Subquery Scan on "*SELECT*" (cost=93666763.69..562005567.10 rows=500000 width=28) (actual time=249417.533..1589517.552 rows=500000 loops=1)
  3. -> Limit (cost=93666763.69..562000567.10 rows=500000 width=28) (actual time=249417.530..1588880.330 rows=500000 loops=1)
  4. -> GroupAggregate (cost=3.01..579476593582.24 rows=618657664 width=28) (actual time=3.488..1588237.083 rows=600000 loops=1)
  5. -> Nested Loop Left Join (cost=3.01..579467313717.28 rows=618657664 width=28) (actual time=3.271..1586737.513 rows=1322861 loops=1)
  6. -> Nested Loop Left Join (cost=2.44..574145856182.56 rows=618657664 width=28) (actual time=3.235..1567144.567 rows=1322861 loops=1)
  7. Join Filter: ("DimStopPoint"."StopAreaNumber" = t2."StopAreaNumber")
  8. Rows Removed by Join Filter: 213599279
  9. -> Nested Loop Left Join (cost=1.44..12911071331.05 rows=618657664 width=40) (actual time=0.131..46894.358 rows=600001 loops=1)
  10. -> Nested Loop Left Join (cost=0.86..7589613796.33 rows=618657664 width=28) (actual time=0.064..7084.816 rows=600001 loops=1)
  11. -> 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)
  12. -> 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)
  13. Index Cond: (t1."StopAreaNumber_id" = id)
  14. -> 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)
  15. Index Cond: (oid = (t1.tapin_oid)::oid)
  16. -> Nested Loop (cost=1.00..906.26 rows=74 width=16) (actual time=0.010..2.310 rows=357 loops=600001)
  17. -> 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)
  18. Index Cond: (("CalendarDateKey" = t3."CalendarDateKey") AND ("VehicleKey" = t3."VehicleKey") AND ("ObservedArrivalCalendarTimeKey" > t3."ValidationCalendarTimeKey"))
  19. -> 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)
  20. Index Cond: ("StopPointKey" = "FactObservation"."ObservedStopPointKey")
  21. -> 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)
  22. Index Cond: (oid = (t1.next_tapin)::oid)
  23. Heap Fetches: 1317025
  24. Trigger for constraint FKA_date: time=653.066 calls=500000
  25. Trigger for constraint FKA_time: time=1334.542 calls=500000
  26. Trigger for constraint FKA_to_stoparea_id: time=2547.736 calls=500000
  27. Total runtime: 1597365.296 ms
Comments powered by Disqus