In this talk, I would like to share the successful experience how to improve index search performance. All of us uses indexes, it's one of the first features that we learns starting our journey with databases. Index on the right column can significantly improve query. Can we do anything more than just run CREATE INDEX ? This talk will explain how in easy way we can improve exists indexes, we will look into pg_stat and EXPLAIN output.