Ups, du hast recht. Ich habe den Befehl im falschen Editor verarbeitet. I-)
Das ist das richtige Ergebnis:
Code:
Nested Loop (cost=39.71..1411746492593230768504832.00 rows=70536754371864697356943360 width=298)
-> Nested Loop (cost=0.00..1011405155936572407808.00 rows=35732904950286071627776 width=256)
-> Nested Loop (cost=0.00..13018407241416594.00 rows=457217316677364544 width=182)
-> Nested Loop (cost=0.00..12673432670.08 rows=388414701668 width=147)
-> Seq Scan on t_user_portal_access (cost=0.00..1980.72 rows=78172 width=90)
-> Seq Scan on t_source_information_portal (cost=0.00..112435.19 rows=4968719 width=57)
-> Seq Scan on t_user_portal_menu (cost=0.00..21745.37 rows=1177137 width=35)
-> Seq Scan on t_user (cost=0.00..1430.53 rows=78153 width=74)
-> Materialize (cost=39.71..59.45 rows=1974 width=42)
-> Seq Scan on t_user_property (cost=0.00..37.74 rows=1974 width=42) und dass ist das Ergebnis, wenn ich die Tabellen einzeln aufrufe:
Code:
Seq Scan on tab_1 (cost=0.00..112435.19 rows=4968719 width=57)
Seq Scan on tab_2 (cost=0.00..1430.53 rows=78153 width=74)
Seq Scan on tab_3 (cost=0.00..1980.72 rows=78172 width=90)
Seq Scan on tab_4 (cost=0.00..21745.37 rows=1177137 width=35)
Seq Scan on tab_5 (cost=0.00..37.74 rows=1974 width=42)
Lesezeichen