Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
Thanks. How, then, do I get only long-running SELECT statements?I've tried this (since I don't want to inadvertently get other DML & DDL statements which might have "select" in a field name), but CTEs and queries that start with a comment slip by this filter.FROM pg_stat_activityWHERE state <> 'idle' AND SUBSTRING(UPPER(query) FROM 1 FOR 6) = 'SELECT'; ThanksOn 06/11/2018 08:47 AM, Shreeyansh Dba wrote:Ron, Yes, It can list the insert,delete and update statement as well..On Mon, Jun 11, 2018 at 7:07 PM, Ron <ronljohnsonjr@gmail.com> wrote:Hi, Does pg_stat_activity only list SELECT statements, or does it also list INSERT, DELETE and UPDATE statements?-- Angular momentum makes the world go 'round.
Ron, Yes, It can list the insert,delete and update statement as well..On Mon, Jun 11, 2018 at 7:07 PM, Ron <ronljohnsonjr@gmail.com> wrote:Hi, Does pg_stat_activity only list SELECT statements, or does it also list INSERT, DELETE and UPDATE statements?
Hi, Does pg_stat_activity only list SELECT statements, or does it also list INSERT, DELETE and UPDATE statements?
В списке pgsql-admin по дате отправления: