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.