ScyllaDB Alternator Slow Query Logging

alternator-slow-query-logging.txt

cqlsh> select parameters, duration from system_traces.node_slow_log where start_time=b7a44589-8711-11eb-8053-14c6c5faf955;

 parameters                                                                                  | duration
---------------------------------------------------------------------------------------------+----------
 {'alternator_op': 'DeleteTable', 'query': '{"TableName": "alternator_Test_1615979572905"}'} |    75732
[{
    'start_time': 'b7d42b37-a661-11eb-a391-3d2009e69e44',
    'node_ip': '127.0.0.1',
    'shard': '0',
    'command': '{"TableName": "Pets", "Key": {"p": {"S": "dog"}}}',
    'date': '2021-04-26T07:33:38.903000',
    'duration': '94',
    'parameters': '{alternator_op : DeleteItem}, {query : {"TableName": "Pets", "Key": {"p": {"S": "dog"}}}}',
    'session_id': 'b7b47e70-a661-11eb-a391-3d2009e69e44',
    'source_ip': '::',
    'table_names': 'alternator_Pets.Pets',
    'username': '<unauthenticated request>'
}, {
    'start_time': 'b7b44416-a661-11eb-a391-3d2009e69e44',
    'node_ip': '127.0.0.1',
    'shard': '0',
    'command': '{"TableName": "Pets", "Item": {"p": {"S": "dog"}}}',
    'date': '2021-04-26T07:33:38.901000',
    'duration': '130',
    'parameters': '{alternator_op : PutItem}, {query : {"TableName": "Pets", "Item": {"p": {"S": "dog"}}}}',
    'session_id': 'b7b43050-a661-11eb-a391-3d2009e69e44',
    'source_ip': '::',
    'table_names': 'alternator_Pets.Pets',
    'username': '<unauthenticated request>'
}]