The output of the following statement
SELECT * FROM perf_out();executed when logging the performance of the current session lists the values of the following parameters.
| Parameter name | Description |
|---|---|
| CI_BUILD | The time it takes to build the index |
| CI_BUILD_THRIFT | Currently unused. |
| CI_ADD_TO_INDEX_BATCH_THRIFT | The time it takes to add the batch of chemical structures into the index including the communication with the jchem-psql service |
| CI_ADD_TO_INDEX_BATCH_SERVER | The time it takes to add the batch of chemical structures into the index not including the communication with the jchem-psql service |
| CI_ADD_TO_INDEX | The time it takes to add a chemical structure to the batch and add the batch into the index if batch size limit is reached |
| CI_ADD_TO_INDEX_FLUSH | The time it takes to add the remaining batch of chemical structures into the index on a commit if last batch is not empty |
| CI_ADD_TO_INDEX_THRIFT | Currently unused. |
| CI_ADD_TO_INDEX_SERVER | Currently unused. |
| CI_BULK_DELETE | The time it takes to complete the full process of bulk delete of previously deleted or updated structures from the index on vacuum |
| CI_BULK_DELETE_THRIFT_DELETE | The time it takes to delete the chemical structures from the index as a part of the bulk delete process if vacuum hack is enabled (enabled by default) |
| CI_BULK_DELETE_THRIFT_GETIDS | The time it takes to collect the ids of chemical structures that will have to be deleted from the index as a part of the bulk delete process if vacuum hack is not enabled |
| CI_DELETE_FLUSH | The time it takes to delete the remaining batch of chemical structures from the index on a commit if last batch is not empty |
| CI_DELETE_THRIFT | The time it takes to delete a batch of chemical structures from the index including the communication with the jchem-psql service |
| CI_DELETE_SERVER | The time it takes to delete a batch of chemical structures from the index not including the communication with the jchem-psql service |
| CI_RESCAN | The time it takes to start a search |
| CI_BITMAP | The time it takes to find hits using bitmap scan |
| CI_FETCHNEXT | The time it takes to find the next hit during an index scan |
| CI_FETCHNEXT_THRIFT | The time it takes to find the next batch of hits during a search including the communication with the jchem-psql service |
| CI_FETCHNEXT_SERVER | The time it takes to find the next batch of hits during a search not including the communication with the jchem-psql service |
| CI_ENDSCAN | The time it takes to close an ongoing search |
| CI_COMPARE_FN | The time it takes to compare two chemical structures |
| CI_COMPARE_FN_THRIFT | The time it takes to compare two chemical structures against each other using the jchem-psql service including the communication |
| CI_COMPARE_FN_SERVER | The time it takes to compare two molecules against each other using the jchem-psql service not including the communication |
| CI_COST_ESTIMATE | The time it takes to calculate the estimated cost of a search |
| CI_COST_SELECTIVITY | The time it takes to calculate the selectivity of a search operator |
| CI_COST_SELECTIVITY_THRIFT | The time it takes to calculate the selectivity of a search operator using the jchem-psql service |
| CI_FINGERPRINT_FN | The time it takes to calculate fingerprint and relevance of a chemical structure |
| CI_FINGERPRINT_THRIFT | The time it takes to calculate fingerprint for a chemical structure including the communication with the jchem-psql service |
| CI_FINGERPRINT_SERVER | The time it takes to calculate fingerprint for a chemical structure not including the communication with the jchem-psql service |
| CI_TANIMOTO_FN | Currently unused. |
| CI_ELEVANCE_COMPARE_FN | The time it takes to compare the relevance of two chemical structures |
| CI_RELEVANCE_FP_FN | The time it takes to calculate the relevance of a chemical structure |
| CI_IMPORT | The time it takes to import a chemical structure from string including fingerprint calculation |
| CI_VACUUM_CLEANUP | The time it takes to cleanup a vacuum process |
| CI_STANDARDIZE_SERVER | The time it takes to standardize a chemical structure not including the communication with the jchem-psql service |
| CI_STANDARDIZE_FN | The time it takes to standardize a chemical structure including the communication with the jchem-psql service |
invocations: number of calls (invocations)
time: time spent on a specific stage in milliseconds