Last active
January 23, 2023 21:35
-
-
Save helderjnpinto/9420f5033515e694491e4c8e0f8c3c7b to your computer and use it in GitHub Desktop.
PSQL stats blockscout tst
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
pid,query | |
218,"SELECT a0.""id"", a0.""name"", a0.""primary"", a0.""metadata"", a0.""address_hash"", a0.""inserted_at"", a0.""updated_at"", a0.""address_hash"" FROM ""address_names"" AS a0 WHERE (a0.""address_hash"" = $1) ORDER BY a0.""address_hash""" | |
210,"SELECT t0.""hash"", t0.""block_number"", t0.""cumulative_gas_used"", t0.""earliest_processing_start"", t0.""error"", t0.""gas"", t0.""gas_price"", t0.""gas_used"", t0.""index"", t0.""created_contract_code_indexed_at"", t0.""input"", t0.""nonce"", t0.""r"", t0.""s"", t0.""status"", t0.""v"", t0.""value"", t0.""revert_reason"", t0.""max_priority_fee_per_gas"", t0.""max_fee_per_gas"", t0.""type"", t0.""has_error_in_internal_txs"", t0.""old_block_hash"", t0.""inserted_at"", t0.""updated_at"", t0.""block_hash"", t0.""from_address_hash"", t0.""to_address_hash"", t0.""created_contract_address_hash"", t0.""block_hash"" FROM ""transactions"" AS t0 WHERE (t0.""block_hash"" = $1) ORDER BY t0.""block_hash""" | |
225,"SELECT a0.""hash"", a0.""fetched_coin_balance"", a0.""fetched_coin_balance_block_number"", a0.""contract_code"", a0.""nonce"", a0.""decompiled"", a0.""verified"", a0.""transactions_count"", a0.""token_transfers_count"", a0.""gas_used"", a0.""inserted_at"", a0.""updated_at"", a0.""hash"" FROM ""addresses"" AS a0 WHERE (a0.""hash"" = $1)" | |
173,"SELECT a0.""id"", a0.""name"", a0.""primary"", a0.""metadata"", a0.""address_hash"", a0.""inserted_at"", a0.""updated_at"", a0.""address_hash"" FROM ""address_names"" AS a0 WHERE (a0.""address_hash"" = $1) ORDER BY a0.""address_hash""" | |
206,"SELECT b0.""address_type"", b0.""reward"", b0.""address_hash"", b0.""block_hash"", b0.""inserted_at"", b0.""updated_at"", b0.""block_hash"" FROM ""block_rewards"" AS b0 WHERE (b0.""block_hash"" = $1) ORDER BY b0.""block_hash""" | |
159,"SELECT b0.""address_type"", b0.""reward"", b0.""address_hash"", b0.""block_hash"", b0.""inserted_at"", b0.""updated_at"", b0.""block_hash"" FROM ""block_rewards"" AS b0 WHERE (b0.""block_hash"" = $1) ORDER BY b0.""block_hash""" | |
163,"SELECT a0.""hash"", a0.""fetched_coin_balance"", a0.""fetched_coin_balance_block_number"", a0.""contract_code"", a0.""nonce"", a0.""decompiled"", a0.""verified"", a0.""transactions_count"", a0.""token_transfers_count"", a0.""gas_used"", a0.""inserted_at"", a0.""updated_at"", a0.""hash"" FROM ""addresses"" AS a0 WHERE (a0.""hash"" = $1)" | |
4457,"SELECT t0.""hash"", t0.""block_number"", t0.""cumulative_gas_used"", t0.""earliest_processing_start"", t0.""error"", t0.""gas"", t0.""gas_price"", t0.""gas_used"", t0.""index"", t0.""created_contract_code_indexed_at"", t0.""input"", t0.""nonce"", t0.""r"", t0.""s"", t0.""status"", t0.""v"", t0.""value"", t0.""revert_reason"", t0.""max_priority_fee_per_gas"", t0.""max_fee_per_gas"", t0.""type"", t0.""has_error_in_internal_txs"", t0.""old_block_hash"", t0.""inserted_at"", t0.""updated_at"", t0.""block_hash"", t0.""from_address_hash"", t0.""to_address_hash"", t0.""created_contract_address_hash"", t0.""block_hash"" FROM ""transactions"" AS t0 WHERE (t0.""block_hash"" = $1) ORDER BY t0.""block_hash""" | |
3565,"DELETE FROM ""event_notifications"" WHERE ""id"" = $1" | |
4204,"DELETE FROM ""event_notifications"" WHERE ""id"" = $1" | |
3895,"SELECT e0.""id"", e0.""data"" FROM ""event_notifications"" AS e0 WHERE (e0.""id"" = $1)" | |
207,"SELECT e0.""id"", e0.""data"" FROM ""event_notifications"" AS e0 WHERE (e0.""id"" = $1)" | |
4765,"SELECT a0.""id"", a0.""name"", a0.""primary"", a0.""metadata"", a0.""address_hash"", a0.""inserted_at"", a0.""updated_at"", a0.""address_hash"" FROM ""address_names"" AS a0 WHERE (a0.""address_hash"" = $1) ORDER BY a0.""address_hash""" | |
149,"SELECT a0.""hash"", a0.""fetched_coin_balance"", a0.""fetched_coin_balance_block_number"", a0.""contract_code"", a0.""nonce"", a0.""decompiled"", a0.""verified"", a0.""transactions_count"", a0.""token_transfers_count"", a0.""gas_used"", a0.""inserted_at"", a0.""updated_at"", a0.""hash"" FROM ""addresses"" AS a0 WHERE (a0.""hash"" = $1)" | |
4324,"SELECT t0.""hash"", t0.""block_number"", t0.""cumulative_gas_used"", t0.""earliest_processing_start"", t0.""error"", t0.""gas"", t0.""gas_price"", t0.""gas_used"", t0.""index"", t0.""created_contract_code_indexed_at"", t0.""input"", t0.""nonce"", t0.""r"", t0.""s"", t0.""status"", t0.""v"", t0.""value"", t0.""revert_reason"", t0.""max_priority_fee_per_gas"", t0.""max_fee_per_gas"", t0.""type"", t0.""has_error_in_internal_txs"", t0.""old_block_hash"", t0.""inserted_at"", t0.""updated_at"", t0.""block_hash"", t0.""from_address_hash"", t0.""to_address_hash"", t0.""created_contract_address_hash"", t0.""block_hash"" FROM ""transactions"" AS t0 WHERE (t0.""block_hash"" = $1) ORDER BY t0.""block_hash""" | |
177,"SELECT b0.""address_type"", b0.""reward"", b0.""address_hash"", b0.""block_hash"", b0.""inserted_at"", b0.""updated_at"", b0.""block_hash"" FROM ""block_rewards"" AS b0 WHERE (b0.""block_hash"" = $1) ORDER BY b0.""block_hash""" | |
4033,"select pg_notify('chain_event', $1::text);" | |
222,"DELETE FROM ""event_notifications"" WHERE ""id"" = $1" | |
216,"SELECT e0.""id"", e0.""data"" FROM ""event_notifications"" AS e0 WHERE (e0.""id"" = $1)" | |
4761,"DELETE FROM ""event_notifications"" WHERE ""id"" = $1" | |
4757,"SELECT e0.""id"", e0.""data"" FROM ""event_notifications"" AS e0 WHERE (e0.""id"" = $1)" | |
4753,"INSERT INTO ""event_notifications"" (""data"") VALUES ($1) RETURNING ""id""" | |
172,"select pg_notify('chain_event', $1::text);" | |
166,"DELETE FROM ""event_notifications"" WHERE ""id"" = $1" | |
211,"DELETE FROM ""event_notifications"" WHERE ""id"" = $1" | |
209,"SELECT e0.""id"", e0.""data"" FROM ""event_notifications"" AS e0 WHERE (e0.""id"" = $1)" | |
219,"DELETE FROM ""event_notifications"" WHERE ""id"" = $1" | |
224,"SELECT e0.""id"", e0.""data"" FROM ""event_notifications"" AS e0 WHERE (e0.""id"" = $1)" | |
213,"SELECT count(*) FROM ""pending_block_operations"" AS p0" | |
4200,"SELECT a0.""id"", a0.""name"", a0.""primary"", a0.""metadata"", a0.""address_hash"", a0.""inserted_at"", a0.""updated_at"", a0.""address_hash"" FROM ""address_names"" AS a0 WHERE (a0.""address_hash"" = $1) ORDER BY a0.""address_hash""" | |
214,"SELECT a0.""hash"", a0.""fetched_coin_balance"", a0.""fetched_coin_balance_block_number"", a0.""contract_code"", a0.""nonce"", a0.""decompiled"", a0.""verified"", a0.""transactions_count"", a0.""token_transfers_count"", a0.""gas_used"", a0.""inserted_at"", a0.""updated_at"", a0.""hash"" FROM ""addresses"" AS a0 WHERE (a0.""hash"" = $1)" | |
223,"SELECT t0.""hash"", t0.""block_number"", t0.""cumulative_gas_used"", t0.""earliest_processing_start"", t0.""error"", t0.""gas"", t0.""gas_price"", t0.""gas_used"", t0.""index"", t0.""created_contract_code_indexed_at"", t0.""input"", t0.""nonce"", t0.""r"", t0.""s"", t0.""status"", t0.""v"", t0.""value"", t0.""revert_reason"", t0.""max_priority_fee_per_gas"", t0.""max_fee_per_gas"", t0.""type"", t0.""has_error_in_internal_txs"", t0.""old_block_hash"", t0.""inserted_at"", t0.""updated_at"", t0.""block_hash"", t0.""from_address_hash"", t0.""to_address_hash"", t0.""created_contract_address_hash"", t0.""block_hash"" FROM ""transactions"" AS t0 WHERE (t0.""block_hash"" = $1) ORDER BY t0.""block_hash""" | |
4322,"SELECT a0.""hash"", a0.""fetched_coin_balance"", a0.""fetched_coin_balance_block_number"", a0.""contract_code"", a0.""nonce"", a0.""decompiled"", a0.""verified"", a0.""transactions_count"", a0.""token_transfers_count"", a0.""gas_used"", a0.""inserted_at"", a0.""updated_at"", a0.""hash"" FROM ""addresses"" AS a0 WHERE (a0.""hash"" = $1)" | |
220,"SELECT b0.""address_type"", b0.""reward"", b0.""address_hash"", b0.""block_hash"", b0.""inserted_at"", b0.""updated_at"", b0.""block_hash"" FROM ""block_rewards"" AS b0 WHERE (b0.""block_hash"" = $1) ORDER BY b0.""block_hash""" | |
181,"SELECT t0.""hash"", t0.""block_number"", t0.""cumulative_gas_used"", t0.""earliest_processing_start"", t0.""error"", t0.""gas"", t0.""gas_price"", t0.""gas_used"", t0.""index"", t0.""created_contract_code_indexed_at"", t0.""input"", t0.""nonce"", t0.""r"", t0.""s"", t0.""status"", t0.""v"", t0.""value"", t0.""revert_reason"", t0.""max_priority_fee_per_gas"", t0.""max_fee_per_gas"", t0.""type"", t0.""has_error_in_internal_txs"", t0.""old_block_hash"", t0.""inserted_at"", t0.""updated_at"", t0.""block_hash"", t0.""from_address_hash"", t0.""to_address_hash"", t0.""created_contract_address_hash"", t0.""block_hash"" FROM ""transactions"" AS t0 WHERE (t0.""block_hash"" = $1) ORDER BY t0.""block_hash""" | |
4326,"SELECT a0.""id"", a0.""name"", a0.""primary"", a0.""metadata"", a0.""address_hash"", a0.""inserted_at"", a0.""updated_at"", a0.""address_hash"" FROM ""address_names"" AS a0 WHERE (a0.""address_hash"" = $1) ORDER BY a0.""address_hash""" | |
221,"DELETE FROM ""event_notifications"" WHERE ""id"" = $1" | |
152,"DELETE FROM ""event_notifications"" WHERE ""id"" = $1" | |
215,"SELECT e0.""id"", e0.""data"" FROM ""event_notifications"" AS e0 WHERE (e0.""id"" = $1)" | |
1585,"INSERT INTO ""event_notifications"" (""data"") VALUES ($1) RETURNING ""id""" | |
179,"SELECT e0.""id"", e0.""data"" FROM ""event_notifications"" AS e0 WHERE (e0.""id"" = $1)" | |
208,"SELECT e0.""id"", e0.""data"" FROM ""event_notifications"" AS e0 WHERE (e0.""id"" = $1)" | |
4459,"INSERT INTO ""event_notifications"" (""data"") VALUES ($1) RETURNING ""id""" | |
4759,"SELECT e0.""id"", e0.""data"" FROM ""event_notifications"" AS e0 WHERE (e0.""id"" = $1)" | |
184,"INSERT INTO ""event_notifications"" (""data"") VALUES ($1) RETURNING ""id""" | |
4763,"SELECT a0.""id"", a0.""name"", a0.""primary"", a0.""metadata"", a0.""address_hash"", a0.""inserted_at"", a0.""updated_at"", a0.""address_hash"" FROM ""address_names"" AS a0 WHERE (a0.""address_hash"" = $1) ORDER BY a0.""address_hash""" | |
165,"SELECT b0.""address_type"", b0.""reward"", b0.""address_hash"", b0.""block_hash"", b0.""inserted_at"", b0.""updated_at"", b0.""block_hash"" FROM ""block_rewards"" AS b0 WHERE (b0.""block_hash"" = $1) ORDER BY b0.""block_hash""" | |
3892,"DELETE FROM ""event_notifications"" WHERE ""id"" = $1" | |
154,"SELECT a0.""hash"", a0.""fetched_coin_balance"", a0.""fetched_coin_balance_block_number"", a0.""contract_code"", a0.""nonce"", a0.""decompiled"", a0.""verified"", a0.""transactions_count"", a0.""token_transfers_count"", a0.""gas_used"", a0.""inserted_at"", a0.""updated_at"", a0.""hash"" FROM ""addresses"" AS a0 WHERE (a0.""hash"" = $1)" | |
158,"SELECT DISTINCT ON (f1.""number"") f1.""number"" FROM ""blocks"" AS b0 RIGHT OUTER JOIN ( | |
SELECT distinct b1.number | |
FROM generate_series(($1)::integer, ($2)::integer) AS b1(number) | |
WHERE NOT EXISTS | |
(SELECT 1 FROM blocks b2 WHERE b2.number=b1.number AND b2.consensus) | |
ORDER BY b1.number DESC | |
LIMIT 500000 | |
) | |
AS f1 ON b0.""number"" = f1.""number"" ORDER BY f1.""number""" | |
4206,"SELECT DISTINCT ON (s0.""hash"") s0.""hash"" FROM (SELECT sb0.""hash"" AS ""hash"", sb0.""consensus"" AS ""consensus"", sb0.""difficulty"" AS ""difficulty"", sb0.""gas_limit"" AS ""gas_limit"", sb0.""gas_used"" AS ""gas_used"", sb0.""nonce"" AS ""nonce"", sb0.""number"" AS ""number"", sb0.""size"" AS ""size"", sb0.""timestamp"" AS ""timestamp"", sb0.""total_difficulty"" AS ""total_difficulty"", sb0.""refetch_needed"" AS ""refetch_needed"", sb0.""base_fee_per_gas"" AS ""base_fee_per_gas"", sb0.""is_empty"" AS ""is_empty"", sb0.""inserted_at"" AS ""inserted_at"", sb0.""updated_at"" AS ""updated_at"", sb0.""miner_hash"" AS ""miner_hash"", sb0.""parent_hash"" AS ""parent_hash"" FROM ""blocks"" AS sb0 WHERE (sb0.""is_empty"" IS NULL) AND (sb0.""consensus"" = TRUE) ORDER BY sb0.""hash"" LIMIT $1 OFFSET 1000 FOR UPDATE) AS s0 INNER JOIN ""transactions"" AS t1 ON s0.""number"" = t1.""block_number"" ORDER BY s0.""hash""" | |
1579,"SELECT min(f1.""number"") FROM ""blocks"" AS b0 RIGHT OUTER JOIN (SELECT b1.number | |
FROM generate_series(0, ($1)::integer) AS b1(number) | |
WHERE NOT EXISTS | |
(SELECT 1 FROM blocks b2 WHERE b2.number=b1.number AND b2.consensus)) | |
AS f1 ON b0.""number"" = f1.""number""" | |
212,"SELECT min(f1.""number"") FROM ""blocks"" AS b0 RIGHT OUTER JOIN (SELECT b1.number | |
FROM generate_series(0, ($1)::integer) AS b1(number) | |
WHERE NOT EXISTS | |
(SELECT 1 FROM blocks b2 WHERE b2.number=b1.number AND b2.consensus)) | |
AS f1 ON b0.""number"" = f1.""number""" | |
204,"SELECT a0.""hash"", a0.""fetched_coin_balance"", a0.""fetched_coin_balance_block_number"", a0.""contract_code"", a0.""nonce"", a0.""decompiled"", a0.""verified"", a0.""transactions_count"", a0.""token_transfers_count"", a0.""gas_used"", a0.""inserted_at"", a0.""updated_at"", a0.""hash"" FROM ""addresses"" AS a0 WHERE (a0.""hash"" = ANY($1))" | |
201,"SELECT a0.""id"", a0.""value"", a0.""block_number"", a0.""value_fetched_at"", a0.""token_id"", a0.""token_type"", a0.""old_value"", a0.""address_hash"", a0.""token_contract_address_hash"", a0.""inserted_at"", a0.""updated_at"" FROM ""address_current_token_balances"" AS a0 WHERE (a0.""token_contract_address_hash"" = $1) AND (a0.""address_hash"" != $2) AND (a0.""value"" > 0) ORDER BY a0.""value"" DESC, a0.""address_hash"" DESC LIMIT $3 OFFSET $4" | |
205,"SELECT a0.""id"", a0.""value"", a0.""block_number"", a0.""value_fetched_at"", a0.""token_id"", a0.""token_type"", a0.""old_value"", a0.""address_hash"", a0.""token_contract_address_hash"", a0.""inserted_at"", a0.""updated_at"" FROM ""address_current_token_balances"" AS a0 WHERE (a0.""token_contract_address_hash"" = $1) AND (a0.""address_hash"" != $2) AND (a0.""value"" > 0) ORDER BY a0.""value"" DESC, a0.""address_hash"" DESC LIMIT $3 OFFSET $4" | |
198,"SELECT a0.""hash"", a0.""fetched_coin_balance"", a0.""fetched_coin_balance_block_number"", a0.""contract_code"", a0.""nonce"", a0.""decompiled"", a0.""verified"", a0.""transactions_count"", a0.""token_transfers_count"", a0.""gas_used"", a0.""inserted_at"", a0.""updated_at"", a0.""hash"" FROM ""addresses"" AS a0 WHERE (a0.""hash"" = ANY($1))" | |
196,"SELECT a0.""id"", a0.""value"", a0.""block_number"", a0.""value_fetched_at"", a0.""token_id"", a0.""token_type"", a0.""old_value"", a0.""address_hash"", a0.""token_contract_address_hash"", a0.""inserted_at"", a0.""updated_at"" FROM ""address_current_token_balances"" AS a0 WHERE (a0.""token_contract_address_hash"" = $1) AND (a0.""address_hash"" != $2) AND (a0.""value"" > 0) ORDER BY a0.""value"" DESC, a0.""address_hash"" DESC LIMIT $3 OFFSET $4" | |
203,"SELECT a0.""hash"", a0.""fetched_coin_balance"", a0.""fetched_coin_balance_block_number"", a0.""contract_code"", a0.""nonce"", a0.""decompiled"", a0.""verified"", a0.""transactions_count"", a0.""token_transfers_count"", a0.""gas_used"", a0.""inserted_at"", a0.""updated_at"", a0.""hash"" FROM ""addresses"" AS a0 WHERE (a0.""hash"" = ANY($1))" | |
197,"SELECT a0.""id"", a0.""value"", a0.""block_number"", a0.""value_fetched_at"", a0.""token_id"", a0.""token_type"", a0.""old_value"", a0.""address_hash"", a0.""token_contract_address_hash"", a0.""inserted_at"", a0.""updated_at"" FROM ""address_current_token_balances"" AS a0 WHERE (a0.""token_contract_address_hash"" = $1) AND (a0.""address_hash"" != $2) AND (a0.""value"" > 0) ORDER BY a0.""value"" DESC, a0.""address_hash"" DESC LIMIT $3 OFFSET $4" | |
200,"SELECT a0.""hash"", a0.""fetched_coin_balance"", a0.""fetched_coin_balance_block_number"", a0.""contract_code"", a0.""nonce"", a0.""decompiled"", a0.""verified"", a0.""transactions_count"", a0.""token_transfers_count"", a0.""gas_used"", a0.""inserted_at"", a0.""updated_at"", a0.""hash"" FROM ""addresses"" AS a0 WHERE (a0.""hash"" = ANY($1))" | |
202,"SELECT a0.""hash"", a0.""fetched_coin_balance"", a0.""fetched_coin_balance_block_number"", a0.""contract_code"", a0.""nonce"", a0.""decompiled"", a0.""verified"", a0.""transactions_count"", a0.""token_transfers_count"", a0.""gas_used"", a0.""inserted_at"", a0.""updated_at"", a0.""hash"" FROM ""addresses"" AS a0 WHERE (a0.""hash"" = ANY($1))" | |
44,"LISTEN ""chain_event""" | |
114,"LISTEN ""chain_event""" | |
45,"SELECT t.oid, t.typname, t.typsend, t.typreceive, t.typoutput, t.typinput, | |
coalesce(d.typelem, t.typelem), coalesce(r.rngsubtype, 0), ARRAY ( | |
SELECT a.atttypid | |
FROM pg_attribute AS a | |
WHERE a.attrelid = t.typrelid AND a.attnum > 0 AND NOT a.attisdropped | |
ORDER BY a.attnum | |
) | |
FROM pg_type AS t | |
LEFT JOIN pg_type AS d ON t.typbasetype = d.oid | |
LEFT JOIN pg_range AS r ON r.rngtypid = t.oid OR (t.typbasetype <> 0 AND r.rngtypid = t.typbasetype) | |
WHERE (t.typrelid = 0) | |
AND (t.typelem = 0 OR NOT EXISTS (SELECT 1 FROM pg_catalog.pg_type s WHERE s.typrelid != 0 AND s.oid = t.typelem)) | |
" | |
81,"SELECT t.oid, t.typname, t.typsend, t.typreceive, t.typoutput, t.typinput, | |
coalesce(d.typelem, t.typelem), coalesce(r.rngsubtype, 0), ARRAY ( | |
SELECT a.atttypid | |
FROM pg_attribute AS a | |
WHERE a.attrelid = t.typrelid AND a.attnum > 0 AND NOT a.attisdropped | |
ORDER BY a.attnum | |
) | |
FROM pg_type AS t | |
LEFT JOIN pg_type AS d ON t.typbasetype = d.oid | |
LEFT JOIN pg_range AS r ON r.rngtypid = t.oid OR (t.typbasetype <> 0 AND r.rngtypid = t.typbasetype) | |
WHERE (t.typrelid = 0) | |
AND (t.typelem = 0 OR NOT EXISTS (SELECT 1 FROM pg_catalog.pg_type s WHERE s.typrelid != 0 AND s.oid = t.typelem)) | |
" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment