How to get more physical details when executing an SQL query?
You should use pg_stat_statements.

Modify postgresql.conf as follows:

shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.track = all
track_io_timing = on


and restart PostgreSQL.

Then

CREATE EXTENSION pg_stat_statements;


and find all the data you want in the view pg_stat_statements.