pg_buffercache
The buffer cache contents of a database cluster can be inspected and analyzed using a set of functions that provide detailed information about the current state of shared buffers, including usage patterns and hit ratios.
Information Analysis
| Extensibility Types: | Functions |
| System Components: | None |
Duplicate Code Analysis
| Total Lines of Code: ? | 239 |
| Lines of Duplicate Code: ? | 0 |
| Percentage of Codebase: ? | 0% |
Versioning Analysis
| Total Lines of Code: ? | 239 |
| Lines of Encapsulated Versioning Code: ? | 0 |
| Percentage of Encapsulated Versioning Code in Codebase: ? | 0% |
Compatibility Analysis
| Number of Failed Extensions: | 6 |
| Failure Rate: | 5.8% |
Failed Extensions
earthdistance
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_buffercache ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 220 ms
======================
1 of 1 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_buffercache ==============
CREATE EXTENSION
============== running regression test queries ==============
test earthdistance ... FAILED 137 ms
======================
1 of 1 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/postgresql-15.3/contrib/earthdistance/regression.out".
waiting for server to shut down.... done
server stopped
pg_queryid
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_buffercache ==============
CREATE EXTENSION
============== running regression test queries ==============
test pg_queryid ... FAILED 49 ms
======================
1 of 1 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_queryid/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_queryid/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
pg_ctl: PID file "pg-15-data/postmaster.pid" does not exist
Is server running?
pg_stat_kcache
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: the database system is shutting down
command failed: "/home/abigalek/pgext-cli-python/pg-15-dist/bin/psql" -X -c "SET client_min_messages = warning" -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
pg_ctl: PID file "pg-15-data/postmaster.pid" does not exist
Is server running?
pg_stat_monitor
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_buffercache ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 19 ms
test version ... ok 18 ms
test guc ... ok 22 ms
test pgsm_query_id ... ok 607 ms
test functions ... FAILED 88 ms
test counters ... ok 90 ms
test relations ... ok 186 ms
test database ... ok 440 ms
test error_insert ... ok 87 ms
test application_name ... ok 33 ms
test application_name_unique ... ok 21 ms
test top_query ... ok 28 ms
test cmd_type ... ok 49 ms
test error ... ok 27 ms
test rows ... ok 65 ms
test tags ... ok 28 ms
test user ... ok 80 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
SET
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_buffercache ==============
CREATE EXTENSION
============== running regression test queries ==============
test basic ... ok 14 ms
test version ... ok 14 ms
test guc ... ok 41 ms
test pgsm_query_id ... ok 351 ms
test functions ... FAILED 67 ms
test counters ... ok 64 ms
test relations ... ok 81 ms
test database ... ok 283 ms
test error_insert ... ok 34 ms
test application_name ... ok 20 ms
test application_name_unique ... ok 16 ms
test top_query ... ok 18 ms
test cmd_type ... ok 35 ms
test error ... ok 43 ms
test rows ... ok 62 ms
test tags ... ok 33 ms
test user ... ok 42 ms
=======================
1 of 17 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pg_stat_monitor/regression.out".
waiting for server to shut down.... done
server stopped
pgextwlist
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_buffercache ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 54 ms
test pgextwlist ... FAILED 93 ms
test errors ... FAILED 8 ms
test crossuser ... ok 46 ms
test hooks ... ok 31 ms
======================
2 of 5 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.out".
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
SET
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== installing pg_buffercache ==============
CREATE EXTENSION
============== running regression test queries ==============
test setup ... ok 33 ms
test pgextwlist ... FAILED 38 ms
test errors ... FAILED 9 ms
test crossuser ... ok 18 ms
test hooks ... ok 9 ms
======================
2 of 5 tests failed.
======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli-python/pgextworkdir/pgextwlist-1.15/regression.out".
waiting for server to shut down.... done
server stopped
timescaledb
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
CREATE EXTENSION
waiting for server to shut down.... done
server stopped
TESTS
IGNORES
SKIPS
(using postmaster on localhost, port 5432)
============== dropping database "single" ==============
SET
DROP DATABASE
============== dropping role "super_user" ==============
SET
DROP ROLE
============== dropping role "default_perm_user" ==============
SET
DROP ROLE
============== dropping role "default_perm_user_2" ==============
SET
DROP ROLE
============== dropping role "cluster_super_user" ==============
SET
DROP ROLE
============== dropping role "test_role_1" ==============
SET
DROP ROLE
============== dropping role "test_role_2" ==============
SET
DROP ROLE
============== dropping role "test_role_3" ==============
SET
DROP ROLE
============== dropping role "test_role_4" ==============
SET
DROP ROLE
============== dropping role "test_role_read_only" ==============
SET
DROP ROLE
============== creating database "single" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== creating role "super_user" ==============
CREATE ROLE
GRANT
============== creating role "default_perm_user" ==============
CREATE ROLE
GRANT
============== creating role "default_perm_user_2" ==============
CREATE ROLE
GRANT
============== creating role "cluster_super_user" ==============
CREATE ROLE
GRANT
============== creating role "test_role_1" ==============
CREATE ROLE
GRANT
============== creating role "test_role_2" ==============
CREATE ROLE
GRANT
============== creating role "test_role_3" ==============
CREATE ROLE
GRANT
============== creating role "test_role_4" ==============
CREATE ROLE
GRANT
============== creating role "test_role_read_only" ==============
CREATE ROLE
GRANT
============== running regression test queries ==============
test alter ... ok 1135 ms
test alternate_users ... ok 799 ms
test chunk_utils ... ok 868 ms
test index ... ok 1023 ms
test pg_dump_unprivileged ... ok 783 ms
test tablespace ... ok 752 ms
parallel group (21 tests): chunks broken_tables drop_extension custom_type ddl_extra create_chunks delete-15 baserel_cache ddl_errors cluster-15 ddl-15 drop_hypertable cursor-15 agg_bookends-15 create_table create_hypertable copy-15 chunk_adaptive constraint-15 drop_owned append-15
agg_bookends-15 ... ok 4986 ms
append-15 ... ok 6782 ms
baserel_cache ... ok 4972 ms
broken_tables ... ok 4967 ms
chunk_adaptive ... ok 5029 ms
chunks ... ok 4965 ms
cluster-15 ... ok 4980 ms
constraint-15 ... ok 5093 ms
copy-15 ... ok 5008 ms
create_chunks ... ok 4971 ms
create_hypertable ... ok 4986 ms
create_table ... ok 4986 ms
cursor-15 ... ok 4982 ms
custom_type ... ok 4970 ms
ddl-15 ... ok 4979 ms
ddl_errors ... ok 4971 ms
ddl_extra ... ok 4969 ms
delete-15 ... ok 4970 ms
drop_extension ... FAILED 4966 ms
drop_hypertable ... FAILED 4978 ms
drop_owned ... ok 5101 ms
parallel group (21 tests): generated_as_identity hash lateral insert_returning histogram_test license partitioning misc information_views partition grant_hypertable merge null_exclusion parallel-15 drop_rename_hypertable drop_schema dump_meta insert_single extension_scripts insert-15 insert_many
drop_rename_hypertable ... ok 6259 ms
drop_schema ... ok 6261 ms
dump_meta ... ok 6262 ms
extension_scripts ... ok 6271 ms
generated_as_identity ... ok 4721 ms
grant_hypertable ... ok 6257 ms
hash ... ok 6243 ms
histogram_test ... ok 6246 ms
information_views ... ok 6247 ms
insert-15 ... ok 6487 ms
insert_many ... ok 7547 ms
insert_returning ... ok 6245 ms
insert_single ... ok 6267 ms
lateral ... ok 6244 ms
license ... ok 6245 ms
merge ... ok 6256 ms
misc ... ok 6245 ms
null_exclusion ... ok 6256 ms
parallel-15 ... ok 6255 ms
partition ... ok 6254 ms
partitioning ... ok 6244 ms
parallel group (21 tests): sort_optimization reloptions tableam triggers partitionwise-15 sql_query timestamp upsert plain plan_hypertable_inline-15 update-15 rowsecurity-15 size_utils query-15 plan_expand_hypertable-15 plan_ordered_append trusted_extension truncate relocate_extension plan_hashagg-15 pg_join
partitionwise-15 ... ok 7573 ms
pg_join ... ok 9880 ms
plain ... ok 7579 ms
plan_expand_hypertable-15 ... ok 7586 ms
plan_hashagg-15 ... ok 9297 ms
plan_hypertable_inline-15 ... ok 7579 ms
plan_ordered_append ... ok 7595 ms
query-15 ... ok 7583 ms
relocate_extension ... ok 8208 ms
reloptions ... ok 7565 ms
rowsecurity-15 ... ok 7581 ms
size_utils ... ok 7581 ms
sort_optimization ... ok 6920 ms
sql_query ... ok 7573 ms
tableam ... ok 7568 ms
timestamp ... ok 7573 ms
triggers ... ok 7568 ms
truncate ... ok 8037 ms
trusted_extension ... ok 7935 ms
update-15 ... ok 7580 ms
upsert ... ok 7576 ms
parallel group (4 tests): util version vacuum_parallel vacuum
util ... ok 736 ms
vacuum ... ok 746 ms
vacuum_parallel ... ok 745 ms
version ... ok 744 ms
=======================
2 of 73 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.out".
The files belonging to this database system will be owned by user "abigalek".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
creating directory pg-15-data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg-15-dist/bin/pg_ctl -D pg-15-data -l logfile start
waiting for server to start.... done
server started
CREATE EXTENSION
waiting for server to shut down.... done
server stopped
TESTS
IGNORES
SKIPS
(using postmaster on localhost, port 5432)
============== dropping database "single" ==============
SET
DROP DATABASE
============== dropping role "super_user" ==============
SET
DROP ROLE
============== dropping role "default_perm_user" ==============
SET
DROP ROLE
============== dropping role "default_perm_user_2" ==============
SET
DROP ROLE
============== dropping role "cluster_super_user" ==============
SET
DROP ROLE
============== dropping role "test_role_1" ==============
SET
DROP ROLE
============== dropping role "test_role_2" ==============
SET
DROP ROLE
============== dropping role "test_role_3" ==============
SET
DROP ROLE
============== dropping role "test_role_4" ==============
SET
DROP ROLE
============== dropping role "test_role_read_only" ==============
SET
DROP ROLE
============== creating database "single" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== creating role "super_user" ==============
CREATE ROLE
GRANT
============== creating role "default_perm_user" ==============
CREATE ROLE
GRANT
============== creating role "default_perm_user_2" ==============
CREATE ROLE
GRANT
============== creating role "cluster_super_user" ==============
CREATE ROLE
GRANT
============== creating role "test_role_1" ==============
CREATE ROLE
GRANT
============== creating role "test_role_2" ==============
CREATE ROLE
GRANT
============== creating role "test_role_3" ==============
CREATE ROLE
GRANT
============== creating role "test_role_4" ==============
CREATE ROLE
GRANT
============== creating role "test_role_read_only" ==============
CREATE ROLE
GRANT
============== running regression test queries ==============
test alter ... ok 1142 ms
test alternate_users ... ok 799 ms
test chunk_utils ... ok 886 ms
test index ... ok 1069 ms
test pg_dump_unprivileged ... ok 774 ms
test tablespace ... ok 775 ms
parallel group (21 tests): custom_type ddl_errors chunks baserel_cache create_table create_chunks broken_tables cursor-15 cluster-15 delete-15 ddl_extra drop_extension drop_hypertable create_hypertable agg_bookends-15 ddl-15 copy-15 chunk_adaptive constraint-15 drop_owned append-15
agg_bookends-15 ... ok 5022 ms
append-15 ... ok 6871 ms
baserel_cache ... ok 5004 ms
broken_tables ... ok 5011 ms
chunk_adaptive ... ok 5049 ms
chunks ... ok 5001 ms
cluster-15 ... ok 5015 ms
constraint-15 ... ok 5161 ms
copy-15 ... ok 5049 ms
create_chunks ... ok 5010 ms
create_hypertable ... ok 5019 ms
create_table ... ok 5008 ms
cursor-15 ... ok 5015 ms
custom_type ... ok 5000 ms
ddl-15 ... ok 5045 ms
ddl_errors ... ok 5000 ms
ddl_extra ... ok 5015 ms
delete-15 ... ok 5014 ms
drop_extension ... FAILED 5016 ms
drop_hypertable ... FAILED 5016 ms
drop_owned ... ok 5172 ms
parallel group (21 tests): misc license merge lateral generated_as_identity insert_single partitioning null_exclusion grant_hypertable drop_rename_hypertable insert_returning dump_meta hash drop_schema histogram_test information_views partition parallel-15 extension_scripts insert-15 insert_many
drop_rename_hypertable ... ok 6106 ms
drop_schema ... ok 6111 ms
dump_meta ... ok 6110 ms
extension_scripts ... ok 6116 ms
generated_as_identity ... ok 6090 ms
grant_hypertable ... ok 6106 ms
hash ... ok 6110 ms
histogram_test ... ok 6111 ms
information_views ... ok 6111 ms
insert-15 ... ok 6357 ms
insert_many ... ok 7274 ms
insert_returning ... ok 6109 ms
insert_single ... ok 6089 ms
lateral ... ok 6078 ms
license ... ok 6078 ms
merge ... ok 6078 ms
misc ... ok 4513 ms
null_exclusion ... ok 6098 ms
parallel-15 ... ok 6110 ms
partition ... ok 6110 ms
partitioning ... ok 6088 ms
parallel group (21 tests): plan_hypertable_inline-15 tableam sql_query upsert sort_optimization timestamp triggers size_utils plain reloptions update-15 rowsecurity-15 partitionwise-15 plan_ordered_append query-15 plan_expand_hypertable-15 trusted_extension truncate relocate_extension plan_hashagg-15 pg_join
partitionwise-15 ... ok 8093 ms
pg_join ... ok 10469 ms
plain ... ok 8087 ms
plan_expand_hypertable-15 ... ok 8120 ms
plan_hashagg-15 ... ok 9028 ms
plan_hypertable_inline-15 ... ok 7417 ms
plan_ordered_append ... ok 8099 ms
query-15 ... ok 8108 ms
relocate_extension ... ok 8924 ms
reloptions ... ok 8087 ms
rowsecurity-15 ... ok 8089 ms
size_utils ... ok 8085 ms
sort_optimization ... ok 8080 ms
sql_query ... ok 8068 ms
tableam ... ok 8063 ms
timestamp ... ok 8083 ms
triggers ... ok 8083 ms
truncate ... ok 8742 ms
trusted_extension ... ok 8574 ms
update-15 ... ok 8086 ms
upsert ... ok 8070 ms
parallel group (4 tests): version util vacuum_parallel vacuum
util ... ok 758 ms
vacuum ... ok 761 ms
vacuum_parallel ... ok 761 ms
version ... ok 747 ms
=======================
2 of 73 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/abigalek/pgext-cli/pgextworkdir/timescaledb-2.11.1/build/test/regression.out".