Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-2426

postgresql - slowest queries

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.8.2
    • Fix Version/s: 1.8.2
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      debian lenny, zabbix 1.8.2, postgresql 8.3

      Description

      I tried to log slow queries. Slowest queries are of this type for example:

      select value from history_uint where itemid=23287 and clock<=1273669687 order by clock desc limit 2;

      It selects many thousand lines, and takes several seconds to perform. Finally, it selects only 2 rows with LIMIT.

      I propose that find this SQL query and restrict choice from clock.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            martinjanda Martin Janda
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: