Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ToaGo-0008TZ-94 for pgsql-admin@arkaria.postgresql.org; Fri, 28 Dec 2012 13:46:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1ToaGn-0007oR-KB for pgsql-admin@arkaria.postgresql.org; Fri, 28 Dec 2012 13:46:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ToVyf-0005K6-3X for pgsql-admin@postgresql.org; Fri, 28 Dec 2012 09:11:41 +0000 Received: from mx0.network-studio.com ([62.93.225.99]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ToVyY-0006wI-MR for pgsql-admin@postgresql.org; Fri, 28 Dec 2012 09:11:40 +0000 Received: from zimbra-ne01.network-studio.com (zimbra-admin.network-studio.com [192.168.101.80]) by mx0.network-studio.com (Postfix) with ESMTP id AD24440804C; Fri, 28 Dec 2012 10:11:32 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by zimbra-ne01.network-studio.com (Postfix) with ESMTP id A7513DA13E4; Fri, 28 Dec 2012 10:11:32 +0100 (CET) X-Virus-Scanned: amavisd-new at zimbra-ne01.network-studio.com Received: from zimbra-ne01.network-studio.com ([127.0.0.1]) by localhost (zimbra-ne01.network-studio.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id LESBxwbUwLJB; Fri, 28 Dec 2012 10:11:29 +0100 (CET) Received: from zimbra-ne01.network-studio.com (zimbra-ne01.network-studio.com [192.168.101.80]) by zimbra-ne01.network-studio.com (Postfix) with ESMTP id F14CDDA0FB9; Fri, 28 Dec 2012 10:11:28 +0100 (CET) Date: Fri, 28 Dec 2012 10:11:28 +0100 (CET) From: Baptiste LHOSTE To: Kevin Grittner Cc: pgsql-admin@postgresql.org, Sylvain CAILLET Message-ID: <523296146.3763479.1356685888860.JavaMail.root@alaloop.com> In-Reply-To: <20121220224612.14720@gmx.com> Subject: Re: Autovacuum issues with truncate and create index ... MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Originating-IP: [192.168.101.82] X-Mailer: Zimbra 7.2.1_GA_2790 (ZimbraWebClient - GC23 (Linux)/7.2.1_GA_2790) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hi, Sorry for the late response but I was on holidays for christmas. > Just so we know how to interpret that, how many minutes, hours, or > days did you wait to see whether it would ever end? I have waiting for 15 minutes in this state. I can not wait more time witho= ut losing some data for our client. > At the time you captured data from pg_stat_activity and pg_locks, > there were three autovacuum processes active, all running ANALYZE, > and eight TRUNCATE commands active on "normal" connections. All the > TRUNCATE statements started in the same second. One of the ANALYZE > tasks started about a minute and a half before that, the other two > started about a minute after the TRUNCATE statements. All are on > different tables, and no heavyweight locking is showing up. > I've heard enough reports of behavior like this to believe that > there is some sort of bug here, but the nature of it is not > apparent. We could really use more clues. > If it doesn't cause too much pain to let it get into this state for > a few minutes, it might help diagnose the issue if you could start > `vmstat 1` before you let it get into this state, and capture `ps > aux | postgres`, pg_stat_activity, and pg_locks at intervals while > it is in this state. Looking at all of the above might suggest a > cause. If we can find the cause, we can almost certainly fix it. ###########################################################################= ############" ###########################################################################= ############" ###########################################################################= ############" Here is the state before changes of autovacuum thresholds : LOAD 1 minute : 0.9 vmstat 1 : procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu--= -- r b swpd free buff cache si so bi bo in cs us sy id = wa 1 12 833844 353632 174740 9998572 0 0 6916 124 1985 1014 0 0 80= 20 0 10 833844 347848 174748 10004896 0 0 6280 28 2165 1079 0 0 8= 9 10 1 0 833844 343244 174768 10009772 0 0 4892 264 2213 1337 1 0 8= 6 14 0 0 833844 337244 174776 10015832 0 0 5116 256 1872 1851 2 0 9= 7 1 0 14 833844 331728 174780 10021824 0 0 5892 8072 2017 1287 0 0 7= 9 21 0 13 833844 325056 174792 10028556 0 0 6920 124 1902 1035 0 0 7= 5 25 0 3 833844 317872 174800 10035104 0 0 6404 264 2043 1642 0 0 8= 4 15 0 0 833844 310928 174816 10043196 0 0 7176 92 1861 1859 0 0 9= 8 2 0 1 833844 304240 174832 10049404 0 0 6664 16 1811 1728 0 0 9= 8 2 0 12 833844 297156 174836 10056628 0 0 6788 8868 2043 1329 0 0 9= 4 6 0 0 833844 309184 174844 10057936 0 0 904 480 1260 1727 1 0 9= 3 6 0 0 833844 308960 174844 10058236 0 0 0 0 702 1834 0 0 1= 00 0 0 0 833844 308780 174848 10058664 0 0 0 76 786 1935 0 0 1= 00 0 0 0 833844 308532 174848 10059052 0 0 0 0 747 1978 0 0 1= 00 0 0 0 833844 308152 174856 10059836 0 0 0 9384 1024 2213 0 0 8= 4 16 0 0 833844 308168 174856 10059780 0 0 0 0 718 1753 0 0 1= 00 0 0 0 833844 307796 174864 10060124 0 0 0 16 717 1755 0 0 9= 9 0 0 1 833844 307472 174868 10061052 0 0 0 20 793 1746 0 0 1= 00 0 0 0 833844 307728 174872 10061004 0 0 0 4 734 1675 0 0 9= 9 0 0 0 833844 307336 174888 10061736 0 0 0 9680 970 2041 0 0 9= 1 9 0 0 833844 307688 174888 10061732 0 0 0 0 632 1502 0 0 1= 00 0 =20 ps aux | grep postgres : postgres 9189 2.5 4.7 991916 774368 ? Ss 08:45 1:11 postgres: = asa flows 10.48.168.160(35031) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9363 3.0 2.8 979456 470404 ? Ss 09:15 0:29 postgres: = asa flows 10.48.168.160(35091) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9364 2.6 3.2 979872 527124 ? Ss 09:15 0:26 postgres: = asa flows 10.48.168.160(35092) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 root 9439 0.0 0.0 69512 3240 pts/3 S+ 09:19 0:00 /usr/lib/p= ostgresql/8.4/bin/psql -U asa flows postgres 9440 0.0 0.0 887536 6152 ? Ss 09:19 0:00 postgres: = asa flows [local] idle=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9450 2.5 2.2 980604 370920 ? Ss 09:20 0:17 postgres: = asa flows 10.48.168.160(35104) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9452 2.5 2.7 981196 459996 ? Ss 09:20 0:17 postgres: = asa flows 10.48.168.160(35106) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9505 6.0 1.3 966604 223428 ? Ss 09:30 0:05 postgres: = asa flows 10.48.168.160(35121) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9507 4.8 1.2 965212 198444 ? Ss 09:30 0:04 postgres: = asa flows 10.48.168.160(35123) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9508 4.8 1.1 975860 190392 ? Ss 09:30 0:04 postgres: = asa flows 10.48.168.160(35124) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 root 9516 0.0 0.0 7548 728 pts/2 D+ 09:31 0:00 grep postg= res postgres 11433 0.0 0.1 885744 26056 ? S Dec20 0:17 /usr/lib/p= ostgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main -c config_file= =3D/etc/postgresql/8.4/main/postgresql.conf postgres 11435 0.0 4.8 889276 790004 ? Ss Dec20 10:44 postgres: = writer process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20 postgres 11436 0.0 0.0 886124 704 ? Ss Dec20 1:47 postgres: = wal writer process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20 postgres 11437 0.0 0.0 894472 5104 ? Ss Dec20 4:42 postgres: = autovacuum launcher process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 11438 0.1 0.0 81956 4768 ? Ss Dec20 13:52 postgres: = stats collector process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 12443 0.0 4.9 903820 810512 ? Ss Dec20 0:58 postgres: = asa flows 10.48.168.163(58799) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 12444 0.0 5.1 945064 844512 ? Ss Dec20 6:09 postgres: = asa flows 10.48.168.163(58800) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 12453 0.0 0.0 887384 6860 ? Ss Dec20 0:00 postgres: = asa flows 10.48.168.163(58801) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 26141 0.3 5.3 976928 885872 ? Ss Dec22 33:47 postgres: = asa flows 10.48.168.160(40884) idle select * from pg_stat_activity : datid | datname | procpid | usesysid | usename | current_query = | waiting | xact_start | query_start = | backend_start | client_addr | client_port=20 -------+---------+---------+----------+---------+--------------------------= -------+---------+------------------------------+--------------------------= -----+-------------------------------+---------------+------------- 42539 | flows | 9189 | 16384 | asa | = | f | | 2012-12-28 09:30:30.2453+= 01 | 2012-12-28 08:45:15.923245+01 | 10.48.168.160 | 35031 42539 | flows | 12443 | 16384 | asa | = | f | | 2012-12-27 21:30:35.76757= 7+01 | 2012-12-20 13:00:09.968633+01 | 10.48.168.163 | 58799 42539 | flows | 9505 | 16384 | asa | = | f | | 2012-12-28 09:30:26.73529= 3+01 | 2012-12-28 09:30:17.273639+01 | 10.48.168.160 | 35121 42539 | flows | 12444 | 16384 | asa | = | f | | 2012-12-27 15:15:22.78542= 2+01 | 2012-12-20 13:00:16.82323+01 | 10.48.168.163 | 58800 42539 | flows | 12453 | 16384 | asa | = | f | | 2012-12-20 13:01:15.01918= 2+01 | 2012-12-20 13:01:15.015847+01 | 10.48.168.163 | 58801 42539 | flows | 26141 | 16384 | asa | = | f | | 2012-12-28 06:19:58.34849= 5+01 | 2012-12-22 06:00:55.453306+01 | 10.48.168.160 | 40884 42539 | flows | 9363 | 16384 | asa | = | f | | 2012-12-28 09:30:26.01673= 5+01 | 2012-12-28 09:15:23.006751+01 | 10.48.168.160 | 35091 42539 | flows | 9364 | 16384 | asa | = | f | | 2012-12-28 09:30:35.51892= +01 | 2012-12-28 09:15:23.179672+01 | 10.48.168.160 | 35092 42539 | flows | 9440 | 16384 | asa | select * from pg_stat_act= ivity; | f | 2012-12-28 09:32:12.41096+01 | 2012-12-28 09:32:12.41096= +01 | 2012-12-28 09:19:19.854963+01 | | -1 42539 | flows | 9450 | 16384 | asa | = | f | | 2012-12-28 09:30:18.43294= 1+01 | 2012-12-28 09:20:20.321349+01 | 10.48.168.160 | 35104 42539 | flows | 9507 | 16384 | asa | = | f | | 2012-12-28 09:30:26.26563= 4+01 | 2012-12-28 09:30:17.444456+01 | 10.48.168.160 | 35123 42539 | flows | 9508 | 16384 | asa | = | f | | 2012-12-28 09:30:26.76307= 6+01 | 2012-12-28 09:30:17.487318+01 | 10.48.168.160 | 35124 42539 | flows | 9452 | 16384 | asa | = | f | | 2012-12-28 09:30:26.09308= 3+01 | 2012-12-28 09:20:20.385564+01 | 10.48.168.160 | 35106 (13 rows) select * from pg_locks : locktype | database | relation | page | tuple | virtualxid | transaction= id | classid | objid | objsubid | virtualtransaction | pid | mode = | granted=20 ------------+----------+----------+------+-------+------------+------------= ---+---------+-------+----------+--------------------+------+--------------= ---+--------- virtualxid | | | | | 9/122683 | = | | | | 9/122683 | 9440 | ExclusiveLock= | t relation | 42539 | 10969 | | | | = | | | | 9/122683 | 9440 | AccessShareLo= ck | t (2 rows) ###########################################################################= ############" ###########################################################################= ############" ###########################################################################= ############" Here is the state 1 minute after changes of autovacuum thresholds : LOAD 1 minute : 10.0 vmstat 1 : 1 0 834028 290856 174980 10081904 0 0 0 0 688 1620 0 0 1= 00 0 0 0 834028 290484 174984 10082368 0 0 0 0 748 1682 0 0 1= 00 0 0 0 834028 289748 174992 10082764 0 0 0 24 765 1647 0 0 1= 00 0 0 0 834028 289732 175000 10083084 0 0 0 2376 783 1818 0 0 9= 7 3 0 0 834028 289128 175000 10083488 0 0 0 0 719 1668 0 0 1= 00 0 0 0 834028 288392 175016 10083812 0 0 0 0 772 1607 0 0 9= 9 0 0 0 834028 288740 175016 10084172 0 0 0 0 731 1662 0 0 1= 00 0 1 0 834028 288128 175016 10084088 0 0 0 1508 771 1627 0 0 1= 00 0 0 0 834028 287988 175024 10084868 0 0 0 824 814 1775 0 0 9= 8 2 0 0 834028 287492 175024 10084840 0 0 0 0 692 1605 0 0 1= 00 0 3 0 834028 275216 175064 10091948 64 0 2364 4352 1227 3882 1 0 9= 7 1 0 0 833564 289228 175064 10076076 280 0 344 312 3777 2424 39 0 6= 0 1 0 0 833564 289196 175064 10077140 0 0 0 56 733 1750 0 0 1= 00 0 1 0 833564 292132 175080 10077124 0 0 4 2176 813 1888 0 0 9= 5 5 0 0 833564 295636 175080 10077532 0 0 0 0 783 1676 0 0 1= 00 0 0 0 833564 295360 175088 10078324 0 0 0 20 719 1685 0 0 9= 9 0 0 0 833564 294864 175096 10078692 0 0 0 52 756 1778 0 0 1= 00 0 1 0 833564 294864 175096 10079096 0 0 0 0 769 1802 0 0 1= 00 0 0 0 833564 294924 175104 10079096 0 0 0 2420 889 1957 0 0 9= 6 4 0 0 833564 295056 175112 10079132 0 0 0 48 704 1722 0 0 1= 00 0 0 0 833564 294936 175112 10079492 0 0 0 0 737 1737 0 0 1= 00 0 3 0 833564 294564 175112 10079832 0 0 0 0 750 1698 0 0 1= 00 0 0 0 833564 286876 175124 10082320 0 0 2036 88 1258 1716 1 0 9= 9 0 0 13 833564 279544 175132 10089292 0 0 6928 1888 2303 1134 0 0 6= 8 32 0 9 833564 270596 175136 10096112 0 0 6916 32 2539 1176 0 0 6= 8 32 0 6 833564 262924 175176 10102960 0 0 6952 44 2527 1287 0 0 8= 4 15 0 1 833564 255472 175184 10110188 0 0 7048 20 2118 1579 0 0 9= 2 7 0 1 833564 248296 175196 10117928 0 0 7044 244 2107 1992 0 0 9= 5 5 0 11 833564 241104 175216 10125004 0 0 7176 716 2475 1284 0 0 7= 8 21 0 7 833564 234160 175224 10131872 0 0 7044 44 2113 1282 0 0 7= 8 22 0 0 833564 228340 175252 10138096 0 0 5524 284 2062 1849 1 0 9= 1 7 1 0 833564 220792 175272 10145728 0 0 7244 0 1887 2029 0 0 9= 9 1 0 0 833564 213072 175276 10152340 0 0 6532 40 2672 1997 0 0 9= 8 1 0 9 833564 207104 175284 10158476 0 0 5768 1492 2368 1140 0 0 8= 4 16 1 7 833564 201748 175288 10164284 0 0 5764 32 2377 1150 0 0 9= 0 10 0 7 833564 195664 175292 10169732 0 0 5508 68 2599 1407 0 0 9= 0 10 0 7 833564 189968 175300 10175568 0 0 5768 36 2560 1377 0 0 7= 9 21 0 9 833564 184732 175336 10180860 0 0 4876 1004 2380 1925 1 0 9= 0 9 1 8 833564 177296 175340 10187792 0 0 6916 24 2206 1200 0 0 6= 5 35 0 0 833564 170592 175356 10194744 0 0 6792 216 2091 1546 0 0 7= 9 21 0 0 833564 162904 175364 10202792 0 0 7560 0 1886 1956 0 0 9= 9 0 1 0 833564 155464 175372 10210116 0 0 7048 0 2290 2053 0 0 9= 9 1 1 11 833564 147776 175380 10216412 0 0 5872 1592 2250 2072 1 0 9= 8 1 0 0 833564 142928 175408 10221808 0 0 5120 400 2040 2277 1 0 9= 2 7 0 0 833564 135696 175412 10229700 0 0 7300 0 2024 2025 0 0 9= 9 0 0 0 833564 128504 175420 10237300 0 0 7176 0 2062 1951 0 0 9= 9 0 0 0 833564 120940 175428 10244916 0 0 7432 0 2062 1917 0 0 9= 9 0 0 10 833564 113848 175436 10252160 0 0 7176 2184 1952 1843 0 0 9= 9 1 1 11 833564 106640 175440 10259608 0 0 7172 48 1982 1126 0 0 5= 2 48 ps aux | grep postgres : postgres 9189 2.4 4.7 991916 774368 ? Ss 08:45 1:12 postgres: = asa flows 10.48.168.160(35031) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9363 2.6 2.8 979456 470404 ? Ss 09:15 0:30 postgres: = asa flows 10.48.168.160(35091) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9364 2.3 3.2 979872 527124 ? Ss 09:15 0:26 postgres: = asa flows 10.48.168.160(35092) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9450 2.1 2.2 980604 370920 ? Ss 09:20 0:18 postgres: = asa flows 10.48.168.160(35104) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9452 2.1 2.7 981196 459996 ? Ss 09:20 0:18 postgres: = asa flows 10.48.168.160(35106) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9505 2.3 1.3 966604 223488 ? Ss 09:30 0:05 postgres: = asa flows 10.48.168.160(35121) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9507 1.9 1.2 965212 198452 ? Ss 09:30 0:04 postgres: = asa flows 10.48.168.160(35123) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9508 1.9 1.1 975860 190428 ? Ss 09:30 0:05 postgres: = asa flows 10.48.168.160(35124) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9530 2.9 0.1 896732 29008 ? Ss 09:33 0:01 postgres: = autovacuum worker process flows=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9565 1.2 0.1 900472 26768 ? Ss 09:34 0:00 postgres: = autovacuum worker process flows=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 root 9568 0.0 0.0 7548 864 pts/2 S+ 09:34 0:00 grep postg= res postgres 11433 0.0 0.1 885744 26056 ? S Dec20 0:17 /usr/lib/p= ostgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main -c config_file= =3D/etc/postgresql/8.4/main/postgresql.conf postgres 11435 0.0 4.8 889276 790004 ? Ss Dec20 10:44 postgres: = writer process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20 postgres 11436 0.0 0.0 886124 704 ? Ss Dec20 1:47 postgres: = wal writer process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20 postgres 11437 0.0 0.0 894472 5104 ? Ss Dec20 4:42 postgres: = autovacuum launcher process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 11438 0.1 0.0 81956 4768 ? Ss Dec20 13:53 postgres: = stats collector process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 12443 0.0 4.9 903820 810512 ? Ss Dec20 0:58 postgres: = asa flows 10.48.168.163(58799) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 12444 0.0 5.1 945064 844596 ? Ss Dec20 6:09 postgres: = asa flows 10.48.168.163(58800) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 12453 0.0 0.0 887384 6860 ? Ss Dec20 0:00 postgres: = asa flows 10.48.168.163(58801) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 26141 0.3 5.3 976928 885892 ? Ss Dec22 33:47 postgres: = asa flows 10.48.168.160(40884) idle=20=20=20=20=20 select * from pg_stat_activity : datid | datname | procpid | usesysid | usename | = current_query | waiting | x= act_start | query_start | backend_start= | client_addr | client_port=20 -------+---------+---------+----------+----------+-------------------------= -----------------------------------------------------+---------+-----------= --------------------+-------------------------------+----------------------= ---------+---------------+------------- 42539 | flows | 9189 | 16384 | asa | TRUNCATE flowpool_31_seg= ment_121 | f | 2012-12-28= 09:41:38.438799+01 | 2012-12-28 09:41:38.441412+01 | 2012-12-28 08:45:15.9= 23245+01 | 10.48.168.160 | 35031 42539 | flows | 12443 | 16384 | asa | = | f | = | 2012-12-27 21:30:35.767577+01 | 2012-12-20 13:00:09.9= 68633+01 | 10.48.168.163 | 58799 42539 | flows | 9505 | 16384 | asa | = | f | = | 2012-12-28 09:39:38.19554+01 | 2012-12-28 09:30:17.2= 73639+01 | 10.48.168.160 | 35121 42539 | flows | 12444 | 16384 | asa | = | f | = | 2012-12-27 15:15:22.785422+01 | 2012-12-20 13:00:16.8= 2323+01 | 10.48.168.163 | 58800 42539 | flows | 12453 | 16384 | asa | = | f | = | 2012-12-20 13:01:15.019182+01 | 2012-12-20 13:01:15.0= 15847+01 | 10.48.168.163 | 58801 42539 | flows | 26141 | 16384 | asa | = | f | = | 2012-12-28 06:19:58.348495+01 | 2012-12-22 06:00:55.4= 53306+01 | 10.48.168.160 | 40884 42539 | flows | 9364 | 16384 | asa | TRUNCATE flowpool_15_seg= ment_129 | f | 2012-12-28= 09:41:38.864158+01 | 2012-12-28 09:41:38.866918+01 | 2012-12-28 09:15:23.1= 79672+01 | 10.48.168.160 | 35092 42539 | flows | 9530 | 10 | postgres | autovacuum: ANALYZE publ= ic.agg_t187_incoming_a3_src_net_and_dst_net_f5 | f | 2012-12-28= 09:42:15.902363+01 | 2012-12-28 09:42:15.902363+01 | 2012-12-28 09:33:37.5= 91954+01 | |=20=20=20=20=20=20=20=20=20=20=20=20 42539 | flows | 9565 | 10 | postgres | autovacuum: VACUUM ANALY= ZE public.agg_t482_outgoing_a7_src_port_and_proto_f5 | f | 2012-12-28= 09:41:47.314486+01 | 2012-12-28 09:41:47.314486+01 | 2012-12-28 09:34:07.6= 09676+01 | |=20=20=20=20=20=20=20=20=20=20=20=20 42539 | flows | 9569 | 10 | postgres | autovacuum: ANALYZE publ= ic.agg_t1258_outgoing_a3_src_net_and_dst_net_f5 | f | 2012-12-28= 09:42:01.611648+01 | 2012-12-28 09:42:01.611648+01 | 2012-12-28 09:34:37.6= 27542+01 | |=20=20=20=20=20=20=20=20=20=20=20=20 42539 | flows | 9571 | 16384 | asa | select * from pg_stat_ac= tivity; | f | 2012-12-28= 09:43:08.646964+01 | 2012-12-28 09:43:08.646964+01 | 2012-12-28 09:34:44.8= 17718+01 | | -1 42539 | flows | 9590 | 16384 | asa | TRUNCATE flowpool_29_seg= ment_132 | f | 2012-12-28= 09:41:38.618347+01 | 2012-12-28 09:41:38.621873+01 | 2012-12-28 09:39:20.6= 04855+01 | 10.48.168.160 | 35128 42539 | flows | 9508 | 16384 | asa | TRUNCATE flowpool_26_seg= ment_139 | f | 2012-12-28= 09:41:38.696041+01 | 2012-12-28 09:41:38.70312+01 | 2012-12-28 09:30:17.4= 87318+01 | 10.48.168.160 | 35124 42539 | flows | 9452 | 16384 | asa | TRUNCATE flowpool_21_seg= ment_136 | f | 2012-12-28= 09:41:38.884658+01 | 2012-12-28 09:41:38.888602+01 | 2012-12-28 09:20:20.3= 85564+01 | 10.48.168.160 | 35106 42539 | flows | 9592 | 16384 | asa | TRUNCATE flowpool_17_seg= ment_124 | f | 2012-12-28= 09:41:38.598054+01 | 2012-12-28 09:41:38.601024+01 | 2012-12-28 09:39:20.6= 49273+01 | 10.48.168.160 | 35130 42539 | flows | 9593 | 16384 | asa | TRUNCATE flowpool_2_segm= ent_131 | f | 2012-12-28= 09:41:37.902248+01 | 2012-12-28 09:41:37.902334+01 | 2012-12-28 09:39:20.6= 71335+01 | 10.48.168.160 | 35131 (16 rows) select * from pg_locks : locktype | database | relation | page | tuple | virtualxid | transact= ionid | classid | objid | objsubid | virtualtransaction | pid | = mode | granted=20 ---------------+----------+----------+------+-------+------------+---------= ------+---------+-------+----------+--------------------+------+-----------= ---------------+--------- virtualxid | | | | | 20/33 | = | | | | 20/33 | 9593 | ExclusiveL= ock | t relation | 42539 | 2168418 | | | | = | | | | 12/128804 | 9569 | AccessShar= eLock | t relation | 42539 | 93056 | | | | = | | | | 15/111991 | 9590 | AccessExcl= usiveLock | t virtualxid | | | | | 8/140596 | = | | | | 8/140596 | 9364 | ExclusiveL= ock | t relation | 42539 | 103506 | | | | = | | | | 16/99223 | 9508 | ShareLock = | t relation | 42539 | 103506 | | | | = | | | | 16/99223 | 9508 | AccessExcl= usiveLock | t relation | 42539 | 105972 | | | | = | | | | 19/303 | 9592 | ShareLock = | t relation | 42539 | 105972 | | | | = | | | | 19/303 | 9592 | AccessExcl= usiveLock | t relation | 42539 | 103511 | | | | = | | | | 16/99223 | 9508 | AccessExcl= usiveLock | t relation | 42539 | 105969 | | | | = | | | | 19/303 | 9592 | ShareLock = | t relation | 42539 | 105969 | | | | = | | | | 19/303 | 9592 | AccessExcl= usiveLock | t relation | 42539 | 85230 | | | | = | | | | 8/140596 | 9364 | ShareLock = | t relation | 42539 | 85230 | | | | = | | | | 8/140596 | 9364 | AccessExcl= usiveLock | t transactionid | | | | | | 286= 15213 | | | | 1/170439 | 9189 | ExclusiveL= ock | t virtualxid | | | | | 19/303 | = | | | | 19/303 | 9592 | ExclusiveL= ock | t virtualxid | | | | | 12/128804 | = | | | | 12/128804 | 9569 | ExclusiveL= ock | t relation | 42539 | 87756 | | | | = | | | | 1/170439 | 9189 | ShareLock = | t relation | 42539 | 87756 | | | | = | | | | 1/170439 | 9189 | AccessExcl= usiveLock | t relation | 42539 | 87761 | | | | = | | | | 1/170439 | 9189 | AccessExcl= usiveLock | t relation | 42539 | 82695 | | | | = | | | | 17/43658 | 9452 | ShareLock = | t relation | 42539 | 82695 | | | | = | | | | 17/43658 | 9452 | AccessExcl= usiveLock | t transactionid | | | | | | 286= 15204 | | | | 20/33 | 9593 | ExclusiveL= ock | t transactionid | | | | | | 286= 15214 | | | | 19/303 | 9592 | ExclusiveL= ock | t relation | 42539 | 105974 | | | | = | | | | 19/303 | 9592 | AccessExcl= usiveLock | t relation | 42539 | 50023 | | | | = | | | | 10/120119 | 9565 | ShareUpdat= eExclusiveLock | t virtualxid | | | | | 1/170439 | = | | | | 1/170439 | 9189 | ExclusiveL= ock | t virtualxid | | | | | 15/111991 | = | | | | 15/111991 | 9590 | ExclusiveL= ock | t relation | 42539 | 45409 | | | | = | | | | 9/122742 | 9530 | ShareUpdat= eExclusiveLock | t relation | 42539 | 10969 | | | | = | | | | 13/114750 | 9571 | AccessShar= eLock | t relation | 42539 | 90449 | | | | = | | | | 20/33 | 9593 | AccessExcl= usiveLock | t relation | 42539 | 82698 | | | | = | | | | 17/43658 | 9452 | ShareLock = | t relation | 42539 | 82698 | | | | = | | | | 17/43658 | 9452 | AccessExcl= usiveLock | t transactionid | | | | | | 286= 15218 | | | | 17/43658 | 9452 | ExclusiveL= ock | t virtualxid | | | | | 13/114750 | = | | | | 13/114750 | 9571 | ExclusiveL= ock | t virtualxid | | | | | 10/120119 | = | | | | 10/120119 | 9565 | ExclusiveL= ock | t relation | 42539 | 90444 | | | | = | | | | 20/33 | 9593 | ShareLock = | t relation | 42539 | 90444 | | | | = | | | | 20/33 | 9593 | AccessExcl= usiveLock | t relation | 42539 | 93051 | | | | = | | | | 15/111991 | 9590 | ShareLock = | t relation | 42539 | 93051 | | | | = | | | | 15/111991 | 9590 | AccessExcl= usiveLock | t relation | 42539 | 93054 | | | | = | | | | 15/111991 | 9590 | ShareLock = | t relation | 42539 | 93054 | | | | = | | | | 15/111991 | 9590 | AccessExcl= usiveLock | t relation | 42539 | 103509 | | | | = | | | | 16/99223 | 9508 | ShareLock = | t relation | 42539 | 103509 | | | | = | | | | 16/99223 | 9508 | AccessExcl= usiveLock | t relation | 42539 | 45416 | | | | = | | | | 9/122742 | 9530 | AccessShar= eLock | t virtualxid | | | | | 16/99223 | = | | | | 16/99223 | 9508 | ExclusiveL= ock | t relation | 42539 | 45415 | | | | = | | | | 9/122742 | 9530 | AccessShar= eLock | t virtualxid | | | | | 9/122742 | = | | | | 9/122742 | 9530 | ExclusiveL= ock | t relation | 42539 | 82700 | | | | = | | | | 17/43658 | 9452 | AccessExcl= usiveLock | t relation | 42539 | 90447 | | | | = | | | | 20/33 | 9593 | ShareLock = | t relation | 42539 | 90447 | | | | = | | | | 20/33 | 9593 | AccessExcl= usiveLock | t relation | 42539 | 50027 | | | | = | | | | 10/120119 | 9565 | RowExclusi= veLock | t transactionid | | | | | | 286= 15216 | | | | 16/99223 | 9508 | ExclusiveL= ock | t relation | 42539 | 2168412 | | | | = | | | | 12/128804 | 9569 | ShareUpdat= eExclusiveLock | t virtualxid | | | | | 17/43658 | = | | | | 17/43658 | 9452 | ExclusiveL= ock | t relation | 42539 | 87759 | | | | = | | | | 1/170439 | 9189 | ShareLock = | t relation | 42539 | 87759 | | | | = | | | | 1/170439 | 9189 | AccessExcl= usiveLock | t transactionid | | | | | | 286= 15215 | | | | 15/111991 | 9590 | ExclusiveL= ock | t relation | 42539 | 50026 | | | | = | | | | 10/120119 | 9565 | RowExclusi= veLock | t transactionid | | | | | | 286= 15217 | | | | 8/140596 | 9364 | ExclusiveL= ock | t relation | 42539 | 2168419 | | | | = | | | | 12/128804 | 9569 | AccessShar= eLock | t relation | 42539 | 85233 | | | | = | | | | 8/140596 | 9364 | ShareLock = | t relation | 42539 | 85233 | | | | = | | | | 8/140596 | 9364 | AccessExcl= usiveLock | t relation | 42539 | 85235 | | | | = | | | | 8/140596 | 9364 | AccessExcl= usiveLock | t (63 rows) ###########################################################################= ############" ###########################################################################= ############" ###########################################################################= ############" Here is the state 5 minutes after changes of autovacuum thresholds : LOAD 1 minute : 16.4 vmstat 1 : procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu--= -- r b swpd free buff cache si so bi bo in cs us sy id = wa 0 14 835088 58252 161736 10309624 0 0 5580 52 1381 1427 0 0 4= 9 51 0 10 835088 57012 161724 10310472 0 0 6304 56 1403 1823 0 0 6= 5 35 0 7 835088 56328 161700 10312044 0 0 5892 40 1367 2482 0 0 8= 6 14 0 5 835088 55584 161692 10311892 0 0 6232 232 1454 2675 0 0 9= 2 7 0 6 835088 59444 161616 10308496 0 0 7240 3108 1508 2407 0 0 9= 3 6 0 13 835088 61024 161620 10306632 0 0 5040 20 1266 1514 0 0 8= 1 19 1 15 835088 59412 161636 10307920 0 0 6184 1012 1511 1503 1 0 6= 5 34 0 13 835088 55320 161644 10311396 0 0 4908 4548 1460 1466 1 0 6= 8 31 0 10 835088 55676 161624 10311552 0 0 5460 1236 1322 1595 0 0 6= 4 35 0 8 835088 55676 161616 10311452 0 0 5412 488 1386 1709 0 0 7= 5 25 0 7 835088 55740 161624 10311924 0 0 5264 204 1302 2145 0 0 7= 9 20 0 7 835088 59068 161624 10308456 0 0 5948 568 1363 2454 0 0 7= 9 20 0 9 835088 57580 161640 10309812 0 0 7012 1548 1443 2664 0 0 8= 0 19 0 7 835088 56648 161644 10311844 0 0 6912 56 1444 2452 0 0 8= 1 18 0 7 835088 55176 161648 10313636 0 0 7200 716 1397 2503 0 0 8= 7 13 0 7 835088 63104 161572 10305228 0 0 4960 12 1324 2452 0 0 9= 1 9 1 5 835088 58144 161580 10309428 0 0 3960 2160 1334 2551 1 0 8= 7 12 0 5 835088 57880 161520 10309432 0 0 5432 4184 1517 2342 1 0 8= 6 13 2 6 835088 58652 161348 10308900 0 0 4800 0 1409 2222 0 0 8= 7 13 0 6 835088 58496 161320 10308456 0 0 5144 15740 1426 2231 0 0 8= 7 13 0 6 835088 57396 161340 10309544 0 0 5956 16 1510 2359 0 0 8= 7 13 0 7 835088 57928 161344 10308664 0 0 4996 12800 1510 2286 0 0 8= 7 13 0 5 835088 59524 161360 10307244 0 0 3892 15032 1490 2224 1 0 9= 0 9 0 13 835088 58364 161372 10307468 0 0 5272 120 1527 2096 0 0 9= 4 6 1 11 835088 57504 161364 10308012 0 0 4968 11188 1496 1830 1 0 8= 7 12 0 12 835088 59280 161376 10307464 0 0 4732 348 1448 1287 1 0 8= 7 12 0 11 835088 57548 161152 10308528 0 0 6096 632 1388 1421 0 0 8= 7 13 0 12 835088 57380 160996 10309848 0 0 5892 0 1426 1431 0 0 8= 7 13 0 13 835088 57184 160936 10310072 0 0 5184 1032 1451 1332 0 0 8= 6 14 0 12 835088 59812 160744 10308436 0 0 4180 0 1363 1349 0 0 8= 7 13 0 11 835088 59892 160756 10308440 0 0 5664 4 1465 1280 0 0 8= 7 13 0 12 835088 55840 160764 10312860 0 0 4408 2196 1343 1280 0 0 9= 1 9 0 11 835088 59840 160564 10309784 0 0 5908 4 1515 1279 0 0 8= 7 13 0 10 835088 56016 160572 10313336 0 0 4088 0 1288 1272 0 0 8= 7 13 0 11 835088 56868 160512 10314216 0 0 5856 368 1333 1730 0 0 8= 6 13 0 11 835088 57364 160500 10314208 0 0 5388 12 1736 1659 0 0 8= 6 14 0 12 835088 57240 160488 10314340 0 0 5320 0 1749 1259 0 0 8= 6 14 0 9 835088 56868 160472 10314544 0 0 5588 16 1756 1405 0 0 8= 7 13 0 10 835088 56752 160464 10315480 0 0 5472 40 1684 1571 0 0 8= 6 13 0 6 835088 56908 160448 10314812 0 0 5008 44 1707 2104 0 0 9= 1 9 0 15 835080 74532 160464 10320344 0 0 5244 2280 1656 1497 0 0 8= 7 12 0 14 835080 68704 160476 10326004 0 0 5732 20 1700 1306 0 0 7= 8 21 0 11 835080 63992 160476 10330436 0 0 4400 32 1735 1399 0 0 7= 6 24 0 11 835080 58836 160496 10335780 0 0 5416 420 1883 1636 1 0 7= 7 22 1 9 835080 57512 160464 10325176 0 0 4892 1220 2289 2061 4 0 7= 3 23 0 6 835080 59156 160348 10321712 0 0 4908 11312 1911 1892 3 0 6= 9 28 0 7 835080 59048 160340 10323272 0 0 5740 0 1848 1529 0 0 7= 3 27 2 17 835080 57544 160348 10324648 0 0 6196 1340 1824 1538 0 0 8= 2 18 0 13 835080 85816 160136 10297068 0 0 5928 8 1997 1372 0 0 8= 0 19 0 16 835080 77104 160144 10305592 0 0 8336 156 2282 1360 1 0 7= 4 25 ps aux | grep postgres : postgres 9189 2.2 4.7 991916 777892 ? Ss 08:45 1:13 postgres: = asa flows 10.48.168.160(35031) idle in transaction=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20 postgres 9363 2.3 3.0 973312 493688 ? Ss 09:15 0:33 postgres: = asa flows 10.48.168.160(35091) idle in transaction=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20 postgres 9364 2.2 3.4 979872 573856 ? Ss 09:15 0:32 postgres: = asa flows 10.48.168.160(35092) idle in transaction=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20 postgres 9450 1.6 2.3 980604 386856 ? Ss 09:20 0:19 postgres: = asa flows 10.48.168.160(35104) idle in transaction=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20 postgres 9452 1.8 2.8 981196 476572 ? Ss 09:20 0:21 postgres: = asa flows 10.48.168.160(35106) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9505 1.4 1.4 959420 245852 ? Ss 09:30 0:08 postgres: = asa flows 10.48.168.160(35121) idle in transaction=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20 postgres 9507 1.1 1.2 955996 204500 ? Ss 09:30 0:06 postgres: = asa flows 10.48.168.160(35123) idle in transaction=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20 postgres 9508 1.3 1.3 975348 223700 ? Ss 09:30 0:07 postgres: = asa flows 10.48.168.160(35124) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9530 1.6 0.2 896732 33000 ? Ss 09:33 0:05 postgres: = autovacuum worker process flows=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9565 0.3 0.1 900472 26828 ? Ds 09:34 0:01 postgres: = autovacuum worker process flows=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9569 1.0 0.1 896732 30896 ? Ds 09:34 0:02 postgres: = autovacuum worker process flows=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 root 9570 0.0 0.0 69516 3236 pts/3 S+ 09:34 0:00 /usr/lib/p= ostgresql/8.4/bin/psql -U asa flows postgres 9571 0.0 0.0 887536 6160 ? Ss 09:34 0:00 postgres: = asa flows [local] idle=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9590 19.0 0.6 927648 99308 ? Ss 09:39 0:01 postgres: = asa flows 10.48.168.160(35128) idle in transaction=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20 postgres 9591 18.8 0.6 931956 101248 ? Ss 09:39 0:01 postgres: = asa flows 10.48.168.160(35129) idle in transaction=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20 postgres 9592 10.6 0.4 927432 81084 ? Ss 09:39 0:00 postgres: = asa flows 10.48.168.160(35130) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9593 13.3 0.5 927836 87920 ? Ss 09:39 0:00 postgres: = asa flows 10.48.168.160(35131) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 root 9595 0.0 0.0 7552 876 pts/2 S+ 09:39 0:00 grep postg= res postgres 11433 0.0 0.1 885744 26056 ? S Dec20 0:17 /usr/lib/p= ostgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main -c config_file= =3D/etc/postgresql/8.4/main/postgresql.conf postgres 11435 0.0 4.8 889276 790012 ? Ss Dec20 10:44 postgres: = writer process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20 postgres 11436 0.0 0.0 886124 704 ? Ss Dec20 1:47 postgres: = wal writer process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20 postgres 11437 0.0 0.0 894472 5104 ? Ss Dec20 4:42 postgres: = autovacuum launcher process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 11438 0.1 0.0 81956 4768 ? Ss Dec20 13:53 postgres: = stats collector process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 12443 0.0 4.9 903820 810512 ? Ss Dec20 0:58 postgres: = asa flows 10.48.168.163(58799) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 12444 0.0 5.1 945064 844596 ? Ss Dec20 6:09 postgres: = asa flows 10.48.168.163(58800) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 12453 0.0 0.0 887384 6864 ? Ss Dec20 0:00 postgres: = asa flows 10.48.168.163(58801) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 26141 0.3 5.3 976928 885892 ? Ss Dec22 33:47 postgres: = asa flows 10.48.168.160(40884) idle select * from pg_stat_activity : datid | datname | procpid | usesysid | usename | = current_query = | waiting | xact_start | query_start = | backend_start | client_addr | client_port=20 -------+---------+---------+----------+----------+-------------------------= ---------------------------------------------------------------------------= ---+---------+-------------------------------+-----------------------------= --+-------------------------------+---------------+------------- 42539 | flows | 9189 | 16384 | asa | CREATE INDEX "flowpool_3= 1_segment_121_timestamp" ON "flowpool_31_segment_121" USING btree (timestam= p) | f | 2012-12-28 09:45:07.277654+01 | 2012-12-28 09:45:07.277704+0= 1 | 2012-12-28 08:45:15.923245+01 | 10.48.168.160 | 35031 42539 | flows | 12443 | 16384 | asa | = = | f | | 2012-12-27 21:30:35.767577+0= 1 | 2012-12-20 13:00:09.968633+01 | 10.48.168.163 | 58799 42539 | flows | 9505 | 16384 | asa | = = | f | | 2012-12-28 09:39:38.19554+01= | 2012-12-28 09:30:17.273639+01 | 10.48.168.160 | 35121 42539 | flows | 12444 | 16384 | asa | = = | f | | 2012-12-27 15:15:22.785422+0= 1 | 2012-12-20 13:00:16.82323+01 | 10.48.168.163 | 58800 42539 | flows | 12453 | 16384 | asa | = = | f | | 2012-12-20 13:01:15.019182+0= 1 | 2012-12-20 13:01:15.015847+01 | 10.48.168.163 | 58801 42539 | flows | 26141 | 16384 | asa | = = | f | | 2012-12-28 06:19:58.348495+0= 1 | 2012-12-22 06:00:55.453306+01 | 10.48.168.160 | 40884 42539 | flows | 9364 | 16384 | asa | CREATE INDEX "flowpool_1= 5_segment_129_timestamp" ON "flowpool_15_segment_129" USING btree (timestam= p) | f | 2012-12-28 09:45:04.464606+01 | 2012-12-28 09:45:04.464668+0= 1 | 2012-12-28 09:15:23.179672+01 | 10.48.168.160 | 35092 42539 | flows | 9530 | 10 | postgres | autovacuum: ANALYZE publ= ic.agg_t93_incoming_a7_src_port_and_proto_f5 = | f | 2012-12-28 09:47:25.338923+01 | 2012-12-28 09:47:25.338923+0= 1 | 2012-12-28 09:33:37.591954+01 | |=20=20=20=20=20=20=20=20= =20=20=20=20 42539 | flows | 9565 | 10 | postgres | autovacuum: VACUUM ANALY= ZE public.agg_t482_outgoing_a7_src_port_and_proto_f5 = | f | 2012-12-28 09:41:47.314486+01 | 2012-12-28 09:41:47.314486+0= 1 | 2012-12-28 09:34:07.609676+01 | |=20=20=20=20=20=20=20=20= =20=20=20=20 42539 | flows | 9569 | 10 | postgres | autovacuum: ANALYZE publ= ic.agg_t1257_incoming_a7_src_port_and_proto_f5 = | f | 2012-12-28 09:47:50.63221+01 | 2012-12-28 09:47:50.63221+01= | 2012-12-28 09:34:37.627542+01 | |=20=20=20=20=20=20=20=20= =20=20=20=20 42539 | flows | 9571 | 16384 | asa | select * from pg_stat_ac= tivity; = | f | 2012-12-28 09:48:02.711778+01 | 2012-12-28 09:48:02.711778+0= 1 | 2012-12-28 09:34:44.817718+01 | | -1 42539 | flows | 9590 | 16384 | asa | CREATE INDEX "flowpool_2= 9_segment_132_timestamp" ON "flowpool_29_segment_132" USING btree (timestam= p) | f | 2012-12-28 09:45:05.258448+01 | 2012-12-28 09:45:05.258499+0= 1 | 2012-12-28 09:39:20.604855+01 | 10.48.168.160 | 35128 42539 | flows | 9508 | 16384 | asa | CREATE INDEX "flowpool_2= 6_segment_139_timestamp" ON "flowpool_26_segment_139" USING btree (timestam= p) | f | 2012-12-28 09:45:04.296674+01 | 2012-12-28 09:45:04.296732+0= 1 | 2012-12-28 09:30:17.487318+01 | 10.48.168.160 | 35124 42539 | flows | 9452 | 16384 | asa | CREATE INDEX "flowpool_2= 1_segment_136_timestamp" ON "flowpool_21_segment_136" USING btree (timestam= p) | f | 2012-12-28 09:45:06.741216+01 | 2012-12-28 09:45:06.741271+0= 1 | 2012-12-28 09:20:20.385564+01 | 10.48.168.160 | 35106 42539 | flows | 9592 | 16384 | asa | CREATE INDEX "flowpool_1= 7_segment_124_timestamp" ON "flowpool_17_segment_124" USING btree (timestam= p) | f | 2012-12-28 09:45:05.966266+01 | 2012-12-28 09:45:05.966332+0= 1 | 2012-12-28 09:39:20.649273+01 | 10.48.168.160 | 35130 42539 | flows | 9593 | 16384 | asa | CREATE INDEX "flowpool_2= _segment_131_timestamp" ON "flowpool_2_segment_131" USING btree (timestamp)= | f | 2012-12-28 09:45:03.358737+01 | 2012-12-28 09:45:03.358818+0= 1 | 2012-12-28 09:39:20.671335+01 | 10.48.168.160 | 35131 (16 rows) select * from pg_locks : locktype | database | relation | page | tuple | virtualxid | transact= ionid | classid | objid | objsubid | virtualtransaction | pid | = mode | granted=20 ---------------+----------+----------+------+-------+------------+---------= ------+---------+-------+----------+--------------------+------+-----------= ---------------+--------- relation | 42539 | 6691584 | | | | = | | | | 9/122762 | 9530 | ShareUpdat= eExclusiveLock | t relation | 42539 | 2168206 | | | | = | | | | 12/128806 | 9569 | AccessShar= eLock | t transactionid | | | | | | 286= 15251 | | | | 8/140603 | 9364 | ExclusiveL= ock | t relation | 42539 | 6691588 | | | | = | | | | 9/122762 | 9530 | AccessShar= eLock | t transactionid | | | | | | 286= 15278 | | | | 1/170450 | 9189 | ExclusiveL= ock | t relation | 42539 | 103506 | | | | = | | | | 16/99231 | 9508 | AccessShar= eLock | t relation | 42539 | 103506 | | | | = | | | | 16/99231 | 9508 | ShareLock = | t relation | 42539 | 7252363 | | | | = | | | | 1/170450 | 9189 | AccessExcl= usiveLock | t relation | 42539 | 105969 | | | | = | | | | 19/311 | 9592 | AccessShar= eLock | t relation | 42539 | 105969 | | | | = | | | | 19/311 | 9592 | ShareLock = | t relation | 42539 | 85230 | | | | = | | | | 8/140603 | 9364 | AccessShar= eLock | t relation | 42539 | 85230 | | | | = | | | | 8/140603 | 9364 | ShareLock = | t relation | 42539 | 7252359 | | | | = | | | | 8/140603 | 9364 | AccessExcl= usiveLock | t relation | 42539 | 87756 | | | | = | | | | 1/170450 | 9189 | AccessShar= eLock | t relation | 42539 | 87756 | | | | = | | | | 1/170450 | 9189 | ShareLock = | t relation | 42539 | 82695 | | | | = | | | | 17/43667 | 9452 | AccessShar= eLock | t relation | 42539 | 82695 | | | | = | | | | 17/43667 | 9452 | ShareLock = | t transactionid | | | | | | 286= 15238 | | | | 20/36 | 9593 | ExclusiveL= ock | t transactionid | | | | | | 286= 15271 | | | | 17/43667 | 9452 | ExclusiveL= ock | t virtualxid | | | | | 17/43667 | = | | | | 17/43667 | 9452 | ExclusiveL= ock | t relation | 42539 | 50023 | | | | = | | | | 10/120119 | 9565 | ShareUpdat= eExclusiveLock | t relation | 42539 | 7252361 | | | | = | | | | 19/311 | 9592 | AccessExcl= usiveLock | t virtualxid | | | | | 9/122762 | = | | | | 9/122762 | 9530 | ExclusiveL= ock | t transactionid | | | | | | 286= 15262 | | | | 15/112000 | 9590 | ExclusiveL= ock | t virtualxid | | | | | 13/114752 | = | | | | 13/114752 | 9571 | ExclusiveL= ock | t relation | 42539 | 6691587 | | | | = | | | | 9/122762 | 9530 | AccessShar= eLock | t transactionid | | | | | | 286= 15266 | | | | 19/311 | 9592 | ExclusiveL= ock | t virtualxid | | | | | 1/170450 | = | | | | 1/170450 | 9189 | ExclusiveL= ock | t relation | 42539 | 10969 | | | | = | | | | 13/114752 | 9571 | AccessShar= eLock | t virtualxid | | | | | 19/311 | = | | | | 19/311 | 9592 | ExclusiveL= ock | t relation | 42539 | 7252362 | | | | = | | | | 17/43667 | 9452 | AccessExcl= usiveLock | t virtualxid | | | | | 10/120119 | = | | | | 10/120119 | 9565 | ExclusiveL= ock | t relation | 42539 | 90444 | | | | = | | | | 20/36 | 9593 | AccessShar= eLock | t relation | 42539 | 90444 | | | | = | | | | 20/36 | 9593 | ShareLock = | t relation | 42539 | 7252360 | | | | = | | | | 15/112000 | 9590 | AccessExcl= usiveLock | t relation | 42539 | 93051 | | | | = | | | | 15/112000 | 9590 | AccessShar= eLock | t relation | 42539 | 93051 | | | | = | | | | 15/112000 | 9590 | ShareLock = | t transactionid | | | | | | 286= 15245 | | | | 16/99231 | 9508 | ExclusiveL= ock | t relation | 42539 | 2168202 | | | | = | | | | 12/128806 | 9569 | ShareUpdat= eExclusiveLock | t virtualxid | | | | | 12/128806 | = | | | | 12/128806 | 9569 | ExclusiveL= ock | t virtualxid | | | | | 20/36 | = | | | | 20/36 | 9593 | ExclusiveL= ock | t relation | 42539 | 7252358 | | | | = | | | | 16/99231 | 9508 | AccessExcl= usiveLock | t relation | 42539 | 7252357 | | | | = | | | | 20/36 | 9593 | AccessExcl= usiveLock | t relation | 42539 | 2168205 | | | | = | | | | 12/128806 | 9569 | AccessShar= eLock | t relation | 42539 | 50027 | | | | = | | | | 10/120119 | 9565 | RowExclusi= veLock | t virtualxid | | | | | 15/112000 | = | | | | 15/112000 | 9590 | ExclusiveL= ock | t virtualxid | | | | | 16/99231 | = | | | | 16/99231 | 9508 | ExclusiveL= ock | t relation | 42539 | 50026 | | | | = | | | | 10/120119 | 9565 | RowExclusi= veLock | t virtualxid | | | | | 8/140603 | = | | | | 8/140603 | 9364 | ExclusiveL= ock | t (49 rows) ###########################################################################= ############" ###########################################################################= ############" ###########################################################################= ############" Here is the state 10 minutes after changes of autovacuum thresholds : LOAD 1 minute : 15.6 vmstat 1 : procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu--= -- r b swpd free buff cache si so bi bo in cs us sy id = wa 0 10 834996 55696 118652 10404024 0 0 4820 328 1421 1617 0 0 5= 6 44 0 8 834996 56680 118660 10402664 0 0 3992 8 1396 1769 0 0 6= 6 33 0 7 834996 59024 118664 10400968 0 0 3204 348 1397 1710 0 0 7= 3 27 0 7 834996 60140 118672 10399404 0 0 3360 72 1558 2342 0 0 7= 5 24 0 6 834996 55692 118684 10403244 0 0 3808 308 1617 1977 0 0 7= 6 24 0 6 834996 57304 118692 10401984 0 0 3912 0 1498 1592 0 0 8= 1 19 0 12 834996 59408 118700 10399908 0 0 3000 748 1652 1805 0 0 7= 7 23 0 13 834996 56432 118704 10403092 0 0 3276 284 1654 1578 0 0 6= 9 31 0 13 834996 58292 118712 10401204 0 0 3496 328 1483 1552 0 0 6= 9 31 0 12 834996 55120 118724 10404192 0 0 2892 432 1473 1562 0 0 6= 9 31 0 12 834996 78920 118652 10380460 0 0 3496 380 1428 1588 0 0 6= 9 31 0 11 834996 75588 118660 10383892 0 0 3136 556 1351 1581 0 0 6= 9 31 0 7 834996 71356 118672 10388272 0 0 4276 396 1588 1885 0 0 6= 9 31 0 6 834996 67484 118680 10391660 0 0 3264 468 1545 2624 0 0 8= 1 19 0 6 834996 63636 118688 10395932 0 0 3668 320 1578 2570 0 0 8= 1 19 0 5 834996 59668 118696 10399928 0 0 3592 464 1457 2379 0 0 8= 1 19 0 14 834996 55696 118708 10403812 0 0 3776 8 1292 1688 0 0 6= 8 31 0 14 834996 57264 118716 10401760 0 0 4256 320 1352 1548 0 0 5= 0 50 0 15 834996 59096 118728 10400508 0 0 3668 464 1381 1549 0 0 5= 0 50 0 15 834996 59696 118732 10399452 0 0 5320 288 1422 1434 0 0 5= 1 49 0 14 834996 56720 118736 10402704 0 0 3252 700 1348 1526 0 0 5= 0 50 0 14 834996 58604 118740 10401152 0 0 3636 208 1432 1560 0 0 5= 1 49 0 13 834996 55488 118748 10404420 0 0 3648 264 1371 1638 0 0 5= 6 44 1 13 834996 56532 118756 10403112 0 0 4168 292 1383 1646 0 0 6= 0 40 0 10 834996 58512 118760 10400596 0 0 3520 376 1334 1694 0 0 7= 3 27 0 10 834996 60372 118764 10398720 0 0 3952 344 1370 1827 0 0 6= 9 31 0 8 834996 55284 118772 10403200 0 0 4216 24 1318 2107 0 0 7= 1 29 0 6 834996 56772 118780 10402160 0 0 3584 352 1188 2098 0 0 8= 0 19 0 7 834996 59004 118776 10399448 0 0 3112 504 1194 1742 0 0 7= 9 21 0 10 834996 55176 118784 10403092 0 0 3864 400 1315 1794 0 0 7= 5 25 1 12 834996 55796 118772 10402840 0 0 4328 612 1355 1811 0 0 7= 5 25 0 11 834996 58012 118760 10400376 0 0 2860 844 1205 1595 0 0 7= 5 25 0 11 834996 59888 118772 10399060 0 0 3620 328 1285 1562 0 0 7= 5 25 0 10 834996 55656 118780 10402796 0 0 4024 464 1372 1925 0 0 7= 5 25 0 6 834996 57472 118788 10400696 0 0 3856 380 1362 2005 0 0 7= 7 23 0 7 834996 58588 118792 10399660 0 0 4192 328 1410 2415 0 0 8= 0 20 0 5 834996 55116 118796 10402884 0 0 3056 8 1354 2426 0 0 8= 1 19 1 6 834996 57364 118808 10400528 0 0 2764 304 1225 2465 0 0 8= 1 19 0 6 834996 58620 118812 10399676 0 0 3920 0 1243 2197 0 0 8= 0 19 0 17 834996 55268 118820 10402988 0 0 3004 480 1202 1796 0 0 7= 9 21 0 16 834996 58368 118824 10400072 0 0 3240 220 1097 1543 0 0 7= 5 25 0 16 834996 59856 118836 10398692 0 0 4188 0 1214 1492 0 0 7= 5 25 0 16 834996 56488 118840 10401720 0 0 3228 628 1206 1455 0 0 7= 5 25 0 16 834996 59216 118848 10399460 0 0 3792 428 1264 1397 0 0 7= 6 24 ps aux | grep postgres : postgres 9189 1.9 4.7 991916 782084 ? Ds 08:45 1:17 postgres: = asa flows 10.48.168.160(35031) CREATE INDEX=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20 postgres 9364 1.5 3.6 979872 598028 ? Ds 09:15 0:36 postgres: = asa flows 10.48.168.160(35092) CREATE INDEX=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20 postgres 9452 1.2 3.0 981196 499464 ? Ds 09:20 0:25 postgres: = asa flows 10.48.168.160(35106) CREATE INDEX=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20 postgres 9505 0.5 1.5 965564 249164 ? Ss 09:30 0:08 postgres: = asa flows 10.48.168.160(35121) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9508 0.8 1.5 955892 255448 ? Ds 09:30 0:12 postgres: = asa flows 10.48.168.160(35124) CREATE INDEX=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20 postgres 9530 1.1 0.2 896732 38028 ? Ds 09:33 0:13 postgres: = autovacuum worker process flows=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9565 0.5 0.2 1093852 34268 ? Ss 09:34 0:06 postgres: = autovacuum worker process flows=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9569 0.5 0.1 896732 31948 ? Ds 09:34 0:06 postgres: = autovacuum worker process flows=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 root 9570 0.0 0.0 69516 3264 pts/3 S+ 09:34 0:00 /usr/lib/p= ostgresql/8.4/bin/psql -U asa flows postgres 9571 0.0 0.0 887600 6768 ? Ss 09:34 0:00 postgres: = asa flows [local] idle=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9590 0.6 1.2 965716 211248 ? Ds 09:39 0:05 postgres: = asa flows 10.48.168.160(35128) CREATE INDEX=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20 postgres 9592 0.6 1.2 963228 199132 ? Ds 09:39 0:05 postgres: = asa flows 10.48.168.160(35130) CREATE INDEX=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20 postgres 9593 1.7 1.9 962992 327904 ? Ds 09:39 0:14 postgres: = asa flows 10.48.168.160(35131) CREATE INDEX=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20 root 9623 0.0 0.0 7552 872 pts/2 S+ 09:53 0:00 grep postg= res postgres 11433 0.0 0.1 885744 26056 ? S Dec20 0:17 /usr/lib/p= ostgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main -c config_file= =3D/etc/postgresql/8.4/main/postgresql.conf postgres 11435 0.0 4.8 889276 790016 ? Ds Dec20 10:44 postgres: = writer process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20 postgres 11436 0.0 0.0 886124 704 ? Ss Dec20 1:47 postgres: = wal writer process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20 postgres 11437 0.0 0.0 894472 5104 ? Ss Dec20 4:42 postgres: = autovacuum launcher process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 11438 0.1 0.0 81956 4768 ? Ss Dec20 13:53 postgres: = stats collector process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 12443 0.0 4.9 903820 810512 ? Ss Dec20 0:58 postgres: = asa flows 10.48.168.163(58799) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 12444 0.0 5.1 945064 844596 ? Ss Dec20 6:09 postgres: = asa flows 10.48.168.163(58800) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 12453 0.0 0.0 887384 6864 ? Ss Dec20 0:00 postgres: = asa flows 10.48.168.163(58801) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 26141 0.3 5.3 976928 885892 ? Ss Dec22 33:47 postgres: = asa flows 10.48.168.160(40884) idle=20 select * from pg_stat_activity : datid | datname | procpid | usesysid | usename | = current_query = | waiting | xact_start | query_start = | backend_start | client_addr | client_port=20 -------+---------+---------+----------+----------+-------------------------= ---------------------------------------------------------------------------= ---+---------+-------------------------------+-----------------------------= --+-------------------------------+---------------+------------- 42539 | flows | 9189 | 16384 | asa | CREATE INDEX "flowpool_3= 1_segment_121_timestamp" ON "flowpool_31_segment_121" USING btree (timestam= p) | f | 2012-12-28 09:45:07.277654+01 | 2012-12-28 09:45:07.277704+0= 1 | 2012-12-28 08:45:15.923245+01 | 10.48.168.160 | 35031 42539 | flows | 12443 | 16384 | asa | = = | f | | 2012-12-27 21:30:35.767577+0= 1 | 2012-12-20 13:00:09.968633+01 | 10.48.168.163 | 58799 42539 | flows | 9505 | 16384 | asa | = = | f | | 2012-12-28 09:39:38.19554+01= | 2012-12-28 09:30:17.273639+01 | 10.48.168.160 | 35121 42539 | flows | 12444 | 16384 | asa | = = | f | | 2012-12-27 15:15:22.785422+0= 1 | 2012-12-20 13:00:16.82323+01 | 10.48.168.163 | 58800 42539 | flows | 12453 | 16384 | asa | = = | f | | 2012-12-20 13:01:15.019182+0= 1 | 2012-12-20 13:01:15.015847+01 | 10.48.168.163 | 58801 42539 | flows | 26141 | 16384 | asa | = = | f | | 2012-12-28 06:19:58.348495+0= 1 | 2012-12-22 06:00:55.453306+01 | 10.48.168.160 | 40884 42539 | flows | 9364 | 16384 | asa | CREATE INDEX "flowpool_1= 5_segment_129_timestamp" ON "flowpool_15_segment_129" USING btree (timestam= p) | f | 2012-12-28 09:45:04.464606+01 | 2012-12-28 09:45:04.464668+0= 1 | 2012-12-28 09:15:23.179672+01 | 10.48.168.160 | 35092 42539 | flows | 9530 | 10 | postgres | autovacuum: ANALYZE publ= ic.agg_t253_incoming_a6_dst_port_and_proto_f5 = | f | 2012-12-28 09:50:19.161336+01 | 2012-12-28 09:50:19.161336+0= 1 | 2012-12-28 09:33:37.591954+01 | |=20=20=20=20=20=20=20=20= =20=20=20=20 42539 | flows | 9565 | 10 | postgres | autovacuum: VACUUM ANALY= ZE public.agg_t482_outgoing_a7_src_port_and_proto_f5 = | f | 2012-12-28 09:41:47.314486+01 | 2012-12-28 09:41:47.314486+0= 1 | 2012-12-28 09:34:07.609676+01 | |=20=20=20=20=20=20=20=20= =20=20=20=20 42539 | flows | 9569 | 10 | postgres | autovacuum: ANALYZE publ= ic.agg_t1244_outgoing_a6_dst_port_and_proto_f5 = | f | 2012-12-28 09:53:34.831039+01 | 2012-12-28 09:53:34.831039+0= 1 | 2012-12-28 09:34:37.627542+01 | |=20=20=20=20=20=20=20=20= =20=20=20=20 42539 | flows | 9571 | 16384 | asa | select * from pg_stat_ac= tivity; = | f | 2012-12-28 09:53:40.35896+01 | 2012-12-28 09:53:40.35896+01= | 2012-12-28 09:34:44.817718+01 | | -1 42539 | flows | 9590 | 16384 | asa | CREATE INDEX "flowpool_2= 9_segment_132_timestamp" ON "flowpool_29_segment_132" USING btree (timestam= p) | f | 2012-12-28 09:45:05.258448+01 | 2012-12-28 09:45:05.258499+0= 1 | 2012-12-28 09:39:20.604855+01 | 10.48.168.160 | 35128 42539 | flows | 9508 | 16384 | asa | CREATE INDEX "flowpool_2= 6_segment_139_timestamp" ON "flowpool_26_segment_139" USING btree (timestam= p) | f | 2012-12-28 09:45:04.296674+01 | 2012-12-28 09:45:04.296732+0= 1 | 2012-12-28 09:30:17.487318+01 | 10.48.168.160 | 35124 42539 | flows | 9452 | 16384 | asa | CREATE INDEX "flowpool_2= 1_segment_136_timestamp" ON "flowpool_21_segment_136" USING btree (timestam= p) | f | 2012-12-28 09:45:06.741216+01 | 2012-12-28 09:45:06.741271+0= 1 | 2012-12-28 09:20:20.385564+01 | 10.48.168.160 | 35106 42539 | flows | 9592 | 16384 | asa | CREATE INDEX "flowpool_1= 7_segment_124_timestamp" ON "flowpool_17_segment_124" USING btree (timestam= p) | f | 2012-12-28 09:45:05.966266+01 | 2012-12-28 09:45:05.966332+0= 1 | 2012-12-28 09:39:20.649273+01 | 10.48.168.160 | 35130 42539 | flows | 9593 | 16384 | asa | CREATE INDEX "flowpool_2= _segment_131_timestamp" ON "flowpool_2_segment_131" USING btree (timestamp)= | f | 2012-12-28 09:45:03.358737+01 | 2012-12-28 09:45:03.358818+0= 1 | 2012-12-28 09:39:20.671335+01 | 10.48.168.160 | 35131 (16 rows) =20=20 select * from pg_locks : locktype | database | relation | page | tuple | virtualxid | transact= ionid | classid | objid | objsubid | virtualtransaction | pid | = mode | granted=20 ---------------+----------+----------+------+-------+------------+---------= ------+---------+-------+----------+--------------------+------+-----------= ---------------+--------- transactionid | | | | | | 286= 15251 | | | | 8/140603 | 9364 | ExclusiveL= ock | t relation | 42539 | 6690376 | | | | = | | | | 12/128814 | 9569 | AccessShar= eLock | t transactionid | | | | | | 286= 15278 | | | | 1/170450 | 9189 | ExclusiveL= ock | t relation | 42539 | 103506 | | | | = | | | | 16/99231 | 9508 | AccessShar= eLock | t relation | 42539 | 103506 | | | | = | | | | 16/99231 | 9508 | ShareLock = | t relation | 42539 | 6690372 | | | | = | | | | 12/128814 | 9569 | ShareUpdat= eExclusiveLock | t relation | 42539 | 7252363 | | | | = | | | | 1/170450 | 9189 | AccessExcl= usiveLock | t relation | 42539 | 105969 | | | | = | | | | 19/311 | 9592 | AccessShar= eLock | t relation | 42539 | 105969 | | | | = | | | | 19/311 | 9592 | ShareLock = | t relation | 42539 | 85230 | | | | = | | | | 8/140603 | 9364 | AccessShar= eLock | t relation | 42539 | 85230 | | | | = | | | | 8/140603 | 9364 | ShareLock = | t relation | 42539 | 7252359 | | | | = | | | | 8/140603 | 9364 | AccessExcl= usiveLock | t relation | 42539 | 87756 | | | | = | | | | 1/170450 | 9189 | AccessShar= eLock | t relation | 42539 | 87756 | | | | = | | | | 1/170450 | 9189 | ShareLock = | t relation | 42539 | 82695 | | | | = | | | | 17/43667 | 9452 | AccessShar= eLock | t relation | 42539 | 82695 | | | | = | | | | 17/43667 | 9452 | ShareLock = | t transactionid | | | | | | 286= 15238 | | | | 20/36 | 9593 | ExclusiveL= ock | t transactionid | | | | | | 286= 15271 | | | | 17/43667 | 9452 | ExclusiveL= ock | t relation | 42539 | 46103 | | | | = | | | | 9/122774 | 9530 | ShareUpdat= eExclusiveLock | t relation | 42539 | 6690375 | | | | = | | | | 12/128814 | 9569 | AccessShar= eLock | t virtualxid | | | | | 17/43667 | = | | | | 17/43667 | 9452 | ExclusiveL= ock | t relation | 42539 | 50023 | | | | = | | | | 10/120119 | 9565 | ShareUpdat= eExclusiveLock | t relation | 42539 | 7252361 | | | | = | | | | 19/311 | 9592 | AccessExcl= usiveLock | t relation | 42539 | 46107 | | | | = | | | | 9/122774 | 9530 | AccessShar= eLock | t transactionid | | | | | | 286= 15262 | | | | 15/112000 | 9590 | ExclusiveL= ock | t transactionid | | | | | | 286= 15266 | | | | 19/311 | 9592 | ExclusiveL= ock | t virtualxid | | | | | 12/128814 | = | | | | 12/128814 | 9569 | ExclusiveL= ock | t virtualxid | | | | | 1/170450 | = | | | | 1/170450 | 9189 | ExclusiveL= ock | t relation | 42539 | 10969 | | | | = | | | | 13/114754 | 9571 | AccessShar= eLock | t virtualxid | | | | | 19/311 | = | | | | 19/311 | 9592 | ExclusiveL= ock | t relation | 42539 | 7252362 | | | | = | | | | 17/43667 | 9452 | AccessExcl= usiveLock | t virtualxid | | | | | 10/120119 | = | | | | 10/120119 | 9565 | ExclusiveL= ock | t relation | 42539 | 90444 | | | | = | | | | 20/36 | 9593 | AccessShar= eLock | t relation | 42539 | 90444 | | | | = | | | | 20/36 | 9593 | ShareLock = | t relation | 42539 | 7252360 | | | | = | | | | 15/112000 | 9590 | AccessExcl= usiveLock | t relation | 42539 | 93051 | | | | = | | | | 15/112000 | 9590 | AccessShar= eLock | t relation | 42539 | 93051 | | | | = | | | | 15/112000 | 9590 | ShareLock = | t transactionid | | | | | | 286= 15245 | | | | 16/99231 | 9508 | ExclusiveL= ock | t virtualxid | | | | | 13/114754 | = | | | | 13/114754 | 9571 | ExclusiveL= ock | t virtualxid | | | | | 20/36 | = | | | | 20/36 | 9593 | ExclusiveL= ock | t relation | 42539 | 7252358 | | | | = | | | | 16/99231 | 9508 | AccessExcl= usiveLock | t relation | 42539 | 7252357 | | | | = | | | | 20/36 | 9593 | AccessExcl= usiveLock | t relation | 42539 | 50027 | | | | = | | | | 10/120119 | 9565 | RowExclusi= veLock | t virtualxid | | | | | 15/112000 | = | | | | 15/112000 | 9590 | ExclusiveL= ock | t virtualxid | | | | | 16/99231 | = | | | | 16/99231 | 9508 | ExclusiveL= ock | t relation | 42539 | 50026 | | | | = | | | | 10/120119 | 9565 | RowExclusi= veLock | t virtualxid | | | | | 9/122774 | = | | | | 9/122774 | 9530 | ExclusiveL= ock | t relation | 42539 | 46106 | | | | = | | | | 9/122774 | 9530 | AccessShar= eLock | t virtualxid | | | | | 8/140603 | = | | | | 8/140603 | 9364 | ExclusiveL= ock | t (49 rows) ###########################################################################= ############" ###########################################################################= ############" ###########################################################################= ############" Here is the state 15 minutes after changes of autovacuum thresholds : LOAD 1 minute : 16.8 vmstat 1 : procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu--= -- r b swpd free buff cache si so bi bo in cs us sy id = wa 0 13 834996 73132 118760 10381432 0 0 4532 504 1758 1599 0 0 5= 9 41 0 15 834996 68932 118772 10385756 0 0 4180 0 1748 1518 0 0 5= 5 45 0 13 834996 64240 118780 10390472 0 0 4856 316 1884 1547 0 0 6= 4 36 0 13 834996 59032 118788 10395604 0 0 5088 4 2011 1491 0 0 5= 9 40 0 13 834996 61124 118632 10392852 0 0 4768 164 2012 1449 0 0 6= 2 37 0 12 834996 56164 118640 10397920 0 0 5344 224 1986 1644 0 0 6= 7 33 0 10 834996 56288 118644 10397492 0 0 4436 8 1941 1639 0 0 5= 7 43 0 11 834996 57156 118632 10395980 0 0 4668 188 2102 1629 0 0 6= 4 36 0 11 834996 58616 118604 10394936 0 0 4020 8 1922 1625 0 0 6= 2 38 0 11 834996 59236 118604 10394448 0 0 4272 216 1894 1631 0 0 6= 2 37 0 7 834996 59608 118600 10394336 0 0 4536 8 1829 1627 0 0 6= 6 34 1 5 834996 60104 118620 10393908 0 0 4372 240 1868 1658 0 0 8= 3 17 0 6 834996 55888 118620 10398288 0 0 4368 216 1805 1618 0 0 8= 8 12 0 7 834996 56756 118628 10397168 0 0 4036 180 1873 1710 0 0 8= 6 13 0 14 834996 56228 118636 10397536 0 0 4832 264 2032 1480 0 0 6= 8 31 0 13 834996 56384 118644 10397312 0 0 4864 392 1983 1513 0 0 6= 0 40 0 12 834996 57004 118656 10396336 0 0 4244 248 1889 1528 0 0 6= 7 32 0 11 834996 58244 118648 10395476 0 0 4408 12 2005 1569 0 0 7= 0 30 0 9 834996 59104 118660 10395136 0 0 4276 208 1977 1770 0 0 7= 3 26 0 9 834996 59476 118660 10394616 0 0 4124 12 1957 2033 0 0 7= 6 24 0 7 834996 55384 118668 10398184 0 0 3920 300 1971 2170 0 0 7= 7 23 0 6 834996 55384 118680 10398520 0 0 4324 4 1919 2664 0 0 8= 1 18 0 7 834996 55616 118684 10397876 0 0 4852 0 1782 2527 0 0 8= 2 18 0 6 834996 55736 118688 10398392 0 0 5108 296 1704 2549 0 0 8= 3 16 0 5 834996 60324 118684 10393980 0 0 5164 0 1836 2658 0 0 8= 8 12 0 5 834996 55856 118696 10398880 0 0 4476 336 1785 2426 0 0 8= 8 11 0 6 834996 55464 118700 10398700 0 0 4388 484 1787 2649 0 0 8= 7 12 0 13 834996 56472 118708 10398832 0 0 4004 80 1758 1631 0 0 7= 3 26 0 13 834996 57336 118680 10396928 0 0 4328 0 1830 1410 0 0 6= 1 39 0 13 834996 57956 118648 10397092 0 0 4264 336 1726 1368 0 0 6= 0 40 0 13 834996 58684 118616 10396608 0 0 4308 384 1783 1448 0 0 6= 0 40 0 13 834996 59924 118600 10394840 0 0 4048 312 1790 1399 0 0 6= 0 40 0 12 834996 55972 118612 10399244 0 0 3924 768 1676 1405 0 0 6= 0 40 0 13 834996 57072 118620 10398020 0 0 4916 0 1758 1406 0 0 6= 0 40 0 12 834996 56452 118628 10398848 0 0 6432 0 1525 1587 0 0 6= 0 40 0 13 834996 57580 118632 10398060 0 0 4108 344 1575 1486 0 0 7= 3 27 0 13 834996 57980 118640 10398132 0 0 4968 0 1684 1474 0 0 6= 1 38 0 13 834996 59096 118652 10397300 0 0 4012 348 1680 1438 0 0 6= 0 40 0 12 834996 59964 118664 10395604 0 0 4212 824 1681 1448 0 0 6= 0 40 0 11 834996 59948 118668 10395780 0 0 5332 432 1712 1524 0 0 6= 4 36 0 12 834996 59948 118668 10395812 0 0 4996 336 1738 1513 0 0 6= 6 34 0 10 834996 56336 118688 10399036 0 0 2992 320 1338 1791 0 0 7= 3 27 0 12 834996 58444 118700 10396076 0 0 3260 1004 1373 1762 0 0 8= 0 20 0 11 834996 58460 118708 10396224 0 0 4104 1064 1365 1809 0 0 8= 7 13 0 8 834996 56476 118720 10397336 0 0 6052 1696 1583 2360 0 0 8= 1 19 0 11 834996 56352 118736 10397312 0 0 5368 964 1524 1898 0 0 8= 3 17 0 7 834996 55840 118744 10397308 0 0 5076 272 1442 2331 0 0 8= 2 18 0 6 834996 58088 118744 10395432 0 0 6560 1020 1534 2994 0 0 8= 4 16 0 4 834996 57592 118744 10396616 0 0 5848 256 1363 2800 0 0 8= 9 10 2 6 834996 59576 118760 10394408 0 0 6936 204 1505 2983 0 0 8= 9 10 ps aux | grep postgres : postgres 9189 1.7 4.7 991916 782084 ? Ds 08:45 1:17 postgres: = asa flows 10.48.168.160(35031) CREATE INDEX=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20 postgres 9364 1.4 3.6 979872 598028 ? Ds 09:15 0:36 postgres: = asa flows 10.48.168.160(35092) CREATE INDEX=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20 postgres 9452 1.0 3.0 981196 499464 ? Ds 09:20 0:25 postgres: = asa flows 10.48.168.160(35106) CREATE INDEX=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20 postgres 9505 0.4 1.5 965564 249164 ? Ss 09:30 0:08 postgres: = asa flows 10.48.168.160(35121) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9508 0.7 1.5 955892 255448 ? Ds 09:30 0:12 postgres: = asa flows 10.48.168.160(35124) CREATE INDEX=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20 postgres 9530 0.9 0.2 896732 38412 ? Ds 09:33 0:14 postgres: = autovacuum worker process flows=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9565 0.6 0.2 1093852 44832 ? Ds 09:34 0:09 postgres: = autovacuum worker process flows=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9569 0.7 0.2 896732 34680 ? Ds 09:34 0:10 postgres: = autovacuum worker process flows=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 root 9570 0.0 0.0 69512 3260 pts/3 S+ 09:34 0:00 /usr/lib/p= ostgresql/8.4/bin/psql -U asa flows postgres 9571 0.0 0.0 887600 6780 ? Ss 09:34 0:00 postgres: = asa flows [local] idle=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 9590 0.4 1.2 965716 211248 ? Ds 09:39 0:05 postgres: = asa flows 10.48.168.160(35128) CREATE INDEX=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20 postgres 9592 0.4 1.2 963228 199132 ? Ds 09:39 0:05 postgres: = asa flows 10.48.168.160(35130) CREATE INDEX=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20 postgres 9593 1.2 1.9 962992 327904 ? Ds 09:39 0:14 postgres: = asa flows 10.48.168.160(35131) CREATE INDEX=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20 root 9634 0.0 0.0 2452 152 pts/2 D+ 09:58 0:00 grep postg= res postgres 11433 0.0 0.1 885744 26056 ? S Dec20 0:17 /usr/lib/p= ostgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main -c config_file= =3D/etc/postgresql/8.4/main/postgresql.conf postgres 11435 0.0 4.8 889276 790016 ? Ds Dec20 10:44 postgres: = writer process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20 postgres 11436 0.0 0.0 886124 704 ? Ss Dec20 1:47 postgres: = wal writer process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20 postgres 11437 0.0 0.0 894472 5104 ? Ss Dec20 4:42 postgres: = autovacuum launcher process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 11438 0.1 0.0 81956 4768 ? Ss Dec20 13:54 postgres: = stats collector process=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 12443 0.0 4.9 903820 810512 ? Ss Dec20 0:58 postgres: = asa flows 10.48.168.163(58799) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 12444 0.0 5.1 945064 844596 ? Ss Dec20 6:09 postgres: = asa flows 10.48.168.163(58800) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 12453 0.0 0.0 887384 6864 ? Ss Dec20 0:00 postgres: = asa flows 10.48.168.163(58801) idle=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 postgres 26141 0.3 5.3 976928 885892 ? Ss Dec22 33:47 postgres: = asa flows 10.48.168.160(40884) idle select * from pg_stat_activity : datid | datname | procpid | usesysid | usename | = current_query = | waiting | xact_start | query_start = | backend_start | client_addr | client_port=20 -------+---------+---------+----------+----------+-------------------------= ---------------------------------------------------------------------------= ---+---------+-------------------------------+-----------------------------= --+-------------------------------+---------------+------------- 42539 | flows | 9189 | 16384 | asa | CREATE INDEX "flowpool_3= 1_segment_121_timestamp" ON "flowpool_31_segment_121" USING btree (timestam= p) | f | 2012-12-28 09:45:07.277654+01 | 2012-12-28 09:45:07.277704+0= 1 | 2012-12-28 08:45:15.923245+01 | 10.48.168.160 | 35031 42539 | flows | 12443 | 16384 | asa | = = | f | | 2012-12-27 21:30:35.767577+0= 1 | 2012-12-20 13:00:09.968633+01 | 10.48.168.163 | 58799 42539 | flows | 9505 | 16384 | asa | = = | f | | 2012-12-28 09:39:38.19554+01= | 2012-12-28 09:30:17.273639+01 | 10.48.168.160 | 35121 42539 | flows | 12444 | 16384 | asa | = = | f | | 2012-12-27 15:15:22.785422+0= 1 | 2012-12-20 13:00:16.82323+01 | 10.48.168.163 | 58800 42539 | flows | 12453 | 16384 | asa | = = | f | | 2012-12-20 13:01:15.019182+0= 1 | 2012-12-20 13:01:15.015847+01 | 10.48.168.163 | 58801 42539 | flows | 26141 | 16384 | asa | = = | f | | 2012-12-28 06:19:58.348495+0= 1 | 2012-12-22 06:00:55.453306+01 | 10.48.168.160 | 40884 42539 | flows | 9364 | 16384 | asa | CREATE INDEX "flowpool_1= 5_segment_129_timestamp" ON "flowpool_15_segment_129" USING btree (timestam= p) | f | 2012-12-28 09:45:04.464606+01 | 2012-12-28 09:45:04.464668+0= 1 | 2012-12-28 09:15:23.179672+01 | 10.48.168.160 | 35092 42539 | flows | 9530 | 10 | postgres | autovacuum: ANALYZE publ= ic.agg_t254_outgoing_a6_dst_port_and_proto_f5 = | f | 2012-12-28 09:56:07.444296+01 | 2012-12-28 09:56:07.444296+0= 1 | 2012-12-28 09:33:37.591954+01 | |=20=20=20=20=20=20=20=20= =20=20=20=20 42539 | flows | 9565 | 10 | postgres | autovacuum: VACUUM ANALY= ZE public.agg_t482_outgoing_a7_src_port_and_proto_f5 = | f | 2012-12-28 09:41:47.314486+01 | 2012-12-28 09:41:47.314486+0= 1 | 2012-12-28 09:34:07.609676+01 | |=20=20=20=20=20=20=20=20= =20=20=20=20 42539 | flows | 9569 | 10 | postgres | autovacuum: ANALYZE publ= ic.agg_t467_incoming_a7_src_port_and_proto_f5 = | f | 2012-12-28 09:57:24.226429+01 | 2012-12-28 09:57:24.226429+0= 1 | 2012-12-28 09:34:37.627542+01 | |=20=20=20=20=20=20=20=20= =20=20=20=20 42539 | flows | 9571 | 16384 | asa | select * from pg_stat_ac= tivity; = | f | 2012-12-28 09:58:39.762966+01 | 2012-12-28 09:58:39.762966+0= 1 | 2012-12-28 09:34:44.817718+01 | | -1 42539 | flows | 9590 | 16384 | asa | CREATE INDEX "flowpool_2= 9_segment_132_timestamp" ON "flowpool_29_segment_132" USING btree (timestam= p) | f | 2012-12-28 09:45:05.258448+01 | 2012-12-28 09:45:05.258499+0= 1 | 2012-12-28 09:39:20.604855+01 | 10.48.168.160 | 35128 42539 | flows | 9508 | 16384 | asa | CREATE INDEX "flowpool_2= 6_segment_139_timestamp" ON "flowpool_26_segment_139" USING btree (timestam= p) | f | 2012-12-28 09:45:04.296674+01 | 2012-12-28 09:45:04.296732+0= 1 | 2012-12-28 09:30:17.487318+01 | 10.48.168.160 | 35124 42539 | flows | 9452 | 16384 | asa | CREATE INDEX "flowpool_2= 1_segment_136_timestamp" ON "flowpool_21_segment_136" USING btree (timestam= p) | f | 2012-12-28 09:45:06.741216+01 | 2012-12-28 09:45:06.741271+0= 1 | 2012-12-28 09:20:20.385564+01 | 10.48.168.160 | 35106 42539 | flows | 9592 | 16384 | asa | CREATE INDEX "flowpool_1= 7_segment_124_timestamp" ON "flowpool_17_segment_124" USING btree (timestam= p) | f | 2012-12-28 09:45:05.966266+01 | 2012-12-28 09:45:05.966332+0= 1 | 2012-12-28 09:39:20.649273+01 | 10.48.168.160 | 35130 42539 | flows | 9593 | 16384 | asa | CREATE INDEX "flowpool_2= _segment_131_timestamp" ON "flowpool_2_segment_131" USING btree (timestamp)= | f | 2012-12-28 09:45:03.358737+01 | 2012-12-28 09:45:03.358818+0= 1 | 2012-12-28 09:39:20.671335+01 | 10.48.168.160 | 35131 (16 rows) select * from pg_locks : locktype | database | relation | page | tuple | virtualxid | transact= ionid | classid | objid | objsubid | virtualtransaction | pid | = mode | granted=20 ---------------+----------+----------+------+-------+------------+---------= ------+---------+-------+----------+--------------------+------+-----------= ---------------+--------- relation | 42539 | 46020 | | | | = | | | | 9/122778 | 9530 | AccessShar= eLock | t transactionid | | | | | | 286= 15251 | | | | 8/140603 | 9364 | ExclusiveL= ock | t transactionid | | | | | | 286= 15278 | | | | 1/170450 | 9189 | ExclusiveL= ock | t relation | 42539 | 103506 | | | | = | | | | 16/99231 | 9508 | AccessShar= eLock | t relation | 42539 | 103506 | | | | = | | | | 16/99231 | 9508 | ShareLock = | t relation | 42539 | 7252363 | | | | = | | | | 1/170450 | 9189 | AccessExcl= usiveLock | t relation | 42539 | 105969 | | | | = | | | | 19/311 | 9592 | AccessShar= eLock | t relation | 42539 | 105969 | | | | = | | | | 19/311 | 9592 | ShareLock = | t relation | 42539 | 46019 | | | | = | | | | 9/122778 | 9530 | AccessShar= eLock | t relation | 42539 | 85230 | | | | = | | | | 8/140603 | 9364 | AccessShar= eLock | t relation | 42539 | 85230 | | | | = | | | | 8/140603 | 9364 | ShareLock = | t relation | 42539 | 7252359 | | | | = | | | | 8/140603 | 9364 | AccessExcl= usiveLock | t relation | 42539 | 49754 | | | | = | | | | 12/128834 | 9569 | AccessShar= eLock | t relation | 42539 | 87756 | | | | = | | | | 1/170450 | 9189 | AccessShar= eLock | t relation | 42539 | 87756 | | | | = | | | | 1/170450 | 9189 | ShareLock = | t relation | 42539 | 82695 | | | | = | | | | 17/43667 | 9452 | AccessShar= eLock | t relation | 42539 | 82695 | | | | = | | | | 17/43667 | 9452 | ShareLock = | t transactionid | | | | | | 286= 15238 | | | | 20/36 | 9593 | ExclusiveL= ock | t transactionid | | | | | | 286= 15271 | | | | 17/43667 | 9452 | ExclusiveL= ock | t relation | 42539 | 46016 | | | | = | | | | 9/122778 | 9530 | ShareUpdat= eExclusiveLock | t virtualxid | | | | | 17/43667 | = | | | | 17/43667 | 9452 | ExclusiveL= ock | t relation | 42539 | 50023 | | | | = | | | | 10/120119 | 9565 | ShareUpdat= eExclusiveLock | t relation | 42539 | 7252361 | | | | = | | | | 19/311 | 9592 | AccessExcl= usiveLock | t relation | 42539 | 49750 | | | | = | | | | 12/128834 | 9569 | ShareUpdat= eExclusiveLock | t transactionid | | | | | | 286= 15262 | | | | 15/112000 | 9590 | ExclusiveL= ock | t transactionid | | | | | | 286= 15266 | | | | 19/311 | 9592 | ExclusiveL= ock | t virtualxid | | | | | 12/128834 | = | | | | 12/128834 | 9569 | ExclusiveL= ock | t virtualxid | | | | | 1/170450 | = | | | | 1/170450 | 9189 | ExclusiveL= ock | t relation | 42539 | 10969 | | | | = | | | | 13/114756 | 9571 | AccessShar= eLock | t virtualxid | | | | | 19/311 | = | | | | 19/311 | 9592 | ExclusiveL= ock | t relation | 42539 | 7252362 | | | | = | | | | 17/43667 | 9452 | AccessExcl= usiveLock | t virtualxid | | | | | 13/114756 | = | | | | 13/114756 | 9571 | ExclusiveL= ock | t virtualxid | | | | | 10/120119 | = | | | | 10/120119 | 9565 | ExclusiveL= ock | t relation | 42539 | 90444 | | | | = | | | | 20/36 | 9593 | AccessShar= eLock | t relation | 42539 | 90444 | | | | = | | | | 20/36 | 9593 | ShareLock = | t relation | 42539 | 7252360 | | | | = | | | | 15/112000 | 9590 | AccessExcl= usiveLock | t relation | 42539 | 93051 | | | | = | | | | 15/112000 | 9590 | AccessShar= eLock | t relation | 42539 | 93051 | | | | = | | | | 15/112000 | 9590 | ShareLock = | t transactionid | | | | | | 286= 15245 | | | | 16/99231 | 9508 | ExclusiveL= ock | t virtualxid | | | | | 20/36 | = | | | | 20/36 | 9593 | ExclusiveL= ock | t relation | 42539 | 7252358 | | | | = | | | | 16/99231 | 9508 | AccessExcl= usiveLock | t relation | 42539 | 7252357 | | | | = | | | | 20/36 | 9593 | AccessExcl= usiveLock | t virtualxid | | | | | 9/122778 | = | | | | 9/122778 | 9530 | ExclusiveL= ock | t relation | 42539 | 50027 | | | | = | | | | 10/120119 | 9565 | RowExclusi= veLock | t virtualxid | | | | | 15/112000 | = | | | | 15/112000 | 9590 | ExclusiveL= ock | t virtualxid | | | | | 16/99231 | = | | | | 16/99231 | 9508 | ExclusiveL= ock | t relation | 42539 | 50026 | | | | = | | | | 10/120119 | 9565 | RowExclusi= veLock | t relation | 42539 | 49753 | | | | = | | | | 12/128834 | 9569 | AccessShar= eLock | t virtualxid | | | | | 8/140603 | = | | | | 8/140603 | 9364 | ExclusiveL= ock | t (49 rows) Best regards, Baptiste. ---=20 Baptiste LHOSTE=20 blhoste@alaloop.com=20 ALALOOP S.A.S. - Technopole Izarbel - 64210 Bidart=20 T=C3=A9l=C3=A9phone : +33 (0) 5 59 41 51 10=20 www.alaloop.com=20 --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin