Unique  (cost=65.25..65.34 rows=2 width=140)
   ->  Sort  (cost=65.25..65.26 rows=2 width=140)
         Sort Key: "C"."caseNo", "C"."filingDate", "CY"."countyName", "S".descr, "P"."nameF", "P"."nameM", "P"."nameL", "P".suffix, "P".dob, "C".caption, "CY"."countyNo", "C"."caseType", "C"."isSeal", "C"."isPartySeal", "LCM"."lastModified", "P"."searchName", (CASE WHEN (((("C"."filingDate")::date >= '2008-11-01'::date) AND (("C"."wcisClsCode")::text = '30709'::text)) OR ((("C"."caseType")::text = ANY ('{CV,FA}'::text[])) AND (("C"."wcisClsCode")::text = '30711'::text) AND (subplan))) THEN true ELSE false END)
         ->  Append  (cost=0.00..65.24 rows=2 width=140)
               ->  Nested Loop  (cost=0.00..32.35 rows=1 width=136)
                     ->  Nested Loop  (cost=0.00..17.98 rows=1 width=130)
                           ->  Nested Loop Left Join  (cost=0.00..17.50 rows=1 width=123)
                                 ->  Nested Loop Left Join  (cost=0.00..16.57 rows=1 width=123)
                                       ->  Nested Loop Left Join  (cost=0.00..16.12 rows=1 width=115)
                                             Filter: ((("WPCT"."profileName" IS NOT NULL) OR ((("C"."caseType")::text = ANY ('{PA,JD}'::text[])) AND (NOT "C"."isConfidential"))) AND ((("WPCT"."profileName")::text <> 'PUBLIC'::text) OR (("C"."caseType")::text <> 'FA'::text) OR (("C"."wcisClsCode")::text <> '40501'::text)))
                                             ->  Nested Loop  (cost=0.00..15.82 rows=1 width=116)
                                                   Join Filter: ((((("P"."partyType")::text = ANY ('{JV,CH}'::text[])) AND (("C"."caseType")::text = 'ZZ'::text)) OR (("P"."partyType")::text <> ALL ('{JV,CH}'::text[]))) AND ((("C"."caseType")::text <> ALL ('{CF,CI,CM,CT,FO,TR}'::text[])) OR (("P"."partyType")::text = 'DE'::text)) AND (((("C"."caseType")::text = ANY ('{JA,JC,JG,JM,JO,JV,JI,TP}'::text[])) AND (("P"."partyType")::text = ANY ('{CH,JV}'::text[]))) OR ((("C"."caseType")::text <> ALL ('{JA,JC,JG,JM,JO,JV,JI,TP}'::text[])) AND (("P"."partyType")::text <> ALL ('{CH,JV}'::text[])))) AND ((("P"."partyType")::text <> ALL ('{PE,PL,JP}'::text[])) OR (((("C"."filingDate")::date < '2008-11-01'::date) OR (("C"."wcisClsCode")::text <> '30709'::text)) AND ((("C"."caseType")::text <> ALL ('{CV,FA}'::text[])) OR (("C"."wcisClsCode")::text <> '30711'::text) OR (NOT (subplan))))))
                                                   ->  Index Scan using "Party_SearchName" on "Party" "P"  (cost=0.00..0.62 rows=1 width=60)
                                                         Index Cond: ((("searchName")::text >= 'HILL,J'::text) AND (("searchName")::text < 'HILL,K'::text))
                                                         Filter: ((NOT "isSeal") AND (("searchName")::text ~~ 'HILL,J%'::text))
                                                   ->  Index Scan using "Case_pkey" on "Case" "C"  (cost=0.00..1.05 rows=1 width=72)
                                                         Index Cond: ((("C"."countyNo")::smallint = ("P"."countyNo")::smallint) AND (("C"."caseNo")::text = ("P"."caseNo")::text))
                                                         Filter: (("C"."isExpunge" <> true) AND (NOT (subplan)))
                                                         SubPlan
                                                           ->  Index Scan using "HiddenCase_pkey" on "HiddenCase" "HCA"  (cost=0.00..0.50 rows=1 width=0)
                                                                 Index Cond: ((("countyNo")::smallint = ($0)::smallint) AND (("caseNo")::text = ($1)::text))
                                                   SubPlan
                                                     ->  Index Scan using "CaseHist_pkey" on "CaseHist" "CHPET"  (cost=0.00..14.08 rows=1 width=0)
                                                           Index Cond: ((($0)::smallint = ("countyNo")::smallint) AND (($1)::text = ("caseNo")::text))
                                                           Filter: (("eventType")::text = ANY ('{FWBCA,CCTRO}'::text[]))
                                             ->  Index Scan using "WccaPermCaseType_ProfileName" on "WccaPermCaseType" "WPCT"  (cost=0.00..0.28 rows=1 width=26)
                                                   Index Cond: ((("WPCT"."profileName")::text = 'PUBLIC'::text) AND (("C"."caseType")::text = ("WPCT"."caseType")::text) AND (("C"."countyNo")::smallint = ("WPCT"."countyNo")::smallint))
                                       ->  Index Scan using "LastCaseMod_pkey" on "LastCaseMod" "LCM"  (cost=0.00..0.43 rows=1 width=23)
                                             Index Cond: ((("LCM"."countyNo")::smallint = ("C"."countyNo")::smallint) AND (("LCM"."caseNo")::text = ("C"."caseNo")::text) AND (("LCM"."updateTypeId")::integer = 0))
                                 ->  Index Scan using "CaseDispo_pkey" on "CaseDispo" "CD"  (cost=0.00..0.92 rows=1 width=15)
                                       Index Cond: ((("CD"."countyNo")::smallint = ("C"."countyNo")::smallint) AND (("CD"."caseNo")::text = ("C"."caseNo")::text))
                                       Filter: (NOT (subplan))
                                       SubPlan
                                         ->  Index Scan using "CaseDispo_pkey" on "CaseDispo" "CD2"  (cost=0.00..0.56 rows=1 width=0)
                                               Index Cond: ((("countyNo")::smallint = ($6)::smallint) AND (("caseNo")::text = ($5)::text) AND (("dispoDate")::date > ($7)::date))
                           ->  Index Scan using "County_pkey" on "County" "CY"  (cost=0.00..0.47 rows=1 width=9)
                                 Index Cond: (("CY"."countyNo")::smallint = ("C"."countyNo")::smallint)
                     ->  Index Scan using "StatusCode_pkey" on "StatusCode" "S"  (cost=0.00..0.27 rows=1 width=12)
                           Index Cond: (("S"."statusCode")::text = ("C"."statusCode")::text)
                     SubPlan
                       ->  Index Scan using "CaseHist_pkey" on "CaseHist" "CH"  (cost=0.00..14.08 rows=1 width=0)
                             Index Cond: ((($0)::smallint = ("countyNo")::smallint) AND (($1)::text = ("caseNo")::text))
                             Filter: (("eventType")::text = ANY ('{FWBCA,CCTRO}'::text[]))
               ->  Nested Loop  (cost=0.00..32.87 rows=1 width=140)
                     ->  Nested Loop  (cost=0.00..18.49 rows=1 width=134)
                           ->  Nested Loop  (cost=0.00..18.01 rows=1 width=129)
                                 Join Filter: ((((("P"."partyType")::text = ANY ('{JV,CH}'::text[])) AND (("C"."caseType")::text = 'ZZ'::text)) OR (("P"."partyType")::text <> ALL ('{JV,CH}'::text[]))) AND ((("C"."caseType")::text <> ALL ('{CF,CI,CM,CT,FO,TR}'::text[])) OR (("P"."partyType")::text = 'DE'::text)) AND (((("C"."caseType")::text = ANY ('{JA,JC,JG,JM,JO,JV,JI,TP}'::text[])) AND (("P"."partyType")::text = ANY ('{CH,JV}'::text[]))) OR ((("C"."caseType")::text <> ALL ('{JA,JC,JG,JM,JO,JV,JI,TP}'::text[])) AND (("P"."partyType")::text <> ALL ('{CH,JV}'::text[])))) AND ((("P"."partyType")::text <> ALL ('{PE,PL,JP}'::text[])) OR (((("C"."filingDate")::date < '2008-11-01'::date) OR (("C"."wcisClsCode")::text <> '30709'::text)) AND ((("C"."caseType")::text <> ALL ('{CV,FA}'::text[])) OR (("C"."wcisClsCode")::text <> '30711'::text) OR (NOT (subplan))))))
                                 ->  Nested Loop Left Join  (cost=0.00..3.22 rows=1 width=142)
                                       ->  Nested Loop Left Join  (cost=0.00..2.29 rows=1 width=142)
                                             ->  Nested Loop Left Join  (cost=0.00..1.84 rows=1 width=134)
                                                   Filter: ((("WPCT"."profileName" IS NOT NULL) OR ((("C"."caseType")::text = ANY ('{PA,JD}'::text[])) AND (NOT "C"."isConfidential"))) AND ((("WPCT"."profileName")::text <> 'PUBLIC'::text) OR (("C"."caseType")::text <> 'FA'::text) OR (("C"."wcisClsCode")::text <> '40501'::text)))
                                                   ->  Nested Loop  (cost=0.00..1.54 rows=1 width=135)
                                                         ->  Index Scan using "Alias_SearchName" on "Alias" "AL"  (cost=0.00..0.48 rows=1 width=63)
                                                               Index Cond: ((("searchName")::text >= 'HILL,J'::text) AND (("searchName")::text < 'HILL,K'::text))
                                                               Filter: (("searchName")::text ~~ 'HILL,J%'::text)
                                                         ->  Index Scan using "Case_pkey" on "Case" "C"  (cost=0.00..1.05 rows=1 width=72)
                                                               Index Cond: ((("C"."countyNo")::smallint = ("AL"."countyNo")::smallint) AND (("C"."caseNo")::text = ("AL"."caseNo")::text))
                                                               Filter: (("C"."isExpunge" <> true) AND (NOT (subplan)))
                                                               SubPlan
                                                                 ->  Index Scan using "HiddenCase_pkey" on "HiddenCase" "HCA"  (cost=0.00..0.50 rows=1 width=0)
                                                                       Index Cond: ((("countyNo")::smallint = ($0)::smallint) AND (("caseNo")::text = ($1)::text))
                                                   ->  Index Scan using "WccaPermCaseType_ProfileName" on "WccaPermCaseType" "WPCT"  (cost=0.00..0.28 rows=1 width=26)
                                                         Index Cond: ((("WPCT"."profileName")::text = 'PUBLIC'::text) AND (("C"."caseType")::text = ("WPCT"."caseType")::text) AND (("C"."countyNo")::smallint = ("WPCT"."countyNo")::smallint))
                                             ->  Index Scan using "LastCaseMod_pkey" on "LastCaseMod" "LCM"  (cost=0.00..0.43 rows=1 width=23)
                                                   Index Cond: ((("LCM"."countyNo")::smallint = ("C"."countyNo")::smallint) AND (("LCM"."caseNo")::text = ("C"."caseNo")::text) AND (("LCM"."updateTypeId")::integer = 0))
                                       ->  Index Scan using "CaseDispo_pkey" on "CaseDispo" "CD"  (cost=0.00..0.92 rows=1 width=15)
                                             Index Cond: ((("CD"."countyNo")::smallint = ("C"."countyNo")::smallint) AND (("CD"."caseNo")::text = ("C"."caseNo")::text))
                                             Filter: (NOT (subplan))
                                             SubPlan
                                               ->  Index Scan using "CaseDispo_pkey" on "CaseDispo" "CD2"  (cost=0.00..0.56 rows=1 width=0)
                                                     Index Cond: ((("countyNo")::smallint = ($3)::smallint) AND (("caseNo")::text = ($2)::text) AND (("dispoDate")::date > ($4)::date))
                                 ->  Index Scan using "Party_pkey" on "Party" "P"  (cost=0.00..0.64 rows=1 width=20)
                                       Index Cond: ((("P"."countyNo")::smallint = ("C"."countyNo")::smallint) AND (("P"."caseNo")::text = ("C"."caseNo")::text) AND (("P"."partyNo")::smallint = ("AL"."partyNo")::smallint))
                                       Filter: (NOT "P"."isSeal")
                                 SubPlan
                                   ->  Index Scan using "CaseHist_pkey" on "CaseHist" "CHPET"  (cost=0.00..14.08 rows=1 width=0)
                                         Index Cond: ((($0)::smallint = ("countyNo")::smallint) AND (($1)::text = ("caseNo")::text))
                                         Filter: (("eventType")::text = ANY ('{FWBCA,CCTRO}'::text[]))
                           ->  Index Scan using "County_pkey" on "County" "CY"  (cost=0.00..0.47 rows=1 width=9)
                                 Index Cond: (("CY"."countyNo")::smallint = ("C"."countyNo")::smallint)
                     ->  Index Scan using "StatusCode_pkey" on "StatusCode" "S"  (cost=0.00..0.27 rows=1 width=12)
                           Index Cond: (("S"."statusCode")::text = ("C"."statusCode")::text)
                     SubPlan
                       ->  Index Scan using "CaseHist_pkey" on "CaseHist" "CH"  (cost=0.00..14.08 rows=1 width=0)
                             Index Cond: ((($0)::smallint = ("countyNo")::smallint) AND (($1)::text = ("caseNo")::text))
                             Filter: (("eventType")::text = ANY ('{FWBCA,CCTRO}'::text[]))
(86 rows)