Enable pg_stat_statements extension on Postgres 14

postgres=# SELECT * FROM pg_stat_statements;


postgres=# select * From pg_available_extensions where name ilike 'pg_stat_statements';

        name        | default_version | installed_version |                                comment

--------------------+-----------------+-------------------+--------------------------------------------------------
----------------
 pg_stat_statements | 1.9             |                   | track planning and execution statistics of all SQL stat
ements executed
(1 row)

    
postgres=# SHOW shared_preload_libraries;

shared_preload_libraries
--------------------------

(1 row)


postgres=# CREATE EXTENSION pg_stat_statements;
CREATE EXTENSION


postgres=# \d pg_stat_statements



postgres=# SELECT *
	 			FROM pg_available_extensions
	 		WHERE
	    		 name = 'pg_stat_statements' and
	   		  installed_version is not null;
	   		  
	   		  
        name        | default_version | installed_version |                                comment

--------------------+-----------------+-------------------+--------------------------------------------------------
----------------
 pg_stat_statements | 1.9             | 1.9               | track planning and execution statistics of all SQL stat
ements executed
(1 row)


postgres=# alter system set shared_preload_libraries='pg_stat_statements';
ALTER SYSTEM



postgres=# select * from pg_file_Settings where name='shared_preload_libraries';


                 sourcefile                  | sourceline | seqno |           name           |      setting       |
 applied |            error
---------------------------------------------+------------+-------+--------------------------+--------------------+
---------+------------------------------
 /var/lib/pgsql/14/data/postgresql.auto.conf |          3 |    30 | shared_preload_libraries | pg_stat_statements |
 f       | setting could not be applied
(1 row)



postgres=# exit

##Restart the Instance

sudo systemctl restart postgresql-14

sudo -iu postgres
 
 
psql -h localhost -p 5432 -U postgres -d postgres


postgres=# SELECT * FROM pg_stat_statements;

 userid | dbid | toplevel | queryid | query | plans | total_plan_time | min_plan_time | max_plan_time | mean_plan_t
ime | stddev_plan_time | calls | total_exec_time | min_exec_time | max_exec_time | mean_exec_time | stddev_exec_tim
e | rows | shared_blks_hit | shared_blks_read | shared_blks_dirtied | shared_blks_written | local_blks_hit | local_
blks_read | local_blks_dirtied | local_blks_written | temp_blks_read | temp_blks_written | blk_read_time | blk_writ
e_time | wal_records | wal_fpi | wal_bytes
--------+------+----------+---------+-------+-------+-----------------+---------------+---------------+------------
----+------------------+-------+-----------------+---------------+---------------+----------------+----------------
--+------+-----------------+------------------+---------------------+---------------------+----------------+-------
----------+--------------------+--------------------+----------------+-------------------+---------------+---------
-------+-------------+---------+-----------
(0 rows)