FilesExpand file tree

 master

/

postgres_active_query_count.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

29 lines (27 loc) · 754 Bytes

 master

/

postgres_active_query_count.sql

Copy path

Top

File metadata and controls

• Code
• Blame

29 lines (27 loc) · 754 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

--

-- Author: Hari Sekhon

-- Date: 2020-08-05 15:33:36 +0100 (Wed, 05 Aug 2020)

--

-- vim:ts=4:sts=4:sw=4:et:filetype=sql

--

-- https://github.com/HariSekhon/SQL-scripts

--

-- License: see accompanying Hari Sekhon LICENSE file

--

-- If you're using my code you're welcome to connect with me on LinkedIn and optionally send me feedback to help steer this or other code I publish

--

-- https://www.linkedin.com/in/HariSekhon

--

-- PostgreSQL number of active queries

--

-- If COUNT consistently > CPU Cores, then upgrade/scale

--

-- Requires PostgreSQL >= 9.2 for state column in pg_stat_activity

--

-- Tested on PostgreSQL 9.2+, 10.x, 11.x, 12.x, 13.0

SELECT

COUNT(*) as active_query_count

FROM

pg_stat_activity

WHERE

state='active';