{"id":38073,"date":"2019-10-31T22:21:32","date_gmt":"2019-10-31T19:21:32","guid":{"rendered":"https:\/\/prohoster.info\/blog\/istoriya-aktivnyh-sessij-v-postgresql-novoe-rasshirenie-pgsentinel\/"},"modified":"2019-10-31T22:21:32","modified_gmt":"2019-10-31T19:21:32","slug":"istoriya-aktivnyh-sessij-v-postgresql-novoe-rasshirenie-pgsentinel","status":"publish","type":"post","link":"https:\/\/prohoster.info\/da\/blog\/administrirovanie\/istoriya-aktivnyh-sessij-v-postgresql-novoe-rasshirenie-pgsentinel","title":{"rendered":"Historik over aktive sessioner i PostgreSQL \u2014 en ny udvidelse, pgsentinel.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Virksomheden pgsentinel<\/a><\/noindex> udgav en tilsvarende udvidelse pgsentinel (github-repositoriet<\/a><\/noindex>), som tilf\u00f8jer visningen pg_active_session_history til PostgreSQL \u2014 historik over aktive sessioner (p\u00e5 samme m\u00e5de som Oracle's v$active_session_history).<\/p>\n

I bund og grund er det blot sekvensfotos fra pg_stat_activity, men der er vigtige detaljer:<\/p>\n

    \n
  1. Al den indsamlede information opbevares kun i RAM, og den forbrugte hukommelsesm\u00e6ngde reguleres af antallet af de seneste gemte poster.<\/li>\n
  2. Et felt queryid tilf\u00f8jes \u2014 den samme queryid fra udvidelsen pg_stat_statements (kr\u00e6ver installation p\u00e5 forh\u00e5nd).<\/li>\n
  3. Et felt top_level_query tilf\u00f8jes \u2014 teksten fra foresp\u00f8rgslen, der kaldte den aktuelle foresp\u00f8rgsel (i tilf\u00e6lde af brug af pl\/pgsql)<\/li>\n<\/ol>\n

    <\/a><\/noindex>
    \nDen komplette liste over felter i pg_active_session_history:<\/b><\/p>\n

    \n      Kolonne      |           Type           \n------------------+--------------------------\n ash_time         | timestamp with time zone \n datid            | oid                      \n datname          | text                     \n pid              | integer                  \n usesysid         | oid                      \n usename          | text                     \n application_name | text                     \n client_addr      | text                     \n client_hostname  | text                     \n client_port      | integer                  \n backend_start    | timestamp with time zone \n xact_start       | timestamp with time zone \n query_start      | timestamp with time zone \n state_change     | timestamp with time zone \n wait_event_type  | text                     \n wait_event       | text                     \n state            | text                     \n backend_xid      | xid                      \n backend_xmin     | xid                      \n top_level_query  | text                     \n query            | text                     \n queryid          | bigint                   \n backend_type     | text                     \n<\/pre>\n
    Der er endnu ikke en f\u00e6rdig pakke til installation. Det anbefales at downloade kilden og samle biblioteket selv. F\u00f8rst skal du installere \"devel\"-pakken til din server og tilf\u00f8je stien til pg_config i variablen PATH. Vi samler:<\/p>\n
    cd pgsentinel\/src
    \nmake
    \nmake install<\/p><\/blockquote>\n
    \nTilf\u00f8j parametre til postgres.conf:<\/p>\n
    shared_preload_libraries = 'pg_stat_statements,pgsentinel'
    \ntrack_activity_query_size = 2048
    \npg_stat_statements.track = all<\/p>\n
    # \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u0443\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u043c\u044b\u0445 \u0432 \u043f\u0430\u043c\u044f\u0442\u0438 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0445 \u0437\u0430\u043f\u0438\u0441\u0435\u0439
    \npgsentinel_ash.max_entries = 10000<\/p><\/blockquote>\n
    \nGenstart PostgreSQL og opret udvidelsen:<\/p>\n
    create extension pgsentinel;<\/p><\/blockquote>\n
    \nDen indsamlede information g\u00f8r det muligt at besvare sp\u00f8rgsm\u00e5l som:<\/p>\n