| CARVIEW |
Select Language
HTTP/2 200
date: Sun, 12 Oct 2025 00:25:08 GMT
content-type: text/html; charset=UTF-8
server: cloudflare
x-frame-options: DENY
x-content-type-options: nosniff
x-xss-protection: 1;mode=block
vary: accept-encoding
cf-cache-status: DYNAMIC
content-encoding: gzip
set-cookie: _csrf-frontend=c4e52b6e0a8094a1a2100d367bce50a981e160ca558acc58a4aa193da52c4bc8a%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_csrf-frontend%22%3Bi%3A1%3Bs%3A32%3A%22gJtmqU0NLPbDm_04V2CNTF_ySkMXBUHM%22%3B%7D; HttpOnly; Path=/
cf-ray: 98d275527910165e-BLR
refreshing: db_logs - Pastebin.com
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- DATABASE LOGS QUERIES
- -- -----------------------------------------------------
- -- Explanation of status codes:
- -- kind: 0 = refresh_clickhouse_tables_started, 1 = refresh_clickhouse_tables_finished
- -- severity: 0 = success (no error), 1 = failure (with error)
- -- QUERY 1: Latest successful log entries
- -- -----------------------------------------------------
- -- Shows the most recent successful log entry for each source (table_name)
- -- Only includes entries where process started (kind=0) without errors (severity=0)
- WITH db_logs AS (
- SELECT
- *,
- RANK() OVER (PARTITION BY SOURCE ORDER BY created_at DESC) AS rank
- FROM db_logs
- WHERE db_logs.kind = 0 AND db_logs.severity = 0
- AND db_logs.created_at BETWEEN '2025-07-04 00:00:00' AND '2025-07-04 23:59:59.999999'
- )
- SELECT db_logs.*
- FROM db_logs
- WHERE db_logs.rank = 1
- ORDER BY db_logs.created_at DESC;
- -- QUERY 2: Latest failed log entries
- -- -----------------------------------------------------
- -- Shows the most recent failed log entry for each source (table_name)
- -- Only includes entries where process started (kind=0) with errors (severity=1)
- WITH db_logs AS (
- SELECT
- *,
- RANK() OVER (PARTITION BY SOURCE ORDER BY created_at DESC) AS rank
- FROM db_logs
- WHERE db_logs.kind = 0 AND db_logs.severity = 1
- AND db_logs.created_at BETWEEN '2024-07-04 00:00:00' AND '2025-07-04 23:59:59.999999'
- )
- SELECT db_logs.*
- FROM db_logs
- WHERE db_logs.rank = 1
- ORDER BY db_logs.created_at DESC;
- -- QUERY 3: Latest successful log entries (finished)
- -- -----------------------------------------------------
- -- Shows the most recent successful log entry for each source (table_name)
- -- Only includes entries where process finished (kind=1) without errors (severity=0)
- WITH db_logs AS (
- SELECT
- *,
- RANK() OVER (PARTITION BY SOURCE ORDER BY created_at DESC) AS rank
- FROM db_logs
- WHERE db_logs.kind = 1 AND db_logs.severity = 0
- AND db_logs.created_at BETWEEN '2024-07-04 00:00:00' AND '2025-07-04 23:59:59.999999'
- )
- SELECT db_logs.*
- FROM db_logs
- WHERE db_logs.rank = 1
- ORDER BY db_logs.created_at DESC;
- -- QUERY 4: Latest failed log entries (finished)
- -- -----------------------------------------------------
- -- Shows the most recent failed log entry for each source (table_name)
- -- Only includes entries where process finished (kind=1) with errors (severity=1)
- WITH db_logs AS (
- SELECT
- *,
- RANK() OVER (PARTITION BY SOURCE ORDER BY created_at DESC) AS rank
- FROM db_logs
- WHERE db_logs.kind = 1 AND db_logs.severity = 1
- AND db_logs.created_at BETWEEN '2024-07-04 00:00:00' AND '2025-07-04 23:59:59.999999'
- )
- SELECT db_logs.*
- FROM db_logs
- WHERE db_logs.rank = 1
- ORDER BY db_logs.created_at DESC;
- -- QUERY 5: SUMMARY OF LOG ENTRIES
- -- -----------------------------------------------------
- WITH db_error_logs AS (
- SELECT
- *,
- DATE(created_at) AS log_date,
- RANK() OVER (PARTITION BY SOURCE ORDER BY created_at DESC) AS rank
- FROM db_logs
- WHERE db_logs.kind = 1 AND db_logs.severity = 1
- AND db_logs.created_at BETWEEN '2024-07-04 00:00:00' AND '2025-07-04 23:59:59.999999'
- ORDER BY db_logs.created_at DESC
- ), db_completed_logs AS (
- SELECT
- *,
- DATE(created_at) AS log_date,
- RANK() OVER (PARTITION BY SOURCE ORDER BY created_at DESC) AS rank
- FROM db_logs
- WHERE db_logs.kind = 1 AND db_logs.severity = 0
- AND db_logs.created_at BETWEEN '2024-07-04 00:00:00' AND '2025-07-04 23:59:59.999999'
- ORDER BY db_logs.created_at DESC
- ), db_logs AS (
- SELECT
- *,
- DATE(created_at) AS log_date,
- RANK() OVER (PARTITION BY SOURCE ORDER BY created_at DESC) AS rank
- FROM db_logs
- WHERE db_logs.kind = 0 AND db_logs.severity IN (0, 1)
- AND db_logs.created_at BETWEEN '2024-07-04 00:00:00' AND '2025-07-04 23:59:59.999999'
- ORDER BY db_logs.created_at DESC
- )
- SELECT
- db_logs.SOURCE AS SOURCE,
- CASE WHEN cl.created_at > el.created_at OR el.created_at IS NULL THEN 'finished' ELSE 'failed' END AS lastest_result,
- db_logs.log_date AS log_date,
- cl.created_at AS finished_at,
- el.created_at AS failed_at,
- CASE WHEN db_logs.severity = 0 THEN 'info' ELSE 'error' END AS kind,
- CASE WHEN cl.created_at > el.created_at OR el.created_at IS NULL THEN cl.description ELSE el.description END AS description,
- CASE WHEN cl.created_at > el.created_at OR el.created_at IS NULL THEN cl.metadata ELSE el.metadata END AS metadata
- FROM db_logs
- LEFT JOIN db_error_logs el ON db_logs.SOURCE = el.SOURCE AND el.rank = 1 AND el.log_date = db_logs.log_date
- LEFT JOIN db_completed_logs cl ON db_logs.SOURCE = cl.SOURCE AND cl.rank = 1 AND cl.log_date = db_logs.log_date
- WHERE db_logs.rank = 1
Advertisement
Add Comment
Please, Sign In to add comment
-
⭐⭐⭐MAKE $9OO INSTANTLY D G⭐⭐
Java | 6 sec ago | 0.10 KB
-
Free Crypto Method (NEVER SEEN BEFORE)⭐⭐ 3
JavaScript | 7 sec ago | 0.25 KB
-
⭐ Free Crypto Method ⭐
JavaScript | 8 sec ago | 0.24 KB
-
⭐✅ Swapzone Glitch ✅ Working ⭐⭐ G
JavaScript | 16 sec ago | 0.25 KB
-
📝 Crypto Swap Glitch ✅ Working
JavaScript | 19 sec ago | 0.24 KB
-
⭐⭐⭐Profit Method⭐⭐
Java | 19 sec ago | 0.10 KB
-
✅ Make $2500 in 20 minutes⭐⭐⭐ U
JavaScript | 25 sec ago | 0.25 KB
-
📝 EASY MONEY GUIDE ✅ Working
JavaScript | 28 sec ago | 0.24 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
