ERROR:  column "procpid" does not exist
LINE 4: ...::integer) from pg_locks join pg_stat_activity on procpid=pi...
                                                             ^
query '
SELECT
coalesce(
	(SELECT max(extract(epoch from now()-xact_start)::integer) from pg_locks join pg_stat_activity on procpid=pid where relation=280866::regclass and database=(select oid from pg_database where datname=current_database()))
	,0
)
' asked for 1 rows but got total 0 rows as answer

(SELECT max(extract(epoch from now()-xact_start)::integer) from pg_locks join pg_stat_activity on procpid=pid where relation=${relid}::regclass and database=(select oid from pg_database where datname=current_database()))

(SELECT max(extract(epoch from now()-xact_start)::integer) from pg_locks join pg_stat_activity using(pid) where relation=${relid}::regclass and database=(select oid from pg_database where datname=current_database()))

perl /usr/bin/pgcompact --all --reindex -v info  -c 500 -E 1

ERROR: column "procpid" does not exist

dbname=# select pg_size_pretty(pg_relation_size( 'table_name' )) as pg_relation_size, pg_size_pretty(pg_total_relation_size( 'table_name' )) as pg_total_relation_size;
 pg_relation_size | pg_total_relation_size 
------------------+------------------------
 6806 MB          | 18 GB

./pgcompact -h 127.0.0.1 0 -U postgres --dbname dbname -t table_name --reindex -v info --no-routine-vacuum
Wed Oct 15 22:15:03 2014 INFO Database connection method: DBI/Pg.
Wed Oct 15 22:15:03 2014 dbname INFO Created environment.
Wed Oct 15 22:15:03 2014 dbname NOTICE Statictics calculation method: approximation.
Wed Oct 15 22:58:21 2014 dbname, public.table_name INFO Vacuum initial: 871154 pages left, duration 2597.573 seconds.
Wed Oct 15 22:58:21 2014 dbname, public.table_name NOTICE Statistics: 871154 pages (2363415 pages including toasts and indexes), approximately 11.49% (100092 pages) can be compacted reducing the size by 782 MB.
Wed Oct 15 22:58:21 2014 dbname, public.table_name INFO Skipping processing: 11.49% space to compact from 20% minimum required.
Wed Oct 15 22:58:21 2014 dbname NOTICE Processing complete.
Wed Oct 15 22:58:21 2014 dbname NOTICE Processing results: size reduced by 0 bytes (120 kB including toasts and indexes) in total.
Wed Oct 15 22:58:21 2014 NOTICE Processing complete: 0 retries from 10.
Wed Oct 15 22:58:21 2014 NOTICE Processing results: size reduced by 0 bytes (120 kB including toasts and indexes) in total, 0 bytes (120 kB) dbname.