Skip to content

Instantly share code, notes, and snippets.

@gtr

gtr/SHOW SESSIONS

Created March 31, 2022 15:27
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save gtr/07fea137316834c8c0aa279e83aeed11 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save gtr/07fea137316834c8c0aa279e83aeed11 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SHOW SESSIONS
Time: 11ms total (execution 10ms / network 2ms)
root@:26257/defaultdb> SHOW SESSIONS;
node_id | session_id | user_name | client_address | application_name | active_queries | last_active_query | session_start | oldest_query_start | status
----------+----------------------------------+-----------+-----------------+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------+----------------------------+----------------------------+---------
1 | 16e18084832cf4400000000000000001 | root | [::1]:51006 | ycsb | UPDATE usertable SET field0 = 'FTgbYDMawkoufXzjKcHqqMyxGyFLMAirqIbdHcYyfEaLqmHQFFVWWuNgTKrtAHVPbEJtGodqasyzHwveApeGJDwopvkJHlrTZIuD' WHERE ycsb_key = 'user9224341225228129156' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.219014 | 2022-03-31 15:26:54.649945 | OPEN
1 | 16e180848be1b6c00000000000000001 | root | [::1]:51010 | ycsb | UPDATE usertable SET field4 = 'XgOKxfIRULCbimyzPeiYmVdbYKQboMMaOYiHaUDbOzAOzfdQsKtjkSgrpglihXYUvJHxSzmMNbOwbRaWAQAHclzeLsQJUwhzBKuY' WHERE ycsb_key = 'user18298038249657427829' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365039 | 2022-03-31 15:26:54.663799 | OPEN
1 | 16e180848be1ed700000000000000001 | root | [::1]:51009 | ycsb | UPDATE usertable SET field8 = 'WzAqEjjzJtSSsEDHqzLAwpQISHULhsOBhKlrhLbWuAFwjzqYeFpxTuNfFOmSrLCVWXBEGBxtPbrapjBmKkvSZKtoRjTaTnNfsVif' WHERE ycsb_key = 'user14562326165948402202' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365051 | 2022-03-31 15:26:54.629755 | OPEN
1 | 16e180848be21c500000000000000001 | root | [::1]:51007 | ycsb | UPDATE usertable SET field4 = 'zISlQyWBGNBnRyxMxeuOyvVbPqsGTAMbsNbZhgFCwEHEskekAlDXqGFlDAaYuuSDCeozMzOEFUHndTvxEmGgKNpGKLPLwQTLEohT' WHERE ycsb_key = 'user8354950358148913169' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365061 | 2022-03-31 15:26:54.671359 | OPEN
1 | 16e180848be22bf00000000000000001 | root | [::1]:51008 | ycsb | | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365065 | NULL | OPEN
1 | 16e180848be3be480000000000000001 | root | [::1]:51011 | ycsb | SELECT * FROM usertable WHERE ycsb_key = 'user16390143479181108970' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365141 | 2022-03-31 15:26:54.677613 | OPEN
1 | 16e180848be529900000000000000001 | root | [::1]:51014 | ycsb | UPDATE usertable SET field8 = 'QnjUWtedxFtKowVlGRfHjJKkXzFEgssWtmkrHBUtydKaozVwzlJrMcvJURnjDSBOttEyXVfSuKCHEJcNdnBAwhRgZCseFtLamYHf' WHERE ycsb_key = 'user8681532469548250846' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365218 | 2022-03-31 15:26:54.664246 | OPEN
1 | 16e180848be57b980000000000000001 | root | [::1]:51015 | ycsb | UPDATE usertable SET field7 = 'JCsXnxfEUCjwtdKsTCJuKXpuVfIDMGKFkvhbnWYZeceJrnmtRFkZCGyODKnOmgxhiYqOPPlyLDkRdcrnoxUJbTcVvsxOiihiiLYl' WHERE ycsb_key = 'user10847574673984414955' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365245 | 2022-03-31 15:26:54.649278 | OPEN
1 | 16e180848be5f8980000000000000001 | root | [::1]:51012 | ycsb | UPDATE usertable SET field8 = 'cyuflMwcgkiXdKpAzTmctyKSjayNXzJBPaopRHKuMNQplemDupvzCBIMXIneLqbBfQhFKNQyFMSkYfYmPSmeTbBhDoPIWMreWTiT' WHERE ycsb_key = 'user16390143479181108970' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365254 | 2022-03-31 15:26:54.673133 | OPEN
1 | 16e180848be5ae600000000000000001 | root | [::1]:51017 | ycsb | UPDATE usertable SET field7 = 'HdfvJbwTdxvHKFcemafZCrqUzRRZrlMTClJvAvsICvgjendUezEOJWfYiIqUWcnWSUBucobOoNReETqrtreXhKhhqMeVaFeVeaSW' WHERE ycsb_key = 'user3162610489313140744' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365256 | 2022-03-31 15:26:54.662421 | OPEN
1 | 16e180848be7e0e00000000000000001 | root | [::1]:51013 | ycsb | UPDATE usertable SET field8 = 'OdZAbAYmPdKVgoarCXnOPGefpkLTkzsuTlzETmYbuQxcoLJycuUIXffoKnsOdxmzwexJVexnpaENADdQtWDtePbMhRZJsUBEuytX' WHERE ycsb_key = 'user3257378224930762617' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365284 | 2022-03-31 15:26:54.672759 | OPEN
1 | 16e180848beaf2080000000000000001 | root | [::1]:51021 | ycsb | UPDATE usertable SET field3 = 'UVELhftkXwzBFTvAONQRqDgXzyuoVZKFQgDjKuyzzvTAXkeuinVWJKVEcQYpwTSYBkVNgUhZgOEqXwyHvPPUvJXOVLbPownpABZB' WHERE ycsb_key = 'user14155845851644422226' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365399 | 2022-03-31 15:26:54.677262 | OPEN
1 | 16e180848beb1d000000000000000001 | root | [::1]:51020 | ycsb | SELECT * FROM usertable WHERE ycsb_key = 'user11788086451719668902' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365409 | 2022-03-31 15:26:54.6771 | OPEN
1 | 16e180848be973380000000000000001 | root | [::1]:51022 | ycsb | UPDATE usertable SET field5 = 'GUGefxCsxFbWmiQbqBdSXXySXdrYJXdViQdthiAnmiUnmaGxNqOGNUbrvhAUSzLYymmYPRwOjjHphTTebvTAhGUCCxGtCVqjNqCe' WHERE ycsb_key = 'user13137943637503646007' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365412 | 2022-03-31 15:26:54.675006 | OPEN
1 | 16e180848beb2ca00000000000000001 | root | [::1]:51018 | ycsb | UPDATE usertable SET field0 = 'ZQeBlXbhMtMgMuwHAHvrjBwVNjGxJnLOiHGEtLQtBdoKHVznjbTijQUYmQnRcomkcpsDWQuqpOlSrPPWFfhGzhhAddwRCrLuCLny' WHERE ycsb_key = 'user8082112645815058137' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.36543 | 2022-03-31 15:26:54.665166 | OPEN
1 | 16e180848be9c9280000000000000001 | root | [::1]:51024 | ycsb | UPDATE usertable SET field1 = 'UXRtmwbJtNZzrIunvjSOaCPuICCWptTZbrUgWQCEiwfcyDxFpbgPaKsVrlnxmWorvufPWKTYPAHPGyrWgKEwmcbCuSWWhlMRcbme' WHERE ycsb_key = 'user11788086451719668902' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365436 | 2022-03-31 15:26:54.666165 | OPEN
1 | 16e180848bea32a00000000000000001 | root | [::1]:51023 | ycsb | | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365455 | NULL | OPEN
1 | 16e180848beb19180000000000000001 | root | [::1]:51026 | ycsb | UPDATE usertable SET field8 = 'sUpIJOCFXIUQlzeKbTAKgBuorVuucFJrdRyPhptDSXOjhWlopWcLyQYLOLwpDRPOztrREhmqXNIecyFUwMODoaNbdvFbMbTBFbhp' WHERE ycsb_key = 'user17897290091896794932' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365459 | 2022-03-31 15:26:54.674933 | OPEN
1 | 16e180848bec2e700000000000000001 | root | [::1]:51019 | ycsb | UPDATE usertable SET field4 = 'XgbPcoGaevxencknqTTzUnbmfwTwEaZxzHKRIQPZWOywDWddQKLqdGVZdAsyLwbLcCDeZuHMrbGQYtEtJzLAXcKCICydFMSeuohr' WHERE ycsb_key = 'user1423829148965480913' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365467 | 2022-03-31 15:26:54.641158 | OPEN
1 | 16e180848bebd0b00000000000000001 | root | [::1]:51016 | ycsb | UPDATE usertable SET field2 = 'CFbmkbEzBPLiJVUUkEZYTyJvfiALHQKVhLUTSBjZXPYvjSudXpDhQPiyycazGWLrmNnGRBdDFzJLUaRuOQvGiptRPJErXDixttoC' WHERE ycsb_key = 'user2723346761499488646' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365502 | 2022-03-31 15:26:54.66935 | OPEN
1 | 16e180848bedb5100000000000000001 | root | [::1]:51029 | ycsb | UPDATE usertable SET field5 = 'ehaOzRSiPdaahkqphYmQdCuTsFGPJftyTaBGtaBhtstKMpPoXCAlYTdUmEbrsLfYGmPJgWyapoCJvsabRaTEoUarCMYinVaRSmZT' WHERE ycsb_key = 'user3883490009330796499' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365625 | 2022-03-31 15:26:54.642347 | OPEN
1 | 16e180848beeda080000000000000001 | root | [::1]:51025 | ycsb | | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365695 | NULL | OPEN
1 | 16e180848bee9b880000000000000001 | root | [::1]:51028 | ycsb | SELECT * FROM usertable WHERE ycsb_key = 'user11788086451719668902' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365697 | 2022-03-31 15:26:54.679832 | OPEN
1 | 16e180848bed9da00000000000000001 | root | [::1]:51037 | ycsb | | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365728 | NULL | OPEN
1 | 16e180848bee07180000000000000001 | root | [::1]:51027 | ycsb | | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365793 | NULL | OPEN
1 | 16e180848bee4d680000000000000001 | root | [::1]:51033 | ycsb | UPDATE usertable SET field5 = 'GCZVfkfgppffSWVYOeogCShbBtzztWsHqKPnUahfNwkXhghKsAlTfArpaChOPmVsTlGBoUCbgNmztHmfHrsTgByEMhplGpiOeJut' WHERE ycsb_key = 'user14013246309275951008' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365835 | 2022-03-31 15:26:54.674405 | OPEN
1 | 16e180848bef72600000000000000001 | root | [::1]:51031 | ycsb | UPDATE usertable SET field1 = 'fxZZpyMOaoLtVyAiNqZeJpHuFWbIHfdOYrNYfMtJoVEiMbbvLeufbAEPcSvDRCDXCtQUdpbkkPYnNrAYEFalCKBpebnwhpOtNrIL' WHERE ycsb_key = 'user11589055489447625220' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365917 | 2022-03-31 15:26:54.66616 | OPEN
1 | 16e180848bf039980000000000000001 | root | [::1]:51030 | ycsb | SELECT * FROM usertable WHERE ycsb_key = 'user11788086451719668902' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365953 | 2022-03-31 15:26:54.666365 | OPEN
1 | 16e180848bf02de00000000000000001 | root | [::1]:51035 | ycsb | SELECT * FROM usertable WHERE ycsb_key = 'user18298038249657427829' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.365983 | 2022-03-31 15:26:54.667947 | OPEN
1 | 16e180848bf049380000000000000001 | root | [::1]:51034 | ycsb | UPDATE usertable SET field9 = 'WGnyIZOzLqJulVIbrjqvXReVdLchMbpRoZNQqXosURXtEGHUVBdPZMQBjuvYSrVjnwgPalkweUwTwlrhrzYHlzssxVHvkoWLXiJC' WHERE ycsb_key = 'user5613494451240624134' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.366 | 2022-03-31 15:26:54.669899 | OPEN
1 | 16e180848bf137800000000000000001 | root | [::1]:51032 | ycsb | UPDATE usertable SET field6 = 'oDKBazJFMKLShgUAbdNqLWCwnMUcGFdHfJihxSFDMcsuhALDlObZNfZavrWZVphFDIomLXvUoNrNGvlMafftloZjNuxBrVSmWxmj' WHERE ycsb_key = 'user16363271082742981576' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.366075 | 2022-03-31 15:26:54.658475 | OPEN
1 | 16e180848bf100d00000000000000001 | root | [::1]:51036 | ycsb | UPDATE usertable SET field2 = 'xBhLuKMyfOAkTMoNEyVgtpkpzpfzxdhziSekxUsejcuFXNCmXXeAjDtHdWbEOaOFfZmaspgTDBZxozYBijCXSDJQWwZcvxvLpjbl' WHERE ycsb_key = 'user13942125792430685191' | SELECT * FROM usertable WHERE ycsb_key = $1 | 2022-03-31 15:24:05.36608 | 2022-03-31 15:26:54.661756 | OPEN
1 | 16e18087d56afcb80000000000000001 | root | [::1]:51085 | movr | | UPSERT INTO vehicle_location_histories VALUES ($1, $2, now(), $3, $4) | 2022-03-31 15:24:19.483691 | NULL | OPEN
1 | 16e18091268d45700000000000000001 | root | 127.0.0.1:51148 | $ cockroach sql | SHOW CLUSTER SESSIONS | SHOW database | 2022-03-31 15:24:59.499645 | 2022-03-31 15:26:54.678121 | OPEN
1 | 16e180abf7b38af00000000100000001 | root | [::1]:54885 | kv | | | 2022-03-31 15:26:54.677694 | NULL | OPEN
1 | 16e180abf7b521300000000000000001 | root | [::1]:54886 | kv | | | 2022-03-31 15:26:54.677791 | NULL | OPEN
1 | 16e180abf7bf17f80000000000000001 | root | [::1]:54887 | kv | | | 2022-03-31 15:26:54.678381 | NULL | OPEN
1 | 16e180abf7c5af780000000100000001 | root | [::1]:54888 | kv | | | 2022-03-31 15:26:54.678818 | NULL | OPEN
1 | 16e180abf7cc43100000000000000001 | root | [::1]:54889 | kv | | | 2022-03-31 15:26:54.679315 | NULL | OPEN
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment