You can get the number of records with a count() in an SQLExecutor, e.g.

select count(*) as record_count from my_table

Expose the attribute "record_count" which will then contain the number of records in my_table.

Concerning the file sizes, which file sizes are you referring to? External files referenced in the table, or the table contents itself?

The table contents itself. I have tried your solution with select count(*) but it gives an error that my_table not excists. If i specify de schema and table then it works OK.

Exactly, if you query a table that isn't in the login user's default schema, you will have to specify the schema.

In an SQLExecutor, try the query listed under "General Table Size Information" here:

https://wiki.postgresql.org/wiki/Disk_Usage

It will give you a lot of information about all the database tables, including estimated record counts and table file sizes.

If you require accurate record counts, you can try the query suggested here (it may be noticably slower than the estimated record count):

https://stackoverflow.com/a/38684225/10661889

Thank you very much.