summary |
shortlog | log |
commit |
commitdiff |
tree
first ⋅ prev ⋅ next
Mark Wong [Wed, 25 Jul 2018 22:14:47 +0000 (15:14 -0700)]
Update versions for pgxn
Mark Wong [Wed, 25 Jul 2018 16:56:27 +0000 (16:56 +0000)]
Update example script to use perl Data::Dumper
Mark Wong [Wed, 25 Jul 2018 16:21:23 +0000 (16:21 +0000)]
Install addition .sql files and scripts
Mark Wong [Wed, 25 Jul 2018 01:53:47 +0000 (01:53 +0000)]
Update .gitignore to stop ignoring .sql files
Mark Wong [Wed, 25 Jul 2018 01:49:28 +0000 (01:49 +0000)]
Bump version to 0.0.7
Mark Wong [Wed, 25 Jul 2018 01:04:00 +0000 (01:04 +0000)]
Rename README to README.pg_proctab
Make the extension's README more easily recognized when it's been
installed.
Mark Wong [Wed, 25 Jul 2018 01:01:17 +0000 (01:01 +0000)]
Move the PORTING file out of the doc dir
The PORTING file is meant for developers, not for how to use the
extension.
Mark Wong [Tue, 24 Jul 2018 23:37:54 +0000 (23:37 +0000)]
Add .gitattribures to ignore files when using git archive
Mark Wong [Sat, 9 Jun 2018 04:41:45 +0000 (21:41 -0700)]
Code formatting
Mark Wong [Tue, 10 Jul 2018 16:07:17 +0000 (09:07 -0700)]
Merge pull request #3 from ibarwick/pg96-fix
Fix log messages for PostgreSQL 9.6 and later
Ian Barwick [Mon, 9 Jul 2018 04:35:38 +0000 (13:35 +0900)]
Fix log messages for PostgreSQL 9.6 and later
Definition of "FuncCallContext" has chanegd to use uint64 in place of
uint32 (commit
23a27b039d94ba359286694831eafe03cd970eef).
Mark Wong [Mon, 29 Jun 2015 20:27:28 +0000 (13:27 -0700)]
Merge pull request #2 from frost242/master
Add pg_diskusage() function
Thomas Reiss [Fri, 26 Jun 2015 14:30:05 +0000 (16:30 +0200)]
Bump version to 0.0.6, add update script and a specific 0.0.6 script
Thomas Reiss [Fri, 26 Jun 2015 14:21:24 +0000 (16:21 +0200)]
Add pg_diskusage function
Uses the tuplestore interface, so the code layout is slighly different from the original.
Mark Wong [Fri, 13 Dec 2013 00:20:30 +0000 (16:20 -0800)]
Merge pull request #1 from junegunn/fix-9.3-make_install
Fix installation error on PostgreSQL 9.3
Junegunn Choi [Fri, 6 Dec 2013 06:17:15 +0000 (15:17 +0900)]
Remove duplicate term to fix installation error on 9.3
Mark Wong [Sat, 30 Mar 2013 05:07:50 +0000 (22:07 -0700)]
Rearrange source code
Move all the source and SQL code into a single file. It seems easier
to deal with with pgxn this way.
Mark Wong [Sat, 30 Mar 2013 05:05:51 +0000 (22:05 -0700)]
Fix Makefile syntax
Some version of GNU make seem unaffected but I think this is more
correct.
Mark Wong [Tue, 19 Mar 2013 03:08:20 +0000 (20:08 -0700)]
Update pg_stat_activity call for pgsql 9.2
Also reorganize the source tree per pgxn recommendations.
Mark Wong [Tue, 19 Mar 2013 02:53:48 +0000 (19:53 -0700)]
Ignore vim swap files and .o and .so files
Mark Wong [Mon, 18 Mar 2013 04:07:28 +0000 (21:07 -0700)]
Revert "Stop using pgxs and moved to using cmake because platform specific linker"
This reverts commit
0f26865ddbc8670d17cc3b0d4aba02ed9e5502b0.
Mark Wong [Sat, 27 Mar 2010 12:42:41 +0000 (05:42 -0700)]
add option to list snapshots
Added a -list flag to list all snapshots and their comments.
Mark Wong [Sat, 27 Mar 2010 12:41:57 +0000 (05:41 -0700)]
take notes for a snapshot
The examples allow for a string to be used to make notes for a snapshot.
Mark Wong [Sat, 27 Mar 2010 12:40:49 +0000 (05:40 -0700)]
fix commit and rollback calculation
The commit and rollback counts were using the values from the wrong
columns.
gabriellew [Sun, 15 Nov 2009 00:40:59 +0000 (16:40 -0800)]
Combined proc util script with io util script
- didn't include stime and utime; they were unused in the original
- started squashing the psql command into something more modular
(will eventually use the DBI to connect)
- added time calcs
- added a half-hearted attempt at figuring out local Hz kernel value
Mark Wong [Fri, 24 Apr 2009 05:56:17 +0000 (22:56 -0700)]
Added examples of using pg_proctab.
Mark Wong [Fri, 17 Apr 2009 06:15:32 +0000 (23:15 -0700)]
Reverted a Solaris specific change that wasn't supposed to be committed
yet.
Mark Wong [Fri, 27 Mar 2009 05:40:25 +0000 (22:40 -0700)]
Merge branch 'master' of git://git.postgresql.org/git/~markwkm/pg_proctab
Mark Wong [Fri, 27 Mar 2009 05:31:36 +0000 (22:31 -0700)]
Stop using pgxs and moved to using cmake because platform specific linker
flags will be needed for at least Solaris. The README has been updated
to describe cmake.
Also made the SQL files static. This can be changed back so they are
generated when running cmake.
Mark Wong [Fri, 27 Mar 2009 02:42:22 +0000 (19:42 -0700)]
Use strncpy instead of strcpy and snprintf instead of sprintf because
they are hopefully safer.
Mark Wong [Fri, 27 Mar 2009 02:41:06 +0000 (19:41 -0700)]
Added functionality to return i/o statistics per process if enabled on
Linux systems.
Mark Wong [Thu, 26 Mar 2009 01:57:55 +0000 (18:57 -0700)]
Updated debug messages for the test of the C stored functions.
Mark Wong [Thu, 26 Mar 2009 00:37:20 +0000 (17:37 -0700)]
Don't change the working directory inside the stored function. That can
keep the database from functioning properly.
Mark Wong [Thu, 26 Mar 2009 00:30:31 +0000 (17:30 -0700)]
Added additional debugging. Added DEBUG5 message to show what pids are
selected from PostgreSQL. Updated debugging at the end of the to show
the column number of the data being returned. In doing so noticed the
full command line arguments were omitted.
Mark Wong [Sat, 11 Oct 2008 00:54:50 +0000 (17:54 -0700)]
Adding PORTING notes.
Mark Wong [Thu, 11 Sep 2008 03:40:58 +0000 (20:40 -0700)]
Make the pg_proctab stored function match the local use of the funtions. May
have to generalize for use when support for other platforms are added.
Mark Wong [Thu, 11 Sep 2008 03:39:18 +0000 (20:39 -0700)]
Turned skip_token() into a macro and hopefully simplified its use.
Mark Wong [Thu, 11 Sep 2008 03:23:42 +0000 (20:23 -0700)]
Restructured all the code to hopefully make adding platform specific code
easier.
Mark Wong [Thu, 11 Sep 2008 03:22:24 +0000 (20:22 -0700)]
Moved all common definitions into a common header files, pg_common.h.
Mark Wong [Thu, 11 Sep 2008 03:20:28 +0000 (20:20 -0700)]
Include the correct header file from Linux for PROC_SUPER_MAGIC.
Mark Wong [Thu, 11 Sep 2008 03:17:25 +0000 (20:17 -0700)]
Fix commment formatting.
Mark Wong [Wed, 27 Aug 2008 03:38:18 +0000 (20:38 -0700)]
Returning proper values for utime and stime.
Mark Wong [Wed, 27 Aug 2008 03:37:25 +0000 (20:37 -0700)]
Added the uid and the username of the pid's owner to the data returned by the
stored function.
Mark Wong [Tue, 26 Aug 2008 05:31:24 +0000 (22:31 -0700)]
Added a column returning the full command line for each pid.
Mark Wong [Tue, 26 Aug 2008 05:27:07 +0000 (22:27 -0700)]
Clarify elog() messages when specific /proc entries are not found.
Mark Wong [Tue, 26 Aug 2008 05:25:59 +0000 (22:25 -0700)]
Contain Linux specific code within #ifdef __linux__.
Mark Wong [Tue, 26 Aug 2008 05:25:20 +0000 (22:25 -0700)]
Stop changing the working directory because it seems to confuse PostgreSQL.
Mark Wong [Mon, 25 Aug 2008 06:02:19 +0000 (23:02 -0700)]
Added stored function to get memory usage statistics.
Mark Wong [Sun, 24 Aug 2008 03:50:51 +0000 (20:50 -0700)]
Added .hgignore file to ignore generated *.so and *.sql files.
Mark Wong [Sat, 23 Aug 2008 05:50:43 +0000 (22:50 -0700)]
Merged branches.
Mark Wong [Sat, 23 Aug 2008 05:49:01 +0000 (22:49 -0700)]
Added C stored function to get processor utilization of the system.
Mark Wong [Sat, 23 Aug 2008 05:47:54 +0000 (22:47 -0700)]
Added a C stored function to get the system load average.
Mark Wong [Sat, 23 Aug 2008 05:21:07 +0000 (22:21 -0700)]
Grouped together Linux specific code within __linux__ #ifdef's.
Mark Wong [Tue, 19 Aug 2008 00:36:22 +0000 (17:36 -0700)]
Stop parsing entries that are marked obsolete in the linux kernel
documentation.
Mark Wong [Tue, 19 Aug 2008 00:33:03 +0000 (17:33 -0700)]
Fixed a bug where the pointer used for parsing /proc/PID/stat skipped entries
when they were 1 digit, or parsed anything more than 1 digit incorrectly by
skipping the first digit.
Mark Wong [Tue, 19 Aug 2008 00:31:39 +0000 (17:31 -0700)]
Different versions of linux have different number of entries in /proc/PID/stat.
Fix a bug when delayacct_blkio_ticks is the last item causing it to be parsed
incorrectly.
Mark Wong [Tue, 19 Aug 2008 00:20:12 +0000 (17:20 -0700)]
Added additional DEBUG5 messages for further debugging.
Mark Wong [Sun, 17 Aug 2008 06:33:25 +0000 (23:33 -0700)]
Use MemoryContextAlloc() instead of palloc(). The former allocates
memory that is persistent between calls while the latter doesn't.
Mark Wong [Sun, 17 Aug 2008 06:29:33 +0000 (23:29 -0700)]
Added DEBUG5 messages to help debug memory problems.
Mark Wong [Wed, 21 May 2008 06:24:33 +0000 (23:24 -0700)]
Removed reading wchan from the process table. The address of the system call
is probably not that important.
Mark Wong [Wed, 21 May 2008 03:35:24 +0000 (20:35 -0700)]
Changed the C stored function to return data for all procpid's in the
pg_stat_activity table. Now you can join with other tables. For example:
SELECT *
FROM pg_stat_activity, pg_proctab()
WHERE procpid = pid;
Mark Wong [Wed, 21 May 2008 03:33:16 +0000 (20:33 -0700)]
Just a whitespace formatting change.
Mark Wong [Sat, 17 May 2008 04:48:18 +0000 (21:48 -0700)]
Removed even more debug messages.
Mark Wong [Sat, 17 May 2008 04:40:13 +0000 (21:40 -0700)]
Removed more debug messages committed by accident.
Mark Wong [Sat, 17 May 2008 04:39:15 +0000 (21:39 -0700)]
Removed debug message committed by accident.
Mark Wong [Fri, 16 May 2008 01:21:18 +0000 (18:21 -0700)]
Added a README.
Mark Wong [Wed, 14 May 2008 14:24:30 +0000 (07:24 -0700)]
Use an INOUT parameter instead of an IN and OUT parameter for the pid.
Mark Wong [Wed, 14 May 2008 07:08:31 +0000 (00:08 -0700)]
Removed debug elog() message.
Mark Wong [Wed, 14 May 2008 04:13:26 +0000 (21:13 -0700)]
First pass at creating a C stored function to access the process table in
Linux.