explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2dRG : Optimization for: plan #6jyU

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 46.849 98,904.272 ↑ 790.1 1,331 1

Gather (cost=1,034.79..673,108.53 rows=1,051,609 width=54) (actual time=70.210..98,904.272 rows=1,331 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1.670 98,857.423 ↑ 986.9 444 3

Hash Left Join (cost=34.79..566,947.63 rows=438,170 width=54) (actual time=455.674..98,857.423 rows=444 loops=3)

  • Hash Cond: (ipe.insurance_carrier_endorsement_id = ice.id)
3. 98,854.897 98,854.897 ↑ 986.9 444 3

Parallel Seq Scan on insurance_policy_endorsements ipe (cost=0.00..565,757.83 rows=438,170 width=50) (actual time=454.660..98,854.897 rows=444 loops=3)

  • Filter: (ROW(insurance_policy_id, insurance_policy_coverage_detail_id) = ANY (ARRAY[ROW(879, 1127), ROW(3922, 2498), ROW(4050, 2035), ROW(5869, 2364), ROW(8958, 2473), ROW(9352, 2464), ROW(10115, 3132), ROW(11218, 1870), ROW(11898, 3147), ROW(16426, 3334), ROW(18143, 5195), ROW(18312, 5364), ROW(19135, 6208), ROW(19277, 6352), ROW(19372, 6450), ROW(19378, 6456), ROW(19593, 6675), ROW(19892, 6980), ROW(19994, 7082), ROW(20032, 7120), ROW(20115, 7207), ROW(20181, 7274), ROW(20523, 7626), ROW(21652, 8787), ROW(21663, 88102), ROW(21923, 9065), ROW(22733, 496211), ROW(23136, 10319), ROW(23157, 10341), ROW(23162, 10346), ROW(24217, 11437), ROW(25318, 12561), ROW(26066, 13329), ROW(26257, 13529), ROW(28419, 15743), ROW(28592, 15923), ROW(29624, 16982), ROW(29700, 17060), ROW(30585, 17968), ROW(30937, 18328), ROW(32157, 19583), ROW(32161, 19587), ROW(32540, 19975), ROW(33432, 66039), ROW(34213, 21696), ROW(34300, 21785), ROW(34429, 21919), ROW(34440, 21930), ROW(34540, 43357), ROW(34827, 22332), ROW(35369, 22892), ROW(35948, 23482), ROW(37052, 24602), ROW(37423, 24979), ROW(37893, 25457), ROW(37934, 25499), ROW(37950, 25515), ROW(38291, 25863), ROW(38351, 25924), ROW(38530, 26108), ROW(38643, 26222), ROW(38726, 26305), ROW(38814, 26396), ROW(38842, 26424), ROW(39285, 26882), ROW(39451, 27052), ROW(39529, 27132), ROW(39779, 544549), ROW(39828, 27434), ROW(39899, 27506), ROW(40075, 27684), ROW(40211, 27820), ROW(40298, 27907), ROW(40326, 27935), ROW(40662, 28273), ROW(40740, 28352), ROW(41536, 29168), ROW(41991, 29638), ROW(42215, 29868), ROW(42241, 29895), ROW(42390, 30046), ROW(42429, 30086), ROW(42474, 30132), ROW(42617, 30278), ROW(42651, 30312), ROW(42774, 30439), ROW(42792, 30458), ROW(43100, 30773), ROW(43149, 30822), ROW(43160, 48504), ROW(43490, 31169), ROW(43581, 31264), ROW(43588, 31271), ROW(43626, 31310), ROW(43636, 31320), ROW(44063, 84966), ROW(44185, 31882), ROW(44536, 32237), ROW(44722, 32425), ROW(45014, 32725), ROW(45023, 32734), ROW(45107, 32821), ROW(45174, 32889), ROW(45195, 476633), ROW(45330, 33048), ROW(45467, 33187), ROW(45785, 33513), ROW(45833, 33563), ROW(45920, 33656), ROW(45924, 33660), ROW(46218, 33957), ROW(46346, 34089), ROW(47132, 34893), ROW(47456, 35221), ROW(47588, 35357), ROW(47731, 35505), ROW(47847, 35623), ROW(48194, 35978), ROW(48200, 35984), ROW(48424, 36209), ROW(48765, 36554), ROW(48794, 36583), ROW(49049, 36846), ROW(49285, 37086), ROW(49304, 37106), ROW(49368, 37172), ROW(49672, 37486), ROW(49692, 37506), ROW(49694, 37508), ROW(50015, 37839), ROW(50053, 37880), ROW(50103, 37930), ROW(50242, 38074), ROW(50460, 38299), ROW(50663, 465941), ROW(50672, 38517), ROW(50820, 38667), ROW(50859, 38706), ROW(50955, 38804), ROW(50991, 38840), ROW(51454, 39317), ROW(51493, 39357), ROW(51620, 39485), ROW(51626, 39491), ROW(51708, 39574), ROW(51799, 39668), ROW(51997, 39871), ROW(51998, 528378), ROW(52102, 39980), ROW(52103, 39981), ROW(52338, 40220), ROW(52343, 40225), ROW(52351, 40233), ROW(52446, 40330), ROW(52537, 40421), ROW(52651, 40536), ROW(52895, 40785), ROW(53069, 40961), ROW(53331, 41229), ROW(53456, 41358), ROW(53465, 41368), ROW(53581, 41488), ROW(53693, 41601), ROW(53820, 41734), ROW(53877, 41793), ROW(54040, 41957), ROW(54091, 42010), ROW(54556, 42485), ROW(54690, 42623), ROW(55052, 42994), ROW(55073, 43016), ROW(55130, 43073), ROW(55131, 43074), ROW(55211, 474330), ROW(55229, 43176), ROW(55360, 43312), ROW(55432, 43385), ROW(55433, 43386), ROW(55548, 43504), ROW(55618, 43576), ROW(55640, 43598), ROW(55701, 43660), ROW(56019, 43979), ROW(56051, 44012), ROW(56331, 44297), ROW(56735, 44709), ROW(56758, 44733), ROW(56919, 44897), ROW(57002, 44982), ROW(57185, 45167), ROW(57297, 45279), ROW(57300, 45282), ROW(57340, 45322), ROW(57497, 45480), ROW(57498, 45481), ROW(57598, 45581), ROW(57609, 45592), ROW(57991, 45983), ROW(58161, 46154), ROW(58219, 46213), ROW(58261, 46255), ROW(58264, 46258), ROW(58270, 46264), ROW(58351, 46345), ROW(58361, 46355), ROW(58471, 46467), ROW(58554, 46554), ROW(58709, 46711), ROW(58786, 46787), ROW(58851, 46852), ROW(58873, 46874), ROW(58879, 46880), ROW(58889, 46890), ROW(59071, 315629), ROW(59089, 47092), ROW(59118, 47123), ROW(59138, 47144), ROW(59185, 47192), ROW(59223, 47231), ROW(59241, 47250), ROW(59348, 47359), ROW(59796, 47815), ROW(59959, 47981), ROW(59964, 47986), ROW(60234, 48266), ROW(60237, 48270), ROW(60396, 533730), ROW(60418, 48456), ROW(60458, 48497), ROW(61073, 49126), ROW(61367, 49427), ROW(61470, 49530), ROW(61594, 49656), ROW(61637, 49699), ROW(61683, 49745), ROW(61824, 49887), ROW(61908, 49972), ROW(62013, 50080), ROW(62199, 50272), ROW(62258, 50332), ROW(62495, 50575), ROW(62822, 50908), ROW(62949, 51037), ROW(62975, 51063), ROW(63143, 51232), ROW(63159, 51248), ROW(63725, 51832), ROW(63899, 52007), ROW(64078, 52191), ROW(64186, 52301), ROW(64224, 52340), ROW(64460, 52581), ROW(64665, 52789), ROW(64667, 52791), ROW(64684, 52808), ROW(64811, 52938), ROW(65064, 53197), ROW(65094, 53228), ROW(65384, 53530), ROW(65439, 53587), ROW(65474, 53623), ROW(65541, 53691), ROW(65675, 53829), ROW(65705, 53861), ROW(65932, 54094), ROW(65943, 54105), ROW(66152, 54319), ROW(66307, 54477), ROW(66358, 54529), ROW(66561, 54736), ROW(66805, 54985), ROW(66954, 55141), ROW(67019, 55209), ROW(67045, 55236), ROW(67235, 55433), ROW(67395, 55599), ROW(67914, 56129), ROW(68188, 56409), ROW(68253, 56477), ROW(68632, 56867), ROW(68651, 514297), ROW(68690, 56927), ROW(68935, 57178), ROW(69270, 57521), ROW(69540, 57799), ROW(69610, 57869), ROW(69759, 58025), ROW(69809, 58079), ROW(69834, 58105), ROW(69883, 58155), ROW(70465, 58751), ROW(70505, 58791), ROW(70506, 58792), ROW(70509, 466009), ROW(70963, 59262), ROW(71077, 59377), ROW(71118, 59421), ROW(72234, 60562), ROW(72366, 60696), ROW(72551, 60883), ROW(73029, 61366), ROW(73334, 61677), ROW(73592, 61948), ROW(73787, 62149), ROW(73870, 62236), ROW(73922, 62289), ROW(74070, 62437), ROW(74157, 62527), ROW(74239, 62610), ROW(74483, 62858), ROW(74875, 63258), ROW(75616, 64015), ROW(75892, 64301), ROW(75937, 64348), ROW(75990, 64402), ROW(76372, 64789), ROW(76448, 64867), ROW(76467, 64887), ROW(76607, 65031), ROW(76900, 65330), ROW(77115, 65549), ROW(77185, 65620), ROW(77192, 65627), ROW(77278, 65716), ROW(77844, 66292), ROW(77869, 66317), ROW(78584, 67047), ROW(78827, 67298), ROW(80272, 68777), ROW(80302, 68808), ROW(80408, 69629), ROW(80456, 68965), ROW(80487, 68997), ROW(81022, 69544), ROW(81264, 69797), ROW(81521, 70060), ROW(81649, 70189), ROW(81961, 70508), ROW(82236, 70790), ROW(82348, 146311), ROW(82452, 71009), ROW(82556, 71114), ROW(82615, 71175), ROW(82650, 71211), ROW(82674, 71235), ROW(83208, 71785), ROW(84468, 73075), ROW(84497, 73104), ROW(84570, 73179), ROW(84653, 73265), ROW(84992, 73607), ROW(85197, 73816), ROW(85200, 73819), ROW(85204, 73823), ROW(85459, 74083), ROW(85538, 74163), ROW(85713, 74344), ROW(85787, 74418), ROW(86542, 75186), ROW(86767, 75419), ROW(87098, 471646), ROW(87105, 513695), ROW(87144, 75805), ROW(87228, 75889), ROW(87600, 76270), ROW(87901, 467299), ROW(88152, 76827), ROW(88373, 77055), ROW(88397, 77080), ROW(88444, 77127), ROW(88672, 77359), ROW(88868, 77561), ROW(88923, 77618), ROW(88976, 77672), ROW(88981, 77677), ROW(89730, 78437), ROW(89864, 78574), ROW(89948, 78659), ROW(90216, 78932), ROW(90218, 78934), ROW(90378, 79097), ROW(90430, 79153), ROW(90467, 79190), ROW(91790, 80532), ROW(91974, 511157), ROW(92300, 81053), ROW(92922, 81692), ROW(93161, 81939), ROW(93186, 522699), ROW(93243, 82019), ROW(93426, 82206), ROW(94448, 83255), ROW(94805, 83619), ROW(94815, 83629), ROW(94832, 83646), ROW(95544, 84366), ROW(95558, 84381), ROW(96444, 85292), ROW(96580, 85435), ROW(96672, 85530), ROW(97090, 503355), ROW(97256, 86118), ROW(97320, 86184), ROW(97907, 86787), ROW(97984, 86869), ROW(98022, 86908), ROW(98107, 86995), ROW(98374, 87265), ROW(99002, 504159), ROW(99120, 88035), ROW(99237, 88151), ROW(99464, 88381), ROW(99662, 88584), ROW(99845, 88767), ROW(100354, 89285), ROW(100365, 89298), ROW(100444, 89377), ROW(100453, 476175), ROW(100570, 89506), ROW(100902, 89852), ROW(101604, 90565), ROW(101915, 90888), ROW(102306, 525168), ROW(102411, 533675), ROW(102433, 91419), ROW(102483, 91470), ROW(103006, 92008), ROW(103014, 475062), ROW(103415, 92427), ROW(103523, 473640), ROW(103994, 93028), ROW(104122, 93156), ROW(104195, 93229), ROW(104271, 93308), ROW(104768, 93817), ROW(105289, 94361), ROW(105515, 94592), ROW(105542, 94619), ROW(105779, 94860), ROW(105781, 94862), ROW(105791, 95785), ROW(106120, 502008), ROW(106193, 95283), ROW(106452, 95551), ROW(106564, 486779), ROW(106781, 95891), ROW(107240, 96358), ROW(107633, 96765), ROW(107635, 96767), ROW(107671, 96805), ROW(108216, 97366), ROW(108277, 222038), ROW(108518, 97676), ROW(108568, 97727), ROW(108592, 97751), ROW(108643, 97802), ROW(108962, 98133), ROW(109013, 98183), ROW(109016, 98185), ROW(109141, 98314), ROW(109329, 486451), ROW(109566, 98755), ROW(109730, 98923), ROW(109789, 185448), ROW(109948, 99146), ROW(110013, 547127), ROW(110534, 479028), ROW(110645, 99867), ROW(110720, 99946), ROW(111210, 100449), ROW(111284, 100525), ROW(111349, 100586), ROW(111574, 100821), ROW(111635, 100883), ROW(111752, 101008), ROW(111849, 101108), ROW(112247, 101519), ROW(112256, 101529), ROW(112445, 101723), ROW(112456, 101734), ROW(113424, 102734), ROW(113552, 102866), ROW(113765, 103084), ROW(114024, 103350), ROW(114594, 528969), ROW(114772, 104127), ROW(114833, 104191), ROW(114851, 104210), ROW(115055, 496657), ROW(115084, 104457), ROW(115444, 104834), ROW(115716, 195449), ROW(116186, 105601), ROW(116519, 105946), ROW(117049, 106503), ROW(117852, 107325), ROW(117896, 107369), ROW(118095, 107572), ROW(118473, 107963), ROW(118739, 108244), ROW(118881, 108390), ROW(119045, 108557), ROW(119128, 108643), ROW(119143, 108658), ROW(119278, 108795), ROW(119511, 109034), ROW(119585, 317635), ROW(119678, 530648), ROW(120361, 471148), ROW(120580, 110136), ROW(120612, 473939), ROW(120676, 486827), ROW(121243, 110812), ROW(121610, 111193), ROW(121685, 111269), ROW(122037, 111635), ROW(122264, 111872), ROW(122318, 111926), ROW(122329, 111938), ROW(122675, 545932), ROW(123482, 113124), ROW(123552, 539621), ROW(125298, 504252), ROW(126249, 496863), ROW(127407, 117168), ROW(127458, 543053), ROW(127527, 117288), ROW(128045, 522515), ROW(128086, 213426), ROW(128912, 508461), ROW(129575, 518928), ROW(130468, 120318), ROW(132170, 122067), ROW(133620, 496731), ROW(134197, 530548), ROW(135380, 125360), ROW(138102, 128154), ROW(139238, 465944), ROW(141958, 505562), ROW(142311, 479711), ROW(142764, 132931), ROW(145783, 136080), ROW(146072, 136377), ROW(146420, 136739), ROW(146578, 483114), ROW(146688, 530617), ROW(146721, 137048), ROW(146969, 485499), ROW(146975, 137309), ROW(147219, 137563), ROW(147220, 137564), ROW(147238, 137583), ROW(147699, 138073), ROW(148062, 138449), ROW(148348, 138747), ROW(148350, 138749), ROW(148562, 534668), ROW(148583, 138988), ROW(149168, 139599), ROW(149743, 140190), ROW(149745, 140192), ROW(149942, 140395), ROW(149955, 140408), ROW(150126, 140581), ROW(150418, 140883), ROW(150747, 141227), ROW(150749, 141229), ROW(150751, 141231), ROW(150752, 141232), ROW(150753, 141233), ROW(150754, 141234), ROW(150973, 141467), ROW(150976, 141470), ROW(151213, 141708), ROW(151668, 498030), ROW(151911, 142432), ROW(152043, 495807), ROW(152326, 533724), ROW(152367, 142905), ROW(152402, 514341), ROW(152545, 143095), ROW(152550, 143100), ROW(152551, 143101), ROW(152750, 488508), ROW(152930, 143494), ROW(153792, 144389), ROW(153793, 144390), ROW(154042, 144651), ROW(154270, 144885), ROW(154419, 498823), ROW(154425, 145042), ROW(154531, 277212), ROW(154847, 145483), ROW(154848, 145484), ROW(154851, 145487), ROW(155417, 464128), ROW(155746, 470142), ROW(156026, 462868), ROW(156386, 147073), ROW(156673, 147371), ROW(158040, 148778), ROW(158082, 148820), ROW(158109, 148848), ROW(158294, 149038), ROW(158295, 149039), ROW(158526, 149284), ROW(159191, 149966), ROW(159192, 149967), ROW(159193, 149968), ROW(159221, 473641), ROW(159631, 150422), ROW(159632, 150423), ROW(160174, 310954), ROW(160698, 151528), ROW(160704, 151534), ROW(160706, 151536), ROW(160720, 151550), ROW(160721, 151551), ROW(160722, 151552), ROW(161350, 152205), ROW(161536, 152392), ROW(161775, 152641), ROW(161981, 152851), ROW(161982, 152852), ROW(162199, 153078), ROW(162786, 153681), ROW(162954, 465429), ROW(163043, 153946), ROW(163048, 153951), ROW(163629, 154551), ROW(163766, 544909), ROW(164002, 474577), ROW(164244, 155184), ROW(164657, 155611), ROW(164664, 155618), ROW(164665, 155619), ROW(164667, 155621), ROW(164870, 155829), ROW(164901, 155860), ROW(165510, 175367), ROW(166263, 157270), ROW(166341, 157349), ROW(166561, 157569), ROW(166562, 157570), ROW(166563, 157571), ROW(166596, 482842), ROW(166809, 157823), ROW(167224, 158256), ROW(167328, 475008), ROW(168718, 315184), ROW(169986, 511677), ROW(170199, 161313), ROW(170255, 318953), ROW(170309, 523304), ROW(170554, 161676), ROW(170563, 161685), ROW(170564, 161686), ROW(170852, 161985), ROW(171151, 162294), ROW(171545, 162698), ROW(171784, 517943), ROW(171910, 163081), ROW(171918, 525876), ROW(172126, 163310), ROW(172185, 316337), ROW(172646, 163849), ROW(172870, 471351), ROW(173269, 164492), ROW(173690, 164939), ROW(173691, 164940), ROW(173694, 164943), ROW(173963, 502437), ROW(174096, 165359), ROW(174097, 165360), ROW(174161, 507272), ROW(174407, 165683), ROW(174639, 518699), ROW(176081, 476613), ROW(176354, 167705), ROW(176355, 167706), ROW(176356, 167707), ROW(176357, 167708), ROW(176358, 167709), ROW(176359, 167710), ROW(176445, 486788), ROW(176584, 167942), ROW(177364, 168752), ROW(177569, 168965), ROW(177570, 168966), ROW(177778, 169178), ROW(177779, 169179), ROW(177781, 169181), ROW(177782, 169182), ROW(177783, 169183), ROW(177785, 169185), ROW(177786, 169186), ROW(178721, 170160), ROW(178723, 170162), ROW(178755, 480900), ROW(180031, 530465), ROW(180250, 171750), ROW(180947, 172477), ROW(180949, 172479), ROW(181343, 172895), ROW(181401, 172955), ROW(181670, 709689), ROW(181671, 173232), ROW(181685, 173246), ROW(181924, 173494), ROW(181934, 173504), ROW(182149, 173726), ROW(182154, 173731), ROW(182171, 488966), ROW(182795, 174401), ROW(182799, 174405), ROW(182834, 508999), ROW(182954, 544305), ROW(182976, 540975), ROW(183007, 174621), ROW(183012, 174626), ROW(183214, 174833), ROW(183215, 174834), ROW(183217, 174836), ROW(183218, 174837), ROW(183238, 174857), ROW(183532, 461766), ROW(183651, 175279), ROW(183664, 175293), ROW(183680, 175309), ROW(183696, 175326), ROW(183698, 175328), ROW(183739, 175370), ROW(183754, 470635), ROW(183761, 175392), ROW(183766, 175397), ROW(183790, 175421), ROW(183796, 175428), ROW(183797, 175429), ROW(183799, 175431), ROW(183800, 175432), ROW(183801, 175433), ROW(183802, 175434), ROW(183803, 175435), ROW(183804, 175436), ROW(183805, 175437), ROW(183811, 175444), ROW(183812, 175445), ROW(183827, 316159), ROW(183911, 484770), ROW(183948, 175587), ROW(184012, 175651), ROW(184013, 175652), ROW(184014, 175653), ROW(184015, 175654), ROW(184016, 175655), ROW(184019, 175658), ROW(184045, 489758), ROW(184226, 175875), ROW(184406, 176057), ROW(184407, 176058), ROW(184409, 176060), ROW(184434, 176085), ROW(184508, 176160), ROW(184793, 176459), ROW(185146, 176821), ROW(185148, 176823), ROW(185149, 176824), ROW(185150, 176825), ROW(185155, 176830), ROW(185156, 176831), ROW(185157, 176832), ROW(185158, 176833), ROW(185755, 177451), ROW(186106, 177812), ROW(186155, 317394), ROW(186198, 318903), ROW(186371, 178088), ROW(186406, 178124), ROW(186559, 483921), ROW(186664, 178382), ROW(186667, 178385), ROW(186830, 178558), ROW(188539, 180314), ROW(188544, 180319), ROW(188548, 180323), ROW(188549, 180324), ROW(188805, 180590), ROW(188814, 180599), ROW(188972, 180768), ROW(189243, 249869), ROW(189690, 181506), ROW(189693, 181509), ROW(189694, 181510), ROW(189695, 181511), ROW(189696, 181512), ROW(189846, 181665), ROW(189889, 504073), ROW(189986, 181808), ROW(190235, 182065), ROW(190534, 490463), ROW(190558, 182397), ROW(190728, 182576), ROW(191391, 183265), ROW(191392, 183266), ROW(191393, 183267), ROW(191673, 183552), ROW(191674, 183553), ROW(191716, 475092), ROW(191719, 183598), ROW(191984, 183874), ROW(191985, 183875), ROW(192454, 184353), ROW(192469, 184368), ROW(192476, 478055), ROW(192621, 650897), ROW(192754, 494867), ROW(192786, 546971), ROW(192820, 184732), ROW(192821, 184733), ROW(193150, 185071), ROW(193151, 185072), ROW(193152, 185073), ROW(193153, 185074), ROW(193154, 185075), ROW(193155, 185076), ROW(193389, 628733), ROW(193535, 484008), ROW(194229, 186172), ROW(194323, 186266), ROW(194538, 186485), ROW(194867, 315042), ROW(195123, 187086), ROW(195124, 187087), ROW(195125, 187088), ROW(195126, 187089), ROW(195128, 187091), ROW(195132, 187095), ROW(195133, 187096), ROW(195134, 187097), ROW(195135, 187098), ROW(195138, 187101), ROW(195139, 187102), ROW(195140, 187103), ROW(195141, 187104), ROW(195142, 187105), ROW(195143, 187106), ROW(195144, 187107), ROW(195146, 187109), ROW(195147, 187110), ROW(195148, 187111), ROW(195149, 187112), ROW(195150, 187113), ROW(195176, 187139), ROW(195515, 187487), ROW(195656, 483128), ROW(195723, 317804), ROW(195900, 187876), ROW(196542, 188534), ROW(196773, 188769), ROW(197400, 516830), ROW(198308, 190344), ROW(198309, 190345), ROW(198311, 190347), ROW(198756, 472555), ROW(198870, 522174), ROW(198974, 191035), ROW(199412, 191490), ROW(199738, 191823), ROW(200040, 192132), ROW(200079, 192172), ROW(200342, 518346), ROW(201608, 193744), ROW(201609, 193745), ROW(201611, 193747), ROW(201920, 483047), ROW(202022, 194165), ROW(202023, 194166), ROW(202024, 194167), ROW(202025, 194168), ROW(202026, 194169), ROW(202027, 194170), ROW(202028, 194171), ROW(202029, 194172), ROW(202030, 194173), ROW(202031, 194174), ROW(202032, 194175), ROW(202439, 194593), ROW(202862, 195025), ROW(203162, 461847), ROW(204434, 531705), ROW(204647, 196857), ROW(204648, 196858), ROW(204650, 196860), ROW(204744, 196955), ROW(205313, 543671), ROW(205372, 197594), ROW(205413, 486821), ROW(207519, 199801), ROW(207520, 199802), ROW(207521, 199803), ROW(207523, 199805), ROW(208371, 465257), ROW(208542, 505175), ROW(208888, 518218), ROW(209201, 516799), ROW(209488, 201813), ROW(209620, 201946), ROW(210459, 202810), ROW(210460, 202811), ROW(211517, 203896), ROW(211519, 203898), ROW(212091, 204481), ROW(212382, 204776), ROW(212409, 313808), ROW(212419, 204814), ROW(212421, 204816), ROW(212423, 204818), ROW(212424, 204819), ROW(212667, 205071), ROW(212708, 541039), ROW(212853, 205259), ROW(213355, 205774), ROW(213421, 205841), ROW(214095, 206527), ROW(214098, 206530), ROW(214662, 207109), ROW(214668, 207115), ROW(214902, 207351), ROW(214922, 207371), ROW(215211, 207666), ROW(215216, 207671), ROW(215234, 207690), ROW(215236, 207692), ROW(215238, 207694), ROW(215615, 545865), ROW(215948, 208424), ROW(215949, 208425), ROW(215954, 208430), ROW(216108, 523793), ROW(216115, 316493), ROW(216187, 545368), ROW(216353, 529227), ROW(216525, 522850), ROW(216843, 315060), ROW(216943, 548188), ROW(217039, 478750), ROW(217245, 209757), ROW(217465, 209993), ROW(217552, 210083), ROW(217713, 210245), ROW(217714, 210246), ROW(217738, 210271), ROW(218111, 317334), ROW(218169, 210715), ROW(218284, 210834), ROW(218607, 211164), ROW(218845, 211410), ROW(218847, 211412), ROW(218860, 510081), ROW(219739, 463702), ROW(220456, 472609), ROW(220543, 213139), ROW(221961, 545308), ROW(222183, 545387), ROW(222737, 461268), ROW(223119, 536162), ROW(223212, 536236), ROW(224575, 460602), ROW(225414, 485604), ROW(226328, 537204), ROW(227134, 587084), ROW(227704, 510584), ROW(228414, 221160), ROW(228418, 221164), ROW(228491, 221237), ROW(228532, 221279), ROW(229441, 464736), ROW(232818, 536586), ROW(234986, 491310), ROW(235212, 516862), ROW(235295, 228128), ROW(236624, 471703), ROW(237629, 230517), ROW(238933, 231850), ROW(239293, 488965), ROW(240499, 505684), ROW(240588, 233534), ROW(241045, 234000), ROW(241329, 234287), ROW(241333, 234291), ROW(241562, 234524), ROW(242865, 624204), ROW(244112, 485558), ROW(245114, 542743), ROW(245258, 540214), ROW(245414, 238467), ROW(245584, 480364), ROW(247593, 545069), ROW(248346, 241451), ROW(248859, 654435)]))
  • Rows Removed by Filter: 352413
4. 0.361 0.856 ↑ 1.0 1,013 3

Hash (cost=22.13..22.13 rows=1,013 width=8) (actual time=0.856..0.856 rows=1,013 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 48kB
5. 0.495 0.495 ↑ 1.0 1,013 3

Seq Scan on insurance_carrier_endorsements ice (cost=0.00..22.13 rows=1,013 width=8) (actual time=0.037..0.495 rows=1,013 loops=3)

Planning time : 11.142 ms