Postgresql similar of SQL Server Query Store
Yes there is such an extension: pg_stat_statements


  The pg_stat_statements module provides a means for tracking execution statistics of all SQL statements executed by a server.


Tools like PoWA use this extension and provide others performance metrics that you might be interested in.