I'm running Metabase v0.37.2 using Docker on a Linux RHEL 8 server. I have setup about 25 Metabase users. I'm using Postgres as the application database and another Postgres database is also being used as the data source of the Metabase dashboards. I use my ID to start the Metabase application using Docker on port: 3000. When I look at Postgres (proccess_id, user logged on etc..) I see that my ID is logged-on about 21 times with different PIDs. It appears that each time a user logs on to the Metabase application, another process is started under my user id (Metabase started with my id) instead of the user who logged on to the Metabase application.The database that is being queried by Metabase to build dashboards is Postgres. The multiple PIDs are happening on the Postgres database being used for the application data. Can someone explain if this is the case and how/why Metabase is handling Postgres processes to the application data ?
Here is the Postgres query I'm using to see these logons:
select datname as database_name,
pid as process_id,
usename as username,
client_addr as client_address,
application_name,
backend_start,
state,
state_change
from pg_stat_activity
where datname > ' ' and application_name > ' '
order by database_name desc, username desc;
Here is the Database- PID - Username from above query: