Advertisement
Guest User

Untitled

a guest
Nov 5th, 2009
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.35 KB | None | 0 0
  1. $ ps auxwww
  2. USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND
  3. pgsql 10610 16.1 3.4 43364 34824 ?? Rs 8:01AM 9:35.40 postgres: netdisco netdisco [local] (postgres)
  4. pgsql 10607 10.5 3.5 43364 34936 ?? Rs 8:01AM 10:01.02 postgres: netdisco netdisco [local] (postgres)
  5. pgsql 10609 10.4 3.5 43364 34916 ?? Ss 8:01AM 9:27.31 postgres: netdisco netdisco [local] (postgres)
  6. pgsql 10606 9.9 3.4 43364 34848 ?? Rs 8:01AM 9:23.36 postgres: netdisco netdisco [local] (postgres)
  7. pgsql 4165 7.8 3.4 43364 34868 ?? Rs 9:00PM 79:26.43 postgres: netdisco netdisco [local] (postgres)
  8. pgsql 4169 7.8 3.5 43364 34964 ?? Rs 9:00PM 76:49.41 postgres: netdisco netdisco [local] (postgres)
  9. pgsql 4166 7.7 3.5 43364 34972 ?? Ss 9:00PM 79:44.18 postgres: netdisco netdisco [local] (postgres)
  10. pgsql 10608 6.4 3.4 43364 34876 ?? Rs 8:01AM 9:45.30 postgres: netdisco netdisco [local] (postgres)
  11. pgsql 4168 5.2 3.4 43364 34880 ?? Rs 9:00PM 78:25.05 postgres: netdisco netdisco [local] (postgres)
  12. pgsql 4167 3.4 3.5 43364 35004 ?? Ss 9:00PM 77:38.79 postgres: netdisco netdisco [local] (postgres)
  13. pgsql 10890 3.0 3.5 43364 35016 ?? Rs 9:00AM 6:12.08 postgres: netdisco netdisco [local] (postgres)
  14. root 0 0.0 0.0 0 0 ?? DLs 10:49AM 0:00.27 [swapper]
  15. root 1 0.0 0.0 1888 312 ?? ILs 10:49AM 0:00.04 /sbin/init --
  16. root 2 0.0 0.0 0 8 ?? DL 10:49AM 0:05.32 [g_event]
  17. root 3 0.0 0.0 0 8 ?? DL 10:49AM 0:33.80 [g_up]
  18. root 4 0.0 0.0 0 8 ?? DL 10:49AM 1:01.60 [g_down]
  19. root 5 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [kqueue taskq]
  20. root 6 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [xpt_thrd]
  21. root 7 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [acpi_task_0]
  22. root 8 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [acpi_task_1]
  23. root 9 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [acpi_task_2]
  24. root 10 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [audit]
  25. root 11 0.0 0.0 0 8 ?? RL 10:49AM 275:32.69 [idle: cpu0]
  26. root 12 0.0 0.0 0 8 ?? WL 10:49AM 0:16.24 [swi1: net]
  27. root 13 0.0 0.0 0 8 ?? LL 10:49AM 2:48.01 [swi4: clock sio]
  28. root 14 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [swi3: vm]
  29. root 15 0.0 0.0 0 8 ?? DL 10:49AM 0:08.62 [yarrow]
  30. root 16 0.0 0.0 0 8 ?? WL 10:49AM 0:44.12 [swi2: cambio]
  31. root 17 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [swi5: +]
  32. root 18 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [thread taskq]
  33. root 19 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [swi6: Giant taskq]
  34. root 20 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [swi6: task queue]
  35. root 21 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [irq9: acpi0]
  36. root 22 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [irq14: ata0]
  37. root 23 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [irq15: ata1]
  38. root 24 0.0 0.0 0 8 ?? WL 10:49AM 0:13.16 [irq17: mpt0]
  39. root 25 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [mpt_recovery0]
  40. root 26 0.0 0.0 0 8 ?? WL 10:49AM 1:07.02 [irq18: le0]
  41. root 27 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [irq1: atkbd0]
  42. root 28 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [irq12: psm0]
  43. root 29 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [swi0: sio]
  44. root 30 0.0 0.0 0 8 ?? DL 10:49AM 0:00.48 [fdc0]
  45. root 31 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [irq7: ppbus0 ppc0]
  46. root 32 0.0 0.0 0 16 ?? DL 10:49AM 0:00.00 [sctp_iterator]
  47. root 33 0.0 0.0 0 8 ?? DL 10:49AM 0:00.37 [pagedaemon]
  48. root 34 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [vmdaemon]
  49. root 35 0.0 0.0 0 8 ?? DL 10:49AM 0:00.01 [pagezero]
  50. root 36 0.0 0.0 0 8 ?? DL 10:49AM 0:02.22 [bufdaemon]
  51. root 37 0.0 0.0 0 8 ?? DL 10:49AM 0:00.67 [vnlru]
  52. root 38 0.0 0.0 0 8 ?? DL 10:49AM 0:31.20 [syncer]
  53. root 39 0.0 0.0 0 8 ?? DL 10:49AM 0:10.63 [softdepflush]
  54. root 129 0.0 0.1 1380 696 ?? Is 10:49AM 0:00.00 adjkerntz -i
  55. root 465 0.0 0.0 1888 412 ?? Is 10:49AM 0:00.00 /sbin/devd
  56. root 522 0.0 0.1 3184 960 ?? Ss 10:49AM 0:00.52 /usr/sbin/syslogd -ss
  57. root 619 0.0 0.2 4672 1788 ?? Ss 10:49AM 0:04.71 /usr/sbin/ntpd -g -c /etc/ntp.conf -p /var/run/ntpd.pid -f /var/db/ntpd.drift
  58. root 660 0.0 0.4 7908 3972 ?? Ss 10:49AM 0:59.68 /usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/local/etc/bacula-fd.conf
  59. root 669 0.0 2.0 24084 20084 ?? Ss 10:49AM 0:04.15 /usr/local/sbin/httpd
  60. root 682 0.0 0.3 5752 2684 ?? Is 10:49AM 0:00.02 /usr/sbin/sshd -4
  61. root 688 0.0 0.3 5876 2728 ?? Ss 10:49AM 0:01.90 sendmail: accepting connections (sendmail)
  62. www 691 0.0 2.6 33972 26504 ?? I 10:49AM 0:00.93 /usr/local/sbin/httpd
  63. www 692 0.0 2.6 33708 26252 ?? I 10:49AM 0:00.99 /usr/local/sbin/httpd
  64. www 693 0.0 2.6 33756 26236 ?? I 10:49AM 0:00.73 /usr/local/sbin/httpd
  65. www 695 0.0 2.5 28524 24808 ?? I 10:49AM 0:00.67 /usr/local/sbin/httpd
  66. smmsp 697 0.0 0.3 5876 2552 ?? Is 10:49AM 0:00.05 sendmail: Queue runner@00:30:00 for /var/spool/clientmqueue (sendmail)
  67. root 703 0.0 0.1 3212 1104 ?? Is 10:49AM 0:00.46 /usr/sbin/cron -s
  68. www 813 0.0 2.6 34028 26552 ?? I 10:51AM 0:01.60 /usr/local/sbin/httpd
  69. www 894 0.0 2.6 34160 26532 ?? I 11:03AM 0:00.70 /usr/local/sbin/httpd
  70. www 895 0.0 2.6 34084 26596 ?? I 11:03AM 0:01.06 /usr/local/sbin/httpd
  71. www 896 0.0 2.7 34140 26856 ?? I 11:03AM 0:00.82 /usr/local/sbin/httpd
  72. www 1060 0.0 2.5 33216 25712 ?? I 11:38AM 0:00.52 /usr/local/sbin/httpd
  73. www 1061 0.0 2.6 34076 26532 ?? I 11:38AM 0:00.79 /usr/local/sbin/httpd
  74. pgsql 2161 0.0 0.5 42332 4660 ?? Ss 2:54PM 0:02.91 /usr/local/bin/postgres -D /usr/local/pgsql/data
  75. pgsql 2167 0.0 3.4 42332 34192 ?? Ss 2:54PM 0:56.88 postgres: writer process (postgres)
  76. pgsql 2168 0.0 0.5 42332 4764 ?? Ss 2:54PM 0:14.51 postgres: wal writer process (postgres)
  77. pgsql 2169 0.0 0.5 42332 4848 ?? Ss 2:54PM 0:03.36 postgres: autovacuum launcher process (postgres)
  78. pgsql 2170 0.0 0.5 10412 4568 ?? Ss 2:54PM 0:40.50 postgres: stats collector process (postgres)
  79. pgsql 2221 0.0 0.8 42332 7940 ?? Is 2:59PM 0:00.04 postgres: netdisco netdisco [local] (postgres)
  80. pgsql 2223 0.0 1.9 43356 18784 ?? Is 2:59PM 0:00.23 postgres: netdisco netdisco [local] (postgres)
  81. pgsql 2244 0.0 0.8 42332 7644 ?? Is 3:00PM 0:00.03 postgres: netdisco netdisco [local] (postgres)
  82. pgsql 2245 0.0 1.7 43356 17072 ?? Is 3:00PM 0:00.38 postgres: netdisco netdisco [local] (postgres)
  83. pgsql 2247 0.0 0.8 42332 7724 ?? Is 3:00PM 0:00.03 postgres: netdisco netdisco [local] (postgres)
  84. pgsql 2248 0.0 2.1 43356 20952 ?? Is 3:00PM 0:00.27 postgres: netdisco netdisco [local] (postgres)
  85. pgsql 2250 0.0 0.7 42332 7324 ?? Is 3:01PM 0:00.02 postgres: netdisco netdisco [local] (postgres)
  86. pgsql 2251 0.0 1.5 43356 15552 ?? Is 3:01PM 0:00.09 postgres: netdisco netdisco [local] (postgres)
  87. pgsql 2253 0.0 0.7 42332 7424 ?? Is 3:01PM 0:00.03 postgres: netdisco netdisco [local] (postgres)
  88. pgsql 2254 0.0 2.2 43356 22624 ?? Is 3:01PM 0:00.24 postgres: netdisco netdisco [local] (postgres)
  89. pgsql 2256 0.0 0.7 42332 7560 ?? Is 3:02PM 0:00.02 postgres: netdisco netdisco [local] (postgres)
  90. pgsql 2257 0.0 1.2 43356 12388 ?? Is 3:02PM 0:00.05 postgres: netdisco netdisco [local] (postgres)
  91. pgsql 2381 0.0 0.7 42332 7552 ?? Is 3:20PM 0:00.02 postgres: netdisco netdisco [local] (postgres)
  92. pgsql 2382 0.0 1.3 43356 12748 ?? Is 3:20PM 0:00.31 postgres: netdisco netdisco [local] (postgres)
  93. pgsql 2650 0.0 0.8 42332 7932 ?? Is 4:01PM 0:00.03 postgres: netdisco netdisco [local] (postgres)
  94. pgsql 2652 0.0 1.3 43356 12872 ?? Is 4:02PM 0:00.10 postgres: netdisco netdisco [local] (postgres)
  95. pgsql 2653 0.0 0.7 42332 7236 ?? Is 4:02PM 0:00.02 postgres: netdisco netdisco [local] (postgres)
  96. pgsql 2677 0.0 0.7 42332 6716 ?? Is 4:10PM 0:00.02 postgres: netdisco netdisco [local] (postgres)
  97. pgsql 2678 0.0 2.7 43356 26960 ?? Is 4:10PM 0:00.36 postgres: netdisco netdisco [local] (postgres)
  98. pgsql 2795 0.0 1.4 43356 13960 ?? Is 4:30PM 0:00.20 postgres: netdisco netdisco [local] (postgres)
  99. root 2830 0.0 0.3 8428 3104 ?? Is 4:34PM 0:00.04 sshd: booloo [priv] (sshd)
  100. booloo 2832 0.0 0.3 8428 3104 ?? I 4:34PM 0:00.06 sshd: booloo@ttyp1 (sshd)
  101. root 4137 0.0 0.1 3212 1152 ?? I 9:00PM 0:00.00 cron: running job (cron)
  102. netdisco 4141 0.0 0.1 3464 1212 ?? Is 9:00PM 0:00.00 /bin/sh -c /usr/local/netdisco/netdisco -b -w
  103. netdisco 4146 0.0 1.9 23208 19288 ?? I 9:00PM 0:06.17 netdisco: parent waiting for children to exit (perl5.8.9)
  104. netdisco 4160 0.0 1.9 23208 19296 ?? S 9:00PM 0:08.32 netdisco: nbtstat 128.114.168.80 (perl5.8.9)
  105. netdisco 4161 0.0 1.9 23208 19292 ?? S 9:00PM 0:08.36 netdisco: worker 2 looking for nbtstat job (perl5.8.9)
  106. netdisco 4162 0.0 1.9 23208 19292 ?? S 9:00PM 0:08.27 netdisco: worker 3 looking for nbtstat job (perl5.8.9)
  107. netdisco 4163 0.0 1.9 23208 19296 ?? S 9:00PM 0:08.07 netdisco: worker 4 looking for nbtstat job (perl5.8.9)
  108. netdisco 4164 0.0 1.9 23208 19296 ?? S 9:00PM 0:07.96 netdisco: nbtstat 128.114.69.157 (perl5.8.9)
  109. root 5804 0.0 0.1 3212 1148 ?? I 2:00AM 0:00.00 cron: running job (cron)
  110. netdisco 5809 0.0 0.0 0 0 ?? Z 2:00AM 0:00.33 <defunct>
  111. netdisco 5827 0.0 1.3 17896 12800 ?? S 2:00AM 0:08.34 netdisco: admin daemon (perl5.8.9)
  112. pgsql 5828 0.0 3.4 42340 34588 ?? Ss 2:00AM 0:11.87 postgres: netdisco netdisco [local] (postgres)
  113. root 10572 0.0 0.1 3212 1148 ?? I 8:00AM 0:00.00 cron: running job (cron)
  114. netdisco 10577 0.0 0.1 3464 1160 ?? Is 8:00AM 0:00.00 /bin/sh -c /usr/local/netdisco/netdisco -b -w
  115. netdisco 10580 0.0 1.9 23136 19276 ?? I 8:00AM 0:05.72 netdisco: parent waiting for children to exit (perl5.8.9)
  116. netdisco 10601 0.0 1.9 23136 19284 ?? S 8:01AM 0:01.06 netdisco: nbtstat 128.114.2.81 (perl5.8.9)
  117. netdisco 10602 0.0 1.9 23136 19284 ?? S 8:01AM 0:01.08 netdisco: nbtstat 128.114.188.92 (perl5.8.9)
  118. netdisco 10603 0.0 1.9 23136 19284 ?? S 8:01AM 0:01.09 netdisco: nbtstat 128.114.151.106 (perl5.8.9)
  119. netdisco 10604 0.0 1.9 23136 19284 ?? S 8:01AM 0:01.12 netdisco: worker 4 looking for nbtstat job (perl5.8.9)
  120. netdisco 10605 0.0 1.9 23136 19284 ?? S 8:01AM 0:01.08 netdisco: nbtstat 169.233.6.104 (perl5.8.9)
  121. root 10859 0.0 0.1 3212 1148 ?? I 9:00AM 0:00.00 cron: running job (cron)
  122. netdisco 10863 0.0 0.1 3464 1160 ?? Is 9:00AM 0:00.00 /bin/sh -c /usr/local/netdisco/netdisco -b -R
  123. netdisco 10868 0.0 1.4 18316 14456 ?? I 9:00AM 0:00.67 netdisco: parent waiting for children to exit (perl5.8.9)
  124. netdisco 10884 0.0 2.0 24464 20396 ?? S 9:00AM 0:43.58 netdisco: rediscover 128.114.27.91 (perl5.8.9)
  125. root 11250 0.0 0.3 8428 3132 ?? Is 10:29AM 0:00.04 sshd: booloo [priv] (sshd)
  126. booloo 11252 0.0 0.3 8428 3124 ?? S 10:29AM 0:00.02 sshd: booloo@ttyp0 (sshd)
  127. root 761 0.0 0.1 3184 900 v0 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv0
  128. root 762 0.0 0.1 3184 900 v1 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv1
  129. root 763 0.0 0.1 3184 900 v2 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv2
  130. root 764 0.0 0.1 3184 900 v3 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv3
  131. root 765 0.0 0.1 3184 900 v4 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv4
  132. root 766 0.0 0.1 3184 900 v5 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv5
  133. root 767 0.0 0.1 3184 900 v6 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv6
  134. root 768 0.0 0.1 3184 900 v7 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv7
  135. booloo 11254 0.0 0.2 4400 1940 p0 Is 10:29AM 0:00.03 -bash (bash)
  136. root 11258 0.0 0.1 3620 1324 p0 I 10:29AM 0:00.01 su -
  137. root 11259 0.0 0.2 4464 2104 p0 I 10:29AM 0:00.02 -su (csh)
  138. root 11263 0.0 0.1 3620 1304 p0 I 10:29AM 0:00.01 su - netdisco
  139. netdisco 11264 0.0 0.1 3464 1304 p0 S 10:29AM 0:00.01 -su (sh)
  140. netdisco 11266 0.0 0.1 3244 976 p0 R+ 10:29AM 0:00.00 ps auxwww
  141. booloo 2834 0.0 0.2 4400 1920 p1 Is+ 4:34PM 0:00.04 -bash (bash)
  142.  
  143.  
  144. $ /usr/local/netdisco/sql/pg -b /usr/local/netdisco/sql/pg_procs.sql
  145. /usr/local/netdisco/sql/pg - Netdisco Postgres Wrapper.
  146. Loading /usr/local/netdisco/sql/pg_procs.sql into psql
  147. select datname, datid, procpid, usesysid, query_start, waiting, current_query from pg_stat_activity order by procpid;
  148. datname | datid | procpid | usesysid | query_start | waiting | current_query
  149. ----------+-------+---------+----------+-------------------------------+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------
  150. netdisco | 16385 | 2221 | 16384 | 2009-11-05 10:08:13.079641-08 | f | <IDLE>
  151. netdisco | 16385 | 2223 | 16384 | 2009-11-05 10:08:13.076505-08 | f | <IDLE>
  152. netdisco | 16385 | 2244 | 16384 | 2009-11-05 09:46:49.696344-08 | f | <IDLE>
  153. netdisco | 16385 | 2245 | 16384 | 2009-11-04 17:11:00.900333-08 | f | <IDLE>
  154. netdisco | 16385 | 2247 | 16384 | 2009-11-05 10:08:17.645875-08 | f | <IDLE>
  155. netdisco | 16385 | 2248 | 16384 | 2009-11-05 10:08:17.634511-08 | f | <IDLE>
  156. netdisco | 16385 | 2250 | 16384 | 2009-11-05 07:02:42.437776-08 | f | <IDLE>
  157. netdisco | 16385 | 2251 | 16384 | 2009-11-04 17:17:45.565971-08 | f | <IDLE>
  158. netdisco | 16385 | 2253 | 16384 | 2009-11-04 17:24:15.098992-08 | f | <IDLE>
  159. netdisco | 16385 | 2254 | 16384 | 2009-11-04 17:24:15.095214-08 | f | <IDLE>
  160. netdisco | 16385 | 2256 | 16384 | 2009-11-05 09:40:41.031347-08 | f | <IDLE>
  161. netdisco | 16385 | 2257 | 16384 | 2009-11-04 17:17:57.133511-08 | f | <IDLE>
  162. netdisco | 16385 | 2381 | 16384 | 2009-11-05 10:08:06.852568-08 | f | <IDLE>
  163. netdisco | 16385 | 2382 | 16384 | 2009-11-05 10:08:06.849928-08 | f | <IDLE>
  164. netdisco | 16385 | 2650 | 16384 | 2009-11-05 09:41:14.945045-08 | f | <IDLE>
  165. netdisco | 16385 | 2652 | 16384 | 2009-11-05 09:41:14.509713-08 | f | <IDLE>
  166. netdisco | 16385 | 2653 | 16384 | 2009-11-05 09:40:57.833446-08 | f | <IDLE>
  167. netdisco | 16385 | 2677 | 16384 | 2009-11-04 16:35:13.183755-08 | f | <IDLE>
  168. netdisco | 16385 | 2678 | 16384 | 2009-11-04 16:35:13.165859-08 | f | <IDLE>
  169. netdisco | 16385 | 2795 | 16384 | 2009-11-05 09:40:57.830067-08 | f | <IDLE>
  170. netdisco | 16385 | 4165 | 16384 | 2009-11-05 10:29:58.351124-08 | f | SELECT * FROM process WHERE controller = '4146' AND action = 'nbtstat' AND device = '169.233.31.119' FOR UPDATE
  171. netdisco | 16385 | 4166 | 16384 | 2009-11-05 10:29:58.45745-08 | f | SELECT * FROM process WHERE controller = '4146' AND action = 'nbtstat' AND device = '128.114.113.107' FOR UPDATE
  172. netdisco | 16385 | 4167 | 16384 | 2009-11-05 10:30:06.521762-08 | t | SELECT controller,action,device FROM process WHERE (controller = '4146') AND (status = 'queued') AND (action = 'nbtstat') LIMIT 1 OFFSET 3 FOR UPDATE
  173. netdisco | 16385 | 4168 | 16384 | 2009-11-05 10:29:59.651495-08 | f | UPDATE process SET count='0',status='done' WHERE controller = '4146' AND action = 'nbtstat' AND device = '128.114.162.241'
  174. netdisco | 16385 | 4169 | 16384 | 2009-11-05 10:30:03.673767-08 | f | SELECT * FROM process WHERE controller = '4146' AND action = 'nbtstat' AND device = '128.114.44.243' FOR UPDATE
  175. netdisco | 16385 | 5828 | 16384 | 2009-11-05 10:30:09.189695-08 | f | <IDLE>
  176. netdisco | 16385 | 10606 | 16384 | 2009-11-05 10:30:07.307818-08 | f | SELECT * FROM process WHERE controller = '10580' AND action = 'nbtstat' AND device = '128.114.204.54' FOR UPDATE
  177. netdisco | 16385 | 10607 | 16384 | 2009-11-05 10:30:03.193168-08 | f | UPDATE process SET count='0',status='done' WHERE controller = '10580' AND action = 'nbtstat' AND device = '128.114.199.195'
  178. netdisco | 16385 | 10608 | 16384 | 2009-11-05 10:30:09.087472-08 | f | SELECT * FROM process WHERE controller = '10580' AND action = 'nbtstat' AND device = '169.233.7.101' FOR UPDATE
  179. netdisco | 16385 | 10609 | 16384 | 2009-11-05 10:30:08.622443-08 | f | UPDATE process SET status='running' WHERE controller = '10580' AND action = 'nbtstat' AND device = '169.233.41.67'
  180. netdisco | 16385 | 10610 | 16384 | 2009-11-05 10:30:07.557831-08 | f | SELECT * FROM process WHERE controller = '10580' AND action = 'nbtstat' AND device = '128.114.252.24' FOR UPDATE
  181. netdisco | 16385 | 10890 | 16384 | 2009-11-05 10:30:02.446825-08 | f | UPDATE process SET status='running' WHERE controller = '10868' AND action = 'rediscover' AND device = '169.233.35.228'
  182. netdisco | 16385 | 11273 | 16384 | 2009-11-05 10:30:08.993754-08 | f | <IDLE>
  183. netdisco | 16385 | 11279 | 16384 | 2009-11-05 10:30:09.256541-08 | f | select datname, datid, procpid, usesysid, query_start, waiting, current_query from pg_stat_activity order by procpid;
  184. (34 rows)
  185.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement