This extension provides cheat (but useful) functions on LightDB.
Note that CREATE EXTENSION lt_cheat_funcs needs to be executed in all the databases that you want to execute the functions that this extension provides.
=# CREATE EXTENSION lt_cheat_funcs;
Return statistics about all memory contexts. This function returns a record, shown in the table below.
Column Name | Data Type | Description |
---|---|---|
name | text | context name |
parent | text | name of parent context |
level | integer | distance from TopMemoryContext in context tree |
total_bytes | bigint | total bytes requested from malloc |
total_nblocks | bigint | total number of malloc blocks |
free_bytes | bigint | free space in bytes |
free_chunks | bigint | number of free chunks |
used_bytes | bigint | used space in bytes |
This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Cause statistics about all memory contexts to be logged. The format of log message for each memory context is:
[name]: [total_bytes] total in [total_nblocks] blocks; [free_bytes] free ([free_chunks] chunks); [used_bytes] used
For descriptions of the above fields, please see pg_stat_get_memory_context().
This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Return information about cached plan source of the specified prepared statement. This function returns a record, shown in the table below.
Column Name | Data Type | Description |
---|---|---|
generic_cost | double precision | cost of generic plan, or -1 if not known |
total_custom_cost | double precision | total cost of custom plans so far |
num_custom_plans | integer | number of plans included in total |
force_generic | boolean | force use of generic plan? |
force_custom | boolean | force use of custom plan? |
Send a signal to LightDB server process. This function can signal to only postmaster, backend, walsender and walreceiver process. Valid signal names are HUP, INT, QUIT, ABRT, KILL, TERM, USR1, USR2, CONT, and STOP. This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
For example, terminate walreceiver process:
=# SELECT pg_signal_process(pid, 'TERM') FROM pg_stat_wal_receiver;
Return the scheduling priority (“nice”) of the specified LightDB server process. This function can get the priority of only postmaster, backend, walsender and walreceiver process. See getpriority(2) man page for details about a scheduling priority. This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Set the scheduling priority (“nice”) of the specified LightDB server process to the specified value. This function can change the priority of only postmaster, backend, walsender and walreceiver process. See getpriority(2) man page for details about a scheduling priority. This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Cause segmentation fault. If lt_cheat_funcs.exit_on_segv is enabled and treat_fatal_as_error is true, segmentation fault that this function causes will lead to ERROR instead of FATAL error. This is intended mainly for testing. This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Read and process the configuration file. Note that, if an error occurs, it’s logged with DEBUG2 level. This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Convert transaction log location string to file name. This function is almost the same as pg_xlogfile_name() which LightDB core provides. The difference of them is whether there is a second parameter of type boolean. If false, this function always fails with an error during recovery. This is the same behavior as the core version of pg_xlogfile_name(). If true, this function can be executed even during recovery. But note that the first 8 digits of returned WAL filename (which represents the timeline ID) can be completely incorrect. That is, this function can return bogus WAL file name. For details of this conversion, please see Section 9.27.3.
Return statistics about all server processes waiting for synchronous replication. This function returns a record per server process waiting for synchronous replication, shown in the table below.
Column Name | Data Type | Description |
---|---|---|
pid | integer | Process ID of a server process |
wait_lsn | pg_lsn | Transaction log position to wait for |
wait_mode | text | Wait mode of this server process |
Possible values of wait_mode are write, flush and apply.
This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Wait for synchronous replication. This function waits until the given transaction log location is acknowledged by synchronous standbys, based on the setting of synchronous_commit.
This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Set and return the next transaction ID. Note that this function doesn’t check if it’s safe to assign the given transaction ID to the next one. The caller must carefully choose the safe transaction ID, e.g., which doesn’t cause a transaction ID wraparound problem. This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Return information about transaction ID assignment state. This function returns a record, shown in the table below.
Column Name | Data Type | Description |
---|---|---|
next_xid | xid | next transaction ID to assign |
oldest_xid | xid | cluster-wide minimum datfrozenxid |
xid_vac_limit | xid | start forcing autovacuums here |
xid_warn_limit | xid | start complaining here |
xid_stop_limit | xid | refuse to advance next transaction ID beyond here |
xid_wrap_limit | xid | where the world ends |
oldest_xid_db | oid | database with minimum datfrozenxid |
This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Set and return the next object ID (OID). Note that the next OID is set to 16384 (FirstNormalObjectId) when the given OID is less than that number. This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Return information about object ID (OID) assignment state. This function returns a record, shown in the table below.
Column Name | Data Type | Description |
---|---|---|
next_oid | oid | next object ID to assign |
oid_count | integer | OIDs available before must do WAL work |
This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Specify the number of transactions by which VACUUM and HOT updates will advance cleanup of dead row versions. vacuum_defer_cleanup_age in the session calling this function is set to the negative value of that specified number. If the argument is omitted or NULL is specified, vacuum_defer_cleanup_age is reset to its original setting value specified in the configuration file. This function returns the vacuum cleanup age.
By advancing the cleanup age, VACUUM and HOT updates can clean up even dead tuples that were produced since oldest transaction had started. So this function is helpful to prevent the database from bloating due to unremovable dead tuples while long transaction is running.
Note that this is extremely dangerous function and can easily corrupt the database. Any important data may disappear and data consistency may be lost completely. This function must not be used for a purpose other than debug.
This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Perform a checkpoint. If fast is true (default), a checkpoint will finish as soon as possible. Otherwise, I/O required for a checkpoint will be spread out over a period of time, to minimize the impact on query processing. If wait is true (default), this function waits for a checkpoint to complete before returning. Otherwise, it just signals checkpointer to do it and returns. If force is true (default), this function forces a checkpoint even if no WAL activity has occurred since the last one. This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Return information about all parameter settings in recovery.conf. This function returns a record, shown in the table below.
Column Name | Data Type | Description |
---|---|---|
name | text | configuration parameter name |
setting | text | value of the parameter |
This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Return the current value of primary_conninfo recovery parameter. If it’s not set yet, NULL is returned. This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function. For details of primary_conninfo parameter, please see primary_conninfo.
Return the Process ID of the postmaster process.
Return the time when the server process attached to the current session was started.
List the file path names of the specified relation.
Return the name of major-version-specific tablespace subdirectory.
Write bytea data to the file. This function creates the file if it does not exist, and truncates it to zero length otherwise. Then this function writes the bytea data from the beginning of the file, and returns the number of bytes written. This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Try to fsync the file or directory. This function is restricted to superusers by default, but other users can be granted EXECUTE to run the function.
Convert number to its equivalent octal representation.
Convert text to its equivalent hexadecimal representation.
Here is an example of the conversion from text to hex:
=# SELECT pg_text_to_hex('LightDB'); pg_text_to_hex ---------------------- 4c696768744442 (1 row)
Convert hexadecimal representation to its equivalent text.
Here is an example of the conversion from hex to text:
=# SELECT pg_hex_to_text('4c696768744442'); pg_hex_to_text ---------------- LightDB (1 row)
Return the character with the given code. This function is almost the same as chr() which LightDB core provides. The difference of them is that this function returns NULL instead of throwing an error when the requested character is too large or not valid. Note that valid Unicode code point stops at U+10FFFF (1114111), even though 4-byte UTF8 sequences can hold values up to U+1FFFFF. Therefore this function returns NULL whenever the given code is larger than 1114111.
Alias of pg_chr(code integer). function.
Return all valid UTF-8 characters. This function returns a record, shown in the table below.
Column Name | Data Type | Description |
---|---|---|
code | text | code of character |
utf8 | text | UTF-8 character |
This function can be executed only under UTF-8 database encoding.
Return EUC_JP character with the given codes. The following table shows the valid combination of the codes.
code1 | code2 | code3 |
---|---|---|
x00 - x7f | - | - |
x8e | xa1 - xdf | - |
xa1 - xfe | xa1 - xfe | - |
x8f | xa1 - xfe | xa1 - xfe |
For example, return EUC_JP character with “a1fa” (BLACK STAR):
=# SELECT pg_eucjp('xa1', 'xfa');
This function returns NULL when the requested character is invalid for EUC_JP. This function can be executed only under EUC_JP database encoding.
Return all valid EUC_JP characters. This function returns a record, shown in the table below.
Column Name | Data Type | Description |
---|---|---|
code1 | text | first byte of character |
code2 | text | second byte of character (x00 means non-existence of this byte) |
code3 | text | third byte of character (x00 means non-existence of this byte) |
eucjp | text | EUC_JP character |
This function can be executed only under EUC_JP database encoding.
Create and return a compressed version of text data. This function uses PGLZ (an implementation of LZ compression for LightDB) for the compression. If the compression fails (e.g., the compressed result is actually bigger than the original), this function returns the original data. Note that the return data may be 4-bytes bigger than the original even when the compression fails because 4-bytes extra information like the length of original data is always stored in it. The bytea data that this function returns needs to be decompressed by using pg_lz_decompress() to obtain the original text data.
Create and return a compressed version of bytea data. This function uses PGLZ (an implementation of LZ compression for LightDB) for the compression. If the compression fails (e.g., the compressed result is actually bigger than the original), this function returns the original data. Note that the return data may be 4-bytes bigger than the original even when the compression fails because 4-bytes extra information like the length of original data is always stored in it. The bytea data that this function returns needs to be decompressed by using pg_lz_decompress_bytea() to obtain the original bytea data.
Decompress a compressed version of bytea data into text. Note that the input of this function must be the bytea data that pg_lz_compress() or pg_lz_compress_bytea() returned. Otherwise this function may return a corrupted data.
Decompress a compressed version of bytea data into bytea. Note that the input of this function must be the bytea data that pg_lz_compress() or pg_lz_compress_bytea() returned. Otherwise this function may return a corrupted data.
Normalize an input string with SASLprep. SASLprep normalization is basically used to process a user-supplied password into canonical form for SCRAM authentication. Note that an error is raised if the input is not a valid UTF-8 string or the normalized string contains characters prohibited by the SASLprep profile.
Release a previously-acquired exclusive transaction-level advisory lock. Return true if the lock is successfully released. If the lock was not held, false is returned, and in addition, an SQL warning will be reported by the server.
Release a previously-acquired shared transaction-level advisory lock. Return true if the lock is successfully released. If the lock was not held, false is returned, and in addition, an SQL warning will be reported by the server.
Same as pg_advisory_xact_unlock(bigint).
Same as pg_advisory_xact_unlock_shared(bigint).
This is an encoding conversion from EUC_JP to UTF-8. It uses two
conversion maps; ordinary map and extra map. They are defined in
conv/euc_jp_to_utf8.map
and
conv/euc_jp_to_utf8.extra
, respectively. For
each character, ordinary map is consulted first. If no match is
found, extra map is consulted next. If still no match, an error
is raised.
The content of ordinary map is the same as the map that euc_jp_to_utf8 (default conversion map from EUC_JP to UTF-8 that LightDB provides) uses. The extra map contains some mappings (e.g., the following mappings for Roman numerals and full-width symbols) that ordinary map doesn’t have.
EUC_JP | UTF-8 | Description |
---|---|---|
fcf1 | e285b0 (U+2170) | SMALL ROMAN NUMERAL ONE |
fcf2 | e285b1 (U+2171) | SMALL ROMAN NUMERAL TWO |
fcf3 | e285b2 (U+2172) | SMALL ROMAN NUMERAL THREE |
fcf4 | e285b3 (U+2173) | SMALL ROMAN NUMERAL FOUR |
fcf5 | e285b4 (U+2174) | SMALL ROMAN NUMERAL FIVE |
fcf6 | e285b5 (U+2175) | SMALL ROMAN NUMERAL SIX |
fcf7 | e285b6 (U+2176) | SMALL ROMAN NUMERAL SEVEN |
fcf8 | e285b7 (U+2177) | SMALL ROMAN NUMERAL EIGHT |
fcf9 | e285b8 (U+2178) | SMALL ROMAN NUMERAL NINE |
fcfa | e285b9 (U+2179) | SMALL ROMAN NUMERAL TEN |
fcfb | efbfa2 (U+FFE2) | FULLWIDTH NOT SIGN |
fcfc | efbfa4 (U+FFE4) | FULLWIDTH BROKEN BAR |
fcfd | efbc87 (U+FF07) | FULLWIDTH APOSTROPHE |
fcfe | efbc82 (U+FF02) | FULLWIDTH QUOTATION MARK |
In order to use pg_euc_jp_to_utf8 as the default conversion from
EUC_JP to UTF-8, its
pg_conversion
.condefault
needs to be enabled. Also condefault for euc_jp_to_utf8
(built-in conversion from EUC_JP to UTF-8) needs to be disabled.
Here is an example of these catalog updates:
=# BEGIN; =# UPDATE pg_conversion SET condefault = 'f' WHERE conname = 'euc_jp_to_utf8'; =# UPDATE pg_conversion SET condefault = 't' WHERE conname = 'pg_euc_jp_to_utf8'; =# COMMIT;
It’s possible to use the customized conversion map by modifying the map files directly and rebuilding lt_cheat_funcs module. Note that entries in a map file must be sorted in ascending order.
Note that shared_preload_libraries or session_preload_libraries must be set to “lt_cheat_funcs” in lightdb.conf if you want to use the configuration parameters which this extension provides.
Cause statistics about the memory contexts to be logged at the end of query execution. For details of log format, please see pg_stat_print_memory_context() This parameter is off by default. Only superusers can change this setting.
If true, client’s application_name is ignored and its setting value is stored in lt_cheat_funcs.hidden_appname parameter. By default, this is set to false, so that the string that client specifies will be used as application_name. This parameter can only be set in the lightdb.conf file or on the server command line.
Report client’s application_name hidden from view. The default is an empty string. Any users can change this setting.
Log options sent to the server at connection start. This parameter is off by default. Only superusers can change this parameter at session start, and it cannot be changed at all within a session.
Specify the scheduling priority (“nice”) of LightDB server process. Valid values are between -20 and 19. Lower values cause more favorable scheduling. The default value is zero. Any users can change this setting. See getpriority(2) man page for details about a scheduling priority.
If off, which is the default, segmentation fault will lead to the server crash. If on, only the current session causing segmentation fault will be terminated. Any users can change this setting.