Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qlsnr-004j0c-Pe for pgsql-general@arkaria.postgresql.org; Thu, 28 Sep 2023 15:19:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qlsnq-00E2lz-32 for pgsql-general@arkaria.postgresql.org; Thu, 28 Sep 2023 15:19:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qlsnp-00E2lK-9t for pgsql-general@lists.postgresql.org; Thu, 28 Sep 2023 15:19:45 +0000 Received: from mail-ej1-x62a.google.com ([2a00:1450:4864:20::62a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qlsni-0087DV-Oy for pgsql-general@lists.postgresql.org; Thu, 28 Sep 2023 15:19:44 +0000 Received: by mail-ej1-x62a.google.com with SMTP id a640c23a62f3a-9a65f9147ccso1669968966b.1 for ; Thu, 28 Sep 2023 08:19:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1695914377; x=1696519177; darn=lists.postgresql.org; h=thread-index:content-language:mime-version:message-id:date:subject :in-reply-to:references:cc:to:from:from:to:cc:subject:date :message-id:reply-to; bh=SJNXHQIxM9ghFRkSKTE0E0i7C4O0Nqe5mG6+IqiDu0k=; b=RaQ3ZVjNHc3/UhE/oYtWXSZgcGqXDx3Yqc6OClBbq9Wr/e1sviXlUjxSFvdYJX6Rqq wqkXNQliqPHrbWp4k6yWNGiMrV4CX2fKKXRzNRtMLMeEZ0O72YN7S0q0hnWZYMvcnOSg uNEm8nT/FhXuHrU23tYub45ExSo6LHLF7/+OtXabaj9NOssnDFGYB8qwIPCrpGZmJ23B haBj0DNLG2uceJCgVXjKiFulkfOOTdYg0FqkK9waA1AZ9JKE+ZD1ONBr44gj5fVxvILd TRy9NJQErFdIU5DipPMS8ADHC/ia91aPca9oJDcQ5/Ovc3bxDK2vD3dnchzS5JrWZZwb 5Gyg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1695914377; x=1696519177; h=thread-index:content-language:mime-version:message-id:date:subject :in-reply-to:references:cc:to:from:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=SJNXHQIxM9ghFRkSKTE0E0i7C4O0Nqe5mG6+IqiDu0k=; b=L+b1TOx4MFW9YQpfYf+O27eWXCMcZFbJj3JdHi77ab7kWQXZ/aAGbHlQ0DM64mWDul 7TzXIoTcJ87rOGGMNGCyZ2B7Lb5tIsGl0Z5Zz4K8Pi++61cQJofpWxO4V5nVp8lXOlQd U3k5yZ7OWwijP/sxhfAGFxdmBaCc6DTEW0iVYm/kS3YcMOVFNmgESHHsoNJupLY2hxYq Wg+bbRAayhZtiSgcNtNlq2XFykXUD+dHsuBXB1ddUDG4NlaTCTkKCEHsQKKVoBZV2uzD peyTt/WAunUDPsIY+jdyHq1/EtPkdKAX++T8AKOjlgHpaVhxh3ffLAfwhXiQDACWfJ2+ JQkg== X-Gm-Message-State: AOJu0Yy3tCiImfI3ovLVFoOM1q0FcsPjBN4CkYksG7wZGjVVmzA5ECon q7WXtPg5Gp+xeimXE1AwBCA/8V1dOp17Kg== X-Google-Smtp-Source: AGHT+IFFRmaBTx5FSOo/ckP6QmVUc9DrlkzuMUP3XP/hsXmhZhvRsj4xQd4OaioKH8Q1R80CzM5hkQ== X-Received: by 2002:a17:906:220f:b0:9b2:c583:cd71 with SMTP id s15-20020a170906220f00b009b2c583cd71mr1327223ejs.50.1695914376537; Thu, 28 Sep 2023 08:19:36 -0700 (PDT) Received: from MONSTER ([91.93.224.198]) by smtp.gmail.com with ESMTPSA id bv13-20020a170906b1cd00b00993a37aebc5sm11067797ejb.50.2023.09.28.08.19.34 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 28 Sep 2023 08:19:36 -0700 (PDT) From: =?UTF-8?Q?Mehmet_=C3=87ako=C4=9Flu?= To: "'Dirschel, Steve'" , "'PostgreSQL General'" Cc: "'Wong, Kam Fook \(TR Technology\)'" References: In-Reply-To: Subject: YNT: Need help tuning a query Date: Thu, 28 Sep 2023 18:19:34 +0300 Message-ID: <07fc01d9f21f$30e48190$92ad84b0$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_07FD_01D9F238.56732F60" X-Mailer: Microsoft Outlook 16.0 Content-Language: tr Thread-Index: AQGILixWQmWimwZSJoFJ9udJII1f1QGJPIY+sMeX/sA= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_07FD_01D9F238.56732F60 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Could you send the the table=E2=80=99s Index scripts? =20 Kimden: Dirschel, Steve =20 Tarih: 27 Eyl=C3=BCl 2023 =C3=87ar=C5=9Famba 20:45 Kime: PostgreSQL General Bilgi: Wong, Kam Fook (TR Technology) Konu: Need help tuning a query =20 We are migrating from Oracle to Postgres. I have a ugly query that = performs great in Oracle- it does 5259 logical reads and completes in < = 1 second. In Postgres it=E2=80=99s taking 35+ seconds. I can see 2 = parts in the plan that are the problem with Postgres but I=E2=80=99m not = sure how to change the query to optimize optimally. I believe the query = is generated based on user selection criteria so I can=E2=80=99t really = hint the query because there can be a lot of variations of it (nor do I = see a push_subq type of hint in pg_hint_plan). The query is long and = ugly, the plan is long and ugly in Postgres. The query is below. The = problem is in 2 spots: =20 1. Inline view sub4. There is no WHERE clause so it=E2=80=99s full = scanning table JRT_FACT. Inline view sub4 is inside inline view sub1. = The join to sub1 is on sub1.judge_id. Sub1.judge_id comes from jrt_fact = jrt1. Higher_judge_id. There is an index on that column. If you look = at the Oracle plan it=E2=80=99s using a PUSHED PREDICATE operation where = it=E2=80=99s pushing the join on sub1.judge_id =3D sub0.judge_id into = sub4. That is the optimal way to access jrt_fact in that part of the = query. 2. Inline view sub5. There is filtering in the WHERE clause- where = lower_judge_court_level_id > 1000 and lower_judge_court_level_id <=3D = 1004 but that filtering alone is not very good. It=E2=80=99s a similar = problem as sub4- in this case sub2 has sub4 in it and the join to sub2 = is on judge_id. That judge_id is coming from jrt_fact = jrtf2.lower_judge_id. That column is indexed. Oracle will use a PUSHED = PREDICATE when accessing jrtf2 which is the optimal way to access that = part of the query. 3. When it accesses table judge judg1 it is full scanning that table = even though there is an index on wld_id. It only does 3445 shared = buffer hits so that is not the main reason the query is slow but I = don=E2=80=99t see why it won=E2=80=99t use the index when accessing that = table. =20 Any ideas on how I can change this query to optimize as Oracle is doing? = Thanks in advance. =20 Steve =20 QUERY: =20 SELECT agg_sub.judge_id, agg_sub.display_name, agg_sub.active_flag, agg_sub.judge_court_level, agg_sub.jrt_fact_first_year_trial, agg_sub.jrt_fact_last_year_trial, agg_sub.jrt_fact_totalcount_trial, agg_sub.filtered_first_year_trial, agg_sub.filtered_last_year_trial, agg_sub.jrt_fact_count_trial, agg_sub.jrt_fact_first_year_appeal, agg_sub.jrt_fact_last_year_appeal, agg_sub.jrt_fact_totalcount_appeal, agg_sub.filtered_first_year_appeal, agg_sub.filtered_last_year_appeal, agg_sub.jrt_fact_count_appeal, appellate_flag_sub.appellate_flag FROM (SELECT sub3.judge_id, sub3.display_name, sub3.active_flag, sub3.judge_court_level, (MIN(sub3.trial_unfilt_case_year_number)) AS = jrt_fact_first_year_trial, (MAX(sub3.trial_unfilt_case_year_number)) AS = jrt_fact_last_year_trial, (SUM(sub3.trial_unfilt_subcount)) AS = jrt_fact_totalcount_trial, (MIN(sub3.trial_filt_case_year_number)) AS = filtered_first_year_trial, (MAX(sub3.trial_filt_case_year_number)) AS = filtered_last_year_trial, (SUM(sub3.trial_filt_subcount)) AS jrt_fact_count_trial, (MIN(sub3.appeal_unfilt_case_year_number)) AS = jrt_fact_first_year_appeal, (MAX(sub3.appeal_unfilt_case_year_number)) AS = jrt_fact_last_year_appeal, (SUM(sub3.appeal_unfilt_subcount)) AS = jrt_fact_totalcount_appeal, (MIN(sub3.appeal_filt_case_year_number)) AS = filtered_first_year_appeal, (MAX(sub3.appeal_filt_case_year_number)) AS = filtered_last_year_appeal, (SUM(sub3.appeal_filt_subcount)) AS jrt_fact_count_appeal FROM (SELECT sub0.judge_id, sub0.display_name, sub0.active_flag, sub0.judge_court_level, (CASE WHEN sub2.grouping_flg =3D 'T' AND = sub2.judge_wld_id =3D sub0.judge_wld_id THEN sub2.case_year_number ELSE = NULL END) AS trial_unfilt_case_year_number, (CASE WHEN sub2.grouping_flg =3D 'T'AND = sub2.judge_wld_id =3D sub0.judge_wld_id THEN sub2.subcount ELSE NULL END = ) AS trial_unfilt_subcount, (CASE WHEN sub2.grouping_flg =3D 'T' AND = sub2.judge_wld_id =3D sub0.judge_wld_id THEN (CASE WHEN = sub2.case_year_number BETWEEN sub0.low_case_year_number AND = sub0.high_case_year_number=20 THEN sub2.case_year_number ELSE NULL END) = ELSE NULL END) AS trial_filt_case_year_number, (CASE WHEN sub2.grouping_flg =3D 'T' AND = sub2.judge_wld_id =3D sub0.judge_wld_id THEN (CASE WHEN = sub2.case_year_number BETWEEN sub0.low_case_year_number AND = sub0.high_case_year_number=20 THEN sub2.subcount ELSE NULL END ) ELSE = NULL END ) AS trial_filt_subcount, (CASE WHEN sub1.grouping_flg =3D 'A'AND = sub1.judge_wld_id =3D sub0.judge_wld_id THEN sub1.case_year_number WHEN = sub2.grouping_flg =3D 'A' AND sub2.judge_wld_id =3D sub0.judge_wld_id=20 THEN sub2.case_year_number ELSE NULL END = ) AS appeal_unfilt_case_year_number, ( CASE WHEN sub1.grouping_flg =3D 'A' AND sub1.judge_wld_id =3D sub0.judge_wld_id THEN = sub1.subcount WHEN sub2.grouping_flg =3D 'A' AND sub2.judge_wld_id =3D sub0.judge_wld_id THEN = sub2.subcount ELSE NULL END ) AS appeal_unfilt_subcount, ( CASE WHEN sub1.grouping_flg =3D 'A' AND sub1.judge_wld_id =3D sub0.judge_wld_id THEN ( CASE WHEN sub1.case_year_number BETWEEN = sub0.low_case_year_number AND sub0.high_case_year_number THEN = sub1.case_year_number ELSE NULL END ) WHEN sub2.grouping_flg =3D 'A' AND sub2.judge_wld_id =3D sub0.judge_wld_id THEN ( CASE WHEN sub2.case_year_number BETWEEN = sub0.low_case_year_number AND sub0.high_case_year_number THEN = sub2.case_year_number ELSE NULL END ) ELSE NULL END ) AS appeal_filt_case_year_number, ( CASE WHEN sub1.grouping_flg =3D 'A' AND sub1.judge_wld_id =3D sub0.judge_wld_id THEN ( CASE WHEN sub1.case_year_number BETWEEN = sub0.low_case_year_number AND sub0.high_case_year_number THEN = sub1.subcount ELSE NULL END ) WHEN sub2.grouping_flg =3D 'A' AND sub2.judge_wld_id =3D sub0.judge_wld_id THEN ( CASE WHEN sub2.case_year_number BETWEEN = sub0.low_case_year_number AND sub0.high_case_year_number THEN = sub2.subcount ELSE NULL END ) ELSE NULL END ) AS appeal_filt_subcount FROM ( SELECT 0104119201 AS judge_wld_id, 2013 AS low_case_year_number, 2023 AS high_case_year_number, judg1.judge_id, judg1.display_name, judg1.active_flag, judg1.judge_court_level FROM wln_mart.judge judg1 WHERE judg1.wld_id =3D 01041192 AND judg1.profile_id =3D 01 AND (judg1.jrt_opt_out_flag <> 'Y' OR = judg1.jrt_opt_out_flag IS NULL) ) sub0=20 LEFT OUTER JOIN ( SELECT sub4.case_year_number, sub4.judge_wld_id, sub4.judge_id, sub4.grouping_flg, COUNT(*) AS subcount FROM (SELECT jrtf1.case_year_number, jrtf1.higher_judge_wld_id AS = judge_wld_id, jrtf1.higher_judge_id AS judge_id, 'A' AS grouping_flg, jrtf1.case_document_id AS subcount FROM wln_mart.jrt_fact jrtf1 GROUP BY jrtf1.case_year_number, jrtf1.higher_judge_wld_id, jrtf1.higher_judge_id, jrtf1.case_document_id ) sub4 GROUP BY sub4.case_year_number, sub4.judge_wld_id, sub4.judge_id, sub4.grouping_flg ) sub1=20 ON sub1.judge_id =3D sub0.judge_id=20 LEFT OUTER JOIN (SELECT sub5.case_year_number, sub5.judge_wld_id, sub5.judge_id, sub5.grouping_flg, COUNT(*) AS subcount FROM (SELECT jrtf2.case_year_number, jrtf2.lower_judge_wld_id AS judge_wld_id, jrtf2.lower_judge_id AS judge_id, ( CASE WHEN = jrtf2.lower_judge_court_level_id =3D 1004 THEN 'T' ELSE 'A' END ) AS grouping_flg, jrtf2.case_document_id AS subcount FROM wln_mart.jrt_fact jrtf2 WHERE jrtf2.lower_judge_court_level_id > 1000 AND jrtf2.lower_judge_court_level_id <=3D = 1004 GROUP BY jrtf2.case_year_number, = jrtf2.lower_judge_wld_id, jrtf2.lower_judge_id, ( CASE WHEN = jrtf2.lower_judge_court_level_id =3D 1004 THEN 'T' ELSE 'A' END ), jrtf2.case_document_id ) sub5 GROUP BY sub5.case_year_number, sub5.judge_wld_id, sub5.judge_id, sub5.grouping_flg ) sub2 ON sub2.judge_id =3D sub0.judge_id ) sub3 GROUP BY sub3.judge_id, sub3.display_name, sub3.active_flag, sub3.judge_court_level ) agg_sub, (SELECT judge_id, (CASE WHEN (SUM (appellate_flag) < (COUNT(*) / 2)) THEN 0 ELSE 1 = END ) AS appellate_flag FROM (SELECT DISTINCT jrtf.case_year_number, jrtf.case_document_id, jrtf.lower_judge_id, jrtf.higher_judge_id, ( CASE WHEN ( lower_judge_wld_id =3D 0104119201 AND lower_judge_court_level_id =3D 1004 ) THEN 0 ELSE 1 END ) AS appellate_flag, ( CASE WHEN lower_judge_wld_id =3D 0104119201 THEN = lower_judge_id ELSE higher_judge_id END ) AS judge_id FROM wln_mart.JRT_FACT jrtf WHERE LOWER_JUDGE_WLD_ID =3D 0104119201 OR HIGHER_JUDGE_WLD_ID =3D 0104119201 ORDER BY case_year_number DESC ) sub0 GROUP BY judge_id LIMIT 11 ) appellate_flag_sub WHERE Agg_sub.judge_id =3D appellate_flag_sub.judge_id =20 =20 Postgres execution plan (again very ugly and somewhat difficult to = read): =20 Nested Loop (cost=3D3465035.45..4564601.26 rows=3D1 width=3D345) = (actual time=3D35125.205..35125.631 rows=3D1 loops=3D1) Join Filter: (judg1.judge_id =3D (CASE WHEN (jrtf.lower_judge_wld_id = =3D '104119201'::numeric) THEN jrtf.lower_judge_id ELSE = jrtf.higher_judge_id END)) Buffers: shared hit=3D734231, temp read=3D340089 written=3D629776 -> GroupAggregate (cost=3D3423317.32..4522882.70 rows=3D1 = width=3D341) (actual time=3D35117.620..35117.989 rows=3D1 loops=3D1) Group Key: judg1.judge_id Buffers: shared hit=3D732655, temp read=3D340089 = written=3D629776 -> Nested Loop Left Join (cost=3D3423317.32..4522882.01 = rows=3D4 width=3D261) (actual time=3D30839.132..35117.682 rows=3D39 = loops=3D1) Join Filter: (sub2.judge_id =3D judg1.judge_id) Rows Removed by Join Filter: 858300 Buffers: shared hit=3D732655, temp read=3D340089 = written=3D629776 -> Nested Loop Left Join (cost=3D1504656.29..2084303.10 = rows=3D2 width=3D205) (actual time=3D19156.871..21775.159 rows=3D3 = loops=3D1) Join Filter: (sub4.judge_id =3D judg1.judge_id) Rows Removed by Join Filter: 55263 Buffers: shared hit=3D368082, temp read=3D183477 = written=3D318607 -> Gather Merge (cost=3D5103.64..5103.76 rows=3D1 = width=3D149) (actual time=3D12.582..12.688 rows=3D1 loops=3D1) Workers Planned: 2 Workers Launched: 2 Buffers: shared hit=3D3525 -> Sort (cost=3D4103.62..4103.62 rows=3D1 = width=3D149) (actual time=3D7.197..7.198 rows=3D0 loops=3D3) Sort Key: judg1.judge_id Sort Method: quicksort Memory: 25kB Buffers: shared hit=3D3525 Worker 0: Sort Method: quicksort = Memory: 25kB Worker 1: Sort Method: quicksort = Memory: 25kB -> Parallel Seq Scan on judge judg1 = (cost=3D0.00..4103.61 rows=3D1 width=3D149) (actual time=3D3.680..7.123 = rows=3D0 loops=3D3) Filter: (((jrt_opt_out_flag <> = 'Y'::bpchar) OR (jrt_opt_out_flag IS NULL)) AND (wld_id =3D 1041192) AND = (profile_id =3D 1)) Rows Removed by Filter: 30107 Buffers: shared hit=3D3445 -> GroupAggregate (cost=3D1499552.65..2075175.87 = rows=3D178821 width=3D64) (actual time=3D16338.330..21757.982 = rows=3D55266 loops=3D1) Group Key: sub4.case_year_number, = sub4.judge_wld_id, sub4.judge_id, sub4.grouping_flg Buffers: shared hit=3D364557, temp = read=3D183477 written=3D318607 -> Incremental Sort = (cost=3D1499552.65..2051035.07 rows=3D1788207 width=3D56) (actual = time=3D16338.158..20599.168 rows=3D4241689 loops=3D1) Sort Key: sub4.case_year_number, = sub4.judge_wld_id, sub4.judge_id, sub4.grouping_flg Presorted Key: sub4.case_year_number, = sub4.judge_wld_id, sub4.judge_id Full-sort Groups: 27027 Sort Method: = quicksort Average Memory: 30kB Peak Memory: 30kB Pre-sorted Groups: 35815 Sort Method: = quicksort Average Memory: 367kB Peak Memory: 580kB Buffers: shared hit=3D364557, temp = read=3D183477 written=3D318607 -> Subquery Scan on sub4 = (cost=3D1499549.72..1970473.37 rows=3D1788207 width=3D56) (actual = time=3D16337.913..18343.845 rows=3D4241689 loops=3D1) Buffers: shared hit=3D364557, = temp read=3D183477 written=3D318607 -> Group = (cost=3D1499549.72..1952591.30 rows=3D1788207 width=3D64) (actual = time=3D16337.912..17955.054 rows=3D4241689 loops=3D1) Group Key: = jrtf1.case_year_number, jrtf1.higher_judge_wld_id, = jrtf1.higher_judge_id, jrtf1.case_document_id Buffers: shared = hit=3D364557, temp read=3D183477 written=3D318607 -> Gather Merge = (cost=3D1499549.72..1916827.16 rows=3D3576414 width=3D32) (actual = time=3D16337.908..17161.246 rows=3D4281068 loops=3D1) Workers Planned: 2 Workers Launched: 2 Buffers: shared = hit=3D364557, temp read=3D183477 written=3D318607 -> Sort = (cost=3D1498549.70..1503020.22 rows=3D1788207 width=3D32) (actual = time=3D15566.878..16546.347 rows=3D1427023 loops=3D3) Sort Key: = jrtf1.case_year_number, jrtf1.higher_judge_wld_id, = jrtf1.higher_judge_id, jrtf1.case_document_id Sort Method: = external sort Disk: 84832kB Buffers: shared = hit=3D364557, temp read=3D183477 written=3D318607 Worker 0: Sort = Method: external merge Disk: 66904kB Worker 1: Sort = Method: external merge Disk: 63288kB -> Partial = HashAggregate (cost=3D1107519.33..1227268.67 rows=3D1788207 width=3D32) = (actual time=3D5553.846..8719.426 rows=3D1427023 loops=3D3) Group = Key: jrtf1.case_year_number, jrtf1.higher_judge_wld_id, = jrtf1.higher_judge_id, jrtf1.case_document_id Planned = Partitions: 64 Batches: 65 Memory Usage: 4129kB Disk Usage: 389200kB Buffers: = shared hit=3D364511, temp read=3D128224 written=3D263245 Worker 0: = Batches: 65 Memory Usage: 4385kB Disk Usage: 379912kB Worker 1: = Batches: 65 Memory Usage: 4129kB Disk Usage: 331784kB -> = Parallel Append (cost=3D0.00..476524.37 rows=3D7450863 width=3D32) = (actual time=3D0.005..1685.119 rows=3D5960690 loops=3D3) = Buffers: shared hit=3D364511 -> = Parallel Seq Scan on jrt_fact_jrt_data_2012 jrtf1_23 = (cost=3D0.00..23580.92 rows=3D400092 width=3D32) (actual = time=3D0.003..189.362 rows=3D960222 loops=3D1) = Buffers: shared hit=3D19580 -> = Parallel Seq Scan on jrt_fact_jrt_data_2011 jrtf1_22 = (cost=3D0.00..22933.88 rows=3D389088 width=3D32) (actual = time=3D0.003..182.503 rows=3D933812 loops=3D1) = Buffers: shared hit=3D19043 -> = Parallel Seq Scan on jrt_fact_jrt_data_2009 jrtf1_20 = (cost=3D0.00..22423.17 rows=3D380418 width=3D32) (actual = time=3D0.005..175.891 rows=3D913002 loops=3D1) = Buffers: shared hit=3D18619 -> = Parallel Seq Scan on jrt_fact_jrt_data_2010 jrtf1_21 = (cost=3D0.00..22416.58 rows=3D380358 width=3D32) (actual = time=3D0.005..178.698 rows=3D912858 loops=3D1) = Buffers: shared hit=3D18613 -> = Parallel Seq Scan on jrt_fact_jrt_data_2014 jrtf1_25 = (cost=3D0.00..22183.48 rows=3D376348 width=3D32) (actual = time=3D0.004..175.463 rows=3D903235 loops=3D1) = Buffers: shared hit=3D18420 -> = Parallel Seq Scan on jrt_fact_jrt_data_2013 jrtf1_24 = (cost=3D0.00..22162.62 rows=3D376062 width=3D32) (actual = time=3D0.003..176.993 rows=3D902548 loops=3D1) = Buffers: shared hit=3D18402 -> = Parallel Seq Scan on jrt_fact_jrt_data_2008 jrtf1_19 = (cost=3D0.00..21732.14 rows=3D368714 width=3D32) (actual = time=3D0.003..171.364 rows=3D884913 loops=3D1) = Buffers: shared hit=3D18045 -> = Parallel Seq Scan on jrt_fact_jrt_data_2016 jrtf1_27 = (cost=3D0.00..21579.48 rows=3D366148 width=3D32) (actual = time=3D0.004..172.011 rows=3D878756 loops=3D1) = Buffers: shared hit=3D17918 -> = Parallel Seq Scan on jrt_fact_jrt_data_2015 jrtf1_26 = (cost=3D0.00..20912.87 rows=3D354787 width=3D32) (actual = time=3D0.004..166.035 rows=3D851489 loops=3D1) = Buffers: shared hit=3D17365 -> = Parallel Seq Scan on jrt_fact_jrt_data_2020 jrtf1_31 = (cost=3D0.00..20362.25 rows=3D345825 width=3D32) (actual = time=3D0.004..163.649 rows=3D829980 loops=3D1) = Buffers: shared hit=3D16904 -> = Parallel Seq Scan on jrt_fact_jrt_data_2018 jrtf1_29 = (cost=3D0.00..19945.36 rows=3D338736 width=3D32) (actual = time=3D0.006..158.181 rows=3D812966 loops=3D1) = Buffers: shared hit=3D16558 -> = Parallel Seq Scan on jrt_fact_jrt_data_2017 jrtf1_28 = (cost=3D0.00..19603.33 rows=3D332833 width=3D32) (actual = time=3D0.004..148.015 rows=3D798799 loops=3D1) = Buffers: shared hit=3D16275 -> = Parallel Seq Scan on jrt_fact_jrt_data_2007 jrtf1_18 = (cost=3D0.00..19034.05 rows=3D322905 width=3D32) (actual = time=3D0.004..50.705 rows=3D258324 loops=3D3) = Buffers: shared hit=3D15805 -> = Parallel Seq Scan on jrt_fact_jrt_data_2021 jrtf1_32 = (cost=3D0.00..18341.26 rows=3D311526 width=3D32) (actual = time=3D0.012..75.774 rows=3D373832 loops=3D2) = Buffers: shared hit=3D15226 -> = Parallel Seq Scan on jrt_fact_jrt_data_2006 jrtf1_17 = (cost=3D0.00..18268.52 rows=3D309952 width=3D32) (actual = time=3D0.003..147.744 rows=3D743884 loops=3D1) = Buffers: shared hit=3D15169 -> = Parallel Seq Scan on jrt_fact_jrt_data_2005 jrtf1_16 = (cost=3D0.00..17316.05 rows=3D293805 width=3D32) (actual = time=3D0.003..140.591 rows=3D705132 loops=3D1) = Buffers: shared hit=3D14378 -> = Parallel Seq Scan on jrt_fact_jrt_data_2019 jrtf1_30 = (cost=3D0.00..17285.60 rows=3D293560 width=3D32) (actual = time=3D0.003..139.968 rows=3D704543 loops=3D1) = Buffers: shared hit=3D14350 -> = Parallel Seq Scan on jrt_fact_jrt_data_2022 jrtf1_33 = (cost=3D0.00..16051.71 rows=3D272771 width=3D32) (actual = time=3D0.003..131.590 rows=3D654650 loops=3D1) = Buffers: shared hit=3D13324 -> = Parallel Seq Scan on jrt_fact_jrt_data_2004 jrtf1_15 = (cost=3D0.00..15976.81 rows=3D271081 width=3D32) (actual = time=3D0.004..128.956 rows=3D650595 loops=3D1) = Buffers: shared hit=3D13266 -> = Parallel Seq Scan on jrt_fact_jrt_data_2003 jrtf1_14 = (cost=3D0.00..15556.01 rows=3D264001 width=3D32) (actual = time=3D0.003..124.530 rows=3D633603 loops=3D1) = Buffers: shared hit=3D12916 -> = Parallel Seq Scan on jrt_fact_jrt_data_2002 jrtf1_13 = (cost=3D0.00..14649.39 rows=3D248639 width=3D32) (actual = time=3D0.003..120.979 rows=3D596733 loops=3D1) = Buffers: shared hit=3D12163 -> = Parallel Seq Scan on jrt_fact_jrt_data_2001 jrtf1_12 = (cost=3D0.00..12176.08 rows=3D206708 width=3D32) (actual = time=3D0.004..96.162 rows=3D496100 loops=3D1) = Buffers: shared hit=3D10109 -> = Parallel Seq Scan on jrt_fact_jrt_data_2000 jrtf1_11 = (cost=3D0.00..10938.86 rows=3D185686 width=3D32) (actual = time=3D0.004..87.876 rows=3D445646 loops=3D1) = Buffers: shared hit=3D9082 -> = Parallel Seq Scan on jrt_fact_jrt_data_2023 jrtf1_34 = (cost=3D0.00..3574.86 rows=3D80086 width=3D32) (actual = time=3D0.002..27.656 rows=3D136147 loops=3D1) = Buffers: shared hit=3D2774 -> = Parallel Seq Scan on jrt_fact_jrt_data_1999 jrtf1_10 = (cost=3D0.00..182.73 rows=3D4073 width=3D32) (actual time=3D0.002..1.380 = rows=3D6924 loops=3D1) = Buffers: shared hit=3D142 -> = Parallel Seq Scan on jrt_fact_jrt_data_1990 jrtf1_1 (cost=3D0.00..42.31 = rows=3D931 width=3D33) (actual time=3D0.002..0.292 rows=3D1583 = loops=3D1) = Buffers: shared hit=3D33 -> = Parallel Seq Scan on jrt_fact_jrt_data_1998 jrtf1_9 (cost=3D0.00..23.00 = rows=3D500 width=3D33) (actual time=3D0.002..0.176 rows=3D850 loops=3D1) = Buffers: shared hit=3D18 -> = Parallel Seq Scan on jrt_fact_jrt_data_1997 jrtf1_8 (cost=3D0.00..6.20 = rows=3D120 width=3D32) (actual time=3D0.002..0.042 rows=3D204 loops=3D1) = Buffers: shared hit=3D5 -> = Parallel Seq Scan on jrt_fact_jrt_data_1995 jrtf1_6 (cost=3D0.00..3.77 = rows=3D77 width=3D33) (actual time=3D0.001..0.025 rows=3D131 loops=3D1) = Buffers: shared hit=3D3 -> = Parallel Seq Scan on jrt_fact_jrt_data_1996 jrtf1_7 (cost=3D0.00..2.40 = rows=3D40 width=3D33) (actual time=3D0.002..0.016 rows=3D68 loops=3D1) = Buffers: shared hit=3D2 -> = Parallel Seq Scan on jrt_fact_jrt_data_1992 jrtf1_3 (cost=3D0.00..1.12 = rows=3D12 width=3D33) (actual time=3D0.001..0.005 rows=3D20 loops=3D1) = Buffers: shared hit=3D1 -> = Parallel Seq Scan on jrt_fact_jrt_data_1994 jrtf1_5 (cost=3D0.00..1.12 = rows=3D12 width=3D33) (actual time=3D0.001..0.005 rows=3D20 loops=3D1) = Buffers: shared hit=3D1 -> = Parallel Seq Scan on jrt_fact_jrt_data_1991 jrtf1_2 (cost=3D0.00..1.11 = rows=3D11 width=3D33) (actual time=3D0.003..0.006 rows=3D19 loops=3D1) = Buffers: shared hit=3D1 -> = Parallel Seq Scan on jrt_fact_jrt_data_1993 jrtf1_4 (cost=3D0.00..1.01 = rows=3D1 width=3D31) (actual time=3D0.004..0.005 rows=3D1 loops=3D1) = Buffers: shared hit=3D1 -> Materialize (cost=3D1918661.03..2431740.34 = rows=3D178821 width=3D64) (actual time=3D3447.156..4418.543 = rows=3D286113 loops=3D3) Buffers: shared hit=3D364573, temp read=3D156612 = written=3D311169 -> Subquery Scan on sub2 = (cost=3D1918661.03..2428925.23 rows=3D178821 width=3D64) (actual = time=3D10341.437..13089.234 rows=3D286113 loops=3D1) Buffers: shared hit=3D364573, temp = read=3D153118 written=3D309422 -> GroupAggregate = (cost=3D1918661.03..2427137.02 rows=3D178821 width=3D64) (actual = time=3D10341.436..13057.326 rows=3D286113 loops=3D1) Group Key: jrtf2.case_year_number, = jrtf2.lower_judge_wld_id, jrtf2.lower_judge_id, (CASE WHEN = (jrtf2.lower_judge_court_level_id =3D 1004) THEN 'T'::text ELSE = 'A'::text END) Buffers: shared hit=3D364573, temp = read=3D153118 written=3D309422 -> Group = (cost=3D1918661.03..2385114.15 rows=3D1788207 width=3D64) (actual = time=3D10341.423..12590.803 rows=3D1610264 loops=3D1) Group Key: = jrtf2.case_year_number, jrtf2.lower_judge_wld_id, jrtf2.lower_judge_id, = (CASE WHEN (jrtf2.lower_judge_court_level_id =3D 1004) THEN 'T'::text = ELSE 'A'::text END), jrtf2.case_document_id Buffers: shared hit=3D364573, = temp read=3D153118 written=3D309422 -> Gather Merge = (cost=3D1918661.03..2335938.46 rows=3D3576414 width=3D64) (actual = time=3D10341.420..12232.748 rows=3D1623917 loops=3D1) Workers Planned: 2 Workers Launched: 2 Buffers: shared = hit=3D364573, temp read=3D153118 written=3D309422 -> Sort = (cost=3D1917661.00..1922131.52 rows=3D1788207 width=3D64) (actual = time=3D10205.573..10833.131 rows=3D541306 loops=3D3) Sort Key: = jrtf2.case_year_number, jrtf2.lower_judge_wld_id, jrtf2.lower_judge_id, = (CASE WHEN (jrtf2.lower_judge_court_level_id =3D 1004) THEN 'T'::text = ELSE 'A'::text END), jrtf2.case_document_id Sort Method: external = merge Disk: 32608kB Buffers: shared = hit=3D364573, temp read=3D153118 written=3D309422 Worker 0: Sort = Method: external merge Disk: 30520kB Worker 1: Sort = Method: external merge Disk: 29224kB -> Partial = HashAggregate (cost=3D1415055.25..1597484.97 rows=3D1788207 width=3D64) = (actual time=3D6980.371..9061.054 rows=3D541306 loops=3D3) Group Key: = jrtf2.case_year_number, jrtf2.lower_judge_wld_id, jrtf2.lower_judge_id, = (CASE WHEN (jrtf2.lower_judge_court_level_id =3D 1004) THEN 'T'::text = ELSE 'A'::text END), jrtf2.case_document_id Planned = Partitions: 128 Batches: 129 Memory Usage: 4633kB Disk Usage: = 462856kB Buffers: shared = hit=3D364511, temp read=3D141574 written=3D297838 Worker 0: = Batches: 129 Memory Usage: 4129kB Disk Usage: 411656kB Worker 1: = Batches: 129 Memory Usage: 4641kB Disk Usage: 389128kB -> Parallel = Append (cost=3D0.00..532593.66 rows=3D7450863 width=3D64) (actual = time=3D0.006..1784.406 rows=3D5960690 loops=3D3) Buffers: = shared hit=3D364511 -> = Parallel Seq Scan on jrt_fact_jrt_data_2012 jrtf2_23 = (cost=3D0.00..26581.62 rows=3D400092 width=3D64) (actual = time=3D0.005..216.086 rows=3D960222 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D19580 -> = Parallel Seq Scan on jrt_fact_jrt_data_2011 jrtf2_22 = (cost=3D0.00..25852.05 rows=3D389088 width=3D64) (actual = time=3D0.004..205.289 rows=3D933812 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D19043 -> = Parallel Seq Scan on jrt_fact_jrt_data_2009 jrtf2_20 = (cost=3D0.00..25276.31 rows=3D380418 width=3D64) (actual = time=3D0.006..195.529 rows=3D913002 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D18619 -> = Parallel Seq Scan on jrt_fact_jrt_data_2010 jrtf2_21 = (cost=3D0.00..25269.26 rows=3D380358 width=3D64) (actual = time=3D0.007..198.928 rows=3D912858 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D18613 -> = Parallel Seq Scan on jrt_fact_jrt_data_2014 jrtf2_25 = (cost=3D0.00..25006.09 rows=3D376348 width=3D64) (actual = time=3D0.005..193.307 rows=3D903235 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D18420 -> = Parallel Seq Scan on jrt_fact_jrt_data_2013 jrtf2_24 = (cost=3D0.00..24983.08 rows=3D376062 width=3D64) (actual = time=3D0.005..199.091 rows=3D902548 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D18402 -> = Parallel Seq Scan on jrt_fact_jrt_data_2008 jrtf2_19 = (cost=3D0.00..24497.49 rows=3D368714 width=3D64) (actual = time=3D0.006..189.346 rows=3D884913 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D18045 -> = Parallel Seq Scan on jrt_fact_jrt_data_2016 jrtf2_27 = (cost=3D0.00..24325.59 rows=3D366148 width=3D64) (actual = time=3D0.006..195.816 rows=3D878756 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D17918 -> = Parallel Seq Scan on jrt_fact_jrt_data_2015 jrtf2_26 = (cost=3D0.00..23573.77 rows=3D354787 width=3D64) (actual = time=3D0.006..186.719 rows=3D851489 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D17365 -> = Parallel Seq Scan on jrt_fact_jrt_data_2020 jrtf2_31 = (cost=3D0.00..22955.94 rows=3D345825 width=3D64) (actual = time=3D0.005..184.122 rows=3D829980 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D16904 -> = Parallel Seq Scan on jrt_fact_jrt_data_2018 jrtf2_29 = (cost=3D0.00..22485.88 rows=3D338736 width=3D64) (actual = time=3D0.006..173.993 rows=3D812966 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D16558 -> = Parallel Seq Scan on jrt_fact_jrt_data_2017 jrtf2_28 = (cost=3D0.00..22099.58 rows=3D332833 width=3D64) (actual = time=3D0.006..176.179 rows=3D798799 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D16275 -> = Parallel Seq Scan on jrt_fact_jrt_data_2007 jrtf2_18 = (cost=3D0.00..21455.84 rows=3D322905 width=3D64) (actual = time=3D0.007..82.994 rows=3D387486 loops=3D2) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D15805 -> = Parallel Seq Scan on jrt_fact_jrt_data_2021 jrtf2_32 = (cost=3D0.00..20677.71 rows=3D311526 width=3D64) (actual = time=3D0.011..86.729 rows=3D373832 loops=3D2) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D15226 -> = Parallel Seq Scan on jrt_fact_jrt_data_2006 jrtf2_17 = (cost=3D0.00..20593.16 rows=3D309952 width=3D64) (actual = time=3D0.005..160.160 rows=3D743884 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D15169 -> = Parallel Seq Scan on jrt_fact_jrt_data_2005 jrtf2_16 = (cost=3D0.00..19519.59 rows=3D293805 width=3D64) (actual = time=3D0.006..153.430 rows=3D705132 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D14378 -> = Parallel Seq Scan on jrt_fact_jrt_data_2019 jrtf2_30 = (cost=3D0.00..19487.29 rows=3D293560 width=3D64) (actual = time=3D0.004..156.767 rows=3D704543 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D14350 -> = Parallel Seq Scan on jrt_fact_jrt_data_2022 jrtf2_33 = (cost=3D0.00..18097.49 rows=3D272771 width=3D64) (actual = time=3D0.006..147.439 rows=3D654650 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D13324 -> = Parallel Seq Scan on jrt_fact_jrt_data_2004 jrtf2_15 = (cost=3D0.00..18009.92 rows=3D271081 width=3D64) (actual = time=3D0.005..143.933 rows=3D650595 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D13266 -> = Parallel Seq Scan on jrt_fact_jrt_data_2003 jrtf2_14 = (cost=3D0.00..17536.02 rows=3D264001 width=3D64) (actual = time=3D0.006..140.594 rows=3D633603 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D12916 -> = Parallel Seq Scan on jrt_fact_jrt_data_2002 jrtf2_13 = (cost=3D0.00..16514.18 rows=3D248639 width=3D64) (actual = time=3D0.005..132.336 rows=3D596733 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D12163 -> = Parallel Seq Scan on jrt_fact_jrt_data_2001 jrtf2_12 = (cost=3D0.00..13726.40 rows=3D206708 width=3D64) (actual = time=3D0.005..109.974 rows=3D496100 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D10109 -> = Parallel Seq Scan on jrt_fact_jrt_data_2000 jrtf2_11 = (cost=3D0.00..12331.50 rows=3D185686 width=3D64) (actual = time=3D0.005..98.570 rows=3D445646 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D9082 -> = Parallel Seq Scan on jrt_fact_jrt_data_2023 jrtf2_34 = (cost=3D0.00..4175.51 rows=3D80086 width=3D64) (actual = time=3D0.003..31.980 rows=3D136147 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D2774 -> = Parallel Seq Scan on jrt_fact_jrt_data_1999 jrtf2_10 = (cost=3D0.00..213.28 rows=3D4073 width=3D64) (actual time=3D0.003..1.614 = rows=3D6924 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D142 -> = Parallel Seq Scan on jrt_fact_jrt_data_1990 jrtf2_1 (cost=3D0.00..49.30 = rows=3D931 width=3D64) (actual time=3D0.003..0.370 rows=3D1583 = loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D33 -> = Parallel Seq Scan on jrt_fact_jrt_data_1998 jrtf2_9 (cost=3D0.00..26.75 = rows=3D500 width=3D64) (actual time=3D0.003..0.199 rows=3D850 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D18 -> = Parallel Seq Scan on jrt_fact_jrt_data_1997 jrtf2_8 (cost=3D0.00..7.10 = rows=3D120 width=3D64) (actual time=3D0.003..0.049 rows=3D204 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D5 -> = Parallel Seq Scan on jrt_fact_jrt_data_1995 jrtf2_6 (cost=3D0.00..4.35 = rows=3D77 width=3D64) (actual time=3D0.002..0.030 rows=3D131 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D3 -> = Parallel Seq Scan on jrt_fact_jrt_data_1996 jrtf2_7 (cost=3D0.00..2.70 = rows=3D40 width=3D64) (actual time=3D0.003..0.018 rows=3D68 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D2 -> = Parallel Seq Scan on jrt_fact_jrt_data_1992 jrtf2_3 (cost=3D0.00..1.21 = rows=3D12 width=3D64) (actual time=3D0.002..0.006 rows=3D20 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D1 -> = Parallel Seq Scan on jrt_fact_jrt_data_1994 jrtf2_5 (cost=3D0.00..1.21 = rows=3D12 width=3D64) (actual time=3D0.002..0.006 rows=3D20 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D1 -> = Parallel Seq Scan on jrt_fact_jrt_data_1991 jrtf2_2 (cost=3D0.00..1.20 = rows=3D11 width=3D64) (actual time=3D0.003..0.007 rows=3D19 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D1 -> = Parallel Seq Scan on jrt_fact_jrt_data_1993 jrtf2_4 (cost=3D0.00..1.01 = rows=3D1 width=3D64) (actual time=3D0.008..0.009 rows=3D1 loops=3D1) = Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004)) = Buffers: shared hit=3D1 -> Limit (cost=3D41718.13..41718.30 rows=3D11 width=3D12) (actual = time=3D7.581..7.636 rows=3D1 loops=3D1) Buffers: shared hit=3D1576 -> HashAggregate (cost=3D41718.13..41721.13 rows=3D200 = width=3D12) (actual time=3D7.580..7.635 rows=3D1 loops=3D1) Group Key: (CASE WHEN (jrtf.lower_judge_wld_id =3D = '104119201'::numeric) THEN jrtf.lower_judge_id ELSE jrtf.higher_judge_id = END) Batches: 1 Memory Usage: 40kB Buffers: shared hit=3D1576 -> Unique (cost=3D41305.59..41511.86 rows=3D11787 = width=3D44) (actual time=3D6.612..7.496 rows=3D763 loops=3D1) Buffers: shared hit=3D1576 -> Sort (cost=3D41305.59..41335.06 rows=3D11787 = width=3D44) (actual time=3D6.611..6.870 rows=3D4564 loops=3D1) Sort Key: jrtf.case_year_number DESC, = jrtf.case_document_id, jrtf.lower_judge_id, jrtf.higher_judge_id, (CASE = WHEN ((jrtf.lower_judge_wld_id =3D '104119201'::numeric) AND = (jrtf.lower_judge_court_level_id =3D 1004)) THEN 0 ELSE 1 END), (CASE = WHEN (j rtf.lower_judge_wld_id =3D '104119201'::numeric) THEN = jrtf.lower_judge_id ELSE jrtf.higher_judge_id END) Sort Method: quicksort Memory: 549kB Buffers: shared hit=3D1576 -> Append (cost=3D8.57..40508.50 = rows=3D11787 width=3D44) (actual time=3D0.450..4.946 rows=3D4564 = loops=3D1) Buffers: shared hit=3D1573 -> Bitmap Heap Scan on = jrt_fact_jrt_data_1990 jrtf_1 (cost=3D8.57..12.59 rows=3D1 width=3D44) = (actual time=3D0.017..0.019 rows=3D0 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Buffers: shared hit=3D4 -> BitmapOr (cost=3D8.57..8.57 = rows=3D1 width=3D0) (actual time=3D0.015..0.016 rows=3D0 loops=3D1) Buffers: shared hit=3D4 -> Bitmap Index Scan on = jrt_fact_jrt_data_1990_lower_judge_wld_id_idx (cost=3D0.00..4.29 = rows=3D1 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D2 -> Bitmap Index Scan on = jrt_fact_jrt_data_1990_higher_judge_wld_id_idx (cost=3D0.00..4.29 = rows=3D1 width=3D0) (actual time=3D0.006..0.006 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D2 -> Seq Scan on jrt_fact_jrt_data_1991 = jrtf_2 (cost=3D0.00..1.29 rows=3D1 width=3D44) (actual = time=3D0.012..0.013 rows=3D0 loops=3D1) Filter: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D '104119201'::numeric)) Rows Removed by Filter: 19 Buffers: shared hit=3D1 -> Seq Scan on jrt_fact_jrt_data_1992 = jrtf_3 (cost=3D0.00..1.31 rows=3D1 width=3D44) (actual = time=3D0.009..0.009 rows=3D0 loops=3D1) Filter: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D '104119201'::numeric)) Rows Removed by Filter: 20 Buffers: shared hit=3D1 -> Seq Scan on jrt_fact_jrt_data_1993 = jrtf_4 (cost=3D0.00..1.02 rows=3D1 width=3D44) (actual = time=3D0.003..0.004 rows=3D0 loops=3D1) Filter: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D '104119201'::numeric)) Rows Removed by Filter: 1 Buffers: shared hit=3D1 -> Seq Scan on jrt_fact_jrt_data_1994 = jrtf_5 (cost=3D0.00..1.31 rows=3D1 width=3D44) (actual = time=3D0.009..0.009 rows=3D0 loops=3D1) Filter: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D '104119201'::numeric)) Rows Removed by Filter: 20 Buffers: shared hit=3D1 -> Seq Scan on jrt_fact_jrt_data_1995 = jrtf_6 (cost=3D0.00..4.97 rows=3D1 width=3D44) (actual = time=3D0.058..0.058 rows=3D0 loops=3D1) Filter: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D '104119201'::numeric)) Rows Removed by Filter: 131 Buffers: shared hit=3D3 -> Seq Scan on jrt_fact_jrt_data_1996 = jrtf_7 (cost=3D0.00..3.03 rows=3D1 width=3D44) (actual = time=3D0.026..0.026 rows=3D0 loops=3D1) Filter: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D '104119201'::numeric)) Rows Removed by Filter: 68 Buffers: shared hit=3D2 -> Seq Scan on jrt_fact_jrt_data_1997 = jrtf_8 (cost=3D0.00..8.07 rows=3D1 width=3D44) (actual = time=3D0.059..0.059 rows=3D0 loops=3D1) Filter: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D '104119201'::numeric)) Rows Removed by Filter: 204 Buffers: shared hit=3D5 -> Bitmap Heap Scan on = jrt_fact_jrt_data_1998 jrtf_9 (cost=3D8.57..14.62 rows=3D2 width=3D44) = (actual time=3D0.012..0.013 rows=3D0 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Buffers: shared hit=3D4 -> BitmapOr (cost=3D8.57..8.57 = rows=3D2 width=3D0) (actual time=3D0.011..0.012 rows=3D0 loops=3D1) Buffers: shared hit=3D4 -> Bitmap Index Scan on = jrt_fact_jrt_data_1998_lower_judge_wld_id_idx (cost=3D0.00..4.28 = rows=3D1 width=3D0) (actual time=3D0.005..0.005 rows=3D0 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D2 -> Bitmap Index Scan on = jrt_fact_jrt_data_1998_higher_judge_wld_id_idx (cost=3D0.00..4.29 = rows=3D2 width=3D0) (actual time=3D0.005..0.005 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D2 -> Bitmap Heap Scan on = jrt_fact_jrt_data_1999 jrtf_10 (cost=3D8.68..51.80 rows=3D14 = width=3D44) (actual time=3D0.014..0.016 rows=3D0 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Buffers: shared hit=3D4 -> BitmapOr (cost=3D8.68..8.68 = rows=3D14 width=3D0) (actual time=3D0.013..0.015 rows=3D0 loops=3D1) Buffers: shared hit=3D4 -> Bitmap Index Scan on = jrt_fact_jrt_data_1999_lower_judge_wld_id_idx (cost=3D0.00..4.33 = rows=3D7 width=3D0) (actual time=3D0.006..0.006 rows=3D0 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D2 -> Bitmap Index Scan on = jrt_fact_jrt_data_1999_higher_judge_wld_id_idx (cost=3D0.00..4.33 = rows=3D7 width=3D0) (actual time=3D0.006..0.006 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D2 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2000 jrtf_11 (cost=3D10.74..839.39 rows=3D237 = width=3D44) (actual time=3D0.018..0.019 rows=3D0 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Buffers: shared hit=3D6 -> BitmapOr = (cost=3D10.74..10.74 rows=3D237 width=3D0) (actual time=3D0.017..0.018 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2000_lower_judge_wld_id_idx (cost=3D0.00..4.83 = rows=3D55 width=3D0) (actual time=3D0.009..0.009 rows=3D0 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2000_higher_judge_wld_id_idx (cost=3D0.00..5.79 = rows=3D182 width=3D0) (actual time=3D0.007..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2001 jrtf_12 (cost=3D10.87..898.62 rows=3D253 = width=3D44) (actual time=3D0.017..0.018 rows=3D0 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Buffers: shared hit=3D6 -> BitmapOr = (cost=3D10.87..10.87 rows=3D253 width=3D0) (actual time=3D0.016..0.016 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2001_lower_judge_wld_id_idx (cost=3D0.00..4.85 = rows=3D57 width=3D0) (actual time=3D0.007..0.008 rows=3D0 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2001_higher_judge_wld_id_idx (cost=3D0.00..5.89 = rows=3D196 width=3D0) (actual time=3D0.007..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2002 jrtf_13 (cost=3D15.27..1074.10 rows=3D301 = width=3D44) (actual time=3D0.018..0.020 rows=3D0 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Buffers: shared hit=3D6 -> BitmapOr = (cost=3D15.27..15.27 rows=3D301 width=3D0) (actual time=3D0.017..0.018 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2002_lower_judge_wld_id_idx (cost=3D0.00..4.92 = rows=3D66 width=3D0) (actual time=3D0.009..0.009 rows=3D0 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2002_higher_judge_wld_id_idx (cost=3D0.00..10.20 = rows=3D236 width=3D0) (actual time=3D0.007..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2003 jrtf_14 (cost=3D15.46..1158.27 rows=3D326 = width=3D44) (actual time=3D0.018..0.020 rows=3D0 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Buffers: shared hit=3D6 -> BitmapOr = (cost=3D15.46..15.46 rows=3D326 width=3D0) (actual time=3D0.017..0.018 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2003_lower_judge_wld_id_idx (cost=3D0.00..4.95 = rows=3D70 width=3D0) (actual time=3D0.008..0.009 rows=3D0 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2003_higher_judge_wld_id_idx (cost=3D0.00..10.35 = rows=3D256 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2004 jrtf_15 (cost=3D15.55..1196.85 rows=3D337 = width=3D44) (actual time=3D0.019..0.021 rows=3D0 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Buffers: shared hit=3D6 -> BitmapOr = (cost=3D15.55..15.55 rows=3D337 width=3D0) (actual time=3D0.018..0.019 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2004_lower_judge_wld_id_idx (cost=3D0.00..4.96 = rows=3D72 width=3D0) (actual time=3D0.007..0.007 rows=3D0 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2004_higher_judge_wld_id_idx (cost=3D0.00..10.41 = rows=3D265 width=3D0) (actual time=3D0.010..0.010 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2005 jrtf_16 (cost=3D15.85..1329.50 rows=3D375 = width=3D44) (actual time=3D0.017..0.019 rows=3D0 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Buffers: shared hit=3D6 -> BitmapOr = (cost=3D15.85..15.85 rows=3D375 width=3D0) (actual time=3D0.016..0.017 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2005_lower_judge_wld_id_idx (cost=3D0.00..5.02 = rows=3D80 width=3D0) (actual time=3D0.007..0.008 rows=3D0 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2005_higher_judge_wld_id_idx (cost=3D0.00..10.64 = rows=3D295 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2006 jrtf_17 (cost=3D15.98..1387.33 rows=3D391 = width=3D44) (actual time=3D0.019..0.020 rows=3D0 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Buffers: shared hit=3D6 -> BitmapOr = (cost=3D15.98..15.98 rows=3D391 width=3D0) (actual time=3D0.018..0.019 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2006_lower_judge_wld_id_idx (cost=3D0.00..5.04 = rows=3D82 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2006_higher_judge_wld_id_idx (cost=3D0.00..10.74 = rows=3D309 width=3D0) (actual time=3D0.009..0.009 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2007 jrtf_18 (cost=3D16.09..1434.30 rows=3D405 = width=3D44) (actual time=3D0.017..0.019 rows=3D0 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Buffers: shared hit=3D6 -> BitmapOr = (cost=3D16.09..16.09 rows=3D405 width=3D0) (actual time=3D0.016..0.017 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2007_lower_judge_wld_id_idx (cost=3D0.00..5.05 = rows=3D83 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2007_higher_judge_wld_id_idx (cost=3D0.00..10.84 = rows=3D322 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2008 jrtf_19 (cost=3D16.54..1633.45 rows=3D461 = width=3D44) (actual time=3D0.018..0.019 rows=3D0 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Buffers: shared hit=3D6 -> BitmapOr = (cost=3D16.54..16.54 rows=3D461 width=3D0) (actual time=3D0.016..0.018 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2008_lower_judge_wld_id_idx (cost=3D0.00..5.12 = rows=3D93 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2008_higher_judge_wld_id_idx (cost=3D0.00..11.19 = rows=3D368 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2009 jrtf_20 (cost=3D16.65..1683.32 rows=3D475 = width=3D44) (actual time=3D0.018..0.019 rows=3D0 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Buffers: shared hit=3D6 -> BitmapOr = (cost=3D16.65..16.65 rows=3D475 width=3D0) (actual time=3D0.017..0.018 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2009_lower_judge_wld_id_idx (cost=3D0.00..5.12 = rows=3D93 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2009_higher_judge_wld_id_idx (cost=3D0.00..11.29 = rows=3D382 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2010 jrtf_21 (cost=3D16.63..1673.33 rows=3D472 = width=3D44) (actual time=3D0.018..0.020 rows=3D0 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Buffers: shared hit=3D6 -> BitmapOr = (cost=3D16.63..16.63 rows=3D472 width=3D0) (actual time=3D0.017..0.018 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2010_lower_judge_wld_id_idx (cost=3D0.00..5.13 = rows=3D94 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2010_higher_judge_wld_id_idx (cost=3D0.00..11.26 = rows=3D378 width=3D0) (actual time=3D0.007..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2011 jrtf_22 (cost=3D16.91..1791.83 rows=3D508 = width=3D44) (actual time=3D0.024..0.026 rows=3D2 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Heap Blocks: exact=3D1 Buffers: shared hit=3D7 -> BitmapOr = (cost=3D16.91..16.91 rows=3D508 width=3D0) (actual time=3D0.017..0.018 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2011_lower_judge_wld_id_idx (cost=3D0.00..5.14 = rows=3D95 width=3D0) (actual time=3D0.009..0.009 rows=3D2 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2011_higher_judge_wld_id_idx (cost=3D0.00..11.52 = rows=3D413 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2012 jrtf_23 (cost=3D16.99..1828.27 rows=3D518 = width=3D44) (actual time=3D0.052..0.142 rows=3D187 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Heap Blocks: exact=3D19 Buffers: shared hit=3D25 -> BitmapOr = (cost=3D16.99..16.99 rows=3D518 width=3D0) (actual time=3D0.042..0.043 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2012_lower_judge_wld_id_idx (cost=3D0.00..5.16 = rows=3D98 width=3D0) (actual time=3D0.028..0.028 rows=3D150 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2012_higher_judge_wld_id_idx (cost=3D0.00..11.58 = rows=3D420 width=3D0) (actual time=3D0.013..0.013 rows=3D37 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2013 jrtf_24 (cost=3D16.81..1744.81 rows=3D495 = width=3D44) (actual time=3D0.063..0.170 rows=3D210 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Heap Blocks: exact=3D31 Buffers: shared hit=3D37 -> BitmapOr = (cost=3D16.81..16.81 rows=3D495 width=3D0) (actual time=3D0.052..0.053 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2013_lower_judge_wld_id_idx (cost=3D0.00..5.12 = rows=3D93 width=3D0) (actual time=3D0.043..0.044 rows=3D210 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2013_higher_judge_wld_id_idx (cost=3D0.00..11.44 = rows=3D402 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2014 jrtf_25 (cost=3D16.83..1754.81 rows=3D498 = width=3D44) (actual time=3D0.047..0.138 rows=3D175 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Heap Blocks: exact=3D25 Buffers: shared hit=3D31 -> BitmapOr = (cost=3D16.83..16.83 rows=3D498 width=3D0) (actual time=3D0.038..0.039 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2014_lower_judge_wld_id_idx (cost=3D0.00..5.13 = rows=3D94 width=3D0) (actual time=3D0.029..0.030 rows=3D175 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2014_higher_judge_wld_id_idx (cost=3D0.00..11.46 = rows=3D404 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2015 jrtf_26 (cost=3D16.70..1695.12 rows=3D482 = width=3D44) (actual time=3D0.056..0.183 rows=3D268 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Heap Blocks: exact=3D28 Buffers: shared hit=3D34 -> BitmapOr = (cost=3D16.70..16.70 rows=3D482 width=3D0) (actual time=3D0.047..0.048 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2015_lower_judge_wld_id_idx (cost=3D0.00..5.09 = rows=3D89 width=3D0) (actual time=3D0.038..0.038 rows=3D268 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2015_higher_judge_wld_id_idx (cost=3D0.00..11.37 = rows=3D392 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2016 jrtf_27 (cost=3D39.15..4057.93 rows=3D1286 = width=3D44) (actual time=3D0.108..0.392 rows=3D589 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Heap Blocks: exact=3D69 Buffers: shared hit=3D78 -> BitmapOr = (cost=3D39.15..39.15 rows=3D1287 width=3D0) (actual time=3D0.094..0.095 = rows=3D0 loops=3D1) Buffers: shared hit=3D9 -> Bitmap Index Scan on = jrt_fact_jrt_data_2016_lower_judge_wld_id_idx (cost=3D0.00..27.02 = rows=3D879 width=3D0) (actual time=3D0.086..0.086 rows=3D589 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2016_higher_judge_wld_id_idx (cost=3D0.00..11.49 = rows=3D408 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2017 jrtf_28 (cost=3D16.47..1592.43 rows=3D453 = width=3D44) (actual time=3D0.073..0.237 rows=3D305 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Heap Blocks: exact=3D49 Buffers: shared hit=3D57 -> BitmapOr = (cost=3D16.47..16.47 rows=3D453 width=3D0) (actual time=3D0.061..0.062 = rows=3D0 loops=3D1) Buffers: shared hit=3D8 -> Bitmap Index Scan on = jrt_fact_jrt_data_2017_lower_judge_wld_id_idx (cost=3D0.00..5.09 = rows=3D89 width=3D0) (actual time=3D0.053..0.053 rows=3D305 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D5 -> Bitmap Index Scan on = jrt_fact_jrt_data_2017_higher_judge_wld_id_idx (cost=3D0.00..11.16 = rows=3D364 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2018 jrtf_29 (cost=3D16.52..1614.07 rows=3D459 = width=3D44) (actual time=3D0.080..0.267 rows=3D379 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Heap Blocks: exact=3D45 Buffers: shared hit=3D53 -> BitmapOr = (cost=3D16.52..16.52 rows=3D459 width=3D0) (actual time=3D0.069..0.070 = rows=3D0 loops=3D1) Buffers: shared hit=3D8 -> Bitmap Index Scan on = jrt_fact_jrt_data_2018_lower_judge_wld_id_idx (cost=3D0.00..5.09 = rows=3D89 width=3D0) (actual time=3D0.060..0.060 rows=3D379 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D5 -> Bitmap Index Scan on = jrt_fact_jrt_data_2018_higher_judge_wld_id_idx (cost=3D0.00..11.20 = rows=3D370 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2019 jrtf_30 (cost=3D31.97..2869.06 rows=3D889 = width=3D44) (actual time=3D0.118..0.360 rows=3D495 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Heap Blocks: exact=3D63 Buffers: shared hit=3D71 -> BitmapOr = (cost=3D31.97..31.97 rows=3D889 width=3D0) (actual time=3D0.106..0.106 = rows=3D0 loops=3D1) Buffers: shared hit=3D8 -> Bitmap Index Scan on = jrt_fact_jrt_data_2019_lower_judge_wld_id_idx (cost=3D0.00..20.66 = rows=3D564 width=3D0) (actual time=3D0.097..0.097 rows=3D495 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D5 -> Bitmap Index Scan on = jrt_fact_jrt_data_2019_higher_judge_wld_id_idx (cost=3D0.00..10.87 = rows=3D326 width=3D0) (actual time=3D0.008..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2020 jrtf_31 (cost=3D38.45..3791.01 rows=3D1200 = width=3D44) (actual time=3D0.188..0.778 rows=3D937 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Heap Blocks: exact=3D239 Buffers: shared hit=3D249 -> BitmapOr = (cost=3D38.45..38.45 rows=3D1200 width=3D0) (actual time=3D0.157..0.158 = rows=3D0 loops=3D1) Buffers: shared hit=3D10 -> Bitmap Index Scan on = jrt_fact_jrt_data_2020_lower_judge_wld_id_idx (cost=3D0.00..26.44 = rows=3D802 width=3D0) (actual time=3D0.149..0.149 rows=3D937 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D7 -> Bitmap Index Scan on = jrt_fact_jrt_data_2020_higher_judge_wld_id_idx (cost=3D0.00..11.41 = rows=3D398 width=3D0) (actual time=3D0.007..0.008 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2021 jrtf_32 (cost=3D16.44..1571.85 rows=3D449 = width=3D44) (actual time=3D0.161..0.698 rows=3D517 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Heap Blocks: exact=3D374 Buffers: shared hit=3D382 -> BitmapOr = (cost=3D16.44..16.44 rows=3D449 width=3D0) (actual time=3D0.115..0.116 = rows=3D0 loops=3D1) Buffers: shared hit=3D8 -> Bitmap Index Scan on = jrt_fact_jrt_data_2021_lower_judge_wld_id_idx (cost=3D0.00..5.04 = rows=3D82 width=3D0) (actual time=3D0.091..0.091 rows=3D517 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D5 -> Bitmap Index Scan on = jrt_fact_jrt_data_2021_higher_judge_wld_id_idx (cost=3D0.00..11.18 = rows=3D367 width=3D0) (actual time=3D0.023..0.023 rows=3D0 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2022 jrtf_33 (cost=3D15.99..1374.94 rows=3D392 = width=3D44) (actual time=3D0.119..0.478 rows=3D319 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Heap Blocks: exact=3D284 Buffers: shared hit=3D290 -> BitmapOr = (cost=3D15.99..15.99 rows=3D392 width=3D0) (actual time=3D0.083..0.084 = rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2022_lower_judge_wld_id_idx (cost=3D0.00..4.98 = rows=3D74 width=3D0) (actual time=3D0.024..0.024 rows=3D129 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2022_higher_judge_wld_id_idx (cost=3D0.00..10.81 = rows=3D318 width=3D0) (actual time=3D0.058..0.058 rows=3D190 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Heap Scan on = jrt_fact_jrt_data_2023 jrtf_34 (cost=3D9.66..354.97 rows=3D101 = width=3D44) (actual time=3D0.065..0.266 rows=3D181 loops=3D1) Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric)) Heap Blocks: exact=3D161 Buffers: shared hit=3D167 -> BitmapOr (cost=3D9.66..9.66 = rows=3D101 width=3D0) (actual time=3D0.041..0.042 rows=3D0 loops=3D1) Buffers: shared hit=3D6 -> Bitmap Index Scan on = jrt_fact_jrt_data_2023_lower_judge_wld_id_idx (cost=3D0.00..4.60 = rows=3D24 width=3D0) (actual time=3D0.014..0.014 rows=3D37 loops=3D1) Index Cond: = (lower_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 -> Bitmap Index Scan on = jrt_fact_jrt_data_2023_higher_judge_wld_id_idx (cost=3D0.00..5.00 = rows=3D78 width=3D0) (actual time=3D0.026..0.026 rows=3D144 loops=3D1) Index Cond: = (higher_judge_wld_id =3D '104119201'::numeric) Buffers: shared = hit=3D3 Planning: Buffers: shared hit=3D9400 Planning Time: 24.631 ms Execution Time: 35251.529 ms (614 rows) =20 ORACLE PLAN: =20 =20 Plan hash value: 3488078505 =20 -------------------------------------------------------------------------= -------------------------------------------------------------------------= ------------- | Id | Operation | Name = | Starts | E-Rows | A-Rows | A-Time | Buffers | OMem | = 1Mem | Used-Mem | -------------------------------------------------------------------------= -------------------------------------------------------------------------= ------------- | 0 | SELECT STATEMENT | = | 1 | | 1 |00:00:00.03 | 5259 | | = | | |* 1 | HASH JOIN | = | 1 | 1 | 1 |00:00:00.03 | 5259 | 872K| = 872K| 455K (0)| | 2 | VIEW | = | 1 | 1 | 1 |00:00:00.02 | 3693 | | = | | | 3 | HASH GROUP BY | = | 1 | 1 | 1 |00:00:00.02 | 3693 | 734K| = 734K| 514K (0)| | 4 | NESTED LOOPS OUTER | = | 1 | 29525 | 39 |00:00:00.02 | 3693 | | = | | | 5 | NESTED LOOPS OUTER | = | 1 | 150 | 3 |00:00:00.01 | 513 | | = | | |* 6 | TABLE ACCESS BY INDEX ROWID BATCHED | JUDGE = | 1 | 1 | 1 |00:00:00.01 | 3 | | = | | |* 7 | INDEX RANGE SCAN | = JUDGE_WLD_PROF_IDX | 1 | 1 | 1 |00:00:00.01 | 2 | = | | | | 8 | VIEW PUSHED PREDICATE | = | 1 | 1 | 3 |00:00:00.01 | 510 | | = | | | 9 | SORT GROUP BY | = | 1 | 2228 | 3 |00:00:00.01 | 510 | 2048 | = 2048 | 2048 (0)| | 10 | VIEW | VM_NWVW_1 = | 1 | 2228 | 87 |00:00:00.01 | 510 | | = | | | 11 | SORT GROUP BY | = | 1 | 2228 | 87 |00:00:00.01 | 510 | 9216 | = 9216 | 8192 (0)| | 12 | PARTITION RANGE ALL | = | 1 | 2228 | 540 |00:00:00.01 | 510 | | = | | | 13 | TABLE ACCESS BY LOCAL INDEX ROWID BATCHED| JRT_FACT = | 34 | 2228 | 540 |00:00:00.01 | 510 | | = | | |* 14 | INDEX RANGE SCAN | = JRT_FACT_IDX05 | 34 | 2228 | 540 |00:00:00.01 | 86 | = | | | | 15 | VIEW PUSHED PREDICATE | = | 3 | 1 | 39 |00:00:00.02 | 3180 | | = | | | 16 | SORT GROUP BY | = | 3 | 481 | 39 |00:00:00.02 | 3180 | 2048 | = 2048 | 2048 (0)| | 17 | VIEW | VM_NWVW_0 = | 3 | 481 | 813 |00:00:00.02 | 3180 | | = | | | 18 | SORT GROUP BY | = | 3 | 481 | 813 |00:00:00.02 | 3180 | 24576 | = 24576 |22528 (0)| |* 19 | FILTER | = | 3 | | 12669 |00:00:00.01 | 3180 | | = | | | 20 | PARTITION RANGE ALL | = | 3 | 481 | 12669 |00:00:00.01 | 3180 | | = | | |* 21 | TABLE ACCESS BY LOCAL INDEX ROWID BATCHED| JRT_FACT = | 102 | 481 | 12669 |00:00:00.01 | 3180 | | = | | |* 22 | INDEX RANGE SCAN | = JRT_FACT_IDX02 | 102 | 481 | 12669 |00:00:00.01 | 288 | = | | | | 23 | VIEW | = | 1 | 11 | 1 |00:00:00.01 | 1566 | | = | | | 24 | HASH GROUP BY | = | 1 | 11 | 1 |00:00:00.01 | 1566 | 1097K| = 1097K| 514K (0)| |* 25 | COUNT STOPKEY | = | 1 | | 11 |00:00:00.01 | 1566 | | = | | | 26 | VIEW | = | 1 | 2689 | 11 |00:00:00.01 | 1566 | | = | | |* 27 | SORT UNIQUE STOPKEY | = | 1 | 2689 | 11 |00:00:00.01 | 1566 | 2048 | = 2048 | 2048 (0)| | 28 | PARTITION RANGE ALL | = | 1 | 2689 | 4763 |00:00:00.01 | 1566 | | = | | | 29 | TABLE ACCESS BY LOCAL INDEX ROWID BATCHED | JRT_FACT = | 34 | 2689 | 4763 |00:00:00.01 | 1566 | | = | | | 30 | BITMAP CONVERSION TO ROWIDS | = | 34 | | 4763 |00:00:00.01 | 186 | | = | | | 31 | BITMAP OR | = | 34 | | 13 |00:00:00.01 | 186 | | = | | | 32 | BITMAP CONVERSION FROM ROWIDS | = | 34 | | 3 |00:00:00.01 | 88 | | = | | |* 33 | INDEX RANGE SCAN | = JRT_FACT_IDX13 | 34 | | 540 |00:00:00.01 | 88 | = | | | | 34 | BITMAP CONVERSION FROM ROWIDS | = | 34 | | 13 |00:00:00.01 | 98 | | = | | |* 35 | INDEX RANGE SCAN | = JRT_FACT_IDX12 | 34 | | 4223 |00:00:00.01 | 98 | = | | | -------------------------------------------------------------------------= -------------------------------------------------------------------------= ------------- =20 Predicate Information (identified by operation id): --------------------------------------------------- =20 1 - access("AGG_SUB"."JUDGE_ID"=3D"APPELLATE_FLAG_SUB"."JUDGE_ID") 6 - filter(("JUDG1"."JRT_OPT_OUT_FLAG" IS NULL OR = "JUDG1"."JRT_OPT_OUT_FLAG"<>:SYS_B_17)) 7 - access("JUDG1"."WLD_ID"=3D:SYS_B_15 AND = "JUDG1"."PROFILE_ID"=3D:SYS_B_16) 14 - access("JRTF1"."HIGHER_JUDGE_ID"=3D"JUDG1"."JUDGE_ID") 19 - filter(:SYS_B_23>:SYS_B_22) 21 - filter(("JRTF2"."LOWER_JUDGE_COURT_LEVEL_ID">:SYS_B_22 AND = "JRTF2"."LOWER_JUDGE_COURT_LEVEL_ID"<=3D:SYS_B_23)) 22 - access("JRTF2"."LOWER_JUDGE_ID"=3D"JUDG1"."JUDGE_ID") 25 - filter(ROWNUM<=3D:SYS_B_37) 27 - filter(ROWNUM<=3D:SYS_B_37) 33 - access("HIGHER_JUDGE_WLD_ID"=3D:SYS_B_36) 35 - access("LOWER_JUDGE_WLD_ID"=3D:SYS_B_35) =20 =20 Postgres table definitions: =20 wldomart01a=3D> \d+ wln_mart.judge Table = "wln_mart.judge" Column | Type | Collation | = Nullable | Default | Storage | Stats target | Description -------------------------+--------------------------------+-----------+--= --------+-------------+----------+--------------+------------- judge_id | bigint | | = not null | | plain | | display_name | character varying(255) | | = not null | | extended | | first_name | character varying(50) | | = | | extended | | middle_name | character varying(50) | | = | | extended | | sur_name | character varying(50) | | = | | extended | | title | character varying(10) | | = | | extended | | prof_suffix | character varying(10) | | = | | extended | | wld_id | bigint | | = | | plain | | profile_id | bigint | | = | | plain | | search_name | character varying(255) | | = not null | | extended | | active_flag | character(1) | | = not null | | extended | | legal_event_count | bigint | | = | | plain | | profile_type | character(1) | | = not null | 'L'::bpchar | extended | | court_name | character varying(255) | | = | | extended | | address | character varying(255) | | = | | extended | | legal_event_total_count | bigint | | = | | plain | | legal_event_first_year | bigint | | = | | plain | | legal_event_last_year | bigint | | = | | plain | | state_id | bigint | | = | | plain | | ec_fact_first_year | bigint | | = | | plain | | judge_padb_code | character varying(33) | | = | | extended | | ec_fact_count | bigint | | = | | plain | | ec_fact_totalcount | bigint | | = | | plain | | ee_fact_totalcount | bigint | | = | | plain | | ec_fact_last_year | bigint | | = | | plain | | jmt_total_count | bigint | | = | | plain | | jrt_total_count | bigint | | = | | plain | | jrt_opt_out_flag | character(1) | | = | | extended | | jmt_opt_out_flag | character(1) | | = | | extended | | judge_court_level | character varying(50) | | = | | extended | | jrt_trial_count | bigint | | = | | plain | | jrt_appellate_count | bigint | | = | | plain | | city_name | character varying(255) | | = | | extended | | zip_code | character varying(20) | | = | | extended | | created_on | timestamp(0) without time zone | | = | | plain | | changed_on | timestamp(0) without time zone | | = | | plain | | Indexes: "pk_judge" PRIMARY KEY, btree (judge_id) "idx_jdg_low_fname" btree (lower(first_name::text)) "idx_jdg_low_surname" btree (lower(sur_name::text)) "idx_judge_first_name" btree (first_name) "idx_judge_search_name" btree (search_name) "idx_judge_sur_name" btree (sur_name) "judge_st_id" btree (state_id) "judge_wld_prof_idx" btree (wld_id, profile_id) Foreign-key constraints: "judge_state_id_fk" FOREIGN KEY (state_id) REFERENCES = wln_mart.state_code(state_id) Referenced by: TABLE "wln_mart.ec_fact" CONSTRAINT "ec_fact_judge_fk" FOREIGN KEY = (judge_id) REFERENCES wln_mart.judge(judge_id) TABLE "wln_mart.ee_fact" CONSTRAINT "ee_judge_fk" FOREIGN KEY = (judge_id) REFERENCES wln_mart.judge(judge_id) TABLE "wln_mart.ea_judge_doc_fact" CONSTRAINT = "fk_judge_doc_judge_id" FOREIGN KEY (judge_id) REFERENCES = wln_mart.judge(judge_id) TABLE "wln_mart.jmt_fact" CONSTRAINT "jmt_fact_fk01" FOREIGN KEY = (judge_id) REFERENCES wln_mart.judge(judge_id) TABLE "wln_mart.jrt_fact" CONSTRAINT "jrt_fact_fk02" FOREIGN KEY = (lower_judge_id) REFERENCES wln_mart.judge(judge_id) TABLE "wln_mart.jrt_fact" CONSTRAINT "jrt_fact_fk04" FOREIGN KEY = (higher_judge_id) REFERENCES wln_mart.judge(judge_id) TABLE "wln_mart.lhr_fact" CONSTRAINT "lhr_judge_id_fk01" FOREIGN KEY = (judge_id) REFERENCES wln_mart.judge(judge_id) Access method: heap =20 =20 =20 wldomart01a=3D> \d+ wln_mart.jrt_fact Partitioned table = "wln_mart.jrt_fact" Column | Type | Collation = | Nullable | Default | Storage | Stats target | Description ----------------------------+--------------------------------+-----------= +----------+---------+----------+--------------+------------- jrt_fact_id | bigint | = | not null | | plain | | case_document_id | double precision | = | not null | | plain | | lower_judge_id | bigint | = | not null | | plain | | appealed_case_ruling_id | bigint | = | not null | | plain | | higher_judge_id | bigint | = | not null | | plain | | lower_judge_court_level_id | bigint | = | not null | | plain | | majority_judge_flag | character(1) | = | not null | | extended | | attorney_id | bigint | = | not null | | plain | | firm_id | bigint | = | not null | | plain | | case_date_id | bigint | = | not null | | plain | | case_year_number | bigint | = | not null | | plain | | lower_judge_wld_id | numeric(10,0) | = | | | main | | higher_judge_wld_id | numeric(10,0) | = | | | main | | created_on | timestamp(0) without time zone | = | | | plain | | changed_on | timestamp(0) without time zone | = | | | plain | | court_id | double precision | = | not null | 1 | plain | | Partition key: RANGE (case_year_number) Indexes: "pk_jrt_fact" PRIMARY KEY, btree (jrt_fact_id, case_year_number) "jrt_fact_idx01" btree (case_document_id) "jrt_fact_idx02" btree (lower_judge_id) "jrt_fact_idx04" btree (appealed_case_ruling_id) "jrt_fact_idx05" btree (higher_judge_id) "jrt_fact_idx06" btree (lower_judge_court_level_id) "jrt_fact_idx07" btree (majority_judge_flag) "jrt_fact_idx08" btree (case_date_id) "jrt_fact_idx09" btree (attorney_id) "jrt_fact_idx10" btree (firm_id) "jrt_fact_idx11" btree (case_year_number) "jrt_fact_idx12" btree (lower_judge_wld_id) "jrt_fact_idx13" btree (higher_judge_wld_id) Foreign-key constraints: "jrt_fact_fk02" FOREIGN KEY (lower_judge_id) REFERENCES = wln_mart.judge(judge_id) "jrt_fact_fk03" FOREIGN KEY (appealed_case_ruling_id) REFERENCES = wln_mart.appealed_case_ruling(appealed_case_ruling_id) "jrt_fact_fk04" FOREIGN KEY (higher_judge_id) REFERENCES = wln_mart.judge(judge_id) "jrt_fact_fk05" FOREIGN KEY (lower_judge_court_level_id) REFERENCES = wln_mart.lower_judge_court_level(lower_judge_court_level_id) "jrt_fact_fk06" FOREIGN KEY (attorney_id) REFERENCES = wln_mart.attorney(attorney_id) "jrt_fact_fk07" FOREIGN KEY (firm_id) REFERENCES = wln_mart.firm(firm_id) "jrt_fact_fk08" FOREIGN KEY (case_date_id) REFERENCES = wln_mart.date_code(date_id) Partitions: wln_mart.jrt_fact_jrt_data_1990 FOR VALUES FROM (MINVALUE) = TO ('1991'), wln_mart.jrt_fact_jrt_data_1991 FOR VALUES FROM ('1991') TO = ('1992'), wln_mart.jrt_fact_jrt_data_1992 FOR VALUES FROM ('1992') TO = ('1993'), wln_mart.jrt_fact_jrt_data_1993 FOR VALUES FROM ('1993') TO = ('1994'), wln_mart.jrt_fact_jrt_data_1994 FOR VALUES FROM ('1994') TO = ('1995'), wln_mart.jrt_fact_jrt_data_1995 FOR VALUES FROM ('1995') TO = ('1996'), wln_mart.jrt_fact_jrt_data_1996 FOR VALUES FROM ('1996') TO = ('1997'), wln_mart.jrt_fact_jrt_data_1997 FOR VALUES FROM ('1997') TO = ('1998'), wln_mart.jrt_fact_jrt_data_1998 FOR VALUES FROM ('1998') TO = ('1999'), wln_mart.jrt_fact_jrt_data_1999 FOR VALUES FROM ('1999') TO = ('2000'), wln_mart.jrt_fact_jrt_data_2000 FOR VALUES FROM ('2000') TO = ('2001'), wln_mart.jrt_fact_jrt_data_2001 FOR VALUES FROM ('2001') TO = ('2002'), wln_mart.jrt_fact_jrt_data_2002 FOR VALUES FROM ('2002') TO = ('2003'), wln_mart.jrt_fact_jrt_data_2003 FOR VALUES FROM ('2003') TO = ('2004'), wln_mart.jrt_fact_jrt_data_2004 FOR VALUES FROM ('2004') TO = ('2005'), wln_mart.jrt_fact_jrt_data_2005 FOR VALUES FROM ('2005') TO = ('2006'), wln_mart.jrt_fact_jrt_data_2006 FOR VALUES FROM ('2006') TO = ('2007'), wln_mart.jrt_fact_jrt_data_2007 FOR VALUES FROM ('2007') TO = ('2008'), wln_mart.jrt_fact_jrt_data_2008 FOR VALUES FROM ('2008') TO = ('2009'), wln_mart.jrt_fact_jrt_data_2009 FOR VALUES FROM ('2009') TO = ('2010'), wln_mart.jrt_fact_jrt_data_2010 FOR VALUES FROM ('2010') TO = ('2011'), wln_mart.jrt_fact_jrt_data_2011 FOR VALUES FROM ('2011') TO = ('2012'), wln_mart.jrt_fact_jrt_data_2012 FOR VALUES FROM ('2012') TO = ('2013'), wln_mart.jrt_fact_jrt_data_2013 FOR VALUES FROM ('2013') TO = ('2014'), wln_mart.jrt_fact_jrt_data_2014 FOR VALUES FROM ('2014') TO = ('2015'), wln_mart.jrt_fact_jrt_data_2015 FOR VALUES FROM ('2015') TO = ('2016'), wln_mart.jrt_fact_jrt_data_2016 FOR VALUES FROM ('2016') TO = ('2017'), wln_mart.jrt_fact_jrt_data_2017 FOR VALUES FROM ('2017') TO = ('2018'), wln_mart.jrt_fact_jrt_data_2018 FOR VALUES FROM ('2018') TO = ('2019'), wln_mart.jrt_fact_jrt_data_2019 FOR VALUES FROM ('2019') TO = ('2020'), wln_mart.jrt_fact_jrt_data_2020 FOR VALUES FROM ('2020') TO = ('2021'), wln_mart.jrt_fact_jrt_data_2021 FOR VALUES FROM ('2021') TO = ('2022'), wln_mart.jrt_fact_jrt_data_2022 FOR VALUES FROM ('2022') TO = ('2023'), wln_mart.jrt_fact_jrt_data_2023 FOR VALUES FROM ('2023') TO = ('2024') =20 =20 This e-mail is for the sole use of the intended recipient and contains = information that may be privileged and/or confidential. If you are not = an intended recipient, please notify the sender by return e-mail and = delete this e-mail and any attachments. Certain required legal entity = disclosures can be accessed on our website: = https://www.thomsonreuters.com/en/resources/disclosures.html=20 ------=_NextPart_000_07FD_01D9F238.56732F60 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Could you send the the = table=E2=80=99s Index scripts?

 

Kimden: Dirschel, Steve <steve.dirschel@thomsonreuters.com> =
Tarih: 27 Eyl=C3=BCl 2023 =C3=87ar=C5=9Famba = 20:45
Kime: PostgreSQL General = <pgsql-general@lists.postgresql.org>
Bilgi: Wong, Kam = Fook (TR Technology) = <kamfook.wong@thomsonreuters.com>
Konu: Need help tuning = a query

 

We are = migrating from Oracle to Postgres.  I have a ugly query that = performs great in Oracle-  it does 5259 logical reads and completes = in < 1 second.  In Postgres it=E2=80=99s taking 35+ seconds. =  I can see 2 parts in the plan that are the problem with Postgres = but I=E2=80=99m not sure how to change the query to optimize = optimally.  I believe the query is generated based on user = selection criteria so I can=E2=80=99t really hint the query because = there can be a lot of variations of it (nor do I see a push_subq type of = hint in pg_hint_plan).  The query is long and ugly, the plan is = long and ugly in Postgres.  The query is below.  The problem = is in 2 spots:

 

  1. Inline view = sub4.  There is no WHERE clause so it=E2=80=99s full scanning table = JRT_FACT.  Inline view sub4 is inside inline view sub1.  The = join to sub1 is on sub1.judge_id.  Sub1.judge_id comes from = jrt_fact jrt1. Higher_judge_id.  There is an index on that = column.  If you look at the Oracle plan it=E2=80=99s using a PUSHED = PREDICATE operation where it=E2=80=99s pushing the join on sub1.judge_id = =3D sub0.judge_id into sub4.  That is the optimal way to access = jrt_fact in that part of the query.
  2. Inline view sub5.  There is filtering in the WHERE = clause-  where lower_judge_court_level_id > 1000 and = lower_judge_court_level_id <=3D 1004 but that filtering alone is not = very good.  It=E2=80=99s a similar problem as sub4-  in this = case sub2 has sub4 in it and the join to sub2 is on judge_id.  That = judge_id is coming from jrt_fact jrtf2.lower_judge_id.  That column = is indexed.  Oracle will use a PUSHED PREDICATE when accessing = jrtf2 which is the optimal way to access that part of the = query.
  3. When it accesses table = judge judg1 it is full scanning that table even though there is an index = on wld_id.  It only does 3445 shared buffer hits so that is not the = main reason the query is slow but I don=E2=80=99t see why it = won=E2=80=99t use the index when accessing that = table.

 

Any ideas on how I can change this query to optimize = as Oracle is doing?  Thanks in advance.

 

Steve

 

QUERY:

 

SELECT = agg_sub.judge_id,

  =      agg_sub.display_name,

       = agg_sub.active_flag,

  =      = agg_sub.judge_court_level,

       = agg_sub.jrt_fact_first_year_trial,

       = agg_sub.jrt_fact_last_year_trial,

       = agg_sub.jrt_fact_totalcount_trial,

       = agg_sub.filtered_first_year_trial,

       = agg_sub.filtered_last_year_trial,

       = agg_sub.jrt_fact_count_trial,

       = agg_sub.jrt_fact_first_year_appeal,

       = agg_sub.jrt_fact_last_year_appeal,

       = agg_sub.jrt_fact_totalcount_appeal,

       = agg_sub.filtered_first_year_appeal,

       = agg_sub.filtered_last_year_appeal,

       = agg_sub.jrt_fact_count_appeal,

       = appellate_flag_sub.appellate_flag

   FROM (SELECT sub3.judge_id,

      =        = sub3.display_name,

      =        = sub3.active_flag,

      =        = sub3.judge_court_level,

      =        = (MIN(sub3.trial_unfilt_case_year_number)) AS = jrt_fact_first_year_trial,

      =        = (MAX(sub3.trial_unfilt_case_year_number)) AS = jrt_fact_last_year_trial,

      =        (SUM(sub3.trial_unfilt_subcount)) = AS jrt_fact_totalcount_trial,

      =        = (MIN(sub3.trial_filt_case_year_number)) AS = filtered_first_year_trial,

      =        = (MAX(sub3.trial_filt_case_year_number)) AS = filtered_last_year_trial,

      =        (SUM(sub3.trial_filt_subcount)) AS = jrt_fact_count_trial,

   =           = (MIN(sub3.appeal_unfilt_case_year_number)) AS = jrt_fact_first_year_appeal,

      =        = (MAX(sub3.appeal_unfilt_case_year_number)) AS = jrt_fact_last_year_appeal,

      =        (SUM(sub3.appeal_unfilt_subcount)) = AS jrt_fact_totalcount_appeal,

      =        = (MIN(sub3.appeal_filt_case_year_number)) AS = filtered_first_year_appeal,

      =        = (MAX(sub3.appeal_filt_case_year_number)) AS = filtered_last_year_appeal,

      =        (SUM(sub3.appeal_filt_subcount)) AS = jrt_fact_count_appeal

           FROM = (SELECT sub0.judge_id,

          =           = sub0.display_name,

          =           = sub0.active_flag,

          =           = sub0.judge_court_level,

          =           (CASE WHEN = sub2.grouping_flg =3D 'T' AND sub2.judge_wld_id =3D sub0.judge_wld_id = THEN sub2.case_year_number ELSE NULL END) AS = trial_unfilt_case_year_number,

        =             (CASE = WHEN sub2.grouping_flg =3D 'T'AND sub2.judge_wld_id =3D = sub0.judge_wld_id THEN sub2.subcount ELSE NULL = END          =              = ) AS trial_unfilt_subcount,

          =           (CASE WHEN = sub2.grouping_flg =3D 'T' AND sub2.judge_wld_id =3D sub0.judge_wld_id = THEN (CASE WHEN sub2.case_year_number BETWEEN sub0.low_case_year_number = AND sub0.high_case_year_number

           &= nbsp;           &n= bsp;   THEN sub2.case_year_number ELSE NULL END) ELSE NULL = END) AS trial_filt_case_year_number,

          =           (CASE WHEN = sub2.grouping_flg =3D 'T' AND sub2.judge_wld_id =3D sub0.judge_wld_id = THEN (CASE WHEN sub2.case_year_number BETWEEN sub0.low_case_year_number = AND sub0.high_case_year_number

           &= nbsp;           &n= bsp;   THEN sub2.subcount ELSE NULL = END       ) ELSE NULL = END        ) AS = trial_filt_subcount,

          =           (CASE WHEN = sub1.grouping_flg =3D 'A'AND sub1.judge_wld_id =3D sub0.judge_wld_id = THEN sub1.case_year_number WHEN sub2.grouping_flg =3D 'A'   = AND sub2.judge_wld_id =3D sub0.judge_wld_id

           &= nbsp;           &n= bsp;   THEN sub2.case_year_number ELSE NULL = END         ) AS = appeal_unfilt_case_year_number,

          =           = (

        =             CASE = WHEN sub1.grouping_flg =3D 'A'

            =         AND sub1.judge_wld_id =3D = sub0.judge_wld_id THEN sub1.subcount WHEN sub2.grouping_flg =3D = 'A'

            =         AND sub2.judge_wld_id =3D = sub0.judge_wld_id THEN sub2.subcount ELSE NULL = END

          =           ) AS = appeal_unfilt_subcount,

          =           = (

            =         CASE WHEN sub1.grouping_flg = =3D 'A'

            =         AND sub1.judge_wld_id =3D = sub0.judge_wld_id THEN (

           &= nbsp;           &n= bsp;  CASE WHEN sub1.case_year_number BETWEEN = sub0.low_case_year_number

           &= nbsp;  =              = AND sub0.high_case_year_number THEN sub1.case_year_number ELSE NULL = END

            =         ) WHEN sub2.grouping_flg =3D = 'A'

            =         AND sub2.judge_wld_id =3D = sub0.judge_wld_id THEN (

           &= nbsp;  =              = CASE WHEN sub2.case_year_number BETWEEN = sub0.low_case_year_number

           &= nbsp;  =              = AND sub0.high_case_year_number THEN sub2.case_year_number ELSE NULL = END

            =         ) ELSE NULL = END

          =           ) AS = appeal_filt_case_year_number,

          =           = (

            =         CASE WHEN sub1.grouping_flg = =3D 'A'

            =         AND sub1.judge_wld_id =3D = sub0.judge_wld_id THEN (

           &= nbsp;  =              = CASE WHEN sub1.case_year_number BETWEEN = sub0.low_case_year_number

           &= nbsp;  =              = AND sub0.high_case_year_number THEN sub1.subcount ELSE NULL = END

            =         ) WHEN sub2.grouping_flg =3D = 'A'

            =         AND sub2.judge_wld_id =3D = sub0.judge_wld_id THEN (

           &= nbsp;  =              = CASE WHEN sub2.case_year_number BETWEEN = sub0.low_case_year_number

           &= nbsp;  =              = AND sub0.high_case_year_number THEN sub2.subcount ELSE NULL = END

            =         ) ELSE NULL = END

          =           ) AS = appeal_filt_subcount

        =        FROM ( SELECT 0104119201 AS = judge_wld_id,

           &= nbsp;  =             &= nbsp;      2013 AS = low_case_year_number,

           &= nbsp;  =             &= nbsp;      2023 AS = high_case_year_number,

           &= nbsp;  =             &= nbsp;      = judg1.judge_id,

           &= nbsp;  =             &= nbsp;      = judg1.display_name,

           &= nbsp;  =             &= nbsp;      = judg1.active_flag,

           &= nbsp;  =             &= nbsp;      = judg1.judge_court_level

            =            FROM = wln_mart.judge judg1

            =           WHERE = judg1.wld_id =3D 01041192

           &= nbsp;  =              =     AND judg1.profile_id =3D = 01

           &= nbsp;  =              =     AND (judg1.jrt_opt_out_flag <> 'Y' OR = judg1.jrt_opt_out_flag IS NULL)

          =           ) sub0 =

           &= nbsp;   LEFT OUTER JOIN

          =          (  SELECT = sub4.case_year_number,

           &= nbsp;  =             &= nbsp;      = sub4.judge_wld_id,

           &= nbsp;  =             &= nbsp;      = sub4.judge_id,

           &= nbsp;  =             &= nbsp;      = sub4.grouping_flg,

           &= nbsp;  =             &= nbsp;      COUNT(*) AS = subcount

            =           FROM  = (SELECT jrtf1.case_year_number,

           &= nbsp;      =             &= nbsp;  jrtf1.higher_judge_wld_id AS = judge_wld_id,

           &= nbsp;      =             &= nbsp;  jrtf1.higher_judge_id AS judge_id,

           &= nbsp;      =             &= nbsp;  'A' AS grouping_flg,

           &= nbsp;      =             &= nbsp;  jrtf1.case_document_id AS subcount

           &= nbsp;    =            =    FROM wln_mart.jrt_fact jrtf1

           &= nbsp;        =        GROUP BY = jrtf1.case_year_number,

           &= nbsp;      =             &= nbsp;  jrtf1.higher_judge_wld_id,

           &= nbsp;      =             &= nbsp;  jrtf1.higher_judge_id,

           &= nbsp;      =             &= nbsp;  jrtf1.case_document_id

           &= nbsp; =             &= nbsp;  ) sub4

            =     GROUP BY = sub4.case_year_number,

           &= nbsp;  =              =      sub4.judge_wld_id,

           &= nbsp;  =              =      sub4.judge_id,

           &= nbsp;  =              =      sub4.grouping_flg

          =         ) sub1 =

           &= nbsp;   ON sub1.judge_id =3D sub0.judge_id =

           &= nbsp; LEFT OUTER JOIN

          =        (SELECT = sub5.case_year_number,

           &= nbsp;  =              =     sub5.judge_wld_id,

           &= nbsp;  =              =     sub5.judge_id,

           &= nbsp;  =              =     sub5.grouping_flg,

           &= nbsp;  =              =     COUNT(*) AS subcount

            =        FROM (SELECT = jrtf2.case_year_number,

           &= nbsp;      =          =     jrtf2.lower_judge_wld_id AS = judge_wld_id,

           &= nbsp;      =          =     jrtf2.lower_judge_id AS = judge_id,

           &= nbsp;      =          =     (

           &= nbsp;        =             &= nbsp;       CASE WHEN = jrtf2.lower_judge_court_level_id =3D 1004 THEN 'T' ELSE 'A' = END

          =             &= nbsp;        ) AS = grouping_flg,

           &= nbsp;      =          =     jrtf2.case_document_id AS = subcount

           &= nbsp;        =        FROM wln_mart.jrt_fact = jrtf2

           &= nbsp;        =       WHERE = jrtf2.lower_judge_court_level_id > 1000

           &= nbsp;      =          AND = jrtf2.lower_judge_court_level_id <=3D 1004

           &= nbsp;           GROUP BY = jrtf2.case_year_number,        &n= bsp;         =

           &= nbsp;           &n= bsp;   =     jrtf2.lower_judge_wld_id,

           &= nbsp;      =          =     jrtf2.lower_judge_id,

           &= nbsp;      =          =     (

           &= nbsp;        =             &= nbsp;       CASE WHEN = jrtf2.lower_judge_court_level_id =3D 1004 THEN 'T' ELSE 'A' = END

           &= nbsp;      =          =     ),

           &= nbsp;      =          =     jrtf2.case_document_id

           &= nbsp;  =              =    ) sub5

            =   GROUP BY sub5.case_year_number,

           &= nbsp;  =              =    sub5.judge_wld_id,

           &= nbsp;  =              =    sub5.judge_id,

           &= nbsp;  =              =    sub5.grouping_flg

          =        ) sub2

        =      ON sub2.judge_id =3D = sub0.judge_id

      ) sub3

    GROUP BY sub3.judge_id,

      =      sub3.display_name,

       =       =      sub3.active_flag,

      =      sub3.judge_court_level

  ) = agg_sub,

  (SELECT = judge_id,

        (CASE WHEN (SUM = (appellate_flag) < (COUNT(*) / 2)) THEN 0 ELSE 1 = END    ) AS appellate_flag

     FROM (SELECT DISTINCT = jrtf.case_year_number,

          =      jrtf.case_document_id,

            =   jrtf.lower_judge_id,

          =      jrtf.higher_judge_id,

         =       (

            =         CASE WHEN = (

           &= nbsp;  =              = lower_judge_wld_id =3D 0104119201

           &= nbsp;  =              = AND lower_judge_court_level_id =3D 1004

            =   ) THEN 0 ELSE 1 END      ) AS = appellate_flag,

          =      (

            =         CASE WHEN lower_judge_wld_id = =3D 0104119201 THEN lower_judge_id ELSE higher_judge_id = END

          =      ) AS judge_id

            = FROM wln_mart.JRT_FACT jrtf

           WHERE = LOWER_JUDGE_WLD_ID =3D 0104119201

         =      OR HIGHER_JUDGE_WLD_ID =3D = 0104119201

        ORDER BY = case_year_number DESC

      ) sub0

  GROUP BY judge_id

  LIMIT 11

  ) = appellate_flag_sub

WHERE

  = Agg_sub.judge_id =3D appellate_flag_sub.judge_id

 

 

Postgres execution = plan (again very ugly and somewhat difficult to = read):

 

Nested Loop  = (cost=3D3465035.45..4564601.26 rows=3D1 width=3D345) (actual = time=3D35125.205..35125.631 rows=3D1 loops=3D1)

   Join Filter: (judg1.judge_id =3D (CASE WHEN = (jrtf.lower_judge_wld_id =3D '104119201'::numeric) THEN = jrtf.lower_judge_id ELSE jrtf.higher_judge_id = END))

   = Buffers: shared hit=3D734231, temp read=3D340089 = written=3D629776

   = ->  GroupAggregate  (cost=3D3423317.32..4522882.70 rows=3D1 = width=3D341) (actual time=3D35117.620..35117.989 rows=3D1 = loops=3D1)

         Group Key: = judg1.judge_id

         Buffers: shared = hit=3D732655, temp read=3D340089 = written=3D629776

         ->  = Nested Loop Left Join  (cost=3D3423317.32..4522882.01 rows=3D4 = width=3D261) (actual time=3D30839.132..35117.682 rows=3D39 = loops=3D1)

           &= nbsp;   Join Filter: (sub2.judge_id =3D = judg1.judge_id)

           &= nbsp;   Rows Removed by Join Filter: = 858300

           &= nbsp;   Buffers: shared hit=3D732655, temp read=3D340089 = written=3D629776

           &= nbsp;   ->  Nested Loop Left Join  = (cost=3D1504656.29..2084303.10 rows=3D2 width=3D205) (actual = time=3D19156.871..21775.159 rows=3D3 loops=3D1)

           &= nbsp;         Join Filter: = (sub4.judge_id =3D judg1.judge_id)

           &= nbsp;         Rows Removed by = Join Filter: 55263

           &= nbsp;         Buffers: shared = hit=3D368082, temp read=3D183477 = written=3D318607

           &= nbsp;         ->  Gather = Merge  (cost=3D5103.64..5103.76 rows=3D1 width=3D149) (actual = time=3D12.582..12.688 rows=3D1 loops=3D1)

           &= nbsp;           &n= bsp;   Workers Planned: 2

           &= nbsp;           &n= bsp;   Workers Launched: 2

           &= nbsp;           &n= bsp;   Buffers: shared hit=3D3525

           &= nbsp;           &n= bsp;   ->  Sort  (cost=3D4103.62..4103.62 = rows=3D1 width=3D149) (actual time=3D7.197..7.198 rows=3D0 = loops=3D3)

           &= nbsp;           &n= bsp;         Sort Key: = judg1.judge_id

           &= nbsp;           &n= bsp;         Sort Method: = quicksort  Memory: 25kB

           &= nbsp;           &n= bsp;         Buffers: shared = hit=3D3525

    =             &= nbsp;           &n= bsp;    Worker 0:  Sort Method: quicksort  = Memory: 25kB

           &= nbsp;           &n= bsp;         Worker 1:  = Sort Method: quicksort  Memory: 25kB

           &= nbsp;           &n= bsp;         ->  = Parallel Seq Scan on judge judg1  (cost=3D0.00..4103.61 rows=3D1 = width=3D149) (actual time=3D3.680..7.123 rows=3D0 = loops=3D3)

           &= nbsp;           &n= bsp;           &nb= sp;   Filter: (((jrt_opt_out_flag <> 'Y'::bpchar) OR = (jrt_opt_out_flag IS NULL)) AND (wld_id =3D 1041192) AND (profile_id =3D = 1))

           &= nbsp;           &n= bsp;           &nb= sp;   Rows Removed by Filter: 30107

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D3445

           &= nbsp;         ->  = GroupAggregate  (cost=3D1499552.65..2075175.87 rows=3D178821 = width=3D64) (actual time=3D16338.330..21757.982 rows=3D55266 = loops=3D1)

           &= nbsp;           &n= bsp;   Group Key: sub4.case_year_number, sub4.judge_wld_id, = sub4.judge_id, sub4.grouping_flg

           &= nbsp;           &n= bsp;   Buffers: shared hit=3D364557, temp read=3D183477 = written=3D318607

           &= nbsp;           &n= bsp;   ->  Incremental Sort  = (cost=3D1499552.65..2051035.07 rows=3D1788207 width=3D56) (actual = time=3D16338.158..20599.168 rows=3D4241689 = loops=3D1)

           &= nbsp;           &n= bsp;         Sort Key: = sub4.case_year_number, sub4.judge_wld_id, sub4.judge_id, = sub4.grouping_flg

           &= nbsp;  =             &= nbsp;      Presorted Key: = sub4.case_year_number, sub4.judge_wld_id, = sub4.judge_id

           &= nbsp;           &n= bsp;         Full-sort Groups: = 27027  Sort Method: quicksort  Average Memory: 30kB  Peak = Memory: 30kB

           &= nbsp;           &n= bsp;         Pre-sorted Groups: = 35815  Sort Method: quicksort  Average Memory: 367kB  = Peak Memory: 580kB

           &= nbsp;           &n= bsp;         Buffers: shared = hit=3D364557, temp read=3D183477 = written=3D318607

           &= nbsp;           &n= bsp;         ->  = Subquery Scan on sub4  (cost=3D1499549.72..1970473.37 = rows=3D1788207 width=3D56) (actual time=3D16337.913..18343.845 = rows=3D4241689 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D364557, temp read=3D183477 = written=3D318607

           &= nbsp;           &n= bsp;           &nb= sp;   ->  Group  (cost=3D1499549.72..1952591.30 = rows=3D1788207 width=3D64) (actual time=3D16337.912..17955.054 = rows=3D4241689 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Group Key: = jrtf1.case_year_number, jrtf1.higher_judge_wld_id, = jrtf1.higher_judge_id, jrtf1.case_document_id

           &= nbsp;    =             &= nbsp;           &n= bsp;    Buffers: shared hit=3D364557, temp = read=3D183477 written=3D318607

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Gather = Merge  (cost=3D1499549.72..1916827.16 rows=3D3576414 width=3D32) = (actual time=3D16337.908..17161.246 rows=3D4281068 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Workers Planned: 2

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Workers Launched: 2

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D364557, temp read=3D183477 = written=3D318607

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   ->  Sort  (cost=3D1498549.70..1503020.22 = rows=3D1788207 width=3D32) (actual time=3D15566.878..16546.347 = rows=3D1427023 loops=3D3)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;         Sort Key: = jrtf1.case_year_number, jrtf1.higher_judge_wld_id, = jrtf1.higher_judge_id, jrtf1.case_document_id

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;         Sort Method: external = sort  Disk: 84832kB

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;         Buffers: shared = hit=3D364557, temp read=3D183477 = written=3D318607

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;         Worker 0:  Sort = Method: external merge  Disk: 66904kB

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;         Worker 1:  Sort = Method: external merge  Disk: 63288kB

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;         ->  Partial = HashAggregate  (cost=3D1107519.33..1227268.67 rows=3D1788207 = width=3D32) (actual time=3D5553.846..8719.426 rows=3D1427023 = loops=3D3)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   Group Key: jrtf1.case_year_number, = jrtf1.higher_judge_wld_id, jrtf1.higher_judge_id, = jrtf1.case_document_id

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   Planned Partitions: 64  Batches: 65  Memory = Usage: 4129kB  Disk Usage: 389200kB

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   Buffers: shared hit=3D364511, temp read=3D128224 = written=3D263245

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   Worker 0:  Batches: 65  Memory Usage: = 4385kB  Disk Usage: 379912kB

   =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;           Worke= r 1:  Batches: 65  Memory Usage: 4129kB  Disk Usage: = 331784kB

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Append  (cost=3D0.00..476524.37 = rows=3D7450863 width=3D32) (actual time=3D0.005..1685.119 rows=3D5960690 = loops=3D3)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D364511

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2012 jrtf1_23  (cost=3D0.00..23580.92 = rows=3D400092 width=3D32) (actual time=3D0.003..189.362 rows=3D960222 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D19580

           &= nbsp;           &n= bsp;           &nb= sp;         =             &= nbsp;           -&= gt;  Parallel Seq Scan on jrt_fact_jrt_data_2011 jrtf1_22  = (cost=3D0.00..22933.88 rows=3D389088 width=3D32) (actual = time=3D0.003..182.503 rows=3D933812 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D19043

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2009 jrtf1_20  (cost=3D0.00..22423.17 = rows=3D380418 width=3D32) (actual time=3D0.005..175.891 rows=3D913002 = loops=3D1)

           &= nbsp;      =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;        Buffers: shared = hit=3D18619

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2010 jrtf1_21  (cost=3D0.00..22416.58 = rows=3D380358 width=3D32) (actual time=3D0.005..178.698 rows=3D912858 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D18613

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2014 jrtf1_25  (cost=3D0.00..22183.48 = rows=3D376348 width=3D32) (actual time=3D0.004..175.463 rows=3D903235 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D18420

           &= nbsp;           &n= bsp;           &nb= sp;         =             &= nbsp;           -&= gt;  Parallel Seq Scan on jrt_fact_jrt_data_2013 jrtf1_24  = (cost=3D0.00..22162.62 rows=3D376062 width=3D32) (actual = time=3D0.003..176.993 rows=3D902548 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D18402

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2008 jrtf1_19  (cost=3D0.00..21732.14 = rows=3D368714 width=3D32) (actual time=3D0.003..171.364 rows=3D884913 = loops=3D1)

           &= nbsp;      =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;        Buffers: shared = hit=3D18045

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2016 jrtf1_27  (cost=3D0.00..21579.48 = rows=3D366148 width=3D32) (actual time=3D0.004..172.011 rows=3D878756 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D17918

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2015 jrtf1_26  (cost=3D0.00..20912.87 = rows=3D354787 width=3D32) (actual time=3D0.004..166.035 rows=3D851489 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D17365

           &= nbsp;           &n= bsp;           &nb= sp;         =             &= nbsp;           -&= gt;  Parallel Seq Scan on jrt_fact_jrt_data_2020 jrtf1_31  = (cost=3D0.00..20362.25 rows=3D345825 width=3D32) (actual = time=3D0.004..163.649 rows=3D829980 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D16904

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2018 jrtf1_29  (cost=3D0.00..19945.36 = rows=3D338736 width=3D32) (actual time=3D0.006..158.181 rows=3D812966 = loops=3D1)

           &= nbsp;      =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;        Buffers: shared = hit=3D16558

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2017 jrtf1_28  (cost=3D0.00..19603.33 = rows=3D332833 width=3D32) (actual time=3D0.004..148.015 rows=3D798799 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D16275

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2007 jrtf1_18  (cost=3D0.00..19034.05 = rows=3D322905 width=3D32) (actual time=3D0.004..50.705 rows=3D258324 = loops=3D3)

           &= nbsp;           &n= bsp;           &nb= sp;  =             &= nbsp;           &n= bsp;           &nb= sp;Buffers: shared hit=3D15805

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2021 jrtf1_32  (cost=3D0.00..18341.26 = rows=3D311526 width=3D32) (actual time=3D0.012..75.774 rows=3D373832 = loops=3D2)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D15226

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2006 jrtf1_17  (cost=3D0.00..18268.52 = rows=3D309952 width=3D32) (actual time=3D0.003..147.744 rows=3D743884 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D15169

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2005 jrtf1_16  (cost=3D0.00..17316.05 = rows=3D293805 width=3D32) (actual time=3D0.003..140.591 rows=3D705132 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D14378

  =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;      ->  Parallel Seq Scan on = jrt_fact_jrt_data_2019 jrtf1_30  (cost=3D0.00..17285.60 = rows=3D293560 width=3D32) (actual time=3D0.003..139.968 rows=3D704543 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   =             &= nbsp;           &n= bsp;           Buf= fers: shared hit=3D14350

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2022 jrtf1_33  (cost=3D0.00..16051.71 = rows=3D272771 width=3D32) (actual time=3D0.003..131.590 rows=3D654650 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D13324

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2004 jrtf1_15  (cost=3D0.00..15976.81 = rows=3D271081 width=3D32) (actual time=3D0.004..128.956 rows=3D650595 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D13266

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2003 jrtf1_14  (cost=3D0.00..15556.01 = rows=3D264001 width=3D32) (actual time=3D0.003..124.530 rows=3D633603 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D12916

  =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;      ->  Parallel Seq Scan on = jrt_fact_jrt_data_2002 jrtf1_13  (cost=3D0.00..14649.39 = rows=3D248639 width=3D32) (actual time=3D0.003..120.979 rows=3D596733 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   =             &= nbsp;           &n= bsp;           Buf= fers: shared hit=3D12163

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2001 jrtf1_12  (cost=3D0.00..12176.08 = rows=3D206708 width=3D32) (actual time=3D0.004..96.162 rows=3D496100 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D10109

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2000 jrtf1_11  (cost=3D0.00..10938.86 = rows=3D185686 width=3D32) (actual time=3D0.004..87.876 rows=3D445646 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D9082

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_2023 jrtf1_34  (cost=3D0.00..3574.86 = rows=3D80086 width=3D32) (actual time=3D0.002..27.656 rows=3D136147 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D2774

         =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;           ->=   Parallel Seq Scan on jrt_fact_jrt_data_1999 jrtf1_10  = (cost=3D0.00..182.73 rows=3D4073 width=3D32) (actual time=3D0.002..1.380 = rows=3D6924 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;      =             &= nbsp;        Buffers: shared = hit=3D142

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_1990 jrtf1_1  (cost=3D0.00..42.31 = rows=3D931 width=3D33) (actual time=3D0.002..0.292 rows=3D1583 = loops=3D1)

   =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;           Buffer= s: shared hit=3D33

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_1998 jrtf1_9  (cost=3D0.00..23.00 = rows=3D500 width=3D33) (actual time=3D0.002..0.176 rows=3D850 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D18

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_1997 jrtf1_8  (cost=3D0.00..6.20 = rows=3D120 width=3D32) (actual time=3D0.002..0.042 rows=3D204 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;  =             &= nbsp;           &n= bsp;Buffers: shared hit=3D5

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_1995 jrtf1_6  (cost=3D0.00..3.77 = rows=3D77 width=3D33) (actual time=3D0.001..0.025 rows=3D131 = loops=3D1)

    =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;          Buffers: = shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_1996 jrtf1_7  (cost=3D0.00..2.40 = rows=3D40 width=3D33) (actual time=3D0.002..0.016 rows=3D68 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D2

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_1992 jrtf1_3  (cost=3D0.00..1.12 = rows=3D12 width=3D33) (actual time=3D0.001..0.005 rows=3D20 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D1

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_1994 jrtf1_5  (cost=3D0.00..1.12 = rows=3D12 width=3D33) (actual time=3D0.001..0.005 rows=3D20 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D1

           &= nbsp;           &n= bsp;    =             &= nbsp;           &n= bsp;           &nb= sp;    ->  Parallel Seq Scan on = jrt_fact_jrt_data_1991 jrtf1_2  (cost=3D0.00..1.11 rows=3D11 = width=3D33) (actual time=3D0.003..0.006 rows=3D19 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =    Buffers: shared hit=3D1

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         ->  Parallel = Seq Scan on jrt_fact_jrt_data_1993 jrtf1_4  (cost=3D0.00..1.01 = rows=3D1 width=3D31) (actual time=3D0.004..0.005 rows=3D1 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp; =             &= nbsp;           &n= bsp;           &nb= sp; Buffers: shared hit=3D1

           &= nbsp;   ->  Materialize  = (cost=3D1918661.03..2431740.34 rows=3D178821 width=3D64) (actual = time=3D3447.156..4418.543 rows=3D286113 = loops=3D3)

           &= nbsp;         Buffers: shared = hit=3D364573, temp read=3D156612 = written=3D311169

           &= nbsp;         ->  = Subquery Scan on sub2  (cost=3D1918661.03..2428925.23 rows=3D178821 = width=3D64) (actual time=3D10341.437..13089.234 rows=3D286113 = loops=3D1)

           &= nbsp;           &n= bsp;   Buffers: shared hit=3D364573, temp read=3D153118 = written=3D309422

           &= nbsp;           &n= bsp;   ->  GroupAggregate  = (cost=3D1918661.03..2427137.02 rows=3D178821 width=3D64) (actual = time=3D10341.436..13057.326 rows=3D286113 = loops=3D1)

           &= nbsp;           &n= bsp;         Group Key: = jrtf2.case_year_number, jrtf2.lower_judge_wld_id, jrtf2.lower_judge_id, = (CASE WHEN (jrtf2.lower_judge_court_level_id =3D 1004) THEN 'T'::text = ELSE 'A'::text END)

           &= nbsp;           &n= bsp;         Buffers: shared = hit=3D364573, temp read=3D153118 = written=3D309422

           &= nbsp;           &n= bsp;         ->  = Group  (cost=3D1918661.03..2385114.15 rows=3D1788207 width=3D64) = (actual time=3D10341.423..12590.803 rows=3D1610264 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Group Key: jrtf2.case_year_number, = jrtf2.lower_judge_wld_id, jrtf2.lower_judge_id, (CASE WHEN = (jrtf2.lower_judge_court_level_id =3D 1004) THEN 'T'::text ELSE = 'A'::text END), jrtf2.case_document_id

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D364573, temp read=3D153118 = written=3D309422

           &= nbsp;           &n= bsp;           &nb= sp;   ->  Gather Merge  = (cost=3D1918661.03..2335938.46 rows=3D3576414 width=3D64) (actual = time=3D10341.420..12232.748 rows=3D1623917 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Workers Planned: = 2

           &= nbsp;           &n= bsp;           &nb= sp;         Workers Launched: = 2

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D364573, temp read=3D153118 = written=3D309422

           &= nbsp;           &n= bsp;           &nb= sp;         ->  = Sort  (cost=3D1917661.00..1922131.52 rows=3D1788207 width=3D64) = (actual time=3D10205.573..10833.131 rows=3D541306 = loops=3D3)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Sort Key: jrtf2.case_year_number, = jrtf2.lower_judge_wld_id, jrtf2.lower_judge_id, (CASE WHEN = (jrtf2.lower_judge_court_level_id =3D 1004) THEN 'T'::text ELSE = 'A'::text END), jrtf2.case_document_id

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Sort Method: external merge  Disk: = 32608kB

           =             &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D364573, temp read=3D153118 = written=3D309422

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Worker 0:  Sort Method: external merge  Disk: = 30520kB

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Worker 1:  Sort Method: external merge  Disk: = 29224kB

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   ->  Partial HashAggregate  = (cost=3D1415055.25..1597484.97 rows=3D1788207 width=3D64) (actual = time=3D6980.371..9061.054 rows=3D541306 = loops=3D3)

           &= nbsp;       =             &= nbsp;           &n= bsp;           &nb= sp; Group Key: jrtf2.case_year_number, jrtf2.lower_judge_wld_id, = jrtf2.lower_judge_id, (CASE WHEN (jrtf2.lower_judge_court_level_id =3D = 1004) THEN 'T'::text ELSE 'A'::text END), = jrtf2.case_document_id

           &= nbsp;           =             &= nbsp;           &n= bsp;         Planned = Partitions: 128  Batches: 129  Memory Usage: 4633kB  Disk = Usage: 462856kB

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;         Buffers: shared = hit=3D364511, temp read=3D141574 = written=3D297838

           &= nbsp;           =             &= nbsp;           &n= bsp;         Worker = 0:  Batches: 129  Memory Usage: 4129kB  Disk Usage: = 411656kB

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;         Worker 1:  = Batches: 129  Memory Usage: 4641kB  Disk Usage: = 389128kB

           &= nbsp;           &n= bsp;     =             &= nbsp;           &n= bsp;   ->  Parallel Append  = (cost=3D0.00..532593.66 rows=3D7450863 width=3D64) (actual = time=3D0.006..1784.406 rows=3D5960690 loops=3D3)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   Buffers: shared hit=3D364511

           &= nbsp;         =             &= nbsp;           &n= bsp;           &nb= sp;     ->  Parallel Seq Scan on = jrt_fact_jrt_data_2012 jrtf2_23  (cost=3D0.00..26581.62 = rows=3D400092 width=3D64) (actual time=3D0.005..216.086 rows=3D960222 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D19580

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2011 = jrtf2_22  (cost=3D0.00..25852.05 rows=3D389088 width=3D64) (actual = time=3D0.004..205.289 rows=3D933812 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D19043

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2009 = jrtf2_20  (cost=3D0.00..25276.31 rows=3D380418 width=3D64) (actual = time=3D0.006..195.529 rows=3D913002 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

    =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;    Buffers: shared = hit=3D18619

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2010 = jrtf2_21  (cost=3D0.00..25269.26 rows=3D380358 width=3D64) (actual = time=3D0.007..198.928 rows=3D912858 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;    =             &= nbsp;    Buffers: shared = hit=3D18613

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2014 = jrtf2_25  (cost=3D0.00..25006.09 rows=3D376348 width=3D64) (actual = time=3D0.005..193.307 rows=3D903235 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D18420

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2013 = jrtf2_24  (cost=3D0.00..24983.08 rows=3D376062 width=3D64) (actual = time=3D0.005..199.091 rows=3D902548 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;       =             &= nbsp;           &n= bsp; Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D18402

           &= nbsp;           &n= bsp;           &nb= sp;            =             &= nbsp;  ->  Parallel Seq Scan on jrt_fact_jrt_data_2008 = jrtf2_19  (cost=3D0.00..24497.49 rows=3D368714 width=3D64) (actual = time=3D0.006..189.346 rows=3D884913 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D18045

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2016 = jrtf2_27  (cost=3D0.00..24325.59 rows=3D366148 width=3D64) (actual = time=3D0.006..195.816 rows=3D878756 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D17918

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2015 = jrtf2_26  (cost=3D0.00..23573.77 rows=3D354787 width=3D64) (actual = time=3D0.006..186.719 rows=3D851489 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;       =             &= nbsp;           &n= bsp;           &nb= sp; Buffers: shared hit=3D17365

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2020 = jrtf2_31  (cost=3D0.00..22955.94 rows=3D345825 width=3D64) (actual = time=3D0.005..184.122 rows=3D829980 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D16904

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2018 = jrtf2_29  (cost=3D0.00..22485.88 rows=3D338736 width=3D64) (actual = time=3D0.006..173.993 rows=3D812966 loops=3D1)

           &= nbsp;           &n= bsp;   =             &= nbsp;           &n= bsp;           &nb= sp;     Filter: ((lower_judge_court_level_id = > 1000) AND (lower_judge_court_level_id <=3D = 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D16558

           &= nbsp;           &n= bsp;        =             &= nbsp;           &n= bsp;      ->  Parallel Seq Scan on = jrt_fact_jrt_data_2017 jrtf2_28  (cost=3D0.00..22099.58 = rows=3D332833 width=3D64) (actual time=3D0.006..176.179 rows=3D798799 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D16275

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2007 = jrtf2_18  (cost=3D0.00..21455.84 rows=3D322905 width=3D64) (actual = time=3D0.007..82.994 rows=3D387486 loops=3D2)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D15805

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2021 = jrtf2_32  (cost=3D0.00..20677.71 rows=3D311526 width=3D64) (actual = time=3D0.011..86.729 rows=3D373832 loops=3D2)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;     =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D15226

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2006 = jrtf2_17  (cost=3D0.00..20593.16 rows=3D309952 width=3D64) (actual = time=3D0.005..160.160 rows=3D743884 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D15169

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2005 = jrtf2_16  (cost=3D0.00..19519.59 rows=3D293805 width=3D64) (actual = time=3D0.006..153.430 rows=3D705132 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;            =             &= nbsp;        Buffers: shared = hit=3D14378

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2019 = jrtf2_30  (cost=3D0.00..19487.29 rows=3D293560 width=3D64) (actual = time=3D0.004..156.767 rows=3D704543 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D14350

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;  ->  Parallel Seq Scan on jrt_fact_jrt_data_2022 = jrtf2_33  (cost=3D0.00..18097.49 rows=3D272771 width=3D64) (actual = time=3D0.006..147.439 rows=3D654650 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;        =             &= nbsp;           &n= bsp;Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D13324

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p; =             &= nbsp; ->  Parallel Seq Scan on jrt_fact_jrt_data_2004 = jrtf2_15  (cost=3D0.00..18009.92 rows=3D271081 width=3D64) (actual = time=3D0.005..143.933 rows=3D650595 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D13266

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2003 = jrtf2_14  (cost=3D0.00..17536.02 rows=3D264001 width=3D64) (actual = time=3D0.006..140.594 rows=3D633603 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D12916

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2002 = jrtf2_13  (cost=3D0.00..16514.18 rows=3D248639 width=3D64) (actual = time=3D0.005..132.336 rows=3D596733 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;        =             &= nbsp;           &n= bsp;           &nb= sp;Buffers: shared hit=3D12163

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2001 = jrtf2_12  (cost=3D0.00..13726.40 rows=3D206708 width=3D64) (actual = time=3D0.005..109.974 rows=3D496100 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D10109

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_2000 = jrtf2_11  (cost=3D0.00..12331.50 rows=3D185686 width=3D64) (actual = time=3D0.005..98.570 rows=3D445646 loops=3D1)

           &= nbsp;           &n= bsp;     =             &= nbsp;           &n= bsp;           &nb= sp;   Filter: ((lower_judge_court_level_id > 1000) AND = (lower_judge_court_level_id <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D9082

           &= nbsp;           &n= bsp;           =             &= nbsp;           &n= bsp;   ->  Parallel Seq Scan on = jrt_fact_jrt_data_2023 jrtf2_34  (cost=3D0.00..4175.51 rows=3D80086 = width=3D64) (actual time=3D0.003..31.980 rows=3D136147 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D2774

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_1999 = jrtf2_10  (cost=3D0.00..213.28 rows=3D4073 width=3D64) (actual = time=3D0.003..1.614 rows=3D6924 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D142

       =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;       ->  Parallel Seq = Scan on jrt_fact_jrt_data_1990 jrtf2_1  (cost=3D0.00..49.30 = rows=3D931 width=3D64) (actual time=3D0.003..0.370 rows=3D1583 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D33

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_1998 = jrtf2_9  (cost=3D0.00..26.75 rows=3D500 width=3D64) (actual = time=3D0.003..0.199 rows=3D850 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D18

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_1997 = jrtf2_8  (cost=3D0.00..7.10 rows=3D120 width=3D64) (actual = time=3D0.003..0.049 rows=3D204 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;        =             &= nbsp;           &n= bsp;           &nb= sp;Buffers: shared hit=3D5

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_1995 = jrtf2_6  (cost=3D0.00..4.35 rows=3D77 width=3D64) (actual = time=3D0.002..0.030 rows=3D131 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D3

       =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;       ->  Parallel Seq = Scan on jrt_fact_jrt_data_1996 jrtf2_7  (cost=3D0.00..2.70 = rows=3D40 width=3D64) (actual time=3D0.003..0.018 rows=3D68 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D2

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_1992 = jrtf2_3  (cost=3D0.00..1.21 rows=3D12 width=3D64) (actual = time=3D0.002..0.006 rows=3D20 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D1

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_1994 = jrtf2_5  (cost=3D0.00..1.21 rows=3D12 width=3D64) (actual = time=3D0.002..0.006 rows=3D20 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;       =             &= nbsp;           &n= bsp; Buffers: shared hit=3D1

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;   ->  Parallel Seq Scan on jrt_fact_jrt_data_1991 = jrtf2_2  (cost=3D0.00..1.20 rows=3D11 width=3D64) (actual = time=3D0.003..0.007 rows=3D19 loops=3D1)

          =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;          Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D1

           &= nbsp;       =             &= nbsp;           &n= bsp;           &nb= sp;       ->  Parallel Seq = Scan on jrt_fact_jrt_data_1993 jrtf2_4  (cost=3D0.00..1.01 rows=3D1 = width=3D64) (actual time=3D0.008..0.009 rows=3D1 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Filter: = ((lower_judge_court_level_id > 1000) AND (lower_judge_court_level_id = <=3D 1004))

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;         Buffers: shared = hit=3D1

   = ->  Limit  (cost=3D41718.13..41718.30 rows=3D11 width=3D12) = (actual time=3D7.581..7.636 rows=3D1 loops=3D1)

         Buffers: shared = hit=3D1576

         ->  = HashAggregate  (cost=3D41718.13..41721.13 rows=3D200 width=3D12) = (actual time=3D7.580..7.635 rows=3D1 loops=3D1)

         =       Group Key: (CASE WHEN = (jrtf.lower_judge_wld_id =3D '104119201'::numeric) THEN = jrtf.lower_judge_id ELSE jrtf.higher_judge_id = END)

           &= nbsp;   Batches: 1  Memory Usage: = 40kB

           &= nbsp;   Buffers: shared hit=3D1576

           &= nbsp;   ->  Unique  (cost=3D41305.59..41511.86 = rows=3D11787 width=3D44) (actual time=3D6.612..7.496 rows=3D763 = loops=3D1)

           &= nbsp;         Buffers: shared = hit=3D1576

           &= nbsp;         ->  = Sort  (cost=3D41305.59..41335.06 rows=3D11787 width=3D44) (actual = time=3D6.611..6.870 rows=3D4564 loops=3D1)

        =             &= nbsp;      Sort Key: jrtf.case_year_number = DESC, jrtf.case_document_id, jrtf.lower_judge_id, jrtf.higher_judge_id, = (CASE WHEN ((jrtf.lower_judge_wld_id =3D '104119201'::numeric) AND = (jrtf.lower_judge_court_level_id =3D 1004)) THEN 0 ELSE 1 END), (CASE = WHEN (j

rtf.lower_judge_wld_id =3D '104119201'::numeric) THEN = jrtf.lower_judge_id ELSE jrtf.higher_judge_id = END)

           &= nbsp;           &n= bsp;   Sort Method: quicksort  Memory: = 549kB

           &= nbsp;           &n= bsp;   Buffers: shared hit=3D1576

           &= nbsp;           &n= bsp;   ->  Append  (cost=3D8.57..40508.50 = rows=3D11787 width=3D44) (actual time=3D0.450..4.946 rows=3D4564 = loops=3D1)

           &= nbsp;           &n= bsp;         Buffers: shared = hit=3D1573

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_1990 jrtf_1  (cost=3D8.57..12.59 = rows=3D1 width=3D44) (actual time=3D0.017..0.019 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D4

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D8.57..8.57 rows=3D1 = width=3D0) (actual time=3D0.015..0.016 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D4

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_1990_lower_judge_wld_id_idx  = (cost=3D0.00..4.29 rows=3D1 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;  Buffers: shared hit=3D2

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_1990_higher_judge_wld_id_idx  = (cost=3D0.00..4.29 rows=3D1 width=3D0) (actual time=3D0.006..0.006 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D2

           &= nbsp;           &n= bsp;         ->  Seq = Scan on jrt_fact_jrt_data_1991 jrtf_2  (cost=3D0.00..1.29 rows=3D1 = width=3D44) (actual time=3D0.012..0.013 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Filter: ((lower_judge_wld_id =3D '104119201'::numeric) = OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp; =             &= nbsp; Rows Removed by Filter: 19

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D1

           &= nbsp;           &n= bsp;         ->  Seq = Scan on jrt_fact_jrt_data_1992 jrtf_3  (cost=3D0.00..1.31 rows=3D1 = width=3D44) (actual time=3D0.009..0.009 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Filter: ((lower_judge_wld_id =3D '104119201'::numeric) = OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Rows Removed by Filter: 20

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D1

           &= nbsp;           &n= bsp;         ->  Seq = Scan on jrt_fact_jrt_data_1993 jrtf_4  (cost=3D0.00..1.02 rows=3D1 = width=3D44) (actual time=3D0.003..0.004 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Filter: ((lower_judge_wld_id =3D '104119201'::numeric) = OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Rows Removed by Filter: 1

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D1

           &= nbsp;           &n= bsp;         ->  Seq = Scan on jrt_fact_jrt_data_1994 jrtf_5  (cost=3D0.00..1.31 rows=3D1 = width=3D44) (actual time=3D0.009..0.009 rows=3D0 = loops=3D1)

           &= nbsp;         =             &= nbsp;     Filter: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Rows Removed by Filter: 20

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D1

         =             &= nbsp;           -&= gt;  Seq Scan on jrt_fact_jrt_data_1995 jrtf_6  = (cost=3D0.00..4.97 rows=3D1 width=3D44) (actual time=3D0.058..0.058 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Filter: ((lower_judge_wld_id =3D '104119201'::numeric) = OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Rows Removed by Filter: 131

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Seq = Scan on jrt_fact_jrt_data_1996 jrtf_7  (cost=3D0.00..3.03 rows=3D1 = width=3D44) (actual time=3D0.026..0.026 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Filter: ((lower_judge_wld_id =3D '104119201'::numeric) = OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Rows Removed by Filter: 68

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D2

           &= nbsp;           &n= bsp;         ->  Seq = Scan on jrt_fact_jrt_data_1997 jrtf_8  (cost=3D0.00..8.07 rows=3D1 = width=3D44) (actual time=3D0.059..0.059 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;    =            Filter:= ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Rows Removed by Filter: 204

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D5

           &= nbsp;   =             &= nbsp;     ->  Bitmap Heap Scan on = jrt_fact_jrt_data_1998 jrtf_9  (cost=3D8.57..14.62 rows=3D2 = width=3D44) (actual time=3D0.012..0.013 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D4

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D8.57..8.57 rows=3D2 = width=3D0) (actual time=3D0.011..0.012 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D4

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_1998_lower_judge_wld_id_idx  = (cost=3D0.00..4.28 rows=3D1 width=3D0) (actual time=3D0.005..0.005 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D2

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_1998_higher_judge_wld_id_idx  = (cost=3D0.00..4.29 rows=3D2 width=3D0) (actual time=3D0.005..0.005 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;    =             &= nbsp;          Buffers:= shared hit=3D2

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_1999 jrtf_10  (cost=3D8.68..51.80 = rows=3D14 width=3D44) (actual time=3D0.014..0.016 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D4

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D8.68..8.68 rows=3D14 = width=3D0) (actual time=3D0.013..0.015 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D4

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_1999_lower_judge_wld_id_idx  = (cost=3D0.00..4.33 rows=3D7 width=3D0) (actual time=3D0.006..0.006 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D2

           &= nbsp;           &n= bsp;            =          ->  Bitmap = Index Scan on jrt_fact_jrt_data_1999_higher_judge_wld_id_idx  = (cost=3D0.00..4.33 rows=3D7 width=3D0) (actual time=3D0.006..0.006 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D2

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2000 jrtf_11  (cost=3D10.74..839.39 = rows=3D237 width=3D44) (actual time=3D0.018..0.019 rows=3D0 = loops=3D1)

    =             &= nbsp;           &n= bsp;          Recheck = Cond: ((lower_judge_wld_id =3D '104119201'::numeric) OR = (higher_judge_wld_id =3D '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D10.74..10.74 = rows=3D237 width=3D0) (actual time=3D0.017..0.018 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2000_lower_judge_wld_id_idx  = (cost=3D0.00..4.83 rows=3D55 width=3D0) (actual time=3D0.009..0.009 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2000_higher_judge_wld_id_idx  = (cost=3D0.00..5.79 rows=3D182 width=3D0) (actual time=3D0.007..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2001 jrtf_12  (cost=3D10.87..898.62 = rows=3D253 width=3D44) (actual time=3D0.017..0.018 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D10.87..10.87 = rows=3D253 width=3D0) (actual time=3D0.016..0.016 rows=3D0 = loops=3D1)

  =             &= nbsp;           &n= bsp;           &nb= sp;      Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2001_lower_judge_wld_id_idx  = (cost=3D0.00..4.85 rows=3D57 width=3D0) (actual time=3D0.007..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2001_higher_judge_wld_id_idx  = (cost=3D0.00..5.89 rows=3D196 width=3D0) (actual time=3D0.007..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;   =             &= nbsp;           Bu= ffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2002 jrtf_13  (cost=3D15.27..1074.10 = rows=3D301 width=3D44) (actual time=3D0.018..0.020 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D15.27..15.27 = rows=3D301 width=3D0) (actual time=3D0.017..0.018 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2002_lower_judge_wld_id_idx  = (cost=3D0.00..4.92 rows=3D66 width=3D0) (actual time=3D0.009..0.009 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;   =             &= nbsp;     ->  Bitmap Index Scan on = jrt_fact_jrt_data_2002_higher_judge_wld_id_idx  (cost=3D0.00..10.20 = rows=3D236 width=3D0) (actual time=3D0.007..0.008 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2003 jrtf_14  (cost=3D15.46..1158.27 = rows=3D326 width=3D44) (actual time=3D0.018..0.020 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D15.46..15.46 = rows=3D326 width=3D0) (actual time=3D0.017..0.018 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2003_lower_judge_wld_id_idx  = (cost=3D0.00..4.95 rows=3D70 width=3D0) (actual time=3D0.008..0.009 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2003_higher_judge_wld_id_idx  = (cost=3D0.00..10.35 rows=3D256 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2004 jrtf_15  (cost=3D15.55..1196.85 = rows=3D337 width=3D44) (actual time=3D0.019..0.021 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D15.55..15.55 = rows=3D337 width=3D0) (actual time=3D0.018..0.019 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2004_lower_judge_wld_id_idx  = (cost=3D0.00..4.96 rows=3D72 width=3D0) (actual time=3D0.007..0.007 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2004_higher_judge_wld_id_idx  = (cost=3D0.00..10.41 rows=3D265 width=3D0) (actual time=3D0.010..0.010 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;  =             &= nbsp;      ->  Bitmap Heap Scan on = jrt_fact_jrt_data_2005 jrtf_16  (cost=3D15.85..1329.50 rows=3D375 = width=3D44) (actual time=3D0.017..0.019 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D15.85..15.85 = rows=3D375 width=3D0) (actual time=3D0.016..0.017 rows=3D0 = loops=3D1)

           &= nbsp;   =             &= nbsp;           &n= bsp;     Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2005_lower_judge_wld_id_idx  = (cost=3D0.00..5.02 rows=3D80 width=3D0) (actual time=3D0.007..0.008 = rows=3D0 loops=3D1)

           =             &= nbsp;           &n= bsp;           &nb= sp;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2005_higher_judge_wld_id_idx  = (cost=3D0.00..10.64 rows=3D295 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;   =             B= uffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2006 jrtf_17  (cost=3D15.98..1387.33 = rows=3D391 width=3D44) (actual time=3D0.019..0.020 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D15.98..15.98 = rows=3D391 width=3D0) (actual time=3D0.018..0.019 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2006_lower_judge_wld_id_idx  = (cost=3D0.00..5.04 rows=3D82 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp; =             &= nbsp;           &n= bsp;           &nb= sp; Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2006_higher_judge_wld_id_idx  = (cost=3D0.00..10.74 rows=3D309 width=3D0) (actual time=3D0.009..0.009 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2007 jrtf_18  (cost=3D16.09..1434.30 = rows=3D405 width=3D44) (actual time=3D0.017..0.019 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp; =             &= nbsp;           &n= bsp; Buffers: shared hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D16.09..16.09 = rows=3D405 width=3D0) (actual time=3D0.016..0.017 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D6

         =             &= nbsp;           &n= bsp;           -&g= t;  Bitmap Index Scan on = jrt_fact_jrt_data_2007_lower_judge_wld_id_idx  (cost=3D0.00..5.05 = rows=3D83 width=3D0) (actual time=3D0.008..0.008 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2007_higher_judge_wld_id_idx  = (cost=3D0.00..10.84 rows=3D322 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2008 jrtf_19  (cost=3D16.54..1633.45 = rows=3D461 width=3D44) (actual time=3D0.018..0.019 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D16.54..16.54 = rows=3D461 width=3D0) (actual time=3D0.016..0.018 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;    =             &= nbsp;    Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2008_lower_judge_wld_id_idx  = (cost=3D0.00..5.12 rows=3D93 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;            =             &= nbsp;           &n= bsp;  Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2008_higher_judge_wld_id_idx  = (cost=3D0.00..11.19 rows=3D368 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2009 jrtf_20  (cost=3D16.65..1683.32 = rows=3D475 width=3D44) (actual time=3D0.018..0.019 rows=3D0 = loops=3D1)

            =             &= nbsp;           &n= bsp;  Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D16.65..16.65 = rows=3D475 width=3D0) (actual time=3D0.017..0.018 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2009_lower_judge_wld_id_idx  = (cost=3D0.00..5.12 rows=3D93 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2009_higher_judge_wld_id_idx  = (cost=3D0.00..11.29 rows=3D382 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2010 jrtf_21  (cost=3D16.63..1673.33 = rows=3D472 width=3D44) (actual time=3D0.018..0.020 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D6

            =             &= nbsp;           &n= bsp;  ->  BitmapOr  (cost=3D16.63..16.63 = rows=3D472 width=3D0) (actual time=3D0.017..0.018 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2010_lower_judge_wld_id_idx  = (cost=3D0.00..5.13 rows=3D94 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp; =             &= nbsp;           &n= bsp; Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2010_higher_judge_wld_id_idx  = (cost=3D0.00..11.26 rows=3D378 width=3D0) (actual time=3D0.007..0.008 = rows=3D0 loops=3D1)

            =             &= nbsp;           &n= bsp;           &nb= sp;  Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2011 jrtf_22  (cost=3D16.91..1791.83 = rows=3D508 width=3D44) (actual time=3D0.024..0.026 rows=3D2 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp; =             &= nbsp; Heap Blocks: exact=3D1

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D7

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D16.91..16.91 = rows=3D508 width=3D0) (actual time=3D0.017..0.018 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;    =             &= nbsp;    Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2011_lower_judge_wld_id_idx  = (cost=3D0.00..5.14 rows=3D95 width=3D0) (actual time=3D0.009..0.009 = rows=3D2 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2011_higher_judge_wld_id_idx  = (cost=3D0.00..11.52 rows=3D413 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;      =             &= nbsp;  ->  Bitmap Heap Scan on jrt_fact_jrt_data_2012 = jrtf_23  (cost=3D16.99..1828.27 rows=3D518 width=3D44) (actual = time=3D0.052..0.142 rows=3D187 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Heap Blocks: exact=3D19

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D25

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D16.99..16.99 = rows=3D518 width=3D0) (actual time=3D0.042..0.043 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2012_lower_judge_wld_id_idx  = (cost=3D0.00..5.16 rows=3D98 width=3D0) (actual time=3D0.028..0.028 = rows=3D150 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp; =             &= nbsp;       ->  Bitmap Index = Scan on jrt_fact_jrt_data_2012_higher_judge_wld_id_idx  = (cost=3D0.00..11.58 rows=3D420 width=3D0) (actual time=3D0.013..0.013 = rows=3D37 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2013 jrtf_24  (cost=3D16.81..1744.81 = rows=3D495 width=3D44) (actual time=3D0.063..0.170 rows=3D210 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Heap Blocks: exact=3D31

           &= nbsp;           &n= bsp;          =      Buffers: shared = hit=3D37

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D16.81..16.81 = rows=3D495 width=3D0) (actual time=3D0.052..0.053 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;     =             &= nbsp;   ->  Bitmap Index Scan on = jrt_fact_jrt_data_2013_lower_judge_wld_id_idx  (cost=3D0.00..5.12 = rows=3D93 width=3D0) (actual time=3D0.043..0.044 rows=3D210 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2013_higher_judge_wld_id_idx  = (cost=3D0.00..11.44 rows=3D402 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2014 jrtf_25  (cost=3D16.83..1754.81 = rows=3D498 width=3D44) (actual time=3D0.047..0.138 rows=3D175 = loops=3D1)

          =             &= nbsp;           &n= bsp;    Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Heap Blocks: exact=3D25

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D31

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D16.83..16.83 = rows=3D498 width=3D0) (actual time=3D0.038..0.039 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2014_lower_judge_wld_id_idx  = (cost=3D0.00..5.13 rows=3D94 width=3D0) (actual time=3D0.029..0.030 = rows=3D175 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

       =             &= nbsp;           &n= bsp;           &nb= sp;       Buffers: shared = hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2014_higher_judge_wld_id_idx  = (cost=3D0.00..11.46 rows=3D404 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2015 jrtf_26  (cost=3D16.70..1695.12 = rows=3D482 width=3D44) (actual time=3D0.056..0.183 rows=3D268 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

     =             &= nbsp;           &n= bsp;         Heap Blocks: = exact=3D28

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D34

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D16.70..16.70 = rows=3D482 width=3D0) (actual time=3D0.047..0.048 rows=3D0 = loops=3D1)

      =             &= nbsp;           &n= bsp;           &nb= sp;  Buffers: shared hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2015_lower_judge_wld_id_idx  = (cost=3D0.00..5.09 rows=3D89 width=3D0) (actual time=3D0.038..0.038 = rows=3D268 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2015_higher_judge_wld_id_idx  = (cost=3D0.00..11.37 rows=3D392 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;    =             &= nbsp;          Buffers:= shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2016 jrtf_27  (cost=3D39.15..4057.93 = rows=3D1286 width=3D44) (actual time=3D0.108..0.392 rows=3D589 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Heap Blocks: exact=3D69

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D78

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D39.15..39.15 = rows=3D1287 width=3D0) (actual time=3D0.094..0.095 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D9

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2016_lower_judge_wld_id_idx  = (cost=3D0.00..27.02 rows=3D879 width=3D0) (actual time=3D0.086..0.086 = rows=3D589 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

        =             &= nbsp;           &n= bsp;           &nb= sp;      Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2016_higher_judge_wld_id_idx  = (cost=3D0.00..11.49 rows=3D408 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2017 jrtf_28  (cost=3D16.47..1592.43 = rows=3D453 width=3D44) (actual time=3D0.073..0.237 rows=3D305 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

      =             &= nbsp;           &n= bsp;        Heap Blocks: = exact=3D49

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D57

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D16.47..16.47 = rows=3D453 width=3D0) (actual time=3D0.061..0.062 rows=3D0 = loops=3D1)

       =             &= nbsp;           &n= bsp;           &nb= sp; Buffers: shared hit=3D8

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2017_lower_judge_wld_id_idx  = (cost=3D0.00..5.09 rows=3D89 width=3D0) (actual time=3D0.053..0.053 = rows=3D305 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;  Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D5

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2017_higher_judge_wld_id_idx  = (cost=3D0.00..11.16 rows=3D364 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;     =             &= nbsp;         Buffers: = shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2018 jrtf_29  (cost=3D16.52..1614.07 = rows=3D459 width=3D44) (actual time=3D0.080..0.267 rows=3D379 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Heap Blocks: exact=3D45

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D53

           &= nbsp;           &n= bsp; =             &= nbsp; ->  BitmapOr  (cost=3D16.52..16.52 rows=3D459 = width=3D0) (actual time=3D0.069..0.070 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D8

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2018_lower_judge_wld_id_idx  = (cost=3D0.00..5.09 rows=3D89 width=3D0) (actual time=3D0.060..0.060 = rows=3D379 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;            =             &= nbsp;  Buffers: shared hit=3D5

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2018_higher_judge_wld_id_idx  = (cost=3D0.00..11.20 rows=3D370 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2019 jrtf_30  (cost=3D31.97..2869.06 = rows=3D889 width=3D44) (actual time=3D0.118..0.360 rows=3D495 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Heap Blocks: exact=3D63

          =             &= nbsp;           &n= bsp;    Buffers: shared = hit=3D71

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D31.97..31.97 = rows=3D889 width=3D0) (actual time=3D0.106..0.106 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D8

     =             &= nbsp;           &n= bsp;           &nb= sp;   ->  Bitmap Index Scan on = jrt_fact_jrt_data_2019_lower_judge_wld_id_idx  (cost=3D0.00..20.66 = rows=3D564 width=3D0) (actual time=3D0.097..0.097 rows=3D495 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D5

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2019_higher_judge_wld_id_idx  = (cost=3D0.00..10.87 rows=3D326 width=3D0) (actual time=3D0.008..0.008 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;       =             &= nbsp; ->  Bitmap Heap Scan on jrt_fact_jrt_data_2020 = jrtf_31  (cost=3D38.45..3791.01 rows=3D1200 width=3D44) (actual = time=3D0.188..0.778 rows=3D937 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Heap Blocks: exact=3D239

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D249

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D38.45..38.45 = rows=3D1200 width=3D0) (actual time=3D0.157..0.158 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D10

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2020_lower_judge_wld_id_idx  = (cost=3D0.00..26.44 rows=3D802 width=3D0) (actual time=3D0.149..0.149 = rows=3D937 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D7

           &= nbsp;       =             &= nbsp;           &n= bsp; ->  Bitmap Index Scan on = jrt_fact_jrt_data_2020_higher_judge_wld_id_idx  (cost=3D0.00..11.41 = rows=3D398 width=3D0) (actual time=3D0.007..0.008 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2021 jrtf_32  (cost=3D16.44..1571.85 = rows=3D449 width=3D44) (actual time=3D0.161..0.698 rows=3D517 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Heap Blocks: exact=3D374

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D382

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D16.44..16.44 = rows=3D449 width=3D0) (actual time=3D0.115..0.116 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D8

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2021_lower_judge_wld_id_idx  = (cost=3D0.00..5.04 rows=3D82 width=3D0) (actual time=3D0.091..0.091 = rows=3D517 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D5

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2021_higher_judge_wld_id_idx  = (cost=3D0.00..11.18 rows=3D367 width=3D0) (actual time=3D0.023..0.023 = rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;         =             &= nbsp;           &n= bsp;     Buffers: shared = hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2022 jrtf_33  (cost=3D15.99..1374.94 = rows=3D392 width=3D44) (actual time=3D0.119..0.478 rows=3D319 = loops=3D1)

           &= nbsp;           &n= bsp;       =         Recheck Cond: = ((lower_judge_wld_id =3D '104119201'::numeric) OR (higher_judge_wld_id = =3D '104119201'::numeric))

           &= nbsp;           &n= bsp;           &nb= sp;   Heap Blocks: exact=3D284

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D290

           &= nbsp;   =             &= nbsp;           -&= gt;  BitmapOr  (cost=3D15.99..15.99 rows=3D392 width=3D0) = (actual time=3D0.083..0.084 rows=3D0 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;         Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2022_lower_judge_wld_id_idx  = (cost=3D0.00..4.98 rows=3D74 width=3D0) (actual time=3D0.024..0.024 = rows=3D129 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;  =             &= nbsp;           &n= bsp;Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2022_higher_judge_wld_id_idx  = (cost=3D0.00..10.81 rows=3D318 width=3D0) (actual time=3D0.058..0.058 = rows=3D190 loops=3D1)

           =             &= nbsp;           &n= bsp;           &nb= sp;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;         ->  Bitmap = Heap Scan on jrt_fact_jrt_data_2023 jrtf_34  (cost=3D9.66..354.97 = rows=3D101 width=3D44) (actual time=3D0.065..0.266 rows=3D181 = loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;   Recheck Cond: ((lower_judge_wld_id =3D = '104119201'::numeric) OR (higher_judge_wld_id =3D = '104119201'::numeric))

           &= nbsp;            =             &= nbsp;  Heap Blocks: exact=3D161

           &= nbsp;           &n= bsp;           &nb= sp;   Buffers: shared hit=3D167

           &= nbsp;           &n= bsp;           &nb= sp;   ->  BitmapOr  (cost=3D9.66..9.66 rows=3D101 = width=3D0) (actual time=3D0.041..0.042 rows=3D0 = loops=3D1)

           &= nbsp;           &n= bsp; =             &= nbsp;       Buffers: shared = hit=3D6

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2023_lower_judge_wld_id_idx  = (cost=3D0.00..4.60 rows=3D24 width=3D0) (actual time=3D0.014..0.014 = rows=3D37 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (lower_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Buffers: shared hit=3D3

           &= nbsp;           &n= bsp;           &nb= sp;         ->  Bitmap = Index Scan on jrt_fact_jrt_data_2023_higher_judge_wld_id_idx  = (cost=3D0.00..5.00 rows=3D78 width=3D0) (actual time=3D0.026..0.026 = rows=3D144 loops=3D1)

           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;   Index Cond: (higher_judge_wld_id =3D = '104119201'::numeric)

           &= nbsp;           &n= bsp;    =             &= nbsp;          Buffers:= shared hit=3D3

Planning:

   = Buffers: shared hit=3D9400

Planning Time: 24.631 ms

Execution Time: 35251.529 ms

(614 rows)

 

ORACLE = PLAN:

 

 

Plan hash value: = 3488078505

 

-------------------------------------------------------------------= -------------------------------------------------------------------------= -------------------

| Id  | = Operation          &nbs= p;            = ;            =         | = Name           &nb= sp;   | Starts | E-Rows | A-Rows |   = A-Time   | Buffers |  OMem |  1Mem | Used-Mem = |

-------------------------------------------------------------------= -------------------------------------------------------------------------= -------------------

|   0 | = SELECT = STATEMENT          &nbs= p;            = ;            = = |            =         = |      1 = |        = |      1 |00:00:00.03 |    5259 = |       = |       = |          = |

|*  1 |  = HASH = JOIN           &nb= sp;           &nbs= p;            = ;      = |            =         = |      1 |      1 = |      1 |00:00:00.03 |    5259 = |   872K|   872K|  455K = (0)|

|   2 = |   = VIEW           &nb= sp;           &nbs= p;     =             &= nbsp;    |       &= nbsp;            = |      1 |      1 = |      1 |00:00:00.02 |    3693 = |       = |       = |          = |

|   3 = |    HASH GROUP = BY            = ;            =             = |            =         = |      1 |      1 = |      1 |00:00:00.02 |    3693 = |   734K|   734K|  514K = (0)|

|   4 = |     NESTED LOOPS = OUTER           &n= bsp;           &nb= sp;      = |            =         = |      1 |  29525 = |     39 |00:00:00.02 |    3693 = |       = |       = |          = |

|   5 = |      NESTED LOOPS = OUTER           &n= bsp;           &nb= sp;     = |            =   =       |      1 = |    150 |      3 |00:00:00.01 = |     513 |       = |       = |          = |

|*  6 = |       TABLE ACCESS BY INDEX ROWID = BATCHED           | = JUDGE           &n= bsp;  |      1 = |      1 |      1 = |00:00:00.01 |       3 = |       = |       = |          = |

|*  7 = |        INDEX RANGE = SCAN           &nb= sp;           &nbs= p;     | JUDGE_WLD_PROF_IDX = |      1 |      1 = |      1 |00:00:00.01 = |       2 = |       = |       = |          = |

|   8 = |       VIEW PUSHED = PREDICATE          &nbs= p;            = ;  = |            =         = |      1 |      1 = |      3 |00:00:00.01 |     = 510 |       = |       = |          = |

|   9 = |        SORT GROUP = BY            = ;            =         = |            =         = |      1 |   2228 = |      3 |00:00:00.01 |     = 510 |  2048 |  2048 | 2048  (0)|

|  10 |         = VIEW           &nb= sp;           =             &= nbsp;    | = VM_NWVW_1          = |      1 |   2228 = |     87 |00:00:00.01 |     510 = |       = |       = |          = |

|  11 = |          SORT GROUP = BY            = ;            =       = |            =         = |      1 |   2228 = |     87 |00:00:00.01 |     510 = |  9216 |  9216 | 8192  (0)|

|  12 = |           PARTITION = RANGE = ALL           &nbs= p;           = |            =         = |      1 |   2228 |    = 540 |00:00:00.01 |     510 = |       = |       = |          = |

|  13 = |            = TABLE ACCESS BY LOCAL INDEX ROWID BATCHED| = JRT_FACT     =       |     34 = |   2228 |    540 |00:00:00.01 = |     510 |       = |       = |          = |

|* 14 = |            = INDEX RANGE = SCAN           &nb= sp;            | = JRT_FACT_IDX05     |     34 = |   2228 |    540 |00:00:00.01 = |      86 |       = |       = |          = |

|  15 = |      VIEW PUSHED = PREDICATE          &nbs= p;            = ;   = |            =         = |      3 |      1 = |     39 |00:00:00.02 |    3180 = |       = |       = |          = |

|  16 = |       SORT GROUP = BY            = ;            =          = |            =         = |      3 |    481 = |     39 |00:00:00.02 |    3180 = |  2048 |  2048 | 2048  (0)|

|  17 |        = VIEW           &nb= sp; =             &= nbsp;           &n= bsp;   | = VM_NWVW_0          = |      3 |    481 = |    813 |00:00:00.02 |    3180 = |       = |       = |          = |

|  18 = |         SORT GROUP = BY            = ;            =        = |            =         = |      3 |    481 = |    813 |00:00:00.02 |    3180 | 24576 | = 24576 |22528  (0)|

|* 19 = |          = FILTER           &= nbsp;           &n= bsp;           &nb= sp; = |            =         = |      3 = |        |  12669 |00:00:00.01 = |    3180 |       = |       = |          = |

|  20 = |           PARTITION = RANGE = ALL           &nbs= p;           = |   =             &= nbsp;    |      3 = |    481 |  12669 |00:00:00.01 |    = 3180 |       = |       = |          = |

|* 21 = |            = TABLE ACCESS BY LOCAL INDEX ROWID BATCHED| = JRT_FACT           = |    102 |    481 |  12669 = |00:00:00.01 |    3180 = |       = |       = |          = |

|* 22 = |            = INDEX RANGE = SCAN           &nb= sp;            | = JRT_FACT_IDX02     |    102 = |    481 |  12669 |00:00:00.01 = |     288 |       = |       = |          = |

|  23 = |   = VIEW           &nb= sp;           &nbs= p;            = ;          = |            =         = |      1 |     11 = |      1 |00:00:00.01 |    1566 = |       = |       = |          = |

|  24 = |    HASH GROUP = BY            = ;            =             = |            =         = |      1 |     11 = |      1 |00:00:00.01 |    1566 = |  1097K|  1097K|  514K (0)|

|* 25 |     COUNT = STOPKEY       =             &= nbsp;           &n= bsp;   |        &n= bsp;           = |      1 = |        |     11 = |00:00:00.01 |    1566 = |       = |       = |          = |

|  26 = |      = VIEW           &nb= sp;           &nbs= p;            = ;       = |            =         = |      1 |   2689 = |     11 |00:00:00.01 |    1566 = |       = |       = |          = |

|* 27 = |       SORT UNIQUE = STOPKEY           =             &= nbsp;   = |            =         = |      1 |   2689 = |     11 |00:00:00.01 |    1566 = |  2048 |  2048 | 2048  (0)|

|  28 |        PARTITION = RANGE = ALL           &nbs= p;            = ;  |   =             &= nbsp;    |      1 = |   2689 |   4763 |00:00:00.01 |    = 1566 |       = |       = |          = |

|  29 = |         TABLE ACCESS BY LOCAL = INDEX ROWID BATCHED   | = JRT_FACT           = |     34 |   2689 |   4763 = |00:00:00.01 |    1566 = |       = |       = |          = |

|  30 = |          BITMAP = CONVERSION TO = ROWIDS           &= nbsp;    = |            =         |     34 = |        |   4763 = |00:00:00.01 |     186 = |       = |       = |          = |

|  31 = |           BITMAP = OR            = ;            =          = |            =         |     34 = |        |     13 = |00:00:00.01 |     186 = |       = |       = |          = |

|  32 = |            = BITMAP CONVERSION FROM = ROWIDS            = |            =         |     34 = |        = |      3 |00:00:00.01 = |      88 |       = |       = |          = |

|* 33 = |            = INDEX RANGE = SCAN           &nb= sp;            | = JRT_FACT_IDX13     |     34 = |        |    540 = |00:00:00.01 |      88 = |       = |       = |          = |

|  34 = |            = BITMAP CONVERSION FROM = ROWIDS            = |            =         |     34 = |        |     13 = |00:00:00.01 |      98 = |       = |       = |          = |

|* 35 = |            = INDEX RANGE = SCAN           &nb= sp;            | = JRT_FACT_IDX12     |     34 = |        |   4223 = |00:00:00.01 |      98 = |       = |       = |          = |

-------------------------------------------------------------------= -------------------------------------------------------------------------= -------------------

 

Predicate = Information (identified by operation id):

---------------------------------------------------

 

   1 = - = access("AGG_SUB"."JUDGE_ID"=3D"APPELLATE_FLAG_SU= B"."JUDGE_ID")

   6 - = filter(("JUDG1"."JRT_OPT_OUT_FLAG" IS NULL OR = "JUDG1"."JRT_OPT_OUT_FLAG"<>:SYS_B_17))

   7 - = access("JUDG1"."WLD_ID"=3D:SYS_B_15 AND = "JUDG1"."PROFILE_ID"=3D:SYS_B_16)

  14 - = access("JRTF1"."HIGHER_JUDGE_ID"=3D"JUDG1".= "JUDGE_ID")

  19 - = filter(:SYS_B_23>:SYS_B_22)

  21 - = filter(("JRTF2"."LOWER_JUDGE_COURT_LEVEL_ID">:SYS_= B_22 AND = "JRTF2"."LOWER_JUDGE_COURT_LEVEL_ID"<=3D:SYS_B_23)= )

  22 - = access("JRTF2"."LOWER_JUDGE_ID"=3D"JUDG1".&= quot;JUDGE_ID")

  25 - = filter(ROWNUM<=3D:SYS_B_37)

  27 - filter(ROWNUM<=3D:SYS_B_37)

  33 - = access("HIGHER_JUDGE_WLD_ID"=3D:SYS_B_36)

=

  35 - = access("LOWER_JUDGE_WLD_ID"=3D:SYS_B_35)

<= p class=3DMsoNormal> 

 

Postgres table = definitions:

 

wldomart01a=3D> \d+ wln_mart.judge

          &nb= sp;           &nbs= p;            = ;            =          Table = "wln_mart.judge"

         = Column          = |            =   = Type           &nb= sp;  | Collation | Nullable |   Default   | = Storage  | Stats target | Description

-------------------------+--------------------------------+----= -------+----------+-------------+----------+--------------+-------------<= o:p>

judge_id         &= nbsp;      | = bigint           &= nbsp;           &n= bsp; |           | not = null = |            = | plain    = |            =   |

display_name        &nb= sp;   | character = varying(255)         = |           | not null = |            = | extended = |            =   |

first_name         = ;     | character = varying(50)          = |           = |          = |            = | extended = |            =   |

middle_name         =     | character = varying(50)          = |           = |          = |            = | extended = |            =   |

sur_name         &= nbsp;      | character = varying(50)          = |           = |          = |            = | extended = |            =   |

title         &nbs= p;         | character = varying(10)          = |           = |          = |            = | extended = |            =   |

prof_suffix        &nbs= p;    | character = varying(10)          = |           = |          = |            = | extended = |            =   |

wld_id         &nb= sp;        | = bigint        =             &= nbsp;    |       &= nbsp;   = |          = |            = | plain    = |            =   |

profile_id         = ;     | = bigint           &= nbsp;           &n= bsp; |           = |          = |            = | plain    = |            =   |

search_name        &nbs= p;    | character varying(255)  =        |     =       | not null = |            = | extended = |            =   |

active_flag        &nbs= p;    | = character(1)          &= nbsp;        = |           | not null = |            = | extended = |            =   |

legal_event_count       | = bigint           &= nbsp;           &n= bsp; |  =          |   =        = |            = | plain    = |            =   |

profile_type        &nb= sp;   | = character(1)          &= nbsp;        = |           | not null = | 'L'::bpchar | extended = |            =   |

court_name         = ;     | character = varying(255)         = |           = |          = |            = | extended = |            =   |

address         &n= bsp;       | character = varying(255)         = |           = |          = |            = | extended = |            =   |

legal_event_total_count | = bigint           &= nbsp;           &n= bsp; |           = |          = |            = | plain    = |            =   |

legal_event_first_year  | = bigint           &= nbsp;           &n= bsp; |           = |          = |            = | plain    = |            =   |

legal_event_last_year   | = bigint           &= nbsp;           &n= bsp; |           = |          = |            = | plain    = |            =   |

state_id =             &= nbsp;  | = bigint           &= nbsp;           &n= bsp; |           = |          = |            = | plain    = |            =   |

ec_fact_first_year      | = bigint           &= nbsp;           &n= bsp; |           = |          = |            = | plain    = |            =   |

judge_padb_code    =      | character = varying(33)          = |           = |          = |            = | extended = |            =   |

ec_fact_count        &n= bsp;  | = bigint           &= nbsp;           &n= bsp; |           = |          = |            = | plain    = |            =   |

ec_fact_totalcount      | = bigint           &= nbsp;           &n= bsp; |           = |          = |            = | plain    = |            =   |

ee_fact_totalcount      | = bigint           &= nbsp;           &n= bsp; |           = |          = |            = | plain    = |            =   |

ec_fact_last_year       | = bigint       =             &= nbsp;     |      &= nbsp;    = |          = |            = | plain    = |            =   |

jmt_total_count        = | = bigint           &= nbsp;           &n= bsp; |           = |          = |            = | plain    = |            =   |

jrt_total_count        = | = bigint           &= nbsp;     =         |    =        = |          = |            = | plain    = |            =   |

jrt_opt_out_flag        | = character(1)          &= nbsp;        = |           = |          = |            = | extended = |            =   |

jmt_opt_out_flag        | = character(1)          &= nbsp;        | =           |  =         = |            = | extended = |            =   |

judge_court_level       | = character = varying(50)          = |           = |          = |            = | extended = |            =   |

jrt_trial_count        = | = bigint           &= nbsp;           &n= bsp; |           = |          = |            = | plain    = |            =   |

jrt_appellate_count     | = bigint           &= nbsp;           &n= bsp; |           = |          = |            = | plain    = |            =   |

city_name         =       | character = varying(255)         = |           = |         =  |           =   | extended = |            =   |

zip_code         &= nbsp;      | character = varying(20)          = |           = |          = |            = | extended = |            =   |

created_on         = ;     | timestamp(0) without time zone = |           = |          = |        =      | plain    = |            =   |

changed_on         = ;     | timestamp(0) without time zone = |           = |          = |            = | plain    = |            =   |

Indexes:

    "pk_judge" PRIMARY KEY, btree = (judge_id)

    "idx_jdg_low_fname" btree = (lower(first_name::text))

    "idx_jdg_low_surname" btree = (lower(sur_name::text))

    "idx_judge_first_name" btree = (first_name)

    "idx_judge_search_name" btree = (search_name)

    "idx_judge_sur_name" btree = (sur_name)

    "judge_st_id" btree = (state_id)

    "judge_wld_prof_idx" btree = (wld_id, profile_id)

Foreign-key = constraints:

    "judge_state_id_fk" FOREIGN KEY = (state_id) REFERENCES = wln_mart.state_code(state_id)

Referenced = by:

    TABLE "wln_mart.ec_fact" = CONSTRAINT "ec_fact_judge_fk" FOREIGN KEY (judge_id) = REFERENCES wln_mart.judge(judge_id)

    TABLE "wln_mart.ee_fact" = CONSTRAINT "ee_judge_fk" FOREIGN KEY (judge_id) REFERENCES = wln_mart.judge(judge_id)

    TABLE = "wln_mart.ea_judge_doc_fact" CONSTRAINT = "fk_judge_doc_judge_id" FOREIGN KEY (judge_id) REFERENCES = wln_mart.judge(judge_id)

    TABLE "wln_mart.jmt_fact" = CONSTRAINT "jmt_fact_fk01" FOREIGN KEY (judge_id) REFERENCES = wln_mart.judge(judge_id)

    TABLE "wln_mart.jrt_fact" = CONSTRAINT "jrt_fact_fk02" FOREIGN KEY (lower_judge_id) = REFERENCES wln_mart.judge(judge_id)

    TABLE "wln_mart.jrt_fact" = CONSTRAINT "jrt_fact_fk04" FOREIGN KEY (higher_judge_id) = REFERENCES wln_mart.judge(judge_id)

    TABLE "wln_mart.lhr_fact" = CONSTRAINT "lhr_judge_id_fk01" FOREIGN KEY (judge_id) = REFERENCES wln_mart.judge(judge_id)

Access method: = heap

 

 

 

wldomart01a=3D> \d+ = wln_mart.jrt_fact

          &nb= sp;           &nbs= p;            = ;            = Partitioned table "wln_mart.jrt_fact"

           = Column           = |       =        Type    &nb= sp;         | Collation | = Nullable | Default | Storage  | Stats target | = Description

----------------------------+--------------------------------+-= ----------+----------+---------+----------+--------------+-------------

jrt_fact_id        &nbs= p;       | = bigint           &= nbsp;           &n= bsp; |           | not = null |         | = plain    = |            =   |

case_document_id        = ;   | double = precision          &nbs= p;    = |           | not null = |         | = plain    = |            =   |

lower_judge_id        &= nbsp;    | = bigint           &= nbsp;           &n= bsp; |           | not = null |         | = plain    = |            =   |

appealed_case_ruling_id    | = bigint           &= nbsp;           &n= bsp; |           | not = null |         | = plain    = |            =   |

higher_judge_id        =     | = bigint           =             &= nbsp; |           = | not null |         | = plain    = |            =   |

lower_judge_court_level_id | = bigint           &= nbsp;           &n= bsp; |           | not = null |         | = plain    = |            =   |

majority_judge_flag        = | = character(1)          &= nbsp;      =   |          = | not null |         | extended = |            =   |

attorney_id        &nbs= p;       | = bigint           &= nbsp;           &n= bsp; |           | not = null |         | = plain    = |            =   |

firm_id         &n= bsp;          | = bigint           &= nbsp;           &n= bsp; |           | not = null |         | = plain    = |            =   |

case_date_id        &nb= sp;      | = bigint           &= nbsp;           &n= bsp; |           | not = null |         | = plain    = |            =   |

case_year_number        = ;   | = bigint           &= nbsp;           &n= bsp; |           | not = null |         | = plain    = |            =   |

lower_judge_wld_id       &nb= sp; | = numeric(10,0)          =         = |           = |          = |         | = main     = |            =   |

higher_judge_wld_id        = | = numeric(10,0)          =         = |           = |          = |         | = main     = |            =   |

created_on         = ;        | timestamp(0) without time = zone |           = |          = |         | = plain    = |            =   |

changed_on         = ;        | timestamp(0) without time = zone |           = |          = |         | = plain    = |            =   |

court_id   =             &= nbsp;   | double = precision          &nbs= p;    = |           | not null = | 1       | plain    = |            =   |

Partition key: = RANGE (case_year_number)

Indexes:

    "pk_jrt_fact" PRIMARY KEY, btree = (jrt_fact_id, case_year_number)

    "jrt_fact_idx01" btree = (case_document_id)

    "jrt_fact_idx02" btree = (lower_judge_id)

    "jrt_fact_idx04" btree = (appealed_case_ruling_id)

    "jrt_fact_idx05" btree = (higher_judge_id)

    "jrt_fact_idx06" btree = (lower_judge_court_level_id)

    "jrt_fact_idx07" btree = (majority_judge_flag)

    "jrt_fact_idx08" btree = (case_date_id)

    "jrt_fact_idx09" btree = (attorney_id)

    "jrt_fact_idx10" btree = (firm_id)

    "jrt_fact_idx11" btree = (case_year_number)

    "jrt_fact_idx12" btree = (lower_judge_wld_id)

    "jrt_fact_idx13" btree = (higher_judge_wld_id)

Foreign-key = constraints:

    "jrt_fact_fk02" FOREIGN KEY = (lower_judge_id) REFERENCES = wln_mart.judge(judge_id)

    "jrt_fact_fk03" FOREIGN KEY = (appealed_case_ruling_id) REFERENCES = wln_mart.appealed_case_ruling(appealed_case_ruling_id)<= /p>

    "jrt_fact_fk04" FOREIGN KEY = (higher_judge_id) REFERENCES = wln_mart.judge(judge_id)

    "jrt_fact_fk05" FOREIGN KEY = (lower_judge_court_level_id) REFERENCES = wln_mart.lower_judge_court_level(lower_judge_court_level_id)

    "jrt_fact_fk06" FOREIGN KEY = (attorney_id) REFERENCES = wln_mart.attorney(attorney_id)

    "jrt_fact_fk07" FOREIGN KEY = (firm_id) REFERENCES wln_mart.firm(firm_id)

    "jrt_fact_fk08" FOREIGN KEY = (case_date_id) REFERENCES = wln_mart.date_code(date_id)

Partitions: = wln_mart.jrt_fact_jrt_data_1990 FOR VALUES FROM (MINVALUE) TO = ('1991'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_1991 FOR VALUES FROM ('1991') TO = ('1992'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_1992 FOR VALUES FROM ('1992') TO = ('1993'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_1993 FOR VALUES FROM ('1993') TO = ('1994'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_1994 FOR VALUES FROM ('1994') TO = ('1995'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_1995 FOR VALUES FROM ('1995') TO = ('1996'),

          =   wln_mart.jrt_fact_jrt_data_1996 FOR VALUES FROM ('1996') TO = ('1997'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_1997 FOR VALUES FROM ('1997') TO = ('1998'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_1998 FOR VALUES FROM ('1998') TO = ('1999'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_1999 FOR VALUES FROM ('1999') TO = ('2000'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2000 FOR VALUES FROM ('2000') TO = ('2001'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2001 FOR VALUES FROM ('2001') TO = ('2002'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2002 FOR VALUES FROM ('2002') TO = ('2003'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2003 FOR VALUES FROM ('2003') TO = ('2004'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2004 FOR VALUES FROM ('2004') TO = ('2005'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2005 FOR VALUES FROM ('2005') TO = ('2006'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2006 FOR VALUES FROM ('2006') TO = ('2007'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2007 FOR VALUES FROM ('2007') TO = ('2008'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2008 FOR VALUES FROM ('2008') TO = ('2009'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2009 FOR VALUES FROM ('2009') TO = ('2010'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2010 FOR VALUES FROM ('2010') TO = ('2011'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2011 FOR VALUES FROM ('2011') TO = ('2012'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2012 FOR VALUES FROM ('2012') TO = ('2013'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2013 FOR VALUES FROM ('2013') TO = ('2014'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2014 FOR VALUES FROM ('2014') TO = ('2015'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2015 FOR VALUES FROM ('2015') TO = ('2016'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2016 FOR VALUES FROM ('2016') TO = ('2017'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2017 FOR VALUES FROM ('2017') TO = ('2018'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2018 FOR VALUES FROM ('2018') TO = ('2019'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2019 FOR VALUES FROM ('2019') TO = ('2020'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2020 FOR VALUES FROM ('2020') TO = ('2021'),

        =     wln_mart.jrt_fact_jrt_data_2021 FOR VALUES FROM = ('2021') TO ('2022'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2022 FOR VALUES FROM ('2022') TO = ('2023'),

          &nb= sp; wln_mart.jrt_fact_jrt_data_2023 FOR VALUES FROM ('2023') TO = ('2024')

 

 

This e-mail = is for the sole use of the intended recipient and contains information = that may be privileged and/or confidential. If you are not an intended = recipient, please notify the sender by return e-mail and delete this = e-mail and any attachments. Certain required legal entity disclosures = can be accessed on our website: = https://www.thomsonreuters.com/en/resources/disclosures.html =

------=_NextPart_000_07FD_01D9F238.56732F60--