Skip to content

Instantly share code, notes, and snippets.

View bogdan's full-sized avatar

Bogdan Gusiev bogdan

View GitHub Profile
Timing is on.
otp_secret | email | crypto_logins | count
------------+-------+---------------+---------
f | f | f | 6697663
f | t | f | 782893
f | f | t | 137459
t | t | f | 41713
f | t | t | 40745
t | t | t | 8726
t | f | t | 833
Timing is on.
otp_secret | email | count
------------+-------+---------
f | f | 6835086
f | t | 823636
t | t | 50439
t | f | 1337
(4 rows)
Time: 1414.042 ms (00:01.414)
Timing is on.
type | fail_reason | count | last_at
---------+----------------------------------------------------------------------------------------------+-------+----------------------------
MaticTx | Unknown Ethereum network rejection reason | 9 | 2023-01-18 10:39:20.063131
MaticTx | Eth call reverted: cannot estimate gas; transaction may fail or may require manual gas limit | 987 | 2023-01-14 09:21:07.43858
MaticTx | Eth call reverted: processing response error | 10 | 2023-01-02 09:58:46.338178
MaticTx | Parent transaction was rejected | 52 | 2022-12-30 15:27:02.687473
MaticTx | Manually Rejected | 10 | 2022-12-16 12:17:24.117274
(5 rows)
Timing is on.
id | blockchain | transaction_hash | level | name | created_at | ?column?
----------+------------+--------------------------------------------------------------------+-------+-------------------------------------+----------------------------+----------
21570897 | ETH | 0x0af2490a093b46d0e5567226d722259a506e3b6bf194559934fff9125ef91daa | 2 | nftslamz.nft | 2023-01-04 04:24:01.147644 | 1
21570890 | ETH | 0xfca9074465c001eb50f46a150ba5b9a0120a78638dc526a94129b05737a98539 | 2 | nftslamz.nft | 2023-01-04 04:23:00.684611 | 1
21520285 | ETH | 0x8d7dfd70a2f7b7090a54b44287769795dd98407d7fdbcea34cfaa80b5e790f64 | 2 | manutec.hi | 2023-01-01 15:02:00.705426 | 1
21520284 | ETH | 0x45fb93bee5b6bacdd308f761931f8ab1238ec6710e12622a46c992ad895dd0d2 | 2 | manutec.hi
Timing is on.
type | blockchain | count
------------------+------------+---------
Set | MATIC | 5287853
NewKey | MATIC | 5127323
Transfer | MATIC | 2924957
NewURI | MATIC | 2624531
Sync | ETH | 457652
Transfer | ETH | 393949
NewURI | ETH | 338442
Timing is on.
registry_type | resolver | count
---------------+--------------------------------------------+---------
UnsMatic | 0xa9a6a3626993d487d2dbda3173cf58ca1a9d9e9f | 1432489
Cns | 0xb66dce2da6afaaa98f2013446dbcb0f4b0ab2842 | 225586
Zns | 0x0000000000000000000000000000000000000000 | 45509
Cns | | 44957
Uns | 0x049aba7510f45ba5b64ea9e658e342f904db358d | 29419
Cns | 0x878bc2f3f717766ab69c0a5f9a6144931e61aed3 | 19568
Cns | 0xa1cac442be6673c49f8e74ffc7c4fd746f3cbd0d | 15915
Timing is on.
parent_id | name | last_updated | unique_owners | subdomains_count
-----------+----------------------------------------+----------------------------+---------------+------------------
1152698 | chat.crypto | 2022-11-22 23:48:16.510753 | 449 | 1926
168006285 | btgape.nft | 2022-11-30 12:27:01.606829 | 4 | 936
168611000 | arukbn.nft | 2022-11-30 12:20:01.607584 | 10 | 663
168439504 | dontsel.nft | 2022-11-30 13:25:02.896583 | 50 | 603
168353111 | binance09.nft | 2022-11-22 22:21:26.948429 | 7 | 494
168648543 | itsforme.x | 2022-11-30 09:00:01.19321 | 8 | 410
168307948 | trustpanda11.klever | 2022-11-22 22:35:57.659682
Timing is on.
parent_id | name | last_updated | subdomains_count
-----------+----------------------------------------+----------------------------+------------------
1152698 | chat.crypto | 2022-11-22 23:48:16.510753 | 1926
168006285 | btgape.nft | 2022-11-30 12:27:01.606829 | 936
168611000 | arukbn.nft | 2022-11-30 12:20:01.607584 | 663
168439504 | dontsel.nft | 2022-11-30 13:25:02.896583 | 603
168353111 | binance09.nft | 2022-11-22 22:21:26.948429 | 494
168648543 | itsforme.x | 2022-11-30 09:00:01.19321 | 410
168307948 | trustpanda11.klever | 2022-11-22 22:35:57.659682 | 374
@bogdan
bogdan / ens.md
Last active November 11, 2022 14:23
Timing is on.
id | type | operation | hash | required | ignoreto | created_at | updated_at | age
---------+---------+------------------------+--------------------------------------------------------------------+----------+----------+----------------------------+----------------------------+-----
3143705 | EthTx | MintOnWithdrawal | 0xb37116bd3ee6c568a5826ff6416d0cadfdd0b4cddc6fea37ad90c61635167575 | true | true | 2022-10-25 19:06:11.481166 | 2022-10-28 08:52:50.099442 | 2
3143657 | EthTx | MintOnWithdrawal | 0xca5590e5361bee7bba468b7a4a7e31e92f17bd22f5c7b3749d8b032d8d9da80a | true | true | 2022-10-25 18:50:36.389803 | 2022-10-28 08:42:12.085035 | 2
3136967 | EthTx | MintOnWithdrawal | 0xf51a13c1261a8fc5c2e4bba00a63a8129a92303dd700ea4b5653d4acfe74fc66 | true | true | 2022-10-24 11:46:40.248592 | 2022-10-27 09:18:18.040591 | 2
3122782 | Et