{"id":"781b9b80-2e22-43dd-a28c-0d46bbaab29c","share_slug":"8mcfjc16","kind":"query","title":"Prompt injection on Hacker News, month by month since 2023","summary":"Monthly count of Hacker News items carrying both tokens 'prompt' and 'injection' since January 2023, one GROUP BY over hackernews.items. Measured 2026-09-09: 1.23 s, 13,655,449 rows read, $0.0073 of machine time, $0 charged. Rows land every few minutes; the current month is partial.","payload":{"params":[],"snapshot":{"as_of":"2026-09-09T13:28:49Z","billing_mode":"free_slack","burden_nanodollars":7267704,"columns":[{"name":"m","type":"Nullable(Date)"},{"name":"n","type":"UInt64"}],"duration_ms":1234,"freshness_lag_seconds":168,"read_bytes":4750005274,"read_rows":13655449,"row_count":45,"rows":[["2023-01-01",19],["2023-02-01",77],["2023-03-01",80],["2023-04-01",120],["2023-05-01",295],["2023-06-01",45],["2023-07-01",32],["2023-08-01",21],["2023-09-01",14],["2023-10-01",59],["2023-11-01",96],["2023-12-01",76],["2024-01-01",39],["2024-02-01",46],["2024-03-01",47],["2024-04-01",28],["2024-05-01",17],["2024-06-01",19],["2024-07-01",15],["2024-08-01",46],["2024-09-01",19],["2024-10-01",26],["2024-11-01",13],["2024-12-01",16],["2025-01-01",45],["2025-02-01",30],["2025-03-01",38],["2025-04-01",65],["2025-05-01",59],["2025-06-01",64],["2025-07-01",104],["2025-08-01",155],["2025-09-01",87],["2025-10-01",90],["2025-11-01",95],["2025-12-01",75],["2026-01-01",244],["2026-02-01",454],["2026-03-01",352],["2026-04-01",177],["2026-05-01",111],["2026-06-01",198],["2026-07-01",175],["2026-08-01",134],["2026-09-01",31]],"spend_nanodollars":0,"truncated":false},"sql":"SELECT toStartOfMonth(original_timestamp) AS m, count() AS n\nFROM hackernews.items\nWHERE original_timestamp >= '2023-01-01'\n  AND hasToken(search_text_lc, 'prompt')\n  AND hasToken(search_text_lc, 'injection')\nGROUP BY m ORDER BY m LIMIT 100"},"is_public":true,"created_at":"2026-09-09T13:30:18Z","updated_at":"2026-09-09T13:30:18Z"}