Hi,
I am trying to show metrics like PID, memory usage, CPU usage for selected processes(nginx,php-fpm,mysql,redis) using node_exporter in a tabular form. In order to achieve that, I added textfile with data coming from bash script. I was successfully able to send data through Prometheus but now I cant align the data in table accordingly.
Queries are as follows:
node_systemd_unit_pid{Service=“Nginx”}
node_systemd_unit_mem{Service=“Nginx”}
node_systemd_unit_cpu{Service=“Nginx”}
node_systemd_unit_pid{Service=“Mysql”}
…
and so on
On applying Outer join and Organize field transform I get the following results:
I have added headings from Organize filed transform:
How can I have all the values in a tabular form under respected fields like all PID’s should be under PID column and so on.
Thanks a lot!