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' ; CREATE OR REPLACE VIEW log_entries AS SELECT l.id AS id, l.datetime AS datetime, l.tdate AS tdate, l.ttime AS ttime, d1.value AS Raumsolltemperatur, d2.value AS Raumtemperatur, d3.value AS Kesselsolltemperatur, d4.value AS Kesseltemperatur, d5.value AS Speichersolltemperatur, d6.value AS Speichertemperatur, d7.value AS Vorlaufsolltemperatur, d8.value AS Vorlauftemperatur, d9.value AS Aussentemperatur, d10.value AS Brenner, d11.value AS Heizkreispumpe, d12.value AS Speicherladepumpe, d13.value AS Mischer_auf, d14.value AS Mischer_zu, d15.value AS Heizkreis_Status_Bedien, d16.value AS Speicher_Status_Bedien, d17.value AS Heizkreis_Status_Kessel, d18.value AS Speicher_Status_Kessel, d19.value AS Programmschalterstellung_Bedien, d20.value AS Programmschalterstellung_Kessel, d1100001.value AS Vorlauftemperatur2, d2000001.value AS of_Kesseltemperatur, d2000002.value AS of_Kesselendtemperatur, d2000003.value AS of_Rauchgastemperatur, d2000004.value AS of_Kesselminimumtemperatur, d2000005.value AS of_Rverz, d2000006.value AS of_Stopzeit, d2000007.value AS of_Stoerung_Zufuhr, d2000008.value AS of_Stoerung_Brenner, d2000009.value AS of_Einschubdauer, d2000010.value AS of_Einschubpause, d2000011.value AS of_Luft, d2000012.value AS of_Starts, d2000013.value AS of_Laufzeit, d2000014.value AS of_Neustarts, d2000015.value AS of_Aktuelle_Einschuebe, d2000016.value AS of_Einschuebe_Gesamt, d2000017.value AS of_D_ES, d2000018.value AS of_Zuendzeit, d2000019.value AS of_Nr, d2000020.value AS of_Zuendungen, d2000021.value AS of_Reinigungsmotor_Dauer, d2000022.value AS of_Reinigungsmotor_Uhrzeit, d2000023.value AS of_Einschuebe_Zeit, d2000024.value AS of_LL, d2000101.value AS of_Brandschutzklappe_offen, d2000102.value AS of_Brandschutzklappe_geschlossen, d2000103.value AS of_Keine_Motorstoerung, d2000104.value AS of_Alter_Kessel, d2000105.value AS of_Pumpe_UW_ohne_Brenneranforderung, d2000106.value AS of_Kein_externer_Heizungsregler, d2000107.value AS of_Saugzugventilator_Dauerlauf, d2000108.value AS of_Leistung_gross, d2000109.value AS of_Materialfuehler1, d2000110.value AS of_Materialfuehler2, d2000111.value AS of_Leistungsschalter, d2000112.value AS of_Lueftergeblaese, d2000113.value AS of_Motor_Brenner, d2000114.value AS of_Motor_Zwischenschnecke, d2000115.value AS of_Motor_Raumentnahmeschnecke, d2000116.value AS of_Brenner_ein, d2000117.value AS of_Zuendung_ein, d2000118.value AS of_Stoerung, d2000119.value AS of_Pufferladepumpe, d2000120.value AS of_Saugzugventilator, d2000121.value AS of_Reinigungsmotor, d2000201.value AS of_s_message1_1, d2000202.value AS of_s_message1_2, d2000203.value AS of_TD200_Kesseltemperatur, d2000204.value AS of_TD200_Kesselendtemperatur, d2000205.value AS of_TD200_Rauchgastemperatur, d2000206.value AS of_TD200_Kesselminimumtemperatur, d2000301.value AS of_s_message2_1, d2000302.value AS of_s_message2_2, d2000303.value AS of_TD200_Rverz, d2000304.value AS of_TD200_Stopzeit, d2000305.value AS of_TD200_Stoerung_Zufuhr, d2000306.value AS of_TD200_Stoerung_Brenner, d2000401.value AS of_s_message3_1, d2000402.value AS of_s_message3_2, d2000403.value AS of_TD200_Einschubdauer, d2000404.value AS of_TD200_Einschubpause, d2000405.value AS of_TD200_Luft, d2000501.value AS of_s_message4_1, d2000502.value AS of_s_message4_2, d2000503.value AS of_TD200_Starts, d2000504.value AS of_TD200_Laufzeit, d2000505.value AS of_TD200_Neustarts, d2000601.value AS of_s_message5_1, d2000602.value AS of_s_message5_2, d2000603.value AS of_TD200_Aktuelle_Einschuebe, d2000604.value AS of_TD200_Einschuebe_Gesamt, d2000605.value AS of_TD200_D_ES, d2000701.value AS of_s_message6_1, d2000702.value AS of_s_message6_2, d2000703.value AS of_TD200_Zuendzeit, d2000704.value AS of_TD200_Nr, d2000705.value AS of_TD200_Zuendungen, d2000801.value AS of_s_message7_1, d2000802.value AS of_s_message7_2, d2000803.value AS of_TD200_Reinigungsmotor_Dauer, d2000804.value AS of_TD200_Reinigungsmotor_Uhrzeit, d2000805.value AS of_TD200_Einschuebe_Zeit, d2000806.value AS of_TD200_LL, d2000901.value AS of_s_message8_1, d2000902.value AS of_s_message8_2, d2000903.value AS of_TD200_Pufferladepumpe, d2000904.value AS of_s_TD200_Statustext FROM log l LEFT JOIN log_details d1 ON l.id = d1.fk_id AND d1.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Raumsolltemperatur') LEFT JOIN log_details d2 ON l.id = d2.fk_id AND d2.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Raumtemperatur') LEFT JOIN log_details d3 ON l.id = d3.fk_id AND d3.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Kesselsolltemperatur') LEFT JOIN log_details d4 ON l.id = d4.fk_id AND d4.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Kesseltemperatur') LEFT JOIN log_details d5 ON l.id = d5.fk_id AND d5.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Speichersolltemperatur') LEFT JOIN log_details d6 ON l.id = d6.fk_id AND d6.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Speichertemperatur') LEFT JOIN log_details d7 ON l.id = d7.fk_id AND d7.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Vorlaufsolltemperatur') LEFT JOIN log_details d8 ON l.id = d8.fk_id AND d8.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Vorlauftemperatur') LEFT JOIN log_details d9 ON l.id = d9.fk_id AND d9.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Aussentemperatur') LEFT JOIN log_details d10 ON l.id = d10.fk_id AND d10.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Brenner') LEFT JOIN log_details d11 ON l.id = d11.fk_id AND d11.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Heizkreispumpe') LEFT JOIN log_details d12 ON l.id = d12.fk_id AND d12.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Speicherladepumpe') LEFT JOIN log_details d13 ON l.id = d13.fk_id AND d13.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Mischer auf') LEFT JOIN log_details d14 ON l.id = d14.fk_id AND d14.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Mischer zu') LEFT JOIN log_details d15 ON l.id = d15.fk_id AND d15.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Heizkreis Status Bedien') LEFT JOIN log_details d16 ON l.id = d16.fk_id AND d16.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Speicher Status Bedien') LEFT JOIN log_details d17 ON l.id = d17.fk_id AND d17.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Heizkreis Status Kessel') LEFT JOIN log_details d18 ON l.id = d18.fk_id AND d18.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Speicher Status Kessel') LEFT JOIN log_details d19 ON l.id = d19.fk_id AND d19.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Programmschalterstellung Bedien') LEFT JOIN log_details d20 ON l.id = d20.fk_id AND d20.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Programmschalterstellung Kessel') LEFT JOIN log_details d1100001 ON l.id = d1100001.fk_id AND d1100001.fk_keyid = (SELECT keyid FROM key_description WHERE description = 'Vorlauftemperatur2') LEFT JOIN log_details d2000001 ON l.id = d2000001.fk_id AND d2000001.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Ökofen Kesseltemperatur') LEFT JOIN log_details d2000002 ON l.id = d2000002.fk_id AND d2000002.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Kesselendtemperatur') LEFT JOIN log_details d2000003 ON l.id = d2000003.fk_id AND d2000003.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Rauchgastemperatur') LEFT JOIN log_details d2000004 ON l.id = d2000004.fk_id AND d2000004.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Kesselminimumtemperatur') LEFT JOIN log_details d2000005 ON l.id = d2000005.fk_id AND d2000005.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Rverz') LEFT JOIN log_details d2000006 ON l.id = d2000006.fk_id AND d2000006.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Stopzeit') LEFT JOIN log_details d2000007 ON l.id = d2000007.fk_id AND d2000007.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Störung Zufuhr') LEFT JOIN log_details d2000008 ON l.id = d2000008.fk_id AND d2000008.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Störung Brenner') LEFT JOIN log_details d2000009 ON l.id = d2000009.fk_id AND d2000009.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Einschubdauer') LEFT JOIN log_details d2000010 ON l.id = d2000010.fk_id AND d2000010.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Einschubpause') LEFT JOIN log_details d2000011 ON l.id = d2000011.fk_id AND d2000011.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Luft') LEFT JOIN log_details d2000012 ON l.id = d2000012.fk_id AND d2000012.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Starts') LEFT JOIN log_details d2000013 ON l.id = d2000013.fk_id AND d2000013.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Laufzeit') LEFT JOIN log_details d2000014 ON l.id = d2000014.fk_id AND d2000014.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Neustarts') LEFT JOIN log_details d2000015 ON l.id = d2000015.fk_id AND d2000015.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Aktuelle Einschübe') LEFT JOIN log_details d2000016 ON l.id = d2000016.fk_id AND d2000016.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Einschübe gesamt') LEFT JOIN log_details d2000017 ON l.id = d2000017.fk_id AND d2000017.fk_keyid = (SELECT keyid FROM key_description WHERE description ='D_ES') LEFT JOIN log_details d2000018 ON l.id = d2000018.fk_id AND d2000018.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Zündzeit') LEFT JOIN log_details d2000019 ON l.id = d2000019.fk_id AND d2000019.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Nr') LEFT JOIN log_details d2000020 ON l.id = d2000020.fk_id AND d2000020.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Zündungen') LEFT JOIN log_details d2000021 ON l.id = d2000021.fk_id AND d2000021.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Reinigungsmotor Dauer') LEFT JOIN log_details d2000022 ON l.id = d2000022.fk_id AND d2000022.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Reinigungsmotor Uhrzeit') LEFT JOIN log_details d2000023 ON l.id = d2000023.fk_id AND d2000023.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Einschübe Zeit') LEFT JOIN log_details d2000024 ON l.id = d2000024.fk_id AND d2000024.fk_keyid = (SELECT keyid FROM key_description WHERE description ='LL') LEFT JOIN log_details d2000101 ON l.id = d2000101.fk_id AND d2000101.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Brandschutzklappe offen') LEFT JOIN log_details d2000102 ON l.id = d2000102.fk_id AND d2000102.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Brandschutzklappe geschlossen') LEFT JOIN log_details d2000103 ON l.id = d2000103.fk_id AND d2000103.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Keine Motorstoerung') LEFT JOIN log_details d2000104 ON l.id = d2000104.fk_id AND d2000104.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Alter Kessel') LEFT JOIN log_details d2000105 ON l.id = d2000105.fk_id AND d2000105.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Pufferladepumpe ohne Brenneranforderung') LEFT JOIN log_details d2000106 ON l.id = d2000106.fk_id AND d2000106.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Kein externer Heizungsregler') LEFT JOIN log_details d2000107 ON l.id = d2000107.fk_id AND d2000107.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Saugzugventilator Dauerlauf') LEFT JOIN log_details d2000108 ON l.id = d2000108.fk_id AND d2000108.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Leistung gross') LEFT JOIN log_details d2000109 ON l.id = d2000109.fk_id AND d2000109.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Materialfühler1') LEFT JOIN log_details d2000110 ON l.id = d2000110.fk_id AND d2000110.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Materialfühler2') LEFT JOIN log_details d2000111 ON l.id = d2000111.fk_id AND d2000111.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Leistungsschalter') LEFT JOIN log_details d2000112 ON l.id = d2000112.fk_id AND d2000112.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Lüftergebläse') LEFT JOIN log_details d2000113 ON l.id = d2000113.fk_id AND d2000113.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Motor Brenner') LEFT JOIN log_details d2000114 ON l.id = d2000114.fk_id AND d2000114.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Motor Zwischenschnecke') LEFT JOIN log_details d2000115 ON l.id = d2000115.fk_id AND d2000115.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Motor Raumentnahmeschnecke') LEFT JOIN log_details d2000116 ON l.id = d2000116.fk_id AND d2000116.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Brenner ein') LEFT JOIN log_details d2000117 ON l.id = d2000117.fk_id AND d2000117.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Zündung ein') LEFT JOIN log_details d2000118 ON l.id = d2000118.fk_id AND d2000118.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Störung') LEFT JOIN log_details d2000119 ON l.id = d2000119.fk_id AND d2000119.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Pufferladepumpe') LEFT JOIN log_details d2000120 ON l.id = d2000120.fk_id AND d2000120.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Saugzugventilator') LEFT JOIN log_details d2000121 ON l.id = d2000121.fk_id AND d2000121.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Reinigungsmotor') LEFT JOIN log_details_str d2000201 ON l.id = d2000201.fk_id AND d2000201.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F1 1. Zeile') LEFT JOIN log_details_str d2000202 ON l.id = d2000202.fk_id AND d2000202.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F1 2. Zeile') LEFT JOIN log_details d2000203 ON l.id = d2000203.fk_id AND d2000203.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Kesseltemperatur') LEFT JOIN log_details d2000204 ON l.id = d2000204.fk_id AND d2000204.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Kesselendtemperatur') LEFT JOIN log_details d2000205 ON l.id = d2000205.fk_id AND d2000205.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Rauchgastemperatur') LEFT JOIN log_details d2000206 ON l.id = d2000206.fk_id AND d2000206.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Kesselminimumtemperatur') LEFT JOIN log_details_str d2000301 ON l.id = d2000301.fk_id AND d2000301.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F2 1. Zeile') LEFT JOIN log_details_str d2000302 ON l.id = d2000302.fk_id AND d2000302.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F2 2. Zeile') LEFT JOIN log_details d2000303 ON l.id = d2000303.fk_id AND d2000303.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Rverz') LEFT JOIN log_details d2000304 ON l.id = d2000304.fk_id AND d2000304.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Stopzeit') LEFT JOIN log_details d2000305 ON l.id = d2000305.fk_id AND d2000305.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Störung Zufuhr') LEFT JOIN log_details d2000306 ON l.id = d2000306.fk_id AND d2000306.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Störung Brenner') LEFT JOIN log_details_str d2000401 ON l.id = d2000401.fk_id AND d2000401.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F3 1. Zeile') LEFT JOIN log_details_str d2000402 ON l.id = d2000402.fk_id AND d2000402.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F3 2. Zeile') LEFT JOIN log_details d2000403 ON l.id = d2000403.fk_id AND d2000403.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Einschubdauer') LEFT JOIN log_details d2000404 ON l.id = d2000404.fk_id AND d2000404.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Einschubpause') LEFT JOIN log_details d2000405 ON l.id = d2000405.fk_id AND d2000405.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Luft') LEFT JOIN log_details_str d2000501 ON l.id = d2000501.fk_id AND d2000501.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F4 1. Zeile') LEFT JOIN log_details_str d2000502 ON l.id = d2000502.fk_id AND d2000502.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F4 2. Zeile') LEFT JOIN log_details d2000503 ON l.id = d2000503.fk_id AND d2000503.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Starts') LEFT JOIN log_details d2000504 ON l.id = d2000504.fk_id AND d2000504.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Laufzeit') LEFT JOIN log_details d2000505 ON l.id = d2000505.fk_id AND d2000505.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Neustarts') LEFT JOIN log_details_str d2000601 ON l.id = d2000601.fk_id AND d2000601.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F5 1. Zeile') LEFT JOIN log_details_str d2000602 ON l.id = d2000602.fk_id AND d2000602.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F5 2. Zeile') LEFT JOIN log_details d2000603 ON l.id = d2000603.fk_id AND d2000603.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Aktuelle Einschübe') LEFT JOIN log_details d2000604 ON l.id = d2000604.fk_id AND d2000604.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Einschübe gesamt') LEFT JOIN log_details d2000605 ON l.id = d2000605.fk_id AND d2000605.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 D_ES') LEFT JOIN log_details_str d2000701 ON l.id = d2000701.fk_id AND d2000701.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F6 1. Zeile') LEFT JOIN log_details_str d2000702 ON l.id = d2000702.fk_id AND d2000702.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F6 2. Zeile') LEFT JOIN log_details d2000703 ON l.id = d2000703.fk_id AND d2000703.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Zündzeit') LEFT JOIN log_details d2000704 ON l.id = d2000704.fk_id AND d2000704.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Nr') LEFT JOIN log_details d2000705 ON l.id = d2000705.fk_id AND d2000705.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Zündungen') LEFT JOIN log_details_str d2000801 ON l.id = d2000801.fk_id AND d2000801.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F7 1. Zeile') LEFT JOIN log_details_str d2000802 ON l.id = d2000802.fk_id AND d2000802.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F7 2. Zeile') LEFT JOIN log_details d2000803 ON l.id = d2000803.fk_id AND d2000803.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Reinigungsmotor Dauer') LEFT JOIN log_details d2000804 ON l.id = d2000804.fk_id AND d2000804.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Reinigungsmotor Uhrzeit') LEFT JOIN log_details d2000805 ON l.id = d2000805.fk_id AND d2000805.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Einschübe Zeit') LEFT JOIN log_details d2000806 ON l.id = d2000806.fk_id AND d2000806.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 LL') LEFT JOIN log_details_str d2000901 ON l.id = d2000901.fk_id AND d2000901.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F8 1. Zeile') LEFT JOIN log_details_str d2000902 ON l.id = d2000902.fk_id AND d2000902.fk_keyid = (SELECT keyid FROM key_description WHERE description ='Meldung F8 2. Zeile') LEFT JOIN log_details d2000903 ON l.id = d2000903.fk_id AND d2000903.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Pufferladepumpe') LEFT JOIN log_details_str d2000904 ON l.id = d2000904.fk_id AND d2000904.fk_keyid = (SELECT keyid FROM key_description WHERE description ='TD200 Statustext') -- Don't sort by default, unnecessary costs --ORDER BY -- datetime DESC ; QUERY PLAN Aggregate (cost=9038477447193979426845123069992130708193285768233805672136944491354321018479634119472560532881408.00..9038477447193979426845123069992130708193285768233805672136944491354321018479634119472560532881408.00 rows=1 width=16) InitPlan 1 (returns $0) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Raumsolltemperatur'::text) InitPlan 2 (returns $1) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Raumtemperatur'::text) InitPlan 3 (returns $2) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Kesselsolltemperatur'::text) InitPlan 4 (returns $3) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Kesseltemperatur'::text) InitPlan 5 (returns $4) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Speichersolltemperatur'::text) InitPlan 6 (returns $5) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Speichertemperatur'::text) InitPlan 7 (returns $6) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Vorlaufsolltemperatur'::text) InitPlan 8 (returns $7) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Vorlauftemperatur'::text) InitPlan 9 (returns $8) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Aussentemperatur'::text) InitPlan 10 (returns $9) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Brenner'::text) InitPlan 11 (returns $10) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Heizkreispumpe'::text) InitPlan 12 (returns $11) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Speicherladepumpe'::text) InitPlan 13 (returns $12) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Mischer auf'::text) InitPlan 14 (returns $13) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Mischer zu'::text) InitPlan 15 (returns $14) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Heizkreis Status Bedien'::text) InitPlan 16 (returns $15) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Speicher Status Bedien'::text) InitPlan 17 (returns $16) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Heizkreis Status Kessel'::text) InitPlan 18 (returns $17) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Speicher Status Kessel'::text) InitPlan 19 (returns $18) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Programmschalterstellung Bedien'::text) InitPlan 20 (returns $19) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Programmschalterstellung Kessel'::text) InitPlan 21 (returns $20) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Vorlauftemperatur2'::text) InitPlan 22 (returns $21) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Ökofen Kesseltemperatur'::text) InitPlan 23 (returns $22) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Kesselendtemperatur'::text) InitPlan 24 (returns $23) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Rauchgastemperatur'::text) InitPlan 25 (returns $24) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Kesselminimumtemperatur'::text) InitPlan 26 (returns $25) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Rverz'::text) InitPlan 27 (returns $26) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Stopzeit'::text) InitPlan 28 (returns $27) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Störung Zufuhr'::text) InitPlan 29 (returns $28) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Störung Brenner'::text) InitPlan 30 (returns $29) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Einschubdauer'::text) InitPlan 31 (returns $30) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Einschubpause'::text) InitPlan 32 (returns $31) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Luft'::text) InitPlan 33 (returns $32) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Starts'::text) InitPlan 34 (returns $33) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Laufzeit'::text) InitPlan 35 (returns $34) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Neustarts'::text) InitPlan 36 (returns $35) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Aktuelle Einschübe'::text) InitPlan 37 (returns $36) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Einschübe gesamt'::text) InitPlan 38 (returns $37) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'D_ES'::text) InitPlan 39 (returns $38) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Zündzeit'::text) InitPlan 40 (returns $39) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Nr'::text) InitPlan 41 (returns $40) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Zündungen'::text) InitPlan 42 (returns $41) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Reinigungsmotor Dauer'::text) InitPlan 43 (returns $42) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Reinigungsmotor Uhrzeit'::text) InitPlan 44 (returns $43) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Einschübe Zeit'::text) InitPlan 45 (returns $44) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'LL'::text) InitPlan 46 (returns $45) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Brandschutzklappe offen'::text) InitPlan 47 (returns $46) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Brandschutzklappe geschlossen'::text) InitPlan 48 (returns $47) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Keine Motorstoerung'::text) InitPlan 49 (returns $48) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Alter Kessel'::text) InitPlan 50 (returns $49) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Pufferladepumpe ohne Brenneranforderung'::text) InitPlan 51 (returns $50) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Kein externer Heizungsregler'::text) InitPlan 52 (returns $51) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Saugzugventilator Dauerlauf'::text) InitPlan 53 (returns $52) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Leistung gross'::text) InitPlan 54 (returns $53) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Materialfühler1'::text) InitPlan 55 (returns $54) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Materialfühler2'::text) InitPlan 56 (returns $55) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Leistungsschalter'::text) InitPlan 57 (returns $56) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Lüftergebläse'::text) InitPlan 58 (returns $57) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Motor Brenner'::text) InitPlan 59 (returns $58) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Motor Zwischenschnecke'::text) InitPlan 60 (returns $59) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Motor Raumentnahmeschnecke'::text) InitPlan 61 (returns $60) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Brenner ein'::text) InitPlan 62 (returns $61) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Zündung ein'::text) InitPlan 63 (returns $62) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Störung'::text) InitPlan 64 (returns $63) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Pufferladepumpe'::text) InitPlan 65 (returns $64) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Saugzugventilator'::text) InitPlan 66 (returns $65) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Reinigungsmotor'::text) InitPlan 67 (returns $66) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F1 1. Zeile'::text) InitPlan 68 (returns $67) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F1 2. Zeile'::text) InitPlan 69 (returns $68) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Kesseltemperatur'::text) InitPlan 70 (returns $69) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Kesselendtemperatur'::text) InitPlan 71 (returns $70) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Rauchgastemperatur'::text) InitPlan 72 (returns $71) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Kesselminimumtemperatur'::text) InitPlan 73 (returns $72) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F2 1. Zeile'::text) InitPlan 74 (returns $73) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F2 2. Zeile'::text) InitPlan 75 (returns $74) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Rverz'::text) InitPlan 76 (returns $75) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Stopzeit'::text) InitPlan 77 (returns $76) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Störung Zufuhr'::text) InitPlan 78 (returns $77) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Störung Brenner'::text) InitPlan 79 (returns $78) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F3 1. Zeile'::text) InitPlan 80 (returns $79) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F3 2. Zeile'::text) InitPlan 81 (returns $80) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Einschubdauer'::text) InitPlan 82 (returns $81) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Einschubpause'::text) InitPlan 83 (returns $82) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Luft'::text) InitPlan 84 (returns $83) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F4 1. Zeile'::text) InitPlan 85 (returns $84) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F4 2. Zeile'::text) InitPlan 86 (returns $85) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Starts'::text) InitPlan 87 (returns $86) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Laufzeit'::text) InitPlan 88 (returns $87) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Neustarts'::text) InitPlan 89 (returns $88) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F5 1. Zeile'::text) InitPlan 90 (returns $89) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F5 2. Zeile'::text) InitPlan 91 (returns $90) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Aktuelle Einschübe'::text) InitPlan 92 (returns $91) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Einschübe gesamt'::text) InitPlan 93 (returns $92) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 D_ES'::text) InitPlan 94 (returns $93) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F6 1. Zeile'::text) InitPlan 95 (returns $94) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F6 2. Zeile'::text) InitPlan 96 (returns $95) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Zündzeit'::text) InitPlan 97 (returns $96) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Nr'::text) InitPlan 98 (returns $97) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Zündungen'::text) InitPlan 99 (returns $98) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F7 1. Zeile'::text) InitPlan 100 (returns $99) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F7 2. Zeile'::text) InitPlan 101 (returns $100) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Reinigungsmotor Dauer'::text) InitPlan 102 (returns $101) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Reinigungsmotor Uhrzeit'::text) InitPlan 103 (returns $102) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Einschübe Zeit'::text) InitPlan 104 (returns $103) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 LL'::text) InitPlan 105 (returns $104) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F8 1. Zeile'::text) InitPlan 106 (returns $105) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'Meldung F8 2. Zeile'::text) InitPlan 107 (returns $106) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Pufferladepumpe'::text) InitPlan 108 (returns $107) -> Seq Scan on key_description (cost=0.00..2.38 rows=1 width=8) Filter: ((description)::text = 'TD200 Statustext'::text) -> Merge Left Join (cost=1750660.22..4273805884876845789194861338991916289697885665127154313046252183850255795798561612107149662486528.00 rows=238233578115856634454073334945297075430094545596765511255148896328828230572227215727052643001958400 width=16) Merge Cond: (l.id = d2000903.fk_id) -> Merge Left Join (cost=1282836.06..637845589790689204099013986629244044483496536672453156562321891233262957869439250425338254065664.00 rows=25046900565899505964304840583383485113150065587818636882595394564453291633481462052027269109514240 width=24) Merge Cond: (l.id = d2000902.fk_id) -> Merge Left Join (cost=1109242.19..239575925819629000216332243206536115801461654561597957013468044491624296542286005307777484849152.00 rows=9032057902454844931744713173381748682982580830610612009876224156225286910203289094564119264100352 width=24) Merge Cond: (l.id = d2000904.fk_id) -> Merge Left Join (cost=935648.32..95957570474085474725150329007117515082854818409979462693311542476113555843515876931204185849856.00 rows=3257012568827088467133152899277696450753885446374103034471201399472786044582551726911423485313024 width=24) Merge Cond: (l.id = d2000803.fk_id) -> Merge Left Join (cost=467824.16..46248505637336332559618874618851372379468415819212930116096078548816416598579737869816233459712.00 rows=342428932976124510078372564899558112595609983770571245607747561819453624643253520890273623703552 width=24) Merge Cond: (l.id = d2000804.fk_id) -> Merge Left Join (cost=0.00..41022298592817962013122639708219191602270426816897195818103055815478109580845497609781036187648.00 rows=36001572502802424630496716718665365819845638484403142025722547559472049741845443563863192633344 width=24) Merge Cond: (l.id = d2000801.fk_id) -> Merge Left Join (cost=0.00..18020412722288590958509378567988935522777517169676595793022688066776174924723439592615169753088.00 rows=12982376265247092127534798051196745718828210935329197978998475962079440562923091874598629670912 width=24) Merge Cond: (l.id = d2000802.fk_id) -> Merge Left Join (cost=0.00..9725799003450670672619375148372208786253829528232186449372686429314235036509092249061082267648.00 rows=4681520327461568814463036013793228967395460926867994970455536682915533805268937657845890940928 width=24) Merge Cond: (l.id = d2000901.fk_id) -> Nested Loop Left Join (cost=0.00..6734713092843516709808107135979191929171290038347330383160950814336879682910574973044708605952.00 rows=1688183436425668992487992672836213139043763725270904937913237435212321105198789522605719158784 width=24) -> Nested Loop Left Join (cost=0.00..664201016760046872868250005804845239997291253738673137537799147414999826419645942111141888000.00 rows=177488677303872851328538785844281744158128621719103314576432632178900402014469341398588981248 width=24) -> Merge Left Join (cost=0.00..25972293688054806637827062739636845567948877251879600224684566794542523049214624374311616512.00 rows=18660431023880238096209989104521158366384142305927613279630164571886695613791593117700325376 width=24) Merge Cond: (l.id = d2000701.fk_id) -> Merge Left Join (cost=0.00..14049894890814290237103810828840365532450299775017914015946562202491010116192756371734659072.00 rows=6729059871061066547093962364399429704477711306834260883344256034565732923826496361241509888 width=24) Merge Cond: (l.id = d2000702.fk_id) -> Nested Loop Left Join (cost=0.00..9750608598304227029835248027631845484817318308277915305351140318470355102158438220307628032.00 rows=2426538094987091575314121719706801481061008218373318191540891094225680358293592282583007232 width=24) -> Nested Loop Left Join (cost=0.00..1025058701970851971666773794877515871918614126416569675504285277173738045905413026393096192.00 rows=255116255505141199795208039830600261515667727340646212639234090848918346205510543268118528 width=24) -> Nested Loop Left Join (cost=0.00..107690200163883563328831215578223562623432726967187057207229402388534525201775045677940736.00 rows=26821875971129441499281852231738169416331163706627850998494384529766245104343616860454912 width=24) -> Nested Loop Left Join (cost=0.00..11241841251718987518169392747517860895971525410232526769709111264895822015484677058461696.00 rows=2819941948372447294407393028262258825317435322357584837786542263717275309264946581209088 width=24) -> Nested Loop Left Join (cost=0.00..1101656671011535685664880005573428594293205368559353815388347503840679812966080216825856.00 rows=296477121911608802335714143355259366194927785253126887378724932222514806063433672294400 width=24) -> Merge Left Join (cost=0.00..35559284901956817875185306809616650248261067907916273160386104964047551210161656823808.00 rows=31170387698130594573384828711301851240208263565038158177755432038463598504942774517760 width=24) Merge Cond: (l.id = d2000502.fk_id) -> Merge Left Join (cost=0.00..15644107576945754899850904740729534206296892089107473886349396304067507047492300570624.00 rows=11240222948574279044791678091152751844131930370165894865343778001197198328214922985472 width=24) Merge Cond: (l.id = d2000601.fk_id) -> Merge Left Join (cost=0.00..8462578897822500991807833463470856906225100379835832962980823366928774917445910528000.00 rows=4053289717061591835742353494891859055660759965409374695117503995844753341690679394304 width=24) Merge Cond: (l.id = d2000602.fk_id) -> Nested Loop Left Join (cost=0.00..5872877921155896423067696309697936566938108237984908492731473047301163931464399585280.00 rows=1461639827395160963057101613802163191528582181246268665305125303989346487241927557120 width=24) -> Nested Loop Left Join (cost=0.00..616990420048100154925961604613374311506889941442923410337568395189568189451844190208.00 rows=153670812105761713296991100016633409833614547973388189704504632792524717702076432384 width=24) -> Nested Loop Left Join (cost=0.00..64407981136904099103439133103769026081869673060330330442159701369753176868395155456.00 rows=16156318438126396989539114044233379126863349744114225922072499589865880180840464384 width=24) -> Nested Loop Left Join (cost=0.00..6311731601751955089084732061003701982702987582825156524983667254176240975589933056.00 rows=1698609006468288748377375273249576279759129714932488584726482456372990107640135680 width=24) -> Merge Left Join (cost=0.00..203730383506436445290145870405150714893026766555312765748160333492050438979059712.00 rows=178584778946074304337342905966275065330131928068793214581523885055600859595931648 width=24) Merge Cond: (l.id = d2000401.fk_id) -> Merge Left Join (cost=0.00..89630181266338235211867949787777532292454501611417656362487266881330111565529088.00 rows=64398709121481860532037562786407008968584786974746285014825504744733363696304128 width=24) Merge Cond: (l.id = d2000501.fk_id) -> Merge Left Join (cost=0.00..48484985252846397225469816785967093814158337857400145620763694169857685993816064.00 rows=23222548758007666822299046938427266720184970132394907073576464752271907042099200 width=24) Merge Cond: (l.id = d2000402.fk_id) -> Nested Loop Left Join (cost=0.00..33647788457819855717800879688039634038417311758918144787193263292797662605082624.00 rows=8374186038430238913733619181279799698534808193645240733414795373527586593308672 width=24) -> Nested Loop Left Join (cost=0.00..3535185539920856236246315751423050314658290442149530723375738018412752738975744.00 rows=880427547971019939748024105796189167918376487750446639770953330840848440492032 width=16) -> Nested Loop Left Join (cost=0.00..369270067257135840691105327554486635938838279015091679663830836374475550752768.00 rows=92564538651157898348983787528447492688436991919785684117198179318313963749376 width=16) -> Nested Loop Left Join (cost=0.00..36418709060736199556569823213762652241644462979105208741820430950428768731136.00 rows=9731855659727419178486247594791247317395162059242771872264613874921572925440 width=16) -> Merge Left Join (cost=0.00..1424083458817638917256695493258620809360144349311366457834112809665285849088.00 rows=1023167359356615422216897787005898067981158313060929733805306822586567491584 width=16) Merge Cond: (l.id = d2000301.fk_id) -> Merge Left Join (cost=0.00..770368157227970975131398239486518225604479841701162319422311063522845392896.00 rows=368960095852837655373355091566851102133583296698103278814117394056145272832 width=16) Merge Cond: (l.id = d2000302.fk_id) -> Nested Loop Left Join (cost=0.00..534634620451878063137486812028669097944910675640259593838131985585094524928.00 rows=133049154751512925418647883224037896167793586615881582917831225191539146752 width=16) -> Nested Loop Left Join (cost=0.00..56205272547705700873417816359507287774489598169660012003501661641420832768.00 rows=13988242026140788365352872013074916243523859171899646579445894358639837184 width=16) -> Nested Loop Left Join (cost=0.00..5905174637341673548319775706349779679272028071228992324540821365967552512.00 rows=1470666351449829943616300455555937384894374450945509082406366458589216768 width=16) -> Nested Loop Left Join (cost=0.00..616828801377242321564075318055968940806514484491098253233689348513202176.00 rows=154619823795218227573449201972636878974730024880261679591444129521860608 width=16) -> Nested Loop Left Join (cost=0.00..60833826365474279764429355863510813618897914530185682427339746758885376.00 rows=16256093631907577899696685487339492672113341644531598811025176723980288 width=16) -> Merge Left Join (cost=0.00..2378796791569574597071138379000585009714828375102920882474844369715200.00 rows=1709098960812026431234126781267814605623831435698313663400536526815232 width=8) Merge Cond: (l.id = d2000201.fk_id) -> Merge Left Join (cost=0.00..1286830621620236239712359163789713032987436611766428185284463395078144.00 rows=616311017583394677307890448678863461383148790418389606485118165188608 width=8) Merge Cond: (l.id = d2000202.fk_id) -> Nested Loop Left Join (cost=0.00..893061274847965291610835662237335145557019415374464605549195268456448.00 rows=222245334590929894377297992116509546940291928911834857492261172674560 width=8) -> Nested Loop Left Join (cost=0.00..93892796839471280256256760087024736761909681664646963937380956897280.00 rows=23365962265936269418641273536445640113386441742930999867769006063616 width=8) -> Nested Loop Left Join (cost=0.00..9871503273769249361757856719302399335781445508673990538681508691968.00 rows=2456601366314752430909972125111157294872505461597148580203406032896 width=8) -> Nested Loop Left Join (cost=0.00..1037849336308956769278231302264519026498602167504063413653700870144.00 rows=258276984456890328567218961097583269877354886073455976517721915392 width=8) -> Nested Loop Left Join (cost=0.00..109115219334335476110691607927414845904223396263938820713127870464.00 rows=27154182039805120047930600082942226481678926325118621569643446272 width=8) -> Nested Loop Left Join (cost=0.00..11471926293968169550024100217980474554072298269874210348438913024.00 rows=2854879244472315326800752437414392742661138036731387211902091264 width=8) -> Nested Loop Left Join (cost=0.00..1206111243666133366020866390749761607546467224655808807181484032.00 rows=300150285822320095915179528374699947654283173571973381219155968 width=8) -> Nested Loop Left Join (cost=0.00..126805585637587023785127641647263301677394648901045597201498112.00 rows=31556569075086176405477143076837751098104106998808778442276864 width=8) -> Nested Loop Left Join (cost=0.00..13331818796428088904590639924508023301866642520526796089196544.00 rows=3317728147625948772157455404576804523169722561767056703750144 width=8) -> Nested Loop Left Join (cost=0.00..1401652707387594248539793026225801576211336124784585679568896.00 rows=348812319722037186580243341992798782672413551812774954270720 width=8) -> Nested Loop Left Join (cost=0.00..147364012527183789941949417648041507609975625770154541973504.00 rows=36672695584456353145177854143534000468475300015060912439296 width=8) -> Nested Loop Left Join (cost=0.00..15493247416891607463039814318994657907120583121247047516160.00 rows=3855616689519230428196071058936993272034867664624403087360 width=8) -> Nested Loop Left Join (cost=0.00..1628896440891489427984228765627951030265871741201638490112.00 rows=405363713236287457121320612959362475423552602735458123776 width=8) -> Nested Loop Left Join (cost=0.00..171255485938743906715889593009561323202021496190222204928.00 rows=42618276981574295467179323813426146918688612954121699328 width=8) -> Nested Loop Left Join (cost=0.00..18005098868080255869401301159311947501939795507606978560.00 rows=4480710713786681112700823510436207193356941708123701248 width=8) -> Nested Loop Left Join (cost=0.00..1892982192496313053570195057344132750224854809638338560.00 rows=471083533229717263562711553914979660792455054271447040 width=8) -> Nested Loop Left Join (cost=0.00..199020377914215563358448735043346448721989671978008576.00 rows=49527789106618806989856893047233138301463764395884544 width=8) -> Nested Loop Left Join (cost=0.00..20924185648510446712747826784352323951824982476062720.00 rows=5207148458304392978875340646216070448476530417860608 width=8) -> Nested Loop Left Join (cost=0.00..2199882995107396550124072190192691588535565227655168.00 rows=547458216001777762854102939219769190097766129336320 width=8) -> Nested Loop Left Join (cost=0.00..231286668616764343520540837221828874757967603302400.00 rows=57557509770989722253393142773464437295645764616192 width=8) -> Nested Loop Left Join (cost=0.00..24316531014973100895436696178020345734746387513344.00 rows=6051360330715759316417886350392976344623836299264 width=8) -> Nested Loop Left Join (cost=0.00..2556540262949207681774799490639394320586133995520.00 rows=636215187172971139763277830281326954351240937472 width=8) -> Nested Loop Left Join (cost=0.00..268784149846697764514423162329318489241765806080.00 rows=66889053414153950933411117338857240011888132096 width=8) -> Nested Loop Left Join (cost=0.00..28258862281899217490307818322584121031392231424.00 rows=7032440527744162480092296401907381832190525440 width=8) -> Nested Loop Left Join (cost=0.00..2971020790931349083753213477145394821346623488.00 rows=739361932214063814594368423386513432981274624 width=8) -> Nested Loop Left Join (cost=0.00..312360931310398777311698356832277130425401344.00 rows=77733478818720710583116264653362611657637888 width=8) -> Nested Loop Left Join (cost=0.00..32840346222724952985810999834493330057592832.00 rows=8172578903495735564093016482519746338619392 width=8) -> Nested Loop Left Join (cost=0.00..3452699207625078051486956176978371929964544.00 rows=859231401306821780245964080864864851984384 width=8) -> Nested Loop Left Join (cost=0.00..363002622977391853379888439445285714788352.00 rows=90336062791133611866596554710624105398272 width=8) -> Nested Loop Left Join (cost=0.00..38164605824179071521408465836264382267392.00 rows=9497562854653603628642421184441352192000 width=8) -> Nested Loop Left Join (cost=0.00..4012470008531253559761503991146135683072.00 rows=998534775493329484408515017301836169216 width=8) -> Nested Loop Left Join (cost=0.00..421854627387838656549603827979214913536.00 rows=104981847778029716374217996041891872768 width=8) -> Nested Loop Left Join (cost=0.00..44352064007993444774926003392674267136.00 rows=11037360574091519327393048788566278144 width=8) -> Nested Loop Left Join (cost=0.00..4662993965361101890568053810836537344.00 rows=1160422787566944360735849956469899264 width=8) -> Nested Loop Left Join (cost=0.00..490248046112922267645748687262449664.00 rows=122002088893020908727959032241848320 width=8) -> Nested Loop Left Join (cost=0.00..51542667329814108203801101438287872.00 rows=12826798864807618903215164272672768 width=8) -> Nested Loop Left Join (cost=0.00..5418984484560214711438914738978816.00 rows=1348556984647184456979737072369664 width=8) -> Nested Loop Left Join (cost=0.00..569729786314693702308961621901312.00 rows=141781746171318218012669513826304 width=8) -> Nested Loop Left Join (cost=0.00..59899051259330050013500213821440.00 rows=14906350844823440425704321187840 width=8) -> Nested Loop Left Join (cost=0.00..6297540391869300834677074952192.00 rows=1567192544239650069503000182784 width=8) -> Nested Loop Left Join (cost=0.00..662097548348863675926843490304.00 rows=164768191510350805300026540032 width=8) -> Nested Loop Left Join (cost=0.00..69610218633223161979634450432.00 rows=17323051359182681414693814272 width=8) -> Nested Loop Left Join (cost=0.00..7318532669769016542551343104.00 rows=1821274516896237801055453184 width=8) -> Nested Loop Left Join (cost=0.00..769440485752377100619218944.00 rows=191481327228029755614822400 width=8) -> Nested Loop Left Join (cost=0.00..80895814479371531032985600.00 rows=20131560803635128938004480 width=8) -> Nested Loop Left Join (cost=0.00..8505053894950551315021824.00 rows=2116549672270768881270784 width=8) -> Nested Loop Left Join (cost=0.00..894186457254340182671360.00 rows=222525345097961386803200 width=8) -> Nested Loop Left Join (cost=0.00..94011093899331890053120.00 rows=23395401421333643395072 width=8) -> Nested Loop Left Join (cost=0.00..9883940541089458421760.00 rows=2459696478279294255104 width=8) -> Nested Loop Left Join (cost=0.00..1039156939546313228288.00 rows=258602391824857989120 width=8) -> Nested Loop Left Join (cost=0.00..109252695372076367872.00 rows=27188394034828480512 width=8) -> Nested Loop Left Join (cost=0.00..11486379960765333504.00 rows=2858476153204863488 width=8) -> Nested Loop Left Join (cost=0.00..1207630843331455744.00 rows=300528450042835392 width=8) -> Nested Loop Left Join (cost=0.00..126965350572952224.00 rows=31596327709044236 width=8) -> Nested Loop Left Join (cost=0.00..13348616289769948.00 rows=3321908207209738 width=8) -> Nested Loop Left Join (cost=0.00..1403418754580575.50 rows=349251794029491 width=8) -> Nested Loop Left Join (cost=0.00..147549715169113.00 rows=36718900109306 width=8) -> Nested Loop Left Join (cost=0.00..15512799119297.06 rows=3860474443614 width=8) -> Nested Loop Left Join (cost=0.00..1630979715487.41 rows=405874437563 width=8) -> Nested Loop Left Join (cost=0.00..171502201734.50 rows=42671972441 width=8) -> Nested Loop Left Join (cost=0.00..18058726409.67 rows=4486356034 width=8) -> Nested Loop Left Join (cost=0.00..1926309228.45 rows=471677059 width=8) -> Nested Loop Left Join (cost=0.00..202765796.68 rows=49590190 width=8) -> Nested Loop Left Join (cost=0.00..21559515.72 rows=5213709 width=8) -> Nested Loop Left Join (cost=0.00..2508229.87 rows=548148 width=8) -> Nested Loop Left Join (cost=0.00..505256.95 rows=57630 width=8) -> Nested Loop Left Join (cost=0.00..294671.96 rows=6059 width=8) -> Nested Loop Left Join (cost=0.00..272532.55 rows=637 width=8) -> Index Scan using log_pkey on log l (cost=0.00..270203.92 rows=67 width=8) Filter: (datetime >= (now() - '00:01:00'::interval)) -> Index Scan using unique_key_and_id on log_details d7 (cost=0.00..34.63 rows=10 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..34.63 rows=10 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..34.63 rows=10 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..34.63 rows=10 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..34.63 rows=10 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..34.63 rows=10 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..34.63 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 width=8) Index Cond: ((l.id = d2000203.fk_id) AND (d2000203.fk_keyid = $68)) -> Index Scan using unique_key_and_id on log_details d2000121 (cost=0.00..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 width=8) Index Cond: ((l.id = d2000119.fk_id) AND (d2000119.fk_keyid = $63)) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000202 (cost=0.00..403223.26 rows=644557 width=8) Filter: (d2000202.fk_keyid = $67) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000201 (cost=0.00..403223.26 rows=644557 width=8) Filter: (d2000201.fk_keyid = $66) -> Index Scan using unique_key_and_id on log_details d2000305 (cost=0.00..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 width=8) Index Cond: ((l.id = d2000303.fk_id) AND (d2000303.fk_keyid = $74)) -> Index Scan using unique_key_and_id on log_details d2000206 (cost=0.00..34.08 rows=10 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..34.08 rows=10 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 d2000302 (cost=0.00..403223.26 rows=644557 width=8) Filter: (d2000302.fk_keyid = $73) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000301 (cost=0.00..403223.26 rows=644557 width=8) Filter: (d2000301.fk_keyid = $72) -> Index Scan using unique_key_and_id on log_details d2000405 (cost=0.00..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 width=8) Index Cond: ((l.id = d2000403.fk_id) AND (d2000403.fk_keyid = $80)) -> Index Scan using unique_key_and_id on log_details d2000306 (cost=0.00..34.08 rows=10 width=16) Index Cond: ((l.id = d2000306.fk_id) AND (d2000306.fk_keyid = $77)) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000402 (cost=0.00..403223.26 rows=644557 width=8) Filter: (d2000402.fk_keyid = $79) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000501 (cost=0.00..403223.26 rows=644557 width=8) Filter: (d2000501.fk_keyid = $83) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000401 (cost=0.00..403223.26 rows=644557 width=8) Filter: (d2000401.fk_keyid = $78) -> Index Scan using unique_key_and_id on log_details d2000603 (cost=0.00..34.08 rows=10 width=8) Index Cond: ((l.id = d2000603.fk_id) AND (d2000603.fk_keyid = $90)) -> Index Scan using unique_key_and_id on log_details d2000505 (cost=0.00..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 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 d2000602 (cost=0.00..403223.26 rows=644557 width=8) Filter: (d2000602.fk_keyid = $89) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000601 (cost=0.00..403223.26 rows=644557 width=8) Filter: (d2000601.fk_keyid = $88) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000502 (cost=0.00..403223.26 rows=644557 width=8) Filter: (d2000502.fk_keyid = $84) -> Index Scan using unique_key_and_id on log_details d2000705 (cost=0.00..34.08 rows=10 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..34.08 rows=10 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..34.08 rows=10 width=8) Index Cond: ((l.id = d2000703.fk_id) AND (d2000703.fk_keyid = $95)) -> Index Scan using unique_key_and_id on log_details d2000605 (cost=0.00..34.08 rows=10 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..34.08 rows=10 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 d2000702 (cost=0.00..403223.26 rows=644557 width=8) Filter: (d2000702.fk_keyid = $94) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000701 (cost=0.00..403223.26 rows=644557 width=8) Filter: (d2000701.fk_keyid = $93) -> Index Scan using unique_key_and_id on log_details d2000806 (cost=0.00..34.08 rows=10 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..34.08 rows=10 width=8) Index Cond: ((l.id = d2000805.fk_id) AND (d2000805.fk_keyid = $102)) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000901 (cost=0.00..403223.26 rows=644557 width=8) Filter: (d2000901.fk_keyid = $104) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000802 (cost=0.00..403223.26 rows=644557 width=8) Filter: (d2000802.fk_keyid = $99) -> Index Scan using i_log_details_str_fk_id on log_details_str d2000801 (cost=0.00..403223.26 rows=644557 width=8) Filter: (d2000801.fk_keyid = $98) -> Sort (cost=467824.16..469437.07 rows=645165 width=8) Sort Key: d2000804.fk_id -> Bitmap Heap Scan on log_details d2000804 (cost=12082.72..405567.97 rows=645165 width=8) Recheck Cond: (fk_keyid = $101) -> Bitmap Index Scan on i_log_details_fk_keyid (cost=0.00..11921.43 rows=645165 width=0) Index Cond: (fk_keyid = $101) -> Sort (cost=467824.16..469437.07 rows=645165 width=8) Sort Key: d2000803.fk_id -> Bitmap Heap Scan on log_details d2000803 (cost=12082.72..405567.97 rows=645165 width=8) Recheck Cond: (fk_keyid = $100) -> Bitmap Index Scan on i_log_details_fk_keyid (cost=0.00..11921.43 rows=645165 width=0) Index Cond: (fk_keyid = $100) -> Sort (cost=173593.87..175205.26 rows=644557 width=8) Sort Key: d2000904.fk_id -> Bitmap Heap Scan on log_details_str d2000904 (cost=12068.77..111400.73 rows=644557 width=8) Recheck Cond: (fk_keyid = $107) -> Bitmap Index Scan on i_log_details_str_fk_keyid (cost=0.00..11907.63 rows=644557 width=0) Index Cond: (fk_keyid = $107) -> Sort (cost=173593.87..175205.26 rows=644557 width=8) Sort Key: d2000902.fk_id -> Bitmap Heap Scan on log_details_str d2000902 (cost=12068.77..111400.73 rows=644557 width=8) Recheck Cond: (fk_keyid = $105) -> Bitmap Index Scan on i_log_details_str_fk_keyid (cost=0.00..11907.63 rows=644557 width=0) Index Cond: (fk_keyid = $105) -> Sort (cost=467824.16..469437.07 rows=645165 width=8) Sort Key: d2000903.fk_id -> Bitmap Heap Scan on log_details d2000903 (cost=12082.72..405567.97 rows=645165 width=8) Recheck Cond: (fk_keyid = $106) -> Bitmap Index Scan on i_log_details_fk_keyid (cost=0.00..11921.43 rows=645165 width=0) Index Cond: (fk_keyid = $106)