EXPLAIN SELECT (MIN(of_TD200_stoerung_zufuhr) <> MAX(of_TD200_stoerung_zufuhr)) OR (MIN(of_TD200_stoerung_brenner) <> MAX(of_TD200_stoerung_brenner)) AS error, MIN(of_TD200_stoerung_zufuhr) AS min_of_TD200_stoerung_zufuhr, MAX(of_TD200_stoerung_zufuhr) AS max_of_TD200_stoerung_zufuhr, MIN(of_TD200_stoerung_brenner) AS min_of_TD200_stoerung_brenner, MAX(of_TD200_stoerung_brenner) AS max_of_TD200_stoerung_brenner FROM log_entries WHERE datetime >= now() - INTERVAL '1 minutes' ; QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Aggregate (cost=1195689.70..1195689.71 rows=1 width=16) InitPlan -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Raumsolltemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Raumtemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Kesselsolltemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Kesseltemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Speichersolltemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Speichertemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Vorlaufsolltemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Vorlauftemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Aussentemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Brenner'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Heizkreispumpe'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Speicherladepumpe'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Mischer auf'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Mischer zu'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Heizkreis Status Bedien'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Speicher Status Bedien'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Heizkreis Status Kessel'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Speicher Status Kessel'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Programmschalterstellung Bedien'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Programmschalterstellung Kessel'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Vorlauftemperatur2'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Ökofen Kesseltemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Kesselendtemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Rauchgastemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Kesselminimumtemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Rverz'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Stopzeit'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Störung Zufuhr'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Störung Brenner'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Einschubdauer'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Einschubpause'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Luft'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Starts'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Laufzeit'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Neustarts'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Aktuelle Einschübe'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Einschübe gesamt'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'D_ES'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Zündzeit'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Nr'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Zündungen'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Reinigungsmotor Dauer'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Reinigungsmotor Uhrzeit'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Einschübe Zeit'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'LL'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Brandschutzklappe offen'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Brandschutzklappe geschlossen'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Keine Motorstoerung'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Alter Kessel'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Pufferladepumpe ohne Brenneranforderung'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Kein externer Heizungsregler'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Saugzugventilator Dauerlauf'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Leistung gross'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Materialfühler1'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Materialfühler2'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Leistungsschalter'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Lüftergebläse'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Motor Brenner'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Motor Zwischenschnecke'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Motor Raumentnahmeschnecke'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Brenner ein'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Zündung ein'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Störung'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Pufferladepumpe'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Saugzugventilator'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Reinigungsmotor'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F1 1. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F1 2. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Kesseltemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Kesselendtemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Rauchgastemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Kesselminimumtemperatur'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F2 1. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F2 2. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Rverz'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Stopzeit'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Störung Zufuhr'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Störung Brenner'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F3 1. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F3 2. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Einschubdauer'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Einschubpause'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Luft'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F4 1. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F4 2. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Starts'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Laufzeit'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Neustarts'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F5 1. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F5 2. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Aktuelle Einschübe'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Einschübe gesamt'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 D_ES'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F6 1. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F6 2. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Zündzeit'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Nr'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Zündungen'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F7 1. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F7 2. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Reinigungsmotor Dauer'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Reinigungsmotor Uhrzeit'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Einschübe Zeit'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 LL'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F8 1. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'Meldung F8 2. Zeile'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Pufferladepumpe'::text) -> Seq Scan on key_description (cost=0.00..2.36 rows=1 width=8) Filter: ((description)::text = 'TD200 Statustext'::text) -> Nested Loop Left Join (cost=0.00..1195433.19 rows=67 width=16) -> Nested Loop Left Join (cost=0.00..1192726.43 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1180097.00 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1177390.24 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1174683.48 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1171976.72 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1159347.30 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1146717.87 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1134088.45 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1121459.02 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1118752.26 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1106122.84 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1093493.41 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1090786.65 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1088079.89 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1075450.46 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1062821.04 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1050191.62 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1047484.85 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1034855.43 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1022226.00 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1009596.58 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1006889.82 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..1004183.06 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..991553.63 rows=67 width=24) -> Nested Loop Left Join (cost=0.00..978924.21 rows=67 width=16) -> Nested Loop Left Join (cost=0.00..976217.45 rows=67 width=16) -> Nested Loop Left Join (cost=0.00..973510.69 rows=67 width=16) -> Nested Loop Left Join (cost=0.00..960881.26 rows=67 width=16) -> Nested Loop Left Join (cost=0.00..948251.84 rows=67 width=16) -> Nested Loop Left Join (cost=0.00..935622.41 rows=67 width=16) -> Nested Loop Left Join (cost=0.00..932915.65 rows=67 width=16) -> Nested Loop Left Join (cost=0.00..920286.23 rows=67 width=16) -> Nested Loop Left Join (cost=0.00..907656.80 rows=67 width=16) -> Nested Loop Left Join (cost=0.00..904950.04 rows=67 width=16) -> Nested Loop Left Join (cost=0.00..902243.28 rows=67 width=16) -> Nested Loop Left Join (cost=0.00..889613.86 rows=67 width=16) -> Nested Loop Left Join (cost=0.00..876984.43 rows=67 width=16) -> Nested Loop Left Join (cost=0.00..864355.01 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..851725.58 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..839096.16 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..826466.73 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..823759.97 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..821053.21 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..808423.79 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..795794.36 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..783164.94 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..770535.51 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..757906.09 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..745276.66 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..732647.24 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..720017.81 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..707388.39 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..694758.96 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..682129.54 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..669500.12 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..656870.69 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..644241.27 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..631611.84 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..618982.42 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..606352.99 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..593723.57 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..581094.14 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..568464.72 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..555835.29 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..543205.87 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..530576.44 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..517947.02 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..505317.60 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..492688.17 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..480058.75 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..467429.32 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..454799.90 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..442170.47 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..429541.05 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..416911.62 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..404282.20 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..391652.77 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..379023.35 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..366393.92 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..353764.50 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..341135.08 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..328505.65 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..315876.23 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..303246.80 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..290617.38 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..277987.95 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..265358.53 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..252729.10 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..240099.68 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..227470.25 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..214840.83 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..202211.41 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..189581.98 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..176952.56 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..164323.13 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..151693.71 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..139064.28 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..126434.86 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..113805.43 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..101176.01 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..88546.58 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..75917.16 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..63287.73 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..50658.31 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..38028.89 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..25399.46 rows=67 width=8) -> Nested Loop Left Join (cost=0.00..12770.04 rows=67 width=8) -> Index Scan using i_log_unique on log l (cost=0.00..140.61 rows=67 width=8) Index Cond: (datetime >= (now() - '00:01:00'::interval)) -> Index Scan using unique_key_and_id on log_details d7 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d7.fk_id) AND (d7.fk_keyid = $6)) -> Index Scan using unique_key_and_id on log_details d6 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d6.fk_id) AND (d6.fk_keyid = $5)) -> Index Scan using unique_key_and_id on log_details d5 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d5.fk_id) AND (d5.fk_keyid = $4)) -> Index Scan using unique_key_and_id on log_details d4 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d4.fk_id) AND (d4.fk_keyid = $3)) -> Index Scan using unique_key_and_id on log_details d3 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d3.fk_id) AND (d3.fk_keyid = $2)) -> Index Scan using unique_key_and_id on log_details d2 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2.fk_id) AND (d2.fk_keyid = $1)) -> Index Scan using unique_key_and_id on log_details d1 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d1.fk_id) AND (d1.fk_keyid = $0)) -> Index Scan using unique_key_and_id on log_details d14 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d14.fk_id) AND (d14.fk_keyid = $13)) -> Index Scan using unique_key_and_id on log_details d13 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d13.fk_id) AND (d13.fk_keyid = $12)) -> Index Scan using unique_key_and_id on log_details d12 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d12.fk_id) AND (d12.fk_keyid = $11)) -> Index Scan using unique_key_and_id on log_details d11 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d11.fk_id) AND (d11.fk_keyid = $10)) -> Index Scan using unique_key_and_id on log_details d10 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d10.fk_id) AND (d10.fk_keyid = $9)) -> Index Scan using unique_key_and_id on log_details d9 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d9.fk_id) AND (d9.fk_keyid = $8)) -> Index Scan using unique_key_and_id on log_details d8 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d8.fk_id) AND (d8.fk_keyid = $7)) -> Index Scan using unique_key_and_id on log_details d1100001 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d1100001.fk_id) AND (d1100001.fk_keyid = $20)) -> Index Scan using unique_key_and_id on log_details d20 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d20.fk_id) AND (d20.fk_keyid = $19)) -> Index Scan using unique_key_and_id on log_details d19 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d19.fk_id) AND (d19.fk_keyid = $18)) -> Index Scan using unique_key_and_id on log_details d18 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d18.fk_id) AND (d18.fk_keyid = $17)) -> Index Scan using unique_key_and_id on log_details d17 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d17.fk_id) AND (d17.fk_keyid = $16)) -> Index Scan using unique_key_and_id on log_details d16 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d16.fk_id) AND (d16.fk_keyid = $15)) -> Index Scan using unique_key_and_id on log_details d15 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d15.fk_id) AND (d15.fk_keyid = $14)) -> Index Scan using unique_key_and_id on log_details d2000007 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000007.fk_id) AND (d2000007.fk_keyid = $27)) -> Index Scan using unique_key_and_id on log_details d2000006 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000006.fk_id) AND (d2000006.fk_keyid = $26)) -> Index Scan using unique_key_and_id on log_details d2000005 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000005.fk_id) AND (d2000005.fk_keyid = $25)) -> Index Scan using unique_key_and_id on log_details d2000004 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000004.fk_id) AND (d2000004.fk_keyid = $24)) -> Index Scan using unique_key_and_id on log_details d2000003 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000003.fk_id) AND (d2000003.fk_keyid = $23)) -> Index Scan using unique_key_and_id on log_details d2000002 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000002.fk_id) AND (d2000002.fk_keyid = $22)) -> Index Scan using unique_key_and_id on log_details d2000001 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000001.fk_id) AND (d2000001.fk_keyid = $21)) -> Index Scan using unique_key_and_id on log_details d2000014 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000014.fk_id) AND (d2000014.fk_keyid = $34)) -> Index Scan using unique_key_and_id on log_details d2000013 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000013.fk_id) AND (d2000013.fk_keyid = $33)) -> Index Scan using unique_key_and_id on log_details d2000012 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000012.fk_id) AND (d2000012.fk_keyid = $32)) -> Index Scan using unique_key_and_id on log_details d2000011 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000011.fk_id) AND (d2000011.fk_keyid = $31)) -> Index Scan using unique_key_and_id on log_details d2000010 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000010.fk_id) AND (d2000010.fk_keyid = $30)) -> Index Scan using unique_key_and_id on log_details d2000009 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000009.fk_id) AND (d2000009.fk_keyid = $29)) -> Index Scan using unique_key_and_id on log_details d2000008 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000008.fk_id) AND (d2000008.fk_keyid = $28)) -> Index Scan using unique_key_and_id on log_details d2000021 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000021.fk_id) AND (d2000021.fk_keyid = $41)) -> Index Scan using unique_key_and_id on log_details d2000020 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000020.fk_id) AND (d2000020.fk_keyid = $40)) -> Index Scan using unique_key_and_id on log_details d2000019 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000019.fk_id) AND (d2000019.fk_keyid = $39)) -> Index Scan using unique_key_and_id on log_details d2000018 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000018.fk_id) AND (d2000018.fk_keyid = $38)) -> Index Scan using unique_key_and_id on log_details d2000017 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000017.fk_id) AND (d2000017.fk_keyid = $37)) -> Index Scan using unique_key_and_id on log_details d2000016 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000016.fk_id) AND (d2000016.fk_keyid = $36)) -> Index Scan using unique_key_and_id on log_details d2000015 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000015.fk_id) AND (d2000015.fk_keyid = $35)) -> Index Scan using unique_key_and_id on log_details d2000104 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000104.fk_id) AND (d2000104.fk_keyid = $48)) -> Index Scan using unique_key_and_id on log_details d2000103 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000103.fk_id) AND (d2000103.fk_keyid = $47)) -> Index Scan using unique_key_and_id on log_details d2000102 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000102.fk_id) AND (d2000102.fk_keyid = $46)) -> Index Scan using unique_key_and_id on log_details d2000101 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000101.fk_id) AND (d2000101.fk_keyid = $45)) -> Index Scan using unique_key_and_id on log_details d2000024 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000024.fk_id) AND (d2000024.fk_keyid = $44)) -> Index Scan using unique_key_and_id on log_details d2000023 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000023.fk_id) AND (d2000023.fk_keyid = $43)) -> Index Scan using unique_key_and_id on log_details d2000022 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000022.fk_id) AND (d2000022.fk_keyid = $42)) -> Index Scan using unique_key_and_id on log_details d2000111 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000111.fk_id) AND (d2000111.fk_keyid = $55)) -> Index Scan using unique_key_and_id on log_details d2000110 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000110.fk_id) AND (d2000110.fk_keyid = $54)) -> Index Scan using unique_key_and_id on log_details d2000109 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000109.fk_id) AND (d2000109.fk_keyid = $53)) -> Index Scan using unique_key_and_id on log_details d2000108 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000108.fk_id) AND (d2000108.fk_keyid = $52)) -> Index Scan using unique_key_and_id on log_details d2000107 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000107.fk_id) AND (d2000107.fk_keyid = $51)) -> Index Scan using unique_key_and_id on log_details d2000106 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000106.fk_id) AND (d2000106.fk_keyid = $50)) -> Index Scan using unique_key_and_id on log_details d2000105 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000105.fk_id) AND (d2000105.fk_keyid = $49)) -> Index Scan using unique_key_and_id on log_details d2000118 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000118.fk_id) AND (d2000118.fk_keyid = $62)) -> Index Scan using unique_key_and_id on log_details d2000117 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000117.fk_id) AND (d2000117.fk_keyid = $61)) -> Index Scan using unique_key_and_id on log_details d2000116 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000116.fk_id) AND (d2000116.fk_keyid = $60)) -> Index Scan using unique_key_and_id on log_details d2000115 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000115.fk_id) AND (d2000115.fk_keyid = $59)) -> Index Scan using unique_key_and_id on log_details d2000114 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000114.fk_id) AND (d2000114.fk_keyid = $58)) -> Index Scan using unique_key_and_id on log_details d2000113 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000113.fk_id) AND (d2000113.fk_keyid = $57)) -> Index Scan using unique_key_and_id on log_details d2000112 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000112.fk_id) AND (d2000112.fk_keyid = $56)) -> Index Scan using unique_key_and_id on log_details d2000204 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000204.fk_id) AND (d2000204.fk_keyid = $69)) -> Index Scan using unique_key_and_id on log_details d2000203 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000203.fk_id) AND (d2000203.fk_keyid = $68)) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000202 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000202.fk_id) Filter: (d2000202.fk_keyid = $67) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000201 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000201.fk_id) Filter: (d2000201.fk_keyid = $66) -> Index Scan using unique_key_and_id on log_details d2000121 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000121.fk_id) AND (d2000121.fk_keyid = $65)) -> Index Scan using unique_key_and_id on log_details d2000120 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000120.fk_id) AND (d2000120.fk_keyid = $64)) -> Index Scan using unique_key_and_id on log_details d2000119 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000119.fk_id) AND (d2000119.fk_keyid = $63)) -> Index Scan using unique_key_and_id on log_details d2000305 (cost=0.00..187.39 rows=89 width=16) Index Cond: ((l.id = d2000305.fk_id) AND (d2000305.fk_keyid = $76)) -> Index Scan using unique_key_and_id on log_details d2000304 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000304.fk_id) AND (d2000304.fk_keyid = $75)) -> Index Scan using unique_key_and_id on log_details d2000303 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000303.fk_id) AND (d2000303.fk_keyid = $74)) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000302 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000302.fk_id) Filter: (d2000302.fk_keyid = $73) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000301 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000301.fk_id) Filter: (d2000301.fk_keyid = $72) -> Index Scan using unique_key_and_id on log_details d2000206 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000206.fk_id) AND (d2000206.fk_keyid = $71)) -> Index Scan using unique_key_and_id on log_details d2000205 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000205.fk_id) AND (d2000205.fk_keyid = $70)) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000501 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000501.fk_id) Filter: (d2000501.fk_keyid = $83) -> Index Scan using unique_key_and_id on log_details d2000405 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000405.fk_id) AND (d2000405.fk_keyid = $82)) -> Index Scan using unique_key_and_id on log_details d2000404 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000404.fk_id) AND (d2000404.fk_keyid = $81)) -> Index Scan using unique_key_and_id on log_details d2000403 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000403.fk_id) AND (d2000403.fk_keyid = $80)) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000402 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000402.fk_id) Filter: (d2000402.fk_keyid = $79) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000401 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000401.fk_id) Filter: (d2000401.fk_keyid = $78) -> Index Scan using unique_key_and_id on log_details d2000306 (cost=0.00..187.39 rows=89 width=16) Index Cond: ((l.id = d2000306.fk_id) AND (d2000306.fk_keyid = $77)) -> Index Scan using unique_key_and_id on log_details d2000603 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000603.fk_id) AND (d2000603.fk_keyid = $90)) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000602 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000602.fk_id) Filter: (d2000602.fk_keyid = $89) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000601 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000601.fk_id) Filter: (d2000601.fk_keyid = $88) -> Index Scan using unique_key_and_id on log_details d2000505 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000505.fk_id) AND (d2000505.fk_keyid = $87)) -> Index Scan using unique_key_and_id on log_details d2000504 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000504.fk_id) AND (d2000504.fk_keyid = $86)) -> Index Scan using unique_key_and_id on log_details d2000503 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000503.fk_id) AND (d2000503.fk_keyid = $85)) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000502 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000502.fk_id) Filter: (d2000502.fk_keyid = $84) -> Index Scan using unique_key_and_id on log_details d2000705 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000705.fk_id) AND (d2000705.fk_keyid = $97)) -> Index Scan using unique_key_and_id on log_details d2000704 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000704.fk_id) AND (d2000704.fk_keyid = $96)) -> Index Scan using unique_key_and_id on log_details d2000703 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000703.fk_id) AND (d2000703.fk_keyid = $95)) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000702 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000702.fk_id) Filter: (d2000702.fk_keyid = $94) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000701 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000701.fk_id) Filter: (d2000701.fk_keyid = $93) -> Index Scan using unique_key_and_id on log_details d2000605 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000605.fk_id) AND (d2000605.fk_keyid = $92)) -> Index Scan using unique_key_and_id on log_details d2000604 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000604.fk_id) AND (d2000604.fk_keyid = $91)) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000901 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000901.fk_id) Filter: (d2000901.fk_keyid = $104) -> Index Scan using unique_key_and_id on log_details d2000806 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000806.fk_id) AND (d2000806.fk_keyid = $103)) -> Index Scan using unique_key_and_id on log_details d2000805 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000805.fk_id) AND (d2000805.fk_keyid = $102)) -> Index Scan using unique_key_and_id on log_details d2000804 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000804.fk_id) AND (d2000804.fk_keyid = $101)) -> Index Scan using unique_key_and_id on log_details d2000803 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000803.fk_id) AND (d2000803.fk_keyid = $100)) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000802 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000802.fk_id) Filter: (d2000802.fk_keyid = $99) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000801 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000801.fk_id) Filter: (d2000801.fk_keyid = $98) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000904 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000904.fk_id) Filter: (d2000904.fk_keyid = $107) -> Index Scan using unique_key_and_id on log_details d2000903 (cost=0.00..187.39 rows=89 width=8) Index Cond: ((l.id = d2000903.fk_id) AND (d2000903.fk_keyid = $106)) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000902 (cost=0.00..40.01 rows=31 width=8) Index Cond: (l.id = d2000902.fk_id) Filter: (d2000902.fk_keyid = $105) (561 rows)