When running the \dt command in PostgreSQL, the error message “Did not find any relations” means that no tables were found in the current schema that is visible to the user running the command. In PostgreSQL, the \dt command is used to list all the tables in the current schema. If the command is executed …

Get table size with pg_relation_size in Postgres PostgreSQL provides a dedicated function, pg_relation_size, to compute the actual disk space used by a specific table or index. We just need to provide the table name. To check the size of a table in a PostgreSQL database, you can use the following SQL query: select pg_size_pretty(pg_relation_size(‘table_name’)); Replace …

Create a file with Ansible file module There are a few ways to create a file with Ansible. One way is to use the file module. The file module has a state option that can be set to touch to create a new file.   Description path The path of the file that needs to …

Some tasks may consume a significant amount of system resources, such as CPU or memory, and running too many of these tasks at once can cause performance issues. By adding a pause between loop iterations, you can help to manage resource consumption and prevent performance issues. It can help to avoid overwhelming the target system …

selectattr in Ansible selectattr is a filter plugin in Ansible that allows you to select a subset of elements from a list of dictionaries based on the value of a particular attribute.  Its syntax is as follows: <list of dictionaries> | selectattr(‘<attribute>’, ‘<operator>’, ‘<value>’)   Key Description list_of_dictionaries A list of dictionaries representing items to …

This article is part of the following series. 4 Ways to Find network interfaces in Linux 5 useful Linux network troubleshooting commands 3 Easy Ways to Find IP address in Linux 3 Ways to Find MAC Address In Linux   Get MAC address with Ansible You can use the ansible_default_ipv4.macaddress variable to get the MAC …

This article is part of the following series. 6 performance tools you should know in Linux 5 Ways to Check disk size in Linux 4 Ways to Check Disk Partition with Examples in Linux How I Fixed a disk performance issue in Minutes – A Step by Step Guide to Optimize Linux System   Get …

When statement in Ansible In Ansible, the “when” keyword is used to specify a condition or a set of conditions that must be met in order for a task to be executed. It allows you to add conditional logic to your Ansible playbooks and control the flow of execution based on certain conditions. The “when” …

This article is part of the following series. 5 useful Linux network troubleshooting commands 3 Ways to Find MAC Address In Linux What is 0.0.0.0 ip address? 4 ways to check network usage in Linux   Get IP address using fact variable with Ansible If you want to get the IP address of a host …

In Ansible, you can use the stat module to get the size of a file on a remote host. The stat module retrieves information about a file, including its size, permissions, and other attributes. Get file size with stat module with Ansible Here’s an example of how you can use the stat module to get …