/opt/puppetlabs/server/bin/psql -d pe-puppetdb -c ‘select count(*) from reports where environment_id = 258;’ count ------- 5 (1 row)