*** /home/vpopov/Projects/pwdtest.new/postgresql/contrib/pgstattuple/expected/pgstattuple.out 2016-03-15 14:32:12.937978027 +0300 --- /home/vpopov/Projects/pwdtest.new/postgresql/contrib/pgstattuple/results/pgstattuple.out 2016-03-15 16:39:52.009673824 +0300 *************** *** 1,4 **** --- 1,5 ---- CREATE EXTENSION pgstattuple; + ERROR: could not load library "/usr/local/pgsql/lib/pgstattuple.so": /usr/local/pgsql/lib/pgstattuple.so: undefined symbol: visibilitymap_test -- -- It's difficult to come up with platform-independent test cases for -- the pgstattuple functions, but the results for empty tables and *************** *** 6,132 **** -- create table test (a int primary key, b int[]); select * from pgstattuple('test'); ! table_len | tuple_count | tuple_len | tuple_percent | dead_tuple_count | dead_tuple_len | dead_tuple_percent | free_space | free_percent ! -----------+-------------+-----------+---------------+------------------+----------------+--------------------+------------+-------------- ! 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 ! (1 row) ! select * from pgstattuple('test'::text); ! table_len | tuple_count | tuple_len | tuple_percent | dead_tuple_count | dead_tuple_len | dead_tuple_percent | free_space | free_percent ! -----------+-------------+-----------+---------------+------------------+----------------+--------------------+------------+-------------- ! 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 ! (1 row) ! select * from pgstattuple('test'::name); ! table_len | tuple_count | tuple_len | tuple_percent | dead_tuple_count | dead_tuple_len | dead_tuple_percent | free_space | free_percent ! -----------+-------------+-----------+---------------+------------------+----------------+--------------------+------------+-------------- ! 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 ! (1 row) ! select * from pgstattuple('test'::regclass); ! table_len | tuple_count | tuple_len | tuple_percent | dead_tuple_count | dead_tuple_len | dead_tuple_percent | free_space | free_percent ! -----------+-------------+-----------+---------------+------------------+----------------+--------------------+------------+-------------- ! 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 ! (1 row) ! select pgstattuple(oid) from pg_class where relname = 'test'; ! pgstattuple ! --------------------- ! (0,0,0,0,0,0,0,0,0) ! (1 row) ! select pgstattuple(relname) from pg_class where relname = 'test'; ! pgstattuple ! --------------------- ! (0,0,0,0,0,0,0,0,0) ! (1 row) ! select version, tree_level, index_size / current_setting('block_size')::int as index_size, root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages, avg_leaf_density, leaf_fragmentation from pgstatindex('test_pkey'); ! version | tree_level | index_size | root_block_no | internal_pages | leaf_pages | empty_pages | deleted_pages | avg_leaf_density | leaf_fragmentation ! ---------+------------+------------+---------------+----------------+------------+-------------+---------------+------------------+-------------------- ! 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | NaN | NaN ! (1 row) ! select version, tree_level, index_size / current_setting('block_size')::int as index_size, root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages, avg_leaf_density, leaf_fragmentation from pgstatindex('test_pkey'::text); ! version | tree_level | index_size | root_block_no | internal_pages | leaf_pages | empty_pages | deleted_pages | avg_leaf_density | leaf_fragmentation ! ---------+------------+------------+---------------+----------------+------------+-------------+---------------+------------------+-------------------- ! 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | NaN | NaN ! (1 row) ! select version, tree_level, index_size / current_setting('block_size')::int as index_size, root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages, avg_leaf_density, leaf_fragmentation from pgstatindex('test_pkey'::name); ! version | tree_level | index_size | root_block_no | internal_pages | leaf_pages | empty_pages | deleted_pages | avg_leaf_density | leaf_fragmentation ! ---------+------------+------------+---------------+----------------+------------+-------------+---------------+------------------+-------------------- ! 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | NaN | NaN ! (1 row) ! select version, tree_level, index_size / current_setting('block_size')::int as index_size, root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages, avg_leaf_density, leaf_fragmentation from pgstatindex('test_pkey'::regclass); ! version | tree_level | index_size | root_block_no | internal_pages | leaf_pages | empty_pages | deleted_pages | avg_leaf_density | leaf_fragmentation ! ---------+------------+------------+---------------+----------------+------------+-------------+---------------+------------------+-------------------- ! 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | NaN | NaN ! (1 row) ! select pg_relpages('test'); ! pg_relpages ! ------------- ! 0 ! (1 row) ! select pg_relpages('test_pkey'); ! pg_relpages ! ------------- ! 1 ! (1 row) ! select pg_relpages('test_pkey'::text); ! pg_relpages ! ------------- ! 1 ! (1 row) ! select pg_relpages('test_pkey'::name); ! pg_relpages ! ------------- ! 1 ! (1 row) ! select pg_relpages('test_pkey'::regclass); ! pg_relpages ! ------------- ! 1 ! (1 row) ! select pg_relpages(oid) from pg_class where relname = 'test_pkey'; ! pg_relpages ! ------------- ! 1 ! (1 row) ! select pg_relpages(relname) from pg_class where relname = 'test_pkey'; ! pg_relpages ! ------------- ! 1 ! (1 row) ! create index test_ginidx on test using gin (b); select * from pgstatginindex('test_ginidx'); ! version | pending_pages | pending_tuples ! ---------+---------------+---------------- ! 2 | 0 | 0 ! (1 row) ! --- 7,115 ---- -- create table test (a int primary key, b int[]); select * from pgstattuple('test'); ! ERROR: function pgstattuple(unknown) does not exist ! LINE 1: select * from pgstattuple('test'); ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select * from pgstattuple('test'::text); ! ERROR: function pgstattuple(text) does not exist ! LINE 1: select * from pgstattuple('test'::text); ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select * from pgstattuple('test'::name); ! ERROR: function pgstattuple(name) does not exist ! LINE 1: select * from pgstattuple('test'::name); ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select * from pgstattuple('test'::regclass); ! ERROR: function pgstattuple(regclass) does not exist ! LINE 1: select * from pgstattuple('test'::regclass); ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select pgstattuple(oid) from pg_class where relname = 'test'; ! ERROR: function pgstattuple(oid) does not exist ! LINE 1: select pgstattuple(oid) from pg_class where relname = 'test'... ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select pgstattuple(relname) from pg_class where relname = 'test'; ! ERROR: function pgstattuple(name) does not exist ! LINE 1: select pgstattuple(relname) from pg_class where relname = 't... ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select version, tree_level, index_size / current_setting('block_size')::int as index_size, root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages, avg_leaf_density, leaf_fragmentation from pgstatindex('test_pkey'); ! ERROR: function pgstatindex(unknown) does not exist ! LINE 5: from pgstatindex('test_pkey'); ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select version, tree_level, index_size / current_setting('block_size')::int as index_size, root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages, avg_leaf_density, leaf_fragmentation from pgstatindex('test_pkey'::text); ! ERROR: function pgstatindex(text) does not exist ! LINE 5: from pgstatindex('test_pkey'::text); ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select version, tree_level, index_size / current_setting('block_size')::int as index_size, root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages, avg_leaf_density, leaf_fragmentation from pgstatindex('test_pkey'::name); ! ERROR: function pgstatindex(name) does not exist ! LINE 5: from pgstatindex('test_pkey'::name); ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select version, tree_level, index_size / current_setting('block_size')::int as index_size, root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages, avg_leaf_density, leaf_fragmentation from pgstatindex('test_pkey'::regclass); ! ERROR: function pgstatindex(regclass) does not exist ! LINE 5: from pgstatindex('test_pkey'::regclass); ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select pg_relpages('test'); ! ERROR: function pg_relpages(unknown) does not exist ! LINE 1: select pg_relpages('test'); ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select pg_relpages('test_pkey'); ! ERROR: function pg_relpages(unknown) does not exist ! LINE 1: select pg_relpages('test_pkey'); ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select pg_relpages('test_pkey'::text); ! ERROR: function pg_relpages(text) does not exist ! LINE 1: select pg_relpages('test_pkey'::text); ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select pg_relpages('test_pkey'::name); ! ERROR: function pg_relpages(name) does not exist ! LINE 1: select pg_relpages('test_pkey'::name); ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select pg_relpages('test_pkey'::regclass); ! ERROR: function pg_relpages(regclass) does not exist ! LINE 1: select pg_relpages('test_pkey'::regclass); ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select pg_relpages(oid) from pg_class where relname = 'test_pkey'; ! ERROR: function pg_relpages(oid) does not exist ! LINE 1: select pg_relpages(oid) from pg_class where relname = 'test_... ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. select pg_relpages(relname) from pg_class where relname = 'test_pkey'; ! ERROR: function pg_relpages(name) does not exist ! LINE 1: select pg_relpages(relname) from pg_class where relname = 't... ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. create index test_ginidx on test using gin (b); select * from pgstatginindex('test_ginidx'); ! ERROR: function pgstatginindex(unknown) does not exist ! LINE 1: select * from pgstatginindex('test_ginidx'); ! ^ ! HINT: No function matches the given name and argument types. You might need to add explicit type casts. ======================================================================