Postgres query optimization with some joins

Using postgres i have a query that is taking 7 seconds to run,

Should I use JSON or different table to store extra details? (PostgreSQL)

Simple question, I guess! Come with me:

Which query used an index in Postgresql

I’m using the pg_stat_all_indexes table to get the number of index scan used (idx_scan).