Achievements

pg_achievements ships 46 builtin achievements. Each one is unlocked when a counter of the role reaches the threshold; the counters are described in the README. Secret achievements show ??? instead of the description in achievements.progress until they are unlocked.

Bronze — 10 points, first steps

Code Title Description Condition
hello_world Hello, World Run your first SELECT. stmt_select ≥ 1
welcome Welcome Connect to the server for the first time. connect ≥ 1
first_table First Table Create your first table. create_table ≥ 1
first_index Indexer Create your first index. create_index ≥ 1
first_function Functionary Create your first function or procedure. create_function ≥ 1
first_cte WITH Love Run a query with a common table expression. cte_any ≥ 1
first_join All Connected Run a query with an explicit JOIN. join_count_max ≥ 1
first_explain Investigator Ask the planner with EXPLAIN. explain_any ≥ 1
typo_apprentice Learning from Typos Make 10 syntax errors. err_syntax ≥ 10
star_gazer Stargazer Run 100 queries with SELECT *. select_star ≥ 100
night_owl Night Owl Run a query between 03:00 and 05:00. night_query ≥ 1
null_not_equal NULL Is Not Equal to NULL Compare with = NULL instead of IS NULL. null_eq ≥ 1

Silver — 25 points, mastering PostgreSQL features

Code Title Description Condition
detective Detective Run EXPLAIN ANALYZE. explain_analyze ≥ 1
recursion Recursion: See Recursion Run a WITH RECURSIVE query. cte_recursive ≥ 1
open_window Open Window Use a window function. window_func ≥ 1
lateral_thinking Lateral Thinking Use LATERAL. lateral ≥ 1
jsonb_juggler JSONB Juggler Use the JSONB operators ->, ->>, @> or ? 10 times. jsonb_ops ≥ 10
patient Patient Wait for a query that runs longer than a minute. query_over_60s ≥ 1
no_locks No Locks Create an index CONCURRENTLY. create_index_concurrently ≥ 1
trigger_happy Trigger Happy Create a trigger. create_trigger ≥ 1
divide_and_conquer Divide and Conquer Create a partitioned table or a partition. partition_create ≥ 1
extender Expanding Horizons Create 3 extensions. create_extension ≥ 3
thousand_and_one A Thousand and One Queries Run 1001 SELECT statements. stmt_select ≥ 1001
night_regular Night Shift Run 20 queries between 03:00 and 05:00. night_query ≥ 20
star_veteran Star Veteran Run 1000 queries with SELECT *. select_star ≥ 1000
bronze_collector Collector Collect every bronze achievement. every builtin bronze achievement

Gold — 50 points, risky and rare events

Code Title Description Condition
forgot_where Forgot WHERE UPDATE without a WHERE clause. update_no_where ≥ 1
forgot_where_again Forgot WHERE, Part 2 DELETE without a WHERE clause. delete_no_where ≥ 1
mutual_understanding Mutual Understanding Take part in a deadlock. deadlock ≥ 1
friday_deploy Friday Deploy Run DDL on a Friday after 18:00. ddl_friday_evening ≥ 1
index_for_the_weak Indexes Are for the Weak Scan a table of a million rows sequentially. seqscan_big ≥ 1
executioner Executioner Call pg_terminate_backend. terminate_backend ≥ 1
clean_slate Clean Slate TRUNCATE a table. truncate ≥ 1
table_owner Master of the Table Run VACUUM FULL. vacuum_full ≥ 1
serial_conflict Conflict of Interest Hit a serialization failure. serialization_failure ≥ 1
many_joins JOINs Without Borders Run a query with 8 JOINs. join_count_max ≥ 8
table_collector Table Collector Create 100 tables. create_table ≥ 100
deadlock_veteran Deadlock Veteran Take part in 5 deadlocks. deadlock ≥ 5

Platinum — 100 points, the stuff of legends

Code Title Description Condition
yolo You Only Live Once 🔒 Drop a database. drop_database ≥ 1
time_machine Time Machine 🔒 Roll back a transaction that ran for over an hour. rollback_long_xact ≥ 1
ten_joins Ten JOINs Run a query with 10 JOINs. join_count_max ≥ 10
scorched_earth Scorched Earth Drop 50 tables. drop_table ≥ 50
marathon Marathon 🔒 Wait for a query that runs longer than an hour. query_over_1h ≥ 1
serial_killer Serial Executioner 🔒 Call pg_terminate_backend 10 times. terminate_backend ≥ 10
gold_rush Gold Rush Collect every gold achievement. every builtin gold achievement
platinum_collection Platinum Collection Collect every other achievement. every other builtin achievement

🔒 — secret achievement.