pgstattuple.diffs
text/plain
Filename: pgstattuple.diffs
Type: text/plain
Part: 8
*** /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.
======================================================================