What exactly did you do with Postgres — queries, indexes?

In my work with Postgres, I was involved in writing complex SQL queries, including JOINs, subqueries, and aggregations to optimize data retrieval. I also created and configured indexes to speed up search and filtering, including composite indexes and GIN indexes for full-text search. I analyzed queries using EXPLAIN to identify bottlenecks and optimize database performance.