sharded.txt

Custom Scan (Citus Adaptive)  (cost=0.00..0.00 rows=100000 width=16) (actual time=343.932..343.952 rows=267 loops=1)
  Output: remote_scan.id
  Task Count: 192
  Tuple data received from nodes: 4272 bytes
  Tasks Shown: One of 192
  ->  Task
"        Query: SELECT g.id FROM ((public.game_103983 g JOIN public.game_map_238328 gm ON ((gm.id OPERATOR(pg_catalog.=) g.game_map_id))) JOIN public.game_player_173679 gp ON ((gp.game_id OPERATOR(pg_catalog.=) g.id))) WHERE ((gp.s64_id OPERATOR(pg_catalog.=) '76561197969209908'::bigint) AND (gp.game_finished_at OPERATOR(pg_catalog.>=) '2019-06-18 11:11:22'::timestamp without time zone) AND (gp.game_finished_at OPERATOR(pg_catalog.<=) '2023-05-01 17:08:44'::timestamp without time zone) AND (g.status OPERATOR(pg_catalog.=) 'ready'::public.game_status_enum))"
        Tuple data received from node: 48 bytes
        Node: host=192.168.109.4 port=11338 dbname=leetify_sharded
        ->  Nested Loop  (cost=1.11..56.92 rows=10 width=16) (actual time=0.078..0.328 rows=3 loops=1)
              Output: g.id
              Inner Unique: true
              Buffers: shared hit=69
              ->  Nested Loop  (cost=0.84..53.73 rows=11 width=20) (actual time=0.069..0.313 rows=3 loops=1)
                    Output: g.id, g.game_map_id
                    Inner Unique: true
                    Buffers: shared hit=59
                    ->  Append  (cost=0.42..22.02 rows=12 width=16) (actual time=0.027..0.148 rows=10 loops=1)
                          Buffers: shared hit=26
                          ->  Index Scan using game_player_m_p_2023_01_s64_id_idx_173871 on public.game_player_m_p_2023_01_173871 gp_1  (cost=0.42..2.64 rows=1 width=16) (actual time=0.026..0.027 rows=1 loops=1)
                                Output: gp_1.game_id
"                                Index Cond: (gp_1.s64_id = '76561197969209908'::bigint)"
"                                Filter: ((gp_1.game_finished_at >= '2019-06-18 11:11:22'::timestamp without time zone) AND (gp_1.game_finished_at <= '2023-05-01 17:08:44'::timestamp without time zone))"
                                Buffers: shared hit=4
                          ->  Index Scan using game_player_m_p_2023_02_s64_id_idx_174063 on public.game_player_m_p_2023_02_174063 gp_2  (cost=0.42..2.64 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=1)
                                Output: gp_2.game_id
"                                Index Cond: (gp_2.s64_id = '76561197969209908'::bigint)"
"                                Filter: ((gp_2.game_finished_at >= '2019-06-18 11:11:22'::timestamp without time zone) AND (gp_2.game_finished_at <= '2023-05-01 17:08:44'::timestamp without time zone))"
                                Buffers: shared hit=3
                          ->  Index Scan using game_player_m_p_2023_03_s64_id_idx_174255 on public.game_player_m_p_2023_03_174255 gp_3  (cost=0.42..2.64 rows=1 width=16) (actual time=0.024..0.024 rows=1 loops=1)
                                Output: gp_3.game_id
"                                Index Cond: (gp_3.s64_id = '76561197969209908'::bigint)"
"                                Filter: ((gp_3.game_finished_at >= '2019-06-18 11:11:22'::timestamp without time zone) AND (gp_3.game_finished_at <= '2023-05-01 17:08:44'::timestamp without time zone))"
                                Buffers: shared hit=4
                          ->  Index Scan using game_player_m_p_2023_04_s64_id_idx_174447 on public.game_player_m_p_2023_04_174447 gp_4  (cost=0.42..2.64 rows=1 width=16) (actual time=0.020..0.020 rows=0 loops=1)
                                Output: gp_4.game_id
"                                Index Cond: (gp_4.s64_id = '76561197969209908'::bigint)"
"                                Filter: ((gp_4.game_finished_at >= '2019-06-18 11:11:22'::timestamp without time zone) AND (gp_4.game_finished_at <= '2023-05-01 17:08:44'::timestamp without time zone))"
                                Buffers: shared hit=3
                          ->  Bitmap Heap Scan on public.game_player_m_p_2023_05_174639 gp_5  (cost=1.43..8.88 rows=7 width=16) (actual time=0.012..0.046 rows=7 loops=1)
                                Output: gp_5.game_id
"                                Recheck Cond: (gp_5.s64_id = '76561197969209908'::bigint)"
"                                Filter: ((gp_5.game_finished_at >= '2019-06-18 11:11:22'::timestamp without time zone) AND (gp_5.game_finished_at <= '2023-05-01 17:08:44'::timestamp without time zone))"
                                Heap Blocks: exact=7
                                Buffers: shared hit=9
                                ->  Bitmap Index Scan on game_player_m_p_2023_05_s64_id_idx_174639  (cost=0.00..1.43 rows=7 width=0) (actual time=0.008..0.009 rows=7 loops=1)
"                                      Index Cond: (gp_5.s64_id = '76561197969209908'::bigint)"
                                      Buffers: shared hit=2
                          ->  Index Scan using game_player_p_default_s64_id_idx_174831 on public.game_player_p_default_174831 gp_6  (cost=0.29..2.51 rows=1 width=16) (actual time=0.011..0.012 rows=1 loops=1)
                                Output: gp_6.game_id
"                                Index Cond: (gp_6.s64_id = '76561197969209908'::bigint)"
"                                Filter: ((gp_6.game_finished_at >= '2019-06-18 11:11:22'::timestamp without time zone) AND (gp_6.game_finished_at <= '2023-05-01 17:08:44'::timestamp without time zone))"
                                Buffers: shared hit=3
"                    ->  Index Scan using ""PK_352a30652cd352f552fef73dec5_103983"" on public.game_103983 g  (cost=0.42..2.64 rows=1 width=20) (actual time=0.016..0.016 rows=0 loops=10)"
                          Output: g.id, g.data_source, g.replay_url, g.team_scores, g.finished_at, g.status, g.retries, g.next_retry_at, g.error_code, g.recalculate, g.created_at, g.game_map_id
                          Index Cond: (g.id = gp.game_id)
"                          Filter: (g.status = 'ready'::game_status_enum)"
                          Buffers: shared hit=33
"              ->  Index Only Scan using ""PK_15dca7a4369ac466eea4cbacd2b_238328"" on public.game_map_238328 gm  (cost=0.27..0.29 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=3)"
                    Output: gm.id
                    Index Cond: (gm.id = g.game_map_id)
                    Heap Fetches: 3
                    Buffers: shared hit=10
            Planning Time: 4.991 ms
            Execution Time: 0.435 ms
  Buffers: shared hit=18
Query Identifier: 1200474522180730015
Planning:
  Buffers: shared hit=13
Planning Time: 14.449 ms
Execution Time: 343.995 ms