Moin, Die Load der DB01.xIBE war eben bei 200 ... also Herzdruckmassage. Ursache waren hunderte gleichlautende Db-Queries, die AAA-Angebote für ein ganzes Jahr abgefragt haben ... siehe unten. Ich habe die lang-laufenden Queries aufgelistet (hier vor 17:30Uhr, was 3min her war): * ssh db01.app.xibe.rz1.xtrav.de * sudo -i * psql -h localhost -U postgres * select pid from pg_stat_activity WHERE query_start < '2020-03-09 17:30:00'; und gekillt: * select pg_cancel_backend(pid) from pg_stat_activity WHERE query_start < '2020-03-09 17:30:00'; Verantwortlicher: FSE (DANKE für die Unterstützung!!!!), SRK Zeitpunkt: 2020-03-09 17:33Uhr Kunden: AAA Info: SELECT hotel_only_table.*, hotel_only_table.offer_id as hotel_offer_id, giata_table.country_name, giata_ table.destination_name, giata_table.city_name, giata_table.hotel_name, room_type_table.description as room_type_description, board_type_table.description as board_type_description, count(*) OVER() AS total_count FROM hotel_only_table LEFT JOIN giata_table ON hotel_only_table.giata_id = giata_table.giata_id LEFT JOIN room_type_table ON hotel_only_table.room_type = room_type_table.room_type LEFT JOIN board_type_table ON hotel_only_table.board_type = board_type_table.board_type WHERE adults = 2 AND children = 0 AND travel_start >= '2020-03-19' AND travel_end <= '2021-03-09' ORDER BY price ASC, travel_start ASC, travel_duration A SC LIMIT 1 OFFSET 0; VG Stefan Rank-Kunitz Mit freundlichen Grüßen Stefan Rank-Kunitz - Technical Director - ________________________________________________________ TraSo GmbH Nonnenstraße 42 D-04229 Leipzig Tel.: +49 341 355 740 - 43 E-Mail: s.rank-kunitz@traso.de ________________________________________________________ Handelsregister: Amtsgericht Leipzig, HRB 21850
participants (1)
-
Stefan Rank-Kunitz