SELECT relname,n_live_tup,seq_scan,idx_scan FROM pg_stat_user_tables;
     relname     | n_live_tup | seq_scan | idx_scan
 ----------------+------------+----------+----------
  path           |       7731 |      366 |  3094707
  media          |        181 |      921 |     6952
  jobmedia       |       2987 |      121 |     1526
  log            |      62971 |       55 |      280
  pathvisibility |     295566 |       55 |      280
  filename       |      89070 |      327 |  8732226
  file           |   17772210 |       62 |     6825
  job            |       1418 |     2780 |     9540