Sort  (cost=44.56..44.57 rows=1 width=245) (actual time=0.196..0.196 rows=0 loops=1)
   Sort Key: "CH"."chargeNo", "CH"."chargeSeqNo"
   Sort Method:  quicksort  Memory: 17kB
   ->  Nested Loop Left Join  (cost=1.54..44.55 rows=1 width=245) (actual time=0.182..0.182 rows=0 loops=1)
         ->  Nested Loop  (cost=1.54..40.26 rows=1 width=256) (actual time=0.180..0.180 rows=0 loops=1)
               ->  Nested Loop  (cost=1.54..37.35 rows=1 width=256) (actual time=0.178..0.178 rows=0 loops=1)
                     Join Filter: (("CH"."sevClsCode")::bpchar = ("S"."sevClsCode")::bpchar)
                     ->  Nested Loop  (cost=1.54..35.81 rows=1 width=225) (actual time=0.175..0.175 rows=0 loops=1)
                           Join Filter: (("CH"."pleaCode")::bpchar = ("PC"."pleaCode")::bpchar)
                           ->  Nested Loop  (cost=1.54..34.59 rows=1 width=189) (actual time=0.172..0.172 rows=0 loops=1)
                                 ->  Nested Loop  (cost=1.54..31.23 rows=1 width=138) (actual time=0.170..0.170 rows=0 loops=1)
                                       ->  Hash Join  (cost=1.54..11.88 rows=1 width=125) (actual time=0.168..0.168 rows=0 loops=1)
                                             Hash Cond: (("CH"."modSevClsCode")::bpchar = ("M"."sevClsCode")::bpchar)
                                             ->  Index Scan using "Charge_pkey" on "Charge" "CH"  (cost=0.00..10.32 rows=4 width=94) (actual time=0.042..0.050 rows=4 loops=1)
                                                   Index Cond: ((("countyNo")::smallint = 53) AND (("caseNo")::bpchar = '2007CM003476'::bpchar))
                                             ->  Hash  (cost=1.24..1.24 rows=24 width=34) (actual time=0.096..0.096 rows=24 loops=1)
                                                   ->  Seq Scan on "SevClsCode" "M"  (cost=0.00..1.24 rows=24 width=34) (actual time=0.011..0.044 rows=24 loops=1)
                                       ->  Index Scan using "CaseHist_pkey" on "CaseHist" "CHST"  (cost=0.00..19.32 rows=2 width=32) (never executed)
                                             Index Cond: ((("CHST"."countyNo")::smallint = 53) AND (("CHST"."caseNo")::bpchar = '2007CM003476'::bpchar) AND (("CHST"."histSeqNo")::smallint = ("CH"."reopHistSeqNo")::smallint))
                                 ->  Index Scan using "CaseTypeHistEventB_pkey" on "CaseTypeHistEventB" b  (cost=0.00..3.34 rows=1 width=60) (never executed)
                                       Index Cond: (((b."caseType")::bpchar = ("CHST"."caseType")::bpchar) AND ((b."eventType")::bpchar = ("CHST"."eventType")::bpchar))
                           ->  Seq Scan on "PleaCode" "PC"  (cost=0.00..1.10 rows=10 width=41) (never executed)
                     ->  Seq Scan on "SevClsCode" "S"  (cost=0.00..1.24 rows=24 width=34) (never executed)
               ->  Seq Scan on "ControlRecord" c  (cost=0.00..2.90 rows=1 width=2) (never executed)
                     Filter: ((c."countyNo")::smallint = 53)
         ->  Index Scan using "CaseTypeHistEventD_pkey" on "CaseTypeHistEventD" d  (cost=0.00..4.27 rows=1 width=11) (never executed)
               Index Cond: (((d."countyNo")::smallint = (c."countyNo")::smallint) AND ((d."caseType")::bpchar = (b."caseType")::bpchar) AND ((d."eventType")::bpchar = (b."eventType")::bpchar))
 Total runtime: 0.747 ms