CODEWITHSUNDEEP
amazon-web-servicesamazon-redshiftamazon-redshift-spectrum
ashu1992
ashu1992

Reputation: 38

Check "CONNECTION LIMIT" of user in Redshift

I have a user in Redshift with username as "redshift_x" and want to know the CONNECTION LIMIT which is currently set for this user. I have tried querying it using the below query:

select * from pg_user where usename = 'redshift_x';

But this query only gives information about these columns viz. usename, usesysid, usecreatedb, usesuper, usecatupd, passwd, valuntil, useconfig.

Kindly let me know from where can I see the CONNECTION LIMIT for this particular user "redshift_x".

Upvotes: 2

Views: 8578

Answers (1)

smb
smb

Reputation: 673

You were very close with the view, there is one more that has the info you need. select * from pg_user_info (a view in the pg_catalog).

The column you are after is useconnlimit

Upvotes: 8

Related Questions