Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
Hi Ron, You can use LIKE operator to get only select query and specify LIMIT as per your requirement. Hope this helps..On Mon, Jun 11, 2018 at 7:26 PM, Ron <ronljohnsonjr@gmail.com> wrote: 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'; Thanks On 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.
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'; Thanks On 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 по дате отправления: