Snippet content copied to clipboard.
Are you sure to delete this snippet? No, don't delete
  1. 2022-09-14T09:36:30.856538Z I i.q.c.h.p.JsonQueryProcessorState [23] exec [q='(SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'SPY' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price']
  2. 2022-09-14T09:36:30.857084Z I i.q.c.h.p.QueryCache hit [thread=questdb-worker-8, sql=(SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'SPY' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price]
  3. 2022-09-14T09:36:30.857186Z I i.q.c.h.p.JsonQueryProcessorState [23] execute-cached [skip: 0, stop: 1000]
  4. 2022-09-14T09:36:33.236240Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T18.283 [rowCount=30399803, partitionNameTxn=283, transientRowCount=465, partitionIndex=10, partitionCount=14]
  5. 2022-09-14T09:36:33.728654Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T19.343 [rowCount=44704889, partitionNameTxn=343, transientRowCount=465, partitionIndex=11, partitionCount=14]
  6. 2022-09-14T09:36:34.230322Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T20.433 [rowCount=1072577, partitionNameTxn=433, transientRowCount=465, partitionIndex=12, partitionCount=14]
  7. 2022-09-14T09:36:34.231381Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T21.434 [rowCount=465, partitionNameTxn=434, transientRowCount=465, partitionIndex=13, partitionCount=14]
  8. 2022-09-14T09:36:34.414571Z I i.q.c.h.p.JsonQueryProcessorState [23] timings [compiler: 0, count: 20000, execute: 3558159667, q=`(SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'SPY' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price`]
  9. 2022-09-14T09:36:34.414690Z I i.q.c.h.p.JsonQueryProcessor all sent [fd=23, lastRequestBytesSent=50489, nCompletedRequests=21, totalBytesSent=834263]
  10. 2022-09-14T09:36:34.416482Z I i.q.c.h.p.QueryCache push [thread=questdb-worker-8, sql=(SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'SPY' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price]
  11. 2022-09-14T09:37:00.512821Z I i.q.c.l.t.TableUpdateDetails network IO thread released table [workerId=1, tableName=orderbooks, nNetworkIoWorkers=1]
  12. 2022-09-14T09:37:02.267156Z I i.q.c.l.t.TableUpdateDetails network IO thread released table [workerId=0, tableName=orderbooks, nNetworkIoWorkers=0]
  13. 2022-09-14T09:37:02.267297Z I i.q.c.l.t.LineTcpMeasurementScheduler active table going idle [tableName=orderbooks]
  14. 2022-09-14T09:37:02.271567Z I i.q.c.l.t.LineTcpMeasurementScheduler releasing writer, its been idle since 2022-09-14T09:36:23.111000Z[tableName=orderbooks]
  15. 2022-09-14T09:37:02.271610Z I i.q.c.TableWriter sorting o3 [table=orderbooks]
  16. 2022-09-14T09:37:02.279642Z I i.q.c.TableWriter sorted [table=orderbooks]
  17. 2022-09-14T09:37:02.299055Z I i.q.c.TableWriter switched partition [path='/opt/homebrew/var/questdb/db/orderbooks/2022-09-15T00.435']
  18. 2022-09-14T09:37:02.305173Z I i.q.c.p.WriterPool << [table=`orderbooks`, thread=15]
  19. 2022-09-14T09:38:55.768239Z I i.q.c.p.ReaderPool closed 'orderbooks' [at=0:0, reason=IDLE]
  20. 2022-09-14T09:40:49.729266Z I i.q.c.h.p.JsonQueryProcessorState [23] exec [q='(SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'SPY' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price']
  21. 2022-09-14T09:40:49.729327Z I i.q.c.h.p.QueryCache hit [thread=questdb-worker-6, sql=(SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'SPY' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price]
  22. 2022-09-14T09:40:49.729354Z I i.q.c.h.p.JsonQueryProcessorState [23] execute-cached [skip: 0, stop: 1000]
  23. 2022-09-14T09:40:49.732879Z I i.q.c.p.ReaderPool open 'orderbooks' [at=0:0]
  24. 2022-09-14T09:40:49.736972Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T08 [rowCount=737951, partitionNameTxn=-1, transientRowCount=21812, partitionIndex=0, partitionCount=17]
  25. 2022-09-14T09:40:49.754560Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T09.0 [rowCount=877189, partitionNameTxn=0, transientRowCount=21812, partitionIndex=1, partitionCount=17]
  26. 2022-09-14T09:40:49.771835Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T10.2 [rowCount=809715, partitionNameTxn=2, transientRowCount=21812, partitionIndex=2, partitionCount=17]
  27. 2022-09-14T09:40:49.787888Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T11.3 [rowCount=804444, partitionNameTxn=3, transientRowCount=21812, partitionIndex=3, partitionCount=17]
  28. 2022-09-14T09:40:49.798232Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T12.5 [rowCount=907499, partitionNameTxn=5, transientRowCount=21812, partitionIndex=4, partitionCount=17]
  29. 2022-09-14T09:40:49.810554Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T13.7 [rowCount=18607473, partitionNameTxn=7, transientRowCount=21812, partitionIndex=5, partitionCount=17]
  30. 2022-09-14T09:40:49.899806Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T14.44 [rowCount=32905086, partitionNameTxn=44, transientRowCount=21812, partitionIndex=6, partitionCount=17]
  31. 2022-09-14T09:40:50.027100Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T15.110 [rowCount=34159057, partitionNameTxn=110, transientRowCount=21812, partitionIndex=7, partitionCount=17]
  32. 2022-09-14T09:40:50.179128Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T16.179 [rowCount=26929625, partitionNameTxn=179, transientRowCount=21812, partitionIndex=8, partitionCount=17]
  33. 2022-09-14T09:40:50.279990Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T17.232 [rowCount=25068950, partitionNameTxn=232, transientRowCount=21812, partitionIndex=9, partitionCount=17]
  34. 2022-09-14T09:40:50.369409Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T18.283 [rowCount=30399803, partitionNameTxn=283, transientRowCount=21812, partitionIndex=10, partitionCount=17]
  35. 2022-09-14T09:40:50.487787Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T19.343 [rowCount=44704889, partitionNameTxn=343, transientRowCount=21812, partitionIndex=11, partitionCount=17]
  36. 2022-09-14T09:40:50.668620Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T20.433 [rowCount=1072577, partitionNameTxn=433, transientRowCount=21812, partitionIndex=12, partitionCount=17]
  37. 2022-09-14T09:40:50.677517Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T21.434 [rowCount=57941, partitionNameTxn=434, transientRowCount=21812, partitionIndex=13, partitionCount=17]
  38. 2022-09-14T09:40:50.677937Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T22.435 [rowCount=88054, partitionNameTxn=435, transientRowCount=21812, partitionIndex=14, partitionCount=17]
  39. 2022-09-14T09:40:50.683047Z I i.q.c.TableReader open partition /opt/homebrew/var/questdb/db/orderbooks/2022-09-14T23.435 [rowCount=5018, partitionNameTxn=435, transientRowCount=21812, partitionIndex=15, partitionCount=17]
  40. 2022-09-14T09:40:50.693850Z I i.q.c.h.p.JsonQueryProcessorState [23] timings [compiler: 0, count: 2208, execute: 964883375, q=`(SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'SPY' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price`]
  41. 2022-09-14T09:40:50.693891Z I i.q.c.h.p.JsonQueryProcessor all sent [fd=23, lastRequestBytesSent=50468, nCompletedRequests=22, totalBytesSent=884752]
  42. 2022-09-14T09:40:50.694992Z I i.q.c.h.p.QueryCache push [thread=questdb-worker-6, sql=(SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'SPY' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price]

Edit this Snippet