presence_stream

154 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: last_user_sync_ts, currently_active

Link rowid ▼ stream_id user_id state last_active_ts last_federation_update_ts last_user_sync_ts status_msg currently_active instance_name
5 5 34 @telegram_6193339016:matrix.jamesst.one offline 1784896372164 1784896371477 0   0 master
41 41 150 @telegram_8377300320:matrix.jamesst.one offline 1784900303151 1784900303195 0   0 master
42 42 151 @telegram_8585289624:matrix.jamesst.one offline 1784900303155 1784900303202 0   0 master
44 44 153 @telegram_8320876841:matrix.jamesst.one offline 1784900303914 1784900303976 0   0 master
45 45 154 @telegram_8068097924:matrix.jamesst.one offline 1784900303922 1784900303994 0   0 master
46 46 155 @telegram_5913927828:matrix.jamesst.one offline 1784900303931 1784900304001 0   0 master
47 47 156 @telegram_5622455753:matrix.jamesst.one offline 1784900303933 1784900304009 0   0 master
48 48 157 @telegram_5640396507:matrix.jamesst.one offline 1784900303938 1784900304014 0   0 master
49 49 158 @telegram_5404053613:matrix.jamesst.one offline 1784900304779 1784900304844 0   0 master
60 60 174 @telegram_5016551904:matrix.jamesst.one offline 1784900523701 1784900521358 0   0 master
75 75 197 @telegram_2123567474:matrix.jamesst.one offline 1784903032109 1784903032109 0   0 master
78 78 200 @telegram_777000:matrix.jamesst.one offline 1784903034813 1784903030376 0   0 master
80 80 202 @telegram_1130788997:matrix.jamesst.one offline 1784903062561 1784903062561 0   0 master
82 82 205 @telegram_227972923:matrix.jamesst.one offline 1784903061715 1784903061540 0   0 master
675 675 1606 @telegram_6988613307:matrix.jamesst.one offline 1785781296726 1785781361704 0   1 master
677 677 1611 @slack_t0qh48pl4-u02d6mfty76:matrix.jamesst.one offline 1785795862265 1785795862285 0   0 master
1590 1590 3674 @telegram_8977292871:matrix.jamesst.one offline 1786303639254 1786303574696 0   0 master
1606 1606 3719 @telegram_7969258720:matrix.jamesst.one offline 1786322460200 1786322525314 0   1 master
1800 1800 4152 @slack_t0qh48pl4-u5u4dugr3:matrix.jamesst.one offline 1786411695387 1786411695394 0   0 master
1915 1915 4396 @slack_t0qh48pl4-u3x5egy72:matrix.jamesst.one offline 1786441311267 1786441311268 0   0 master
1995 1995 4601 @telegram_8408610309:matrix.jamesst.one offline 0 0 0   0 master
2028 2028 4658 @slack_t0qh48pl4-u3hhys7c6:matrix.jamesst.one offline 1786523378071 1786523350543 0   0 master
2076 2076 4798 @slack_t0qh48pl4-u05n9dfg3ek:matrix.jamesst.one offline 1786585950815 1786585828832 0   0 master
3131 3131 7259 @slack_t0qh48pl4-u013d6ufzfz:matrix.jamesst.one offline 1787118885104 1787118885104 0   0 master
3267 3267 7580 @slack_t0qh48pl4-uk3qfnct1:matrix.jamesst.one offline 1787145744692 1787145671356 0   0 master
3644 3644 8331 @slack_t0qh48pl4-u02lzjgurcj:matrix.jamesst.one offline 1787238279269 1787238144086 0   0 master
3828 3828 8713 @telegram_8392104260:matrix.jamesst.one offline 1787297195020 1787297264853 0   1 master
3972 3972 9067 @telegram_207034457:matrix.jamesst.one offline 1787478257226 1787478257226 0   0 master
3975 3975 9074 @telegram_5721525852:matrix.jamesst.one offline 1787488562893 1787488629856 0   1 master
4057 4057 9253 @slack_t0qh48pl4-ul30bc7qw:matrix.jamesst.one offline 1787543802872 1787543660024 0   0 master
4302 4302 9685 @telegram_7538289450:matrix.jamesst.one offline 1787571023980 1787571023992 0   0 master
4399 4399 9892 @slack_t0qh48pl4-ubh7l2d7c:matrix.jamesst.one offline 1787639061106 1787639041723 0   0 master
4608 4608 10316 @slack_t0qh48pl4-u3p7e6ucb:matrix.jamesst.one offline 1787721476860 1787721476861 0   0 master
4871 4871 10949 @telegram_6417044050:matrix.jamesst.one offline 1787793490571 1787793490574 0   0 master
4886 4886 10984 @slack_t0qh48pl4-u02chaghkch:matrix.jamesst.one offline 1787799278455 1787799274547 0   0 master
5135 5135 11463 @slack_t0qh48pl4-u07rf5aa5rd:matrix.jamesst.one offline 1787836607010 1787836606982 0   0 master
5150 5150 11519 @telegram_93372553:matrix.jamesst.one offline 1787842167223 1787842125454 0   0 master
5294 5294 12944 @telegram_7727835414:matrix.jamesst.one offline 1787888322126 1787888387447 0   1 master
5347 5347 13065 @slack_t0qh48pl4-u02h3dwuf2s:matrix.jamesst.one offline 1787890382157 1787890307847 0   0 master
5502 5502 13504 @slack_t0qh48pl4-upj758cjz:matrix.jamesst.one offline 1787899612274 1787899604413 0   0 master
5552 5552 13614 @slack_t0qh48pl4-uk3qmm4bz:matrix.jamesst.one offline 1787901313057 1787901133651 0   0 master
5554 5554 13616 @whatsapp_lid-202125992829087:matrix.jamesst.one offline 1787901340993 1787901340993 0   0 master
5693 5693 13989 @gmessages_1.26:matrix.jamesst.one offline 1787910316079 1787910316081 0   0 master
5924 5924 15070 @meta_100002288617985:matrix.jamesst.one offline 1787954902607 1787954902608 0   0 master
5962 5962 15568 @slack_t0qh48pl4-u0qp3lk0f:matrix.jamesst.one offline 1787977617953 1787977520463 0   0 master
5974 5974 15632 @telegram_108815787:matrix.jamesst.one offline 1787980643260 1787980707447 0   1 master
5978 5978 15644 @meta_100012297879419:matrix.jamesst.one offline 1787981099135 1787981099135 0   0 master
6054 6054 16207 @signal_69b79387-9aa9-4dad-8a4e-cad534fcfcd0:matrix.jamesst.one offline 1788005400201 1788005400206 0   0 master
6090 6090 17052 @telegram_219161728:matrix.jamesst.one offline 1788049724377 1788049787447 0   1 master
6102 6102 17145 @meta_100021772481857:matrix.jamesst.one offline 1788054298247 1788054298247 0   0 master
6111 6111 17355 @whatsapp_lid-63539846840345:matrix.jamesst.one offline 1788084266549 1788084266663 0   0 master
6123 6123 17367 @telegram_8606696926:matrix.jamesst.one offline 1788084271194 1788084270903 0   0 master
6141 6141 17403 @telegram_1078232703:matrix.jamesst.one offline 1788092759919 1788092820480 0   1 master
6319 6319 17691 @slack_t0qh48pl4-uk3qk3wbh:matrix.jamesst.one offline 1788161526968 1788161519859 0   0 master
6326 6326 17701 @telegram_6165847276:matrix.jamesst.one offline 1788162086270 1788162150484 0   1 master
6388 6388 17818 @slack_t0qh48pl4-u02rf50p8tt:matrix.jamesst.one offline 1788165783389 1788165775906 0   0 master
6414 6414 17862 @telegram_8811074613:matrix.jamesst.one offline 1788167382446 1788167307235 0   0 master
6502 6502 18008 @telegrambot:matrix.jamesst.one offline 1788204018076 1788204017928 0   0 master
6505 6505 18015 @slack_t0qh48pl4-u0a68v69v3r:matrix.jamesst.one offline 1788212796251 1788212791236 0   0 master
6637 6637 18279 @slack_t0qh48pl4-u06rsaz02hm:matrix.jamesst.one offline 1788250788754 1788250666910 0   0 master
6670 6670 18355 @signal_2bf0b917-c5b3-4c8f-a145-c0b0bbb5af44:matrix.jamesst.one offline 1788256076031 1788256076033 0   0 master
6681 6681 18376 @slack_t0qh48pl4-uk20qf2mn:matrix.jamesst.one offline 1788256485527 1788256316256 0   0 master
6705 6705 18441 @meta_1078277752:matrix.jamesst.one offline 1788259954024 1788259954024 0   0 master
6706 6706 18442 @meta_1571773735:matrix.jamesst.one offline 1788259954059 1788259954059 0   0 master
6707 6707 18443 @meta_1110815375:matrix.jamesst.one offline 1788259954095 1788259954096 0   0 master
6732 6732 18503 @telegram_8069975634:matrix.jamesst.one offline 1788268621536 1788268685479 0   1 master
6734 6734 18507 @telegram_8958700705:matrix.jamesst.one offline 1788283782666 1788283752843 0   0 master
6738 6738 18515 @telegram_1779778499:matrix.jamesst.one offline 1788297976095 1788298040479 0   1 master
6750 6750 18542 @signal_7d49f5b3-36e3-454f-9e4f-dff731d14a53:matrix.jamesst.one offline 1788326932066 1788326922765 0   0 master
6753 6753 18549 @signal_e86076e2-74d3-4749-8ee1-aeba0ee04b87:matrix.jamesst.one offline 1788327351335 1788327310799 0   0 master
6778 6778 18588 @meta_100000675039685:matrix.jamesst.one offline 1788332570839 1788332570841 0   0 master
6835 6835 18700 @signal_ee9352df-a332-42ea-aa2f-9d0c65579263:matrix.jamesst.one offline 1788335806640 1788335654833 0   0 master
6843 6843 18708 @whatsapp_lid-217333951914120:matrix.jamesst.one offline 1788336125461 1788336125462 0   0 master
6963 6963 18916 @telegram_8465481152:matrix.jamesst.one offline 1788347835785 1788347903807 0   1 master
7024 7024 19034 @signalbot:matrix.jamesst.one offline 1788362798425 1788362798425 0   0 master
7197 7197 19375 @slack_t0qh48pl4-u0qjbsw7n:matrix.jamesst.one offline 1788415011574 1788414942638 0   0 master
7228 7228 19431 @signal_bc53bb96-98c5-4e60-b0cb-c2d3e2fa91a3:matrix.jamesst.one offline 1788417378108 1788417360468 0   0 master
7254 7254 19488 @slack_t0qh48pl4-u8qnykg3g:matrix.jamesst.one offline 1788418734129 1788418724950 0   0 master
7265 7265 19516 @slack_t0qh48pl4-u5e0cm2p6:matrix.jamesst.one offline 1788419373668 1788419369983 0   0 master
7284 7284 19545 @slack_t0qh48pl4-u0qnmqws0:matrix.jamesst.one offline 1788420351816 1788420347588 0   0 master
7308 7308 19581 @slack_t0qh48pl4-uslackbot:matrix.jamesst.one offline 1788422665933 1788422665933 0   0 master
7340 7340 19646 @slack_t0qh48pl4-u1ad08sp4:matrix.jamesst.one offline 1788424985413 1788424927034 0   0 master
7344 7344 19659 @slack_t0qh48pl4-urw7rghja:matrix.jamesst.one offline 1788425314446 1788425234487 0   0 master
7362 7362 19687 @meta_641981339:matrix.jamesst.one offline 1788428243163 1788428243165 0   0 master
7388 7388 19730 @slack_t0qh48pl4-u020gga57m5:matrix.jamesst.one offline 1788431602992 1788431597470 0   0 master
7430 7430 19822 @whatsapp_lid-215101307129906:matrix.jamesst.one offline 1788449806288 1788449764313 0   0 master
7431 7431 19824 @whatsapp_lid-251440421437670:matrix.jamesst.one offline 1788450168479 1788450165826 0   0 master
7453 7453 19876 @slack_t0qh48pl4-b0a2zef3j8l:matrix.jamesst.one offline 1788481080321 1788481080321 0   0 master
7457 7457 19881 @slack_t0qh48pl4-b0a2pfak6cb:matrix.jamesst.one offline 1788482850496 1788482850496 0   0 master
7477 7477 19930 @slack_t0qh48pl4-u0qnts7ge:matrix.jamesst.one offline 1788490074071 1788490048677 0   0 master
7521 7521 20038 @slack_t0qh48pl4-ule84aeba:matrix.jamesst.one offline 1788494870606 1788494870606 0   0 master
7555 7555 20117 @meta_572483676:matrix.jamesst.one offline 1788499106784 1788499012374 0   0 master
7560 7560 20130 @slack_t0qh48pl4-u0qk730nn:matrix.jamesst.one offline 1788499716983 1788499711617 0   0 master
7564 7564 20137 @slack_t0qh48pl4-u5g22hjnp:matrix.jamesst.one offline 1788499846813 1788499842851 0   0 master
7568 7568 20141 @slack_t0qh48pl4-uk2rre5h6:matrix.jamesst.one offline 1788500870712 1788500870712 0   0 master
7578 7578 20154 @slack_t0qh48pl4-u0qnrl7qq:matrix.jamesst.one offline 1788501433060 1788501397318 0   0 master
7579 7579 20157 @slack_t0qh48pl4-u378fmg2k:matrix.jamesst.one offline 1788501601415 1788501553276 0   0 master
7580 7580 20159 @slack_t0qh48pl4-u0qp3q866:matrix.jamesst.one offline 1788501647440 1788501645399 0   0 master
7590 7590 20175 @slack_t0qh48pl4-umv8j1c2u:matrix.jamesst.one offline 1788502379283 1788502339336 0   0 master
7614 7614 20219 @slack_t0qh48pl4-u087vnuavfg:matrix.jamesst.one offline 1788505320978 1788505243707 0   0 master

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE presence_stream( stream_id BIGINT, user_id TEXT, state TEXT, last_active_ts BIGINT, last_federation_update_ts BIGINT, last_user_sync_ts BIGINT, status_msg TEXT, currently_active BOOLEAN , instance_name TEXT);
CREATE INDEX presence_stream_id ON presence_stream(stream_id, user_id);
CREATE INDEX presence_stream_user_id ON presence_stream(user_id);
CREATE INDEX presence_stream_state_not_offline_idx ON presence_stream (state) WHERE state != 'offline';