optimize count query postgresql

citus gives you all the greatness of postgres plus the superpowers of distributed tables and a distributed sql engine. by distributing your data and queries, your application gets high performance—at any scale. citus is available as open source and as an option in azure database for postgresql.