diff options
| -rw-r--r-- | api.py | 10 | ||||
| -rw-r--r-- | logs/processor.log | 445 | ||||
| -rw-r--r-- | queries/match.sql | 12 | ||||
| -rw-r--r-- | queries/participant.sql | 34 | ||||
| -rw-r--r-- | queries/player.sql | 12 | ||||
| -rw-r--r-- | queries/roster.sql | 16 |
6 files changed, 344 insertions, 185 deletions
@@ -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", |