PostgreSQL 12 High Availability Cookbook - Third Edition

There's more...

Unlike the handy psql command-line tool for PostgreSQL, InfluxDB's influx does not offer a ready supply of handy shortcuts for finding information about the database itself. Like MySQL, it uses SHOW syntax. InfluxDB was also designed from the ground up to track performance measurements. As such, it doesn't actually have tables but refers to collected data as measurements instead.

Hence, if we want to know what measurements are available for analysis, we can issue SHOW MEASUREMENTS and receive a list like this:

name: measurements 
name 
---- 
cpu 
disk 
kernel 
mem 
postgresql 
postgresql.sessions 
postgresql.slot_lag 
postgresql.xid 
processes 
swap 
system 

Notice how all of our PostgreSQL measurements, including the custom ones, are ...