Col case changes

6 files changed, 344 insertions, 185 deletions

diff --git a/api.py b/api.py
index 8cb18a2..936ff30 100644
--- a/api.py
+++ b/api.py
@@ -126,9 +126,9 @@ class Worker(object):
         query = """
             INSERT INTO player ("{0}", "lastMatchCreatedDate")
             VALUES ({1}, 'epoch'::timestamp)
-            ON CONFLICT("apiId") DO UPDATE SET ("{0}") = ({1})
+            ON CONFLICT("api_id") DO UPDATE SET ("{0}") = ({1})
             WHERE player.played < EXCLUDED.played
-            RETURNING "apiId"
+            RETURNING "api_id"
         """.format(
             "\", \"".join(keys), ", ".join(placeholders))
         objid = await conn.fetchval(query, *data.values())
@@ -149,8 +149,10 @@ class Worker(object):
         items = list(data.items())
         keys, values = [x[0] for x in items], [x[1] for x in items]
         placeholders = ["${}".format(i) for i, _ in enumerate(values, 1)]
-        query = "INSERT INTO {} (\"{}\") VALUES ({}) ON CONFLICT DO NOTHING RETURNING \"apiId\"".format(
+        query = "INSERT INTO {} (\"{}\") VALUES ({}) ON CONFLICT DO NOTHING RETURNING api_id".format(
             table, "\", \"".join(keys), ", ".join(placeholders))
+        logging.debug(query)
+        logging.debug((*data))
         return await conn.fetchval(query, (*data))
 
     async def _work(self):
@@ -192,7 +194,7 @@ logging.basicConfig(
     level=logging.DEBUG
 )
 console = logging.StreamHandler()
-console.setLevel(logging.WARNING)
+console.setLevel(logging.DEBUG)
 logging.getLogger("").addHandler(console)
 
 loop = asyncio.get_event_loop()
diff --git a/logs/processor.log b/logs/processor.log
index be470e4..a349fac 100644
--- a/logs/processor.log
+++ b/logs/processor.log
@@ -1,155 +1,312 @@
 DEBUG:asyncio:Using selector: EpollSelector
 WARNING:root:connecting to database
 INFO:root:loaded query 'match'
-INFO:root:loaded query 'player'
-INFO:root:loaded query 'roster'
 INFO:root:loaded query 'participant'
-DEBUG:root:820: running 'match' query
-DEBUG:root:812: running 'match' query
-DEBUG:root:812: running 'player' query
-DEBUG:root:813: running 'match' query
-DEBUG:root:813: running 'player' query
-DEBUG:root:820: running 'player' query
-DEBUG:root:812: running 'roster' query
-DEBUG:root:814: running 'match' query
-DEBUG:root:814: running 'player' query
-DEBUG:root:812: running 'participant' query
-DEBUG:root:813: running 'roster' query
-DEBUG:root:813: running 'participant' query
-DEBUG:root:815: running 'match' query
-DEBUG:root:815: running 'player' query
-DEBUG:root:816: running 'match' query
-DEBUG:root:816: running 'player' query
-ERROR:asyncio:Task exception was never retrieved
-future: <Task finished coro=<Worker.run() done, defined at /apps/api/api.py:164> exception=DeadlockDetectedError('deadlock detected',)>
-Traceback (most recent call last):
-  File "/apps/api/api.py", line 168, in run
-    await self._work()
-  File "/apps/api/api.py", line 161, in _work
-    await self._execute_job(jobid, payload, priority)
-  File "/apps/api/api.py", line 79, in _execute_job
-    data["name"] == explicit_player)
-  File "/apps/api/api.py", line 134, in _playerinto
-    objid = await conn.fetchval(query, *data.values())
-  File "/usr/local/lib/python3.6/site-packages/asyncpg/connection.py", line 289, in fetchval
-    False, timeout)
-  File "asyncpg/protocol/protocol.pyx", line 165, in bind_execute (asyncpg/protocol/protocol.c:55643)
-asyncpg.exceptions.DeadlockDetectedError: deadlock detected
-ERROR:asyncio:Task exception was never retrieved
-future: <Task finished coro=<Worker.run() done, defined at /apps/api/api.py:164> exception=DeadlockDetectedError('deadlock detected',)>
-Traceback (most recent call last):
-  File "/apps/api/api.py", line 168, in run
-    await self._work()
-  File "/apps/api/api.py", line 161, in _work
-    await self._execute_job(jobid, payload, priority)
-  File "/apps/api/api.py", line 79, in _execute_job
-    data["name"] == explicit_player)
-  File "/apps/api/api.py", line 134, in _playerinto
-    objid = await conn.fetchval(query, *data.values())
-  File "/usr/local/lib/python3.6/site-packages/asyncpg/connection.py", line 289, in fetchval
-    False, timeout)
-  File "asyncpg/protocol/protocol.pyx", line 165, in bind_execute (asyncpg/protocol/protocol.c:55643)
-asyncpg.exceptions.DeadlockDetectedError: deadlock detected
-ERROR:asyncio:Task exception was never retrieved
-future: <Task finished coro=<Worker.run() done, defined at /apps/api/api.py:164> exception=DeadlockDetectedError('deadlock detected',)>
-Traceback (most recent call last):
-  File "/apps/api/api.py", line 168, in run
-    await self._work()
-  File "/apps/api/api.py", line 161, in _work
-    await self._execute_job(jobid, payload, priority)
-  File "/apps/api/api.py", line 79, in _execute_job
-    data["name"] == explicit_player)
-  File "/apps/api/api.py", line 141, in _playerinto
-    """, lmcd)
-  File "/usr/local/lib/python3.6/site-packages/asyncpg/connection.py", line 174, in execute
-    True, timeout)
-  File "asyncpg/protocol/protocol.pyx", line 165, in bind_execute (asyncpg/protocol/protocol.c:55643)
-asyncpg.exceptions.DeadlockDetectedError: deadlock detected
-DEBUG:root:816: running 'roster' query
-DEBUG:root:816: running 'participant' query
-DEBUG:root:817: running 'match' query
-DEBUG:root:817: running 'player' query
-DEBUG:root:817: running 'roster' query
-DEBUG:root:817: running 'participant' query
-DEBUG:root:818: running 'match' query
-DEBUG:root:818: running 'player' query
-DEBUG:root:818: running 'roster' query
-DEBUG:root:818: running 'participant' query
-DEBUG:root:819: running 'match' query
-DEBUG:root:819: running 'player' query
-DEBUG:root:819: running 'roster' query
-DEBUG:root:819: running 'participant' query
-DEBUG:root:880: running 'match' query
-DEBUG:root:880: running 'player' query
-DEBUG:root:880: running 'roster' query
-DEBUG:root:880: running 'participant' query
-DEBUG:root:881: running 'match' query
-DEBUG:root:881: running 'player' query
-DEBUG:root:881: running 'roster' query
-DEBUG:root:881: running 'participant' query
-DEBUG:root:882: running 'match' query
-DEBUG:root:882: running 'player' query
-DEBUG:root:882: running 'roster' query
-DEBUG:root:882: running 'participant' query
-DEBUG:root:883: running 'match' query
-DEBUG:root:883: running 'player' query
-DEBUG:root:883: running 'roster' query
-DEBUG:root:883: running 'participant' query
-DEBUG:root:884: running 'match' query
-DEBUG:root:884: running 'player' query
-DEBUG:root:884: running 'roster' query
-DEBUG:root:884: running 'participant' query
-DEBUG:asyncio:Using selector: EpollSelector
-WARNING:root:connecting to database
-DEBUG:asyncio:Using selector: EpollSelector
-WARNING:root:connecting to database
-INFO:root:loaded query 'match'
 INFO:root:loaded query 'player'
 INFO:root:loaded query 'roster'
-INFO:root:loaded query 'participant'
+DEBUG:root:7: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:7: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:7: running 'player' query
+DEBUG:root:6: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:6: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:6: running 'player' query
+DEBUG:root:9: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:9: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:9: running 'player' query
+DEBUG:root:2: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:2: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:2: running 'player' query
+DEBUG:root:5: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:5: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:5: running 'player' query
+DEBUG:root:11: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:11: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:11: running 'player' query
+DEBUG:root:8: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:8: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:8: running 'player' query
+DEBUG:root:10: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:10: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:10: running 'player' query
+DEBUG:root:3: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:3: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:3: running 'player' query
+DEBUG:root:4: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:4: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:4: running 'player' query
+DEBUG:root:7: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:7: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:7: running 'player' query
+DEBUG:root:6: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:6: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:6: running 'player' query
+DEBUG:root:9: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:9: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:9: running 'player' query
+DEBUG:root:2: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:2: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:2: running 'player' query
+DEBUG:root:5: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:5: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:5: running 'player' query
+DEBUG:root:11: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:11: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:11: running 'player' query
+DEBUG:root:8: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:8: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:8: running 'player' query
 DEBUG:asyncio:Using selector: EpollSelector
 WARNING:root:connecting to database
 INFO:root:loaded query 'match'
+INFO:root:loaded query 'participant'
 INFO:root:loaded query 'player'
 INFO:root:loaded query 'roster'
-INFO:root:loaded query 'participant'
-DEBUG:root:928: running 'match' query
-DEBUG:root:928: running 'player' query
-DEBUG:root:928: running 'roster' query
-DEBUG:root:929: running 'match' query
-DEBUG:root:929: running 'player' query
-DEBUG:root:930: running 'match' query
-DEBUG:root:930: running 'player' query
-DEBUG:root:928: running 'participant' query
-DEBUG:root:931: running 'match' query
-DEBUG:root:931: running 'player' query
-DEBUG:root:929: running 'roster' query
-DEBUG:root:929: running 'participant' query
-DEBUG:root:932: running 'match' query
-DEBUG:root:932: running 'player' query
-DEBUG:root:931: running 'roster' query
-DEBUG:root:931: running 'participant' query
-DEBUG:root:930: running 'roster' query
-DEBUG:root:930: running 'participant' query
-DEBUG:root:932: running 'roster' query
-DEBUG:root:932: running 'participant' query
-DEBUG:root:977: running 'match' query
-DEBUG:root:977: running 'player' query
-DEBUG:root:977: running 'roster' query
-DEBUG:root:977: running 'participant' query
-DEBUG:root:978: running 'match' query
-DEBUG:root:978: running 'player' query
-DEBUG:root:974: running 'match' query
-DEBUG:root:978: running 'roster' query
-DEBUG:root:974: running 'player' query
-DEBUG:root:978: running 'participant' query
-DEBUG:root:975: running 'match' query
-DEBUG:root:975: running 'player' query
-DEBUG:root:974: running 'roster' query
-DEBUG:root:974: running 'participant' query
-DEBUG:root:976: running 'match' query
-DEBUG:root:976: running 'player' query
-DEBUG:root:975: running 'roster' query
-DEBUG:root:975: running 'participant' query
-DEBUG:root:976: running 'roster' query
-DEBUG:root:976: running 'participant' query
+DEBUG:root:10: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:10: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:10: running 'player' query
+DEBUG:root:4: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:4: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:4: running 'player' query
+DEBUG:root:3: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:3: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:3: running 'player' query
+DEBUG:root:7: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:7: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:7: running 'player' query
+DEBUG:root:6: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:6: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:6: running 'player' query
+DEBUG:root:9: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:9: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:9: running 'player' query
+DEBUG:root:2: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:2: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:2: running 'player' query
+DEBUG:root:5: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:5: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:5: running 'player' query
+DEBUG:root:11: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:11: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:11: running 'player' query
+DEBUG:root:8: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:8: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:8: running 'player' query
+DEBUG:root:10: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:10: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:10: running 'player' query
+DEBUG:root:4: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:4: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:4: running 'player' query
+DEBUG:root:3: running 'match' query
+DEBUG:root:INSERT INTO match ("api_id", "created_at", "duration", "game_mode", "patch_version", "shard_id", "end_game_reason", "queue", "roster_1", "roster_2") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:3: running 'participant' query
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:INSERT INTO participant ("api_id", "roster_api_id", "player_api_id", "hero", "assists", "crystal_mine_captures", "deaths", "farm", "first_afk_time", "gold_mine_captures", "jungle_kills", "karma_level", "kills", "kraken_captures", "level", "minion_kills", "skill_tier", "skin_key", "turret_kills", "went_afk", "winner", "item_grants", "item_sells", "item_uses", "items") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) ON CONFLICT DO NOTHING RETURNING api_id
+DEBUG:root:3: running 'player' query
diff --git a/queries/match.sql b/queries/match.sql
index 1e6d37f..0b992f9 100644
--- a/queries/match.sql
+++ b/queries/match.sql
@@ -1,12 +1,12 @@
 SELECT
 
-match.id AS "apiId",
-(match.data->'data'->'attributes'->>'createdAt')::timestamp as "createdAt",
+match.id AS "api_id",
+(match.data->'data'->'attributes'->>'createdAt')::timestamp as "created_at",
 (match.data->'data'->'attributes'->>'duration')::int AS "duration",
-match.data->'data'->'attributes'->>'gameMode' AS "gameMode",
-COALESCE(NULLIF(match.data->'data'->'attributes'->>'patchVersion', ''), '0') AS "patchVersion",
-match.data->'data'->'attributes'->>'shardId' AS "shardId",
-match.data->'data'->'attributes'->'stats'->>'endGameReason' AS "endGameReason",
+match.data->'data'->'attributes'->>'gameMode' AS "game_mode",
+COALESCE(NULLIF(match.data->'data'->'attributes'->>'patch_version', '2.2'), '0') AS "patch_version",
+match.data->'data'->'attributes'->>'shardId' AS "shard_id",
+match.data->'data'->'attributes'->'stats'->>'endGameReason' AS "end_game_reason",
 match.data->'data'->'attributes'->'stats'->>'queue' AS "queue",
 
 match.data->'relations'->0->'data'->>'id' as "roster_1",
diff --git a/queries/participant.sql b/queries/participant.sql
index d4490e9..a65bdde 100644
--- a/queries/participant.sql
+++ b/queries/participant.sql
@@ -7,31 +7,31 @@ participants AS (SELECT
 FROM rosters)
 SELECT
 
-participant->'data'->>'id' AS "apiId",
-rosterid AS "roster_apiId",
-participant->'relations'->0->'data'->>'id' AS "player_apiId",
+participant->'data'->>'id' AS "api_id",
+rosterid AS "roster_api_id",
+participant->'relations'->0->'data'->>'id' AS "player_api_id",
 
 participant->'data'->'attributes'->>'actor' AS "hero",
 (participant->'data'->'attributes'->'stats'->>'assists')::int AS "assists",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'crystalMineCaptures', ''), '0')::int AS "crystalMineCaptures",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'crystalMineCaptures', ''), '0')::int AS "crystal_mine_captures",
 (participant->'data'->'attributes'->'stats'->>'deaths')::int AS "deaths",
 (participant->'data'->'attributes'->'stats'->>'farm')::float AS "farm",
-(participant->'data'->'attributes'->'stats'->>'firstAfkTime')::float AS "firstAfkTime",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'goldMineCaptures', ''), '0')::int AS "goldMineCaptures",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'jungleKills', ''), '0')::int AS "jungleKills",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'karmaLevel', ''), '0')::int AS "karmaLevel",
+(participant->'data'->'attributes'->'stats'->>'firstAfkTime')::float AS "first_afk_time",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'goldMineCaptures', ''), '0')::int AS "gold_mine_captures",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'jungleKills', ''), '0')::int AS "jungle_kills",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'karmaLevel', ''), '0')::int AS "karma_level",
 COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'kills', ''), '0')::int AS "kills",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'krakenCaptures', ''), '0')::int AS "krakenCaptures",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'krakenCaptures', ''), '0')::int AS "kraken_captures",
 COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'level', ''), '0')::int AS "level",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'minionKills', ''), '0')::int AS "minionKills",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'skillTier', ''), '0')::int AS "skillTier",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'skinKey', ''), '0') AS "skinKey",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'turretKills', ''), '0')::int AS "turretKills",
-(participant->'data'->'attributes'->'stats'->>'wentAfk')::bool AS "wentAfk",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'minionKills', ''), '0')::int AS "minion_kills",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'skillTier', ''), '0')::int AS "skill_tier",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'skinKey', ''), '0') AS "skin_key",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'turretKills', ''), '0')::int AS "turret_kills",
+(participant->'data'->'attributes'->'stats'->>'wentAfk')::bool AS "went_afk",
 (participant->'data'->'attributes'->'stats'->>'winner')::bool AS "winner",
-participant->'data'->'attributes'->'stats'->'itemGrants' AS "itemGrants",
-participant->'data'->'attributes'->'stats'->'itemSells' AS "itemSells",
-participant->'data'->'attributes'->'stats'->'itemUses' AS "itemUses",
+participant->'data'->'attributes'->'stats'->'itemGrants' AS "item_grants",
+participant->'data'->'attributes'->'stats'->'itemSells' AS "item_sells",
+participant->'data'->'attributes'->'stats'->'itemUses' AS "item_uses",
 participant->'data'->'attributes'->'stats'->'items' AS "items"
 
 FROM participants
diff --git a/queries/player.sql b/queries/player.sql
index 0619ee6..585858d 100644
--- a/queries/player.sql
+++ b/queries/player.sql
@@ -1,5 +1,5 @@
 WITH rosters AS (SELECT
-  match.data->'data'->'attributes'->>'createdAt' AS matchdate,
+  match.data->'data'->'attributes'->>'created_at' AS matchdate,
   JSONB_ARRAY_ELEMENTS(match.data->'relations') AS roster
 FROM match WHERE id=$1),
 participants AS (SELECT
@@ -13,16 +13,16 @@ FROM participants)
 
 SELECT
 
-players.player->'data'->>'id' AS "apiId",
+players.player->'data'->>'id' AS "api_id",
 players.player->'data'->'attributes'->>'name' AS "name",
 (players.player->'data'->'attributes'->'stats'->>'level')::int AS "level",
 (players.player->'data'->'attributes'->'stats'->>'xp')::int AS "xp",
 (players.player->'data'->'attributes'->'stats'->>'played')::int AS "played",
-(players.player->'data'->'attributes'->'stats'->>'played_ranked')::int AS "playedRanked",
-(players.player->'data'->'attributes'->'stats'->>'played')::int - (players.player->'data'->'attributes'->'stats'->>'played_ranked')::int AS "playedCasual",
+(players.player->'data'->'attributes'->'stats'->>'played_ranked')::int AS "played_ranked",
+(players.player->'data'->'attributes'->'stats'->>'played')::int - (players.player->'data'->'attributes'->'stats'->>'played_ranked')::int AS "played_casual",
 (players.player->'data'->'attributes'->'stats'->>'wins')::int AS "wins",
-(players.player->'data'->'attributes'->'stats'->>'lifetimeGold')::float AS "lifetimeGold",
-CASE WHEN players.player->'data'->'attributes'->>'name'=$2 THEN matchdate ELSE 'epoch'::timestamp::text END AS "lastMatchCreatedDate",
+(players.player->'data'->'attributes'->'stats'->>'lifetimeGold')::float AS "lifetime_gold",
+CASE WHEN players.player->'data'->'attributes'->>'name'=$2 THEN matchdate ELSE 'epoch'::timestamp::text END AS "last_match_created_date",
 
 0 AS "streak"
 
diff --git a/queries/roster.sql b/queries/roster.sql
index 2344c7f..f6500fb 100644
--- a/queries/roster.sql
+++ b/queries/roster.sql
@@ -3,16 +3,16 @@ WITH rosters AS (SELECT
   JSONB_ARRAY_ELEMENTS(match.data->'relations') AS roster
 FROM match WHERE id=$1)
 SELECT
-roster->'data'->>'id' AS "apiId",
-matchid AS "match_apiId",
-(roster->'data'->'attributes'->'stats'->>'acesEarned')::int AS "acesEarned",
+roster->'data'->>'id' AS "api_id",
+matchid AS "match_api_id",
+(roster->'data'->'attributes'->'stats'->>'acesEarned')::int AS "aces_earned",
 (roster->'data'->'attributes'->'stats'->>'gold')::int AS "gold",
-(roster->'data'->'attributes'->'stats'->>'heroKills')::int AS "heroKills",
-(roster->'data'->'attributes'->'stats'->>'krakenCaptures')::int AS "krakenCaptures",
+(roster->'data'->'attributes'->'stats'->>'heroKills')::int AS "hero_kills",
+(roster->'data'->'attributes'->'stats'->>'krakenCaptures')::int AS "kraken_captures",
 roster->'data'->'attributes'->'stats'->>'side' AS "side",
-roster->'data'->'attributes'->'stats'->>'side' AS "teamColor",
-(roster->'data'->'attributes'->'stats'->>'turretKills')::int AS "turretKills",
-(roster->'data'->'attributes'->'stats'->>'turretsRemaining')::int AS "turretsRemaining",
+roster->'data'->'attributes'->'stats'->>'side' AS "team_color",
+(roster->'data'->'attributes'->'stats'->>'turretKills')::int AS "turret_kills",
+(roster->'data'->'attributes'->'stats'->>'turretsRemaining')::int AS "turrets_remaining",
 
 roster->'relations'->0->'data'->>'id' AS "participant_1",
 roster->'relations'->1->'data'->>'id' AS "participant_2",