Tags:
create new tag
view all tags

Arrow left Go to previous page / next page of Tier3 site log MOVED TO...

11. 06. 2013 Constantly more than 250 PG DB connections

Today I'm trying to understand why there are so many PG DB connections to asses if this is somehow expected or not in dCache.

According to this pnp4nagios plot they were always pretty few, especially in the last weeks ( 28th March 2013 ) when we migrated dCache from 1.9.12 to 2.2; so I would raise them of 50 slots:
TOT_POSTGRESQL_CONNECTIONS_early2013.png

To dump the actual connections:

[root@t3dcachedb03 ~]# psql -U postgres -H -c "SELECT * FROM pg_stat_activity order by datname;" -o 
/tmp/table.html


Arrow left Go to previous page / next page of Tier3 site log MOVED TO...

Topic attachments
I Attachment History Action Size Date Who Comment
PNGpng TOT_POSTGRESQL_CONNECTIONS_early2013.png r1 manage 28.8 K 2013-06-11 - 11:33 FabioMartinelli Tot_postgresql_connections_up_to_June_2013
HTMLhtml pg_stat_activity.html r1 manage 189.5 K 2013-06-11 - 09:23 FabioMartinelli pg_stat_activity
Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r2 - 2013-06-11 - FabioMartinelli
 
This site is powered by the TWiki collaboration platform Powered by Perl This site is powered by the TWiki collaboration platformCopyright © 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback