By doing \timing in psql, we enable the timing and then when we type the query we are able to see its execution time. Similarly, is there any way to view the number I/Os and memory usage by a particular query.
PGsnap module will describes tables,Indexes,Sequences I/O statistics and URL as follows