Final Cut Server provides a wealth of logging information beyond what can be accessed from the “Search All Jobs…” option in the Final Cut Server application. Search All Jobs will show the contents of the pxjob table of the PostGreSQL database. However, Final Cut Server stores far more information that can be useful in troubleshooting. For example, information about any jobs that contain the text ldsd, stored or the actual transcode processes can be found in logs in the /Library/Logs/Final Cut Server directory of the Final Cut Server that start with fcsvr_ldsd, fcsvr_stored or pm_transcoder respectively. This folder also has a subdirectory, dbinit, which shows all of the logs pertaining to the initialization of the database (thus the name).
There is also a wealth of information tracked in the database that you cannot see natively. This includes the jobs archive (old data), which is stored in the pxjobarchive table, the pxlog table (stores events, such as responses) and the archive of that data, which is stored in the pxlogarchive table. These can be queried through the fcsvr_run command or directly from the postgres database. However, I do not recommend editing anything within the database given that you are likely to render Final Cut Server unstable or worse, unusable.