blob: 2fd1152e8cee0c99525c753d5d3cf6f386b7afb9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
CREATE EXTENSION pgstattuple;
--
-- It's difficult to come up with platform-independent test cases for
-- the pgstattuple functions, but the results for empty tables and
-- indexes should be that.
--
create table test (a int primary key);
select * from pgstattuple('test'::text);
select * from pgstattuple('test'::regclass);
select * from pgstatindex('test_pkey');
select pg_relpages('test');
select pg_relpages('test_pkey');
|
