helderjnpinto/PSQL stats blockscout.txt

## PSQL stats blockscout.txt
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))

"
	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))

	"