test_result.txt
text/plain
Filename: test_result.txt
Type: text/plain
Part: 3
CREATE EXTENSION IF NOT EXISTS pg_prewarm;
psql:test.sql:7: NOTICE: extension "pg_prewarm" already exists, skipping
CREATE EXTENSION
SELECT pg_prewarm('pgbench_accounts');
psql:test.sql:9: ERROR: relation "pgbench_accounts" does not have storage
DETAIL: This operation is not supported for partitioned tables.
SELECT pg_prewarm('pgbench_accounts_1');
pg_prewarm
------------
580
(1 row)
SELECT pg_prewarm('pgbench_accounts_pkey');
psql:test.sql:11: ERROR: relation "pgbench_accounts_pkey" does not have storage
DETAIL: This operation is not supported for partitioned indexes.
SELECT pg_prewarm('pgbench_accounts_1_pkey');
pg_prewarm
------------
94
(1 row)
CREATE EXTENSION IF NOT EXISTS amcheck;
psql:test.sql:15: NOTICE: extension "amcheck" already exists, skipping
CREATE EXTENSION
SELECT bt_index_check('pgbench_accounts'::regclass, true, true);
psql:test.sql:16: ERROR: "pgbench_accounts" is not an index
SELECT bt_index_check('pgbench_accounts_1'::regclass, true, true);
psql:test.sql:17: ERROR: "pgbench_accounts_1" is not an index
SELECT bt_index_check('pgbench_accounts_pkey'::regclass, true, true);
psql:test.sql:18: ERROR: expected "btree" index as targets for verification
DETAIL: Relation "pgbench_accounts_pkey" is a btree index.
SELECT bt_index_check('pgbench_accounts_1_pkey'::regclass, true, true);
bt_index_check
----------------
(1 row)
SELECT bt_index_parent_check('pgbench_accounts'::regclass, true, true);
psql:test.sql:21: ERROR: "pgbench_accounts" is not an index
SELECT bt_index_parent_check('pgbench_accounts_1'::regclass, true, true);
psql:test.sql:22: ERROR: "pgbench_accounts_1" is not an index
SELECT bt_index_parent_check('pgbench_accounts_pkey'::regclass, true, true);
psql:test.sql:23: ERROR: expected "btree" index as targets for verification
DETAIL: Relation "pgbench_accounts_pkey" is a btree index.
SELECT bt_index_parent_check('pgbench_accounts_1_pkey'::regclass, true, true);
bt_index_parent_check
-----------------------
(1 row)
SELECT gin_index_check('pgbench_accounts'::regclass);
psql:test.sql:26: ERROR: "pgbench_accounts" is not an index
SELECT gin_index_check('pgbench_accounts_1'::regclass);
psql:test.sql:27: ERROR: "pgbench_accounts_1" is not an index
SELECT gin_index_check('pgbench_accounts_pkey'::regclass);
psql:test.sql:28: ERROR: expected "gin" index as targets for verification
DETAIL: Relation "pgbench_accounts_pkey" is a btree index.
SELECT gin_index_check('pgbench_accounts_1_pkey'::regclass);
psql:test.sql:29: ERROR: expected "gin" index as targets for verification
DETAIL: Relation "pgbench_accounts_1_pkey" is a btree index.
SELECT verify_heapam('pgbench_accounts'::regclass);
psql:test.sql:31: ERROR: cannot check relation "pgbench_accounts"
DETAIL: This operation is not supported for partitioned tables.
SELECT verify_heapam('pgbench_accounts_1'::regclass);
verify_heapam
---------------
(0 rows)
SELECT verify_heapam('pgbench_accounts_pkey'::regclass);
psql:test.sql:33: ERROR: cannot check relation "pgbench_accounts_pkey"
DETAIL: This operation is not supported for partitioned indexes.
SELECT verify_heapam('pgbench_accounts_1_pkey'::regclass);
psql:test.sql:34: ERROR: cannot check relation "pgbench_accounts_1_pkey"
DETAIL: This operation is not supported for indexes.
SELECT brin_summarize_new_values('pgbench_accounts'::regclass);
psql:test.sql:37: ERROR: "pgbench_accounts" is not an index
SELECT brin_summarize_new_values('pgbench_accounts_1'::regclass);
psql:test.sql:38: ERROR: "pgbench_accounts_1" is not an index
SELECT brin_summarize_new_values('pgbench_accounts_pkey'::regclass);
psql:test.sql:39: ERROR: "pgbench_accounts_pkey" is not a BRIN index
SELECT brin_summarize_new_values('pgbench_accounts_1_pkey'::regclass);
psql:test.sql:40: ERROR: "pgbench_accounts_1_pkey" is not a BRIN index
SELECT brin_summarize_range('pgbench_accounts'::regclass, 1);
psql:test.sql:42: ERROR: "pgbench_accounts" is not an index
SELECT brin_summarize_range('pgbench_accounts_1'::regclass, 1);
psql:test.sql:43: ERROR: "pgbench_accounts_1" is not an index
SELECT brin_summarize_range('pgbench_accounts_pkey'::regclass, 1);
psql:test.sql:44: ERROR: "pgbench_accounts_pkey" is not a BRIN index
SELECT brin_summarize_range('pgbench_accounts_1_pkey'::regclass, 1);
psql:test.sql:45: ERROR: "pgbench_accounts_1_pkey" is not a BRIN index
SELECT brin_desummarize_range('pgbench_accounts'::regclass, 1);
psql:test.sql:47: ERROR: "pgbench_accounts" is not an index
SELECT brin_desummarize_range('pgbench_accounts_1'::regclass, 1);
psql:test.sql:48: ERROR: "pgbench_accounts_1" is not an index
SELECT brin_desummarize_range('pgbench_accounts_pkey'::regclass, 1);
psql:test.sql:49: ERROR: "pgbench_accounts_pkey" is not a BRIN index
SELECT brin_desummarize_range('pgbench_accounts_1_pkey'::regclass, 1);
psql:test.sql:50: ERROR: "pgbench_accounts_1_pkey" is not a BRIN index
CREATE EXTENSION IF NOT EXISTS pageinspect;
psql:test.sql:53: NOTICE: extension "pageinspect" already exists, skipping
CREATE EXTENSION
SELECT tuple_data_split(
'pgbench_accounts'::regclass,
t_data, t_infomask, t_infomask2, t_bits
)
FROM heap_page_items(get_raw_page('pgbench_accounts_1', 2)) LIMIT 1;
psql:test.sql:59: ERROR: only heap AM is supported
SELECT tuple_data_split(
'pgbench_accounts_1'::regclass,
t_data, t_infomask, t_infomask2, t_bits
)
FROM heap_page_items(get_raw_page('pgbench_accounts_1', 2)) LIMIT 1;
tuple_data_split
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"\\x7b000000","\\x01000000","\\x00000000","\\xab202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020"}
(1 row)
SELECT tuple_data_split(
'pgbench_accounts_pkey'::regclass,
t_data, t_infomask, t_infomask2, t_bits
)
FROM heap_page_items(get_raw_page('pgbench_accounts_1', 2)) LIMIT 1;
psql:test.sql:69: ERROR: only heap AM is supported
SELECT tuple_data_split(
'pgbench_accounts_1_pkey'::regclass,
t_data, t_infomask, t_infomask2, t_bits
)
FROM heap_page_items(get_raw_page('pgbench_accounts_1', 2)) LIMIT 1;
psql:test.sql:74: ERROR: only heap AM is supported
SELECT * FROM heap_page_item_attrs(
get_raw_page('pgbench_accounts', 0),
'pgbench_accounts'::regclass
) LIMIT 1;
psql:test.sql:79: ERROR: cannot get raw page from relation "pgbench_accounts"
DETAIL: This operation is not supported for partitioned tables.
SELECT * FROM heap_page_item_attrs(
get_raw_page('pgbench_accounts_1', 0),
'pgbench_accounts_1'::regclass
) LIMIT 1;
lp | lp_off | lp_flags | lp_len | t_xmin | t_xmax | t_field3 | t_ctid | t_infomask2 | t_infomask | t_hoff | t_bits | t_oid | t_attrs
----+--------+----------+--------+--------+--------+----------+--------+-------------+------------+--------+--------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 | 8064 | 1 | 121 | 766 | 0 | 8 | (0,1) | 4 | 2306 | 24 | | | {"\\x01000000","\\x01000000","\\x00000000","\\xab202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020"}
(1 row)
SELECT * FROM heap_page_item_attrs(
get_raw_page('pgbench_accounts_pkey', 0),
'pgbench_accounts_pkey'::regclass
) LIMIT 1;
psql:test.sql:87: ERROR: cannot get raw page from relation "pgbench_accounts_pkey"
DETAIL: This operation is not supported for partitioned indexes.
SELECT * FROM heap_page_item_attrs(
get_raw_page('pgbench_accounts_1_pkey', 0),
'pgbench_accounts_1_pkey'::regclass
) LIMIT 1;
lp | lp_off | lp_flags | lp_len | t_xmin | t_xmax | t_field3 | t_ctid | t_infomask2 | t_infomask | t_hoff | t_bits | t_oid | t_attrs
----+--------+----------+--------+--------+--------+----------+--------+-------------+------------+--------+--------+-------+---------
1 | 12642 | 2 | 2 | | | | | | | | | |
(1 row)
SELECT * FROM gist_page_items(
get_raw_page('pgbench_accounts', 1),
'pgbench_accounts'::regclass
);
psql:test.sql:96: ERROR: cannot get raw page from relation "pgbench_accounts"
DETAIL: This operation is not supported for partitioned tables.
SELECT * FROM gist_page_items(
get_raw_page('pgbench_accounts_1', 1),
'pgbench_accounts_1'::regclass
);
psql:test.sql:100: ERROR: "pgbench_accounts_1" is not an index
SELECT * FROM gist_page_items(
get_raw_page('pgbench_accounts_pkey', 1),
'pgbench_accounts_pkey'::regclass
);
psql:test.sql:104: ERROR: cannot get raw page from relation "pgbench_accounts_pkey"
DETAIL: This operation is not supported for partitioned indexes.
SELECT * FROM gist_page_items(
get_raw_page('pgbench_accounts_1_pkey', 1),
'pgbench_accounts_1_pkey'::regclass
);
psql:test.sql:108: ERROR: "pgbench_accounts_1_pkey" is not a GiST index
CREATE EXTENSION IF NOT EXISTS pgstattuple;
psql:test.sql:111: NOTICE: extension "pgstattuple" already exists, skipping
CREATE EXTENSION
SELECT * FROM pgstattuple('pgbench_accounts');
psql:test.sql:113: ERROR: cannot get tuple-level statistics for relation "pgbench_accounts"
DETAIL: This operation is not supported for partitioned tables.
SELECT * FROM pgstattuple('pgbench_accounts_1');
table_len | tuple_count | tuple_len | tuple_percent | dead_tuple_count | dead_tuple_len | dead_tuple_percent | free_space | free_percent
-----------+-------------+-----------+---------------+------------------+----------------+--------------------+------------+--------------
4751360 | 33334 | 4033414 | 84.89 | 0 | 0 | 0 | 67808 | 1.43
(1 row)
SELECT * FROM pgstattuple('pgbench_accounts_pkey');
psql:test.sql:115: ERROR: cannot get tuple-level statistics for relation "pgbench_accounts_pkey"
DETAIL: This operation is not supported for partitioned indexes.
SELECT * FROM pgstattuple('pgbench_accounts_1_pkey');
table_len | tuple_count | tuple_len | tuple_percent | dead_tuple_count | dead_tuple_len | dead_tuple_percent | free_space | free_percent
-----------+-------------+-----------+---------------+------------------+----------------+--------------------+------------+--------------
770048 | 33334 | 533344 | 69.26 | 0 | 0 | 0 | 81484 | 10.58
(1 row)
SELECT * FROM pgstatindex('pgbench_accounts_pkey');
psql:test.sql:118: ERROR: relation "pgbench_accounts_pkey" is not a btree index
SELECT * FROM pgstatindex('pgbench_accounts_1_pkey');
version | tree_level | index_size | root_block_no | internal_pages | leaf_pages | empty_pages | deleted_pages | avg_leaf_density | leaf_fragmentation
---------+------------+------------+---------------+----------------+------------+-------------+---------------+------------------+--------------------
4 | 1 | 770048 | 3 | 1 | 92 | 0 | 0 | 89.14 | 0
(1 row)
SELECT * FROM pgstatindex('pgbench_accounts');
psql:test.sql:120: ERROR: relation "pgbench_accounts" is not a btree index
SELECT * FROM pgstatindex('pgbench_accounts_1');
psql:test.sql:121: ERROR: relation "pgbench_accounts_1" is not a btree index
SELECT * FROM pgstatginindex('pgbench_accounts_pkey');
psql:test.sql:123: ERROR: relation "pgbench_accounts_pkey" is not a GIN index
SELECT * FROM pgstatginindex('pgbench_accounts_1_pkey');
psql:test.sql:124: ERROR: relation "pgbench_accounts_1_pkey" is not a GIN index
SELECT * FROM pgstatginindex('pgbench_accounts');
psql:test.sql:125: ERROR: relation "pgbench_accounts" is not a GIN index
SELECT * FROM pgstatginindex('pgbench_accounts_1');
psql:test.sql:126: ERROR: relation "pgbench_accounts_1" is not a GIN index
SELECT * FROM pgstathashindex('pgbench_accounts_pkey');
psql:test.sql:128: ERROR: relation "pgbench_accounts_pkey" is not a hash index
SELECT * FROM pgstathashindex('pgbench_accounts_1_pkey');
psql:test.sql:129: ERROR: relation "pgbench_accounts_1_pkey" is not a hash index
SELECT * FROM pgstathashindex('pgbench_accounts');
psql:test.sql:130: ERROR: relation "pgbench_accounts" is not a hash index
SELECT * FROM pgstathashindex('pgbench_accounts_1');
psql:test.sql:131: ERROR: relation "pgbench_accounts_1" is not a hash index
SELECT pg_relpages('pgbench_accounts');
psql:test.sql:133: ERROR: cannot get page count of relation "pgbench_accounts"
DETAIL: This operation is not supported for partitioned tables.
SELECT pg_relpages('pgbench_accounts_1');
pg_relpages
-------------
580
(1 row)
SELECT pg_relpages('pgbench_accounts_pkey');
psql:test.sql:135: ERROR: cannot get page count of relation "pgbench_accounts_pkey"
DETAIL: This operation is not supported for partitioned indexes.
SELECT pg_relpages('pgbench_accounts_1_pkey');
pg_relpages
-------------
94
(1 row)
SELECT * FROM pgstattuple_approx('pgbench_accounts');
psql:test.sql:138: ERROR: relation "pgbench_accounts" is of wrong relation kind
DETAIL: This operation is not supported for partitioned tables.
SELECT * FROM pgstattuple_approx('pgbench_accounts_1');
table_len | scanned_percent | approx_tuple_count | approx_tuple_len | approx_tuple_percent | dead_tuple_count | dead_tuple_len | dead_tuple_percent | approx_free_space | approx_free_percent
-----------+-------------------+--------------------+------------------+----------------------+------------------+----------------+--------------------+-------------------+---------------------
4751360 | 5.689655172413793 | 31437 | 4424160 | 93.11355064655173 | 0 | 0 | 0 | 56864 | 1.1967941810344827
(1 row)
SELECT * FROM pgstattuple_approx('pgbench_accounts_pkey');
psql:test.sql:140: ERROR: relation "pgbench_accounts_pkey" is of wrong relation kind
DETAIL: This operation is not supported for partitioned indexes.
SELECT * FROM pgstattuple_approx('pgbench_accounts_1_pkey');
psql:test.sql:141: ERROR: relation "pgbench_accounts_1_pkey" is of wrong relation kind
DETAIL: This operation is not supported for indexes.
CREATE EXTENSION IF NOT EXISTS pg_surgery;
psql:test.sql:144: NOTICE: extension "pg_surgery" already exists, skipping
CREATE EXTENSION
SELECT heap_force_kill('pgbench_accounts', ARRAY['(0, 1)']::tid[]);
psql:test.sql:145: ERROR: cannot operate on relation "pgbench_accounts"
DETAIL: This operation is not supported for partitioned tables.
SELECT heap_force_kill('pgbench_accounts_1', ARRAY['(0, 1)']::tid[]);
heap_force_kill
-----------------
(1 row)
SELECT heap_force_kill('pgbench_accounts_pkey', ARRAY['(0, 1)']::tid[]);
psql:test.sql:147: ERROR: cannot operate on relation "pgbench_accounts_pkey"
DETAIL: This operation is not supported for partitioned indexes.
SELECT heap_force_kill('pgbench_accounts_1_pkey', ARRAY['(0, 1)']::tid[]);
psql:test.sql:148: ERROR: cannot operate on relation "pgbench_accounts_1_pkey"
DETAIL: This operation is not supported for indexes.
SELECT heap_force_freeze('pgbench_accounts', ARRAY['(0, 1)']::tid[]);
psql:test.sql:150: ERROR: cannot operate on relation "pgbench_accounts"
DETAIL: This operation is not supported for partitioned tables.
SELECT heap_force_freeze('pgbench_accounts_1', ARRAY['(0, 1)']::tid[]);
psql:test.sql:151: NOTICE: skipping tid (0, 1) for relation "pgbench_accounts_1" because it is marked dead
heap_force_freeze
-------------------
(1 row)
SELECT heap_force_freeze('pgbench_accounts_pkey', ARRAY['(0, 1)']::tid[]);
psql:test.sql:152: ERROR: cannot operate on relation "pgbench_accounts_pkey"
DETAIL: This operation is not supported for partitioned indexes.
SELECT heap_force_freeze('pgbench_accounts_1_pkey', ARRAY['(0, 1)']::tid[]);
psql:test.sql:153: ERROR: cannot operate on relation "pgbench_accounts_1_pkey"
DETAIL: This operation is not supported for indexes.
CREATE EXTENSION IF NOT EXISTS pg_visibility;
psql:test.sql:156: NOTICE: extension "pg_visibility" already exists, skipping
CREATE EXTENSION
SELECT * FROM pg_visibility_map('pgbench_accounts') LIMIT 1;
psql:test.sql:158: ERROR: relation "pgbench_accounts" is of wrong relation kind
DETAIL: This operation is not supported for partitioned tables.
SELECT * FROM pg_visibility_map('pgbench_accounts_1') LIMIT 1;
blkno | all_visible | all_frozen
-------+-------------+------------
0 | f | f
(1 row)
SELECT * FROM pg_visibility_map('pgbench_accounts_pkey') LIMIT 1;
psql:test.sql:160: ERROR: relation "pgbench_accounts_pkey" is of wrong relation kind
DETAIL: This operation is not supported for partitioned indexes.
SELECT * FROM pg_visibility_map('pgbench_accounts_1_pkey') LIMIT 1;
psql:test.sql:161: ERROR: relation "pgbench_accounts_1_pkey" is of wrong relation kind
DETAIL: This operation is not supported for indexes.
SELECT * FROM pg_visibility('pgbench_accounts') LIMIT 1;
psql:test.sql:163: ERROR: relation "pgbench_accounts" is of wrong relation kind
DETAIL: This operation is not supported for partitioned tables.
SELECT * FROM pg_visibility('pgbench_accounts_1') LIMIT 1;
blkno | all_visible | all_frozen | pd_all_visible
-------+-------------+------------+----------------
0 | f | f | f
(1 row)
SELECT * FROM pg_visibility('pgbench_accounts_pkey') LIMIT 1;
psql:test.sql:165: ERROR: relation "pgbench_accounts_pkey" is of wrong relation kind
DETAIL: This operation is not supported for partitioned indexes.
SELECT * FROM pg_visibility('pgbench_accounts_1_pkey') LIMIT 1;
psql:test.sql:166: ERROR: relation "pgbench_accounts_1_pkey" is of wrong relation kind
DETAIL: This operation is not supported for indexes.
SELECT * FROM pg_visibility_map_summary('pgbench_accounts');
psql:test.sql:168: ERROR: relation "pgbench_accounts" is of wrong relation kind
DETAIL: This operation is not supported for partitioned tables.
SELECT * FROM pg_visibility_map_summary('pgbench_accounts_1');
all_visible | all_frozen
-------------+------------
546 | 0
(1 row)
SELECT * FROM pg_visibility_map_summary('pgbench_accounts_pkey');
psql:test.sql:170: ERROR: relation "pgbench_accounts_pkey" is of wrong relation kind
DETAIL: This operation is not supported for partitioned indexes.
SELECT * FROM pg_visibility_map_summary('pgbench_accounts_1_pkey');
psql:test.sql:171: ERROR: relation "pgbench_accounts_1_pkey" is of wrong relation kind
DETAIL: This operation is not supported for indexes.
SELECT * FROM pg_check_frozen('pgbench_accounts');
psql:test.sql:173: ERROR: relation "pgbench_accounts" is of wrong relation kind
DETAIL: This operation is not supported for partitioned tables.
SELECT * FROM pg_check_frozen('pgbench_accounts_1');
t_ctid
--------
(0 rows)
SELECT * FROM pg_check_frozen('pgbench_accounts_pkey');
psql:test.sql:175: ERROR: relation "pgbench_accounts_pkey" is of wrong relation kind
DETAIL: This operation is not supported for partitioned indexes.
SELECT * FROM pg_check_frozen('pgbench_accounts_1_pkey');
psql:test.sql:176: ERROR: relation "pgbench_accounts_1_pkey" is of wrong relation kind
DETAIL: This operation is not supported for indexes.
SELECT * FROM pg_check_visible('pgbench_accounts');
psql:test.sql:178: ERROR: relation "pgbench_accounts" is of wrong relation kind
DETAIL: This operation is not supported for partitioned tables.
SELECT * FROM pg_check_visible('pgbench_accounts_1');
t_ctid
--------
(0 rows)
SELECT * FROM pg_check_visible('pgbench_accounts_pkey');
psql:test.sql:180: ERROR: relation "pgbench_accounts_pkey" is of wrong relation kind
DETAIL: This operation is not supported for partitioned indexes.
SELECT * FROM pg_check_visible('pgbench_accounts_1_pkey');
psql:test.sql:181: ERROR: relation "pgbench_accounts_1_pkey" is of wrong relation kind
DETAIL: This operation is not supported for indexes.
SELECT pg_truncate_visibility_map('pgbench_accounts');
psql:test.sql:183: ERROR: relation "pgbench_accounts" is of wrong relation kind
DETAIL: This operation is not supported for partitioned tables.
SELECT pg_truncate_visibility_map('pgbench_accounts_1');
pg_truncate_visibility_map
----------------------------
(1 row)
SELECT pg_truncate_visibility_map('pgbench_accounts_pkey');
psql:test.sql:185: ERROR: relation "pgbench_accounts_pkey" is of wrong relation kind
DETAIL: This operation is not supported for partitioned indexes.
SELECT pg_truncate_visibility_map('pgbench_accounts_1_pkey');
psql:test.sql:186: ERROR: relation "pgbench_accounts_1_pkey" is of wrong relation kind
DETAIL: This operation is not supported for indexes.