explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jfYn

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 615.216 ↓ 0.0 0 1

GroupAggregate (cost=318,836.91..318,837.09 rows=3 width=54) (actual time=615.216..615.216 rows=0 loops=1)

  • Group Key: bcc.claim_id
2. 0.016 615.214 ↓ 0.0 0 1

Sort (cost=318,836.91..318,836.91 rows=3 width=22) (actual time=615.214..615.214 rows=0 loops=1)

  • Sort Key: bcc.claim_id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.002 615.198 ↓ 0.0 0 1

Append (cost=2.26..318,836.88 rows=3 width=22) (actual time=615.198..615.198 rows=0 loops=1)

4. 0.001 355.488 ↓ 0.0 0 1

Nested Loop (cost=2.26..293,883.51 rows=1 width=22) (actual time=355.488..355.488 rows=0 loops=1)

  • Join Filter: ((bc.charge_id)::text = (bcc.charge_id)::text)
5. 0.000 355.487 ↓ 0.0 0 1

Nested Loop (cost=1.70..293,881.69 rows=1 width=53) (actual time=355.487..355.487 rows=0 loops=1)

6. 0.000 355.487 ↓ 0.0 0 1

Nested Loop (cost=1.14..293,871.34 rows=1 width=43) (actual time=355.487..355.487 rows=0 loops=1)

7. 2.161 355.487 ↓ 0.0 0 1

Nested Loop (cost=0.56..293,864.13 rows=1 width=37) (actual time=355.486..355.487 rows=0 loops=1)

8. 6.791 6.791 ↑ 1.0 69,307 1

Seq Scan on service_documents sd (cost=0.00..2,770.56 rows=69,752 width=8) (actual time=0.010..6.791 rows=69,307 loops=1)

9. 346.535 346.535 ↓ 0.0 0 69,307

Index Scan using patient_documents_docid_pkey on patient_documents pd (cost=0.56..4.17 rows=1 width=37) (actual time=0.005..0.005 rows=0 loops=69,307)

  • Index Cond: (doc_id = sd.doc_id)
  • Filter: ((doc_format)::text = 'DOC_FILEUPLOAD'::text)
  • Rows Removed by Filter: 1
10. 0.000 0.000 ↓ 0.0 0

Index Scan using bac_activity_id_index on bill_activity_charge bac (cost=0.57..7.12 rows=3 width=18) (never executed)

  • Index Cond: ((activity_id)::text = (sd.prescription_id)::text)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using bill_charge_pkey on bill_charge bc (cost=0.56..10.35 rows=1 width=10) (never executed)

  • Index Cond: ((charge_id)::text = (bac.charge_id)::text)
  • Filter: ((status <> 'X'::bpchar) AND (SubPlan 1))
12.          

SubPlan (for Index Scan)

13. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.00..16.70 rows=1,000 width=32) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Seq Scan on eclaim_rules er (cost=0.00..1.68 rows=1 width=10) (never executed)

  • Filter: (((rule_name)::text ~~ 'UNIVERSALDENTAL'::text) AND (status = 'A'::bpchar) AND ((code_type)::text = (bc.code_type)::text) AND ((health_authority)::text = 'HAAD'::text))
15. 0.000 0.000 ↓ 0.0 0

Index Scan using bill_charge_claim_charge_id on bill_charge_claim bcc (cost=0.56..1.77 rows=1 width=24) (never executed)

  • Index Cond: ((charge_id)::text = (bac.charge_id)::text)
  • Filter: ((claim_id)::text = ANY ('{C1320000062566,C1320000064982,C1320000062321,C1320000063652,C1320000063419,C1320000061238,C1320000063658,C1320000064506,C1320000063659,C1320000068093,C1320000058066,C1320000065822,C1320000063400,C1320000064734,C1320000066911,C1320000062556,C1320000066910,C1320000063885,C1320000064974,C1320000063881,C1320000066919,C1320000049118,C1320000062316,C1320000063404,C1320000062317,C1320000063889,C1320000064978,C1320000050597,C1320000040315,C1320000062587,C1320000062102,C1320000061015,C1320000061258,C1320000062347,C1320000066940,C1320000061012,C1320000066708,C1320000066707,C1320000063437,C1320000041402,C1320000064768,C1320000065615,C1320000062570,C1320000062575,C1320000061247,C1320000062336,C1320000060396,C1320000063427,C1320000064517,C1320000061007,C1320000062579,C1320000063668,C1320000063429,C1320000063690,C1320000063692,C1320000040337,C1320000064304,C1320000064305,C1320000066724,C1320000068905,C1320000065633,C1320000063699,C1320000062121,C1320000062123,C1320000063211,C1320000065872,C1320000059181,C1320000065639,C1320000064309,C1320000064548,C1320000066727,C1320000067816,C1320000062113,C1320000067802,C1320000063689,C1320000063446,C1320000065623,C1320000066711,C1320000066953,C1320000063683,C1320000065862,C1320000062593,C1320000065621,C1320000062354,C1320000063201,C1320000064530,C1320000059194,C1320000029912,C1320000053664,C1320000063471,C1320000063236,C1320000063479,C1320000067833,C1320000063474,C1320000064564,C1320000065896,C1320000063234,C1320000066741,C1320000066983,C1320000064563,C1320000066982,C1320000064329,C1320000065418,C1320000055616,C1320000062372,C1320000062371,C1320000048083,C1320000062377,C1320000063224,C1320000064558,C1320000064313,C1320000066976,C1320000065403,C1320000067822,C1320000062132,C1320000061044,C1320000063223,C1320000064559,C1320000066979,C1320000052358,C1320000062161,C1320000063250,C1320000064582,C1320000061074,C1320000063493,C1320000065670,C1320000063490,C1320000064348,C1320000065437,C1320000046917,C1320000063257,C1320000064107,C1320000062166,C1320000065674,C1320000067851,C1320000066529,C1320000063480,C1320000062394,C1320000054786,C1320000063240,C1320000058904,C1320000065668,C1320000066516,C1320000036893,C1320000065669,C1320000066515,C1320000066756,C1320000067845,C1320000061064,C1320000062154,C1320000065422,C1320000067601,C1320000064334,C1320000066753,C1320000063487,C1320000064331,C1320000062397,C1320000063244,C1320000065428,C1320000066541,C1320000066540,C1320000067870,C1320000054799,C1320000065690,C1320000065216,C1320000063036,C1320000066543,C1320000051283,C1320000068720,C1320000068723,C1320000068725,C1320000066309,C1320000066530,C1320000058925,C1320000068717,C1320000067624,C1320000063265,C1320000066776,C1320000067865,C1320000063264,C1320000064114,C1320000036870,C1320000063266,C1320000066773,C1320000052381,C1320000065473,C1320000067652,C1320000064382,C1320000054338,C1320000063050,C1320000067658,C1320000063298,C1320000066325,C1320000065478,C1320000067896,C1320000063057,C1320000066564,C1320000068506,C1320000057852,C1320000063282,C1320000064132,C1320000019289,C1320000062196,C1320000063043,C1320000063285,C1320000066550,C1320000063284,C1320000064372,C1320000067880,C1320000067407,C1320000063048,C1320000066317,C1320000064378,C1320000066795,C1320000054354,C1320000057622,C1320000064164,C1320000065495,C1320000066101,C1320000067674,C1320000065496,C1320000066584,C1320000058710,C1320000066341,C1320000065010,C1320000066106,C1320000066348,C1320000054593,C1320000054352,C1320000065255,C1320000054353,C1320000065498,C1320000066102,C1320000068529,C1320000068510,C1320000035746,C1320000067420,C1320000067662,C1320000067660,C1320000057878,C1320000065481,C1320000066339,C1320000058720,C1320000066577,C1320000067424,C1320000065002,C1320000067665,C1320000064156,C1320000052079,C1320000068662,C1320000064063,C1320000067573,C1320000032343,C1320000057766,C1320000066482,C1320000055107,C1320000057526,C1320000058851,C1320000066248,C1320000065156,C1320000066246,C1320000066245,C1320000024966,C1320000068426,C1320000060942,C1320000060929,C1320000056445,C1320000058624,C1320000067564,C1320000058867,C1320000065386,C1320000067321,C1320000065383,C1320000066231,C1320000064050,C1320000067560,C1320000065140,C1320000066239,C1320000067568,C1320000049919,C1320000066477,C1320000067323,C1320000068656,C1320000068658,C1320000036927,C1320000057787,C1320000066266,C1320000064085,C1320000067352,C1320000067118,C1320000066028,C1320000066268,C1320000067599,C1320000065179,C1320000060725,C1320000060967,C1320000047744,C1320000060962,C1320000060963,C1320000045574,C1320000060948,C1320000066255,C1320000066253,C1320000067100,C1320000064075,C1320000064072,C1320000067581,C1320000066491,C1320000067346,C1320000060951,C1320000068439,C1320000048603,C1320000060712,C1320000066046,C1320000066287,C1320000065196,C1320000066044,C1320000058414,C1320000059506,C1320000056474,C1320000058653,C1320000066047,C1320000066289,C1320000067378,C1320000060746,C1320000061836,C1320000028038,C1320000068211,C1320000066277,C1320000066034,C1320000067123,C1320000033620,C1320000066033,C1320000056009,C1320000065183,C1320000067362,C1320000065181,C1320000059992,C1320000059996,C1320000067125,C1320000068457,C1320000062910,C1320000068487,C1320000066066,C1320000067397,C1320000066065,C1320000056492,C1320000062940,C1320000066069,C1320000068489,C1320000060769,C1320000068006,C1320000060529,C1320000068008,C1320000061612,C1320000060525,C1320000062929,C1320000058207,C1320000059536,C1320000059771,C1320000060751,C1320000056025,C1320000059531,C1320000060759,C1320000068238,C1320000062932,C1320000066087,C1320000063810,C1320000063813,C1320000058690,C1320000068014,C1320000067167,C1320000066074,C1320000067161,C1320000062710,C1320000062952,C1320000059312,C1320000061868,C1320000063807,C1320000060539,C1320000049756,C1320000061865,C1320000061864,C1320000061867,C1320000062714,C1320000068283,C1320000068282,C1320000061894,C1320000062740,C1320000056057,C1320000062748,C1320000060324,C1320000060567,C1320000062986,C1320000060326,C1320000064922,C1320000066092,C1320000051850,C1320000048441,C1320000048200,C1320000066097,C1320000066094,C1320000064917,C1320000062737,C1320000063829,C1320000064913,C1320000063825,C1320000027110,C1320000050535,C1320000063611,C1320000060106,C1320000063616,C1320000051631,C1320000068057,C1320000062752,C1320000061665,C1320000061664,C1320000062753,C1320000057178,C1320000058268,C1320000063849,C1320000059350,C1320000061424,C1320000061666,C1320000063602,C1320000060579,C1320000062758,C1320000063604,C1320000063632,C1320000064964,C1320000061695,C1320000062300,C1320000066900,C1320000058031,C1320000063634,C1320000063874,C1320000060360,C1320000061210,C1320000063630,C1320000065817,C1320000064729,C1320000063636,C1320000060369,C1320000066902,C1320000061685,C1320000062776,C1320000063862,C1320000063622,C1320000059138,C1320000064950,C1320000065809,C1320000063625,C1320000059029,C1320000061112,C1320000062445,C1320000064622,C1320000065953,C1320000063531,C1320000061110,C1320000062683,C1320000064629,C1320000065958,C1320000063778,C1320000064867,C1320000065956,C1320000066804,C1320000055914,C1319000712624,C1320000051310,C1320000063763,C1320000059278,C1320000063529,C1320000064618,C1320000063769,C1320000062460,C1320000058198,C1320000067913,C1320000058199,C1320000064888,C1320000067912,C1320000063557,C1320000063796,C1320000064643,C1320000062467,C1320000063314,C1320000060283,C1320000062220,C1320000065972,C1320000060284,C1320000061372,C1320000060285,C1320000063311,C1320000063792,C1320000061132,C1320000062228,C1320000061138,C1320000052666,C1320000052422,C1320000062691,C1320000051579,C1320000062697,C1320000064635,C1320000060278,C1320000065963,C1320000062456,C1320000063545,C1320000064633,C1320000061364,C1320000063300,C1320000063542,C1320000062216,C1320000063305,C1320000064636,C1320000055705,C1320000054855,C1320000065514,C1320000062245,C1320000067934,C1320000062005,C1320000062489,C1320000065994,C1320000065995,C1320000062485,C1320000065758,C1320000066606,C1320000040469,C1320000060056,C1320000063566,C1320000064656,C1320000066834,C1320000062237,C1320000060052,C1320000063564,C1320000064651,C1320000065982,C1320000064658,C1320000065989,C1320000051363,C1320000063351,C1320000063593,C1320000062028,C1320000065535,C1320000067712,C1320000064685,C1320000063110,C1320000065533,C1320000067951,C1320000065773,C1320000066861,C1320000067950,C1320000068800,C1320000053799,C1320000056828,C1320000053312,C1320000040240,C1320000063580,C1320000065525,C1320000061167,C1320000064679,C1320000066856,C1320000066855,C1320000063347,C1320000064674,C1320000066611,C1320000066853,C1320000063341,C1320000063102,C1320000064672,C1320000043511,C1320000067708,C1320000063349,C1320000066616,C1320000066858,C1320000063370,C1320000067737,C1320000065798,C1320000067735,C1320000066403,C1320000063375,C1320000064223,C1320000066402,C1320000062043,C1320000063374,C1320000066643,C1320000067732,C1320000068821,C1320000068824,C1320000065318,C1320000068825,C1320000057939,C1320000039807,C1320000038716,C1320000037629,C1320000054665,C1320000062036,C1320000064456,C1320000065545,C1320000066876,C1320000065544,C1320000062035,C1320000060099,C1320000065542,C1320000043533,C1320000067969,C1320000034108,C1320000063150,C1320000063392,C1320000065331,C1320000063391,C1320000064249,C1320000067759,C1320000062069,C1320000065339,C1320000064247,C1320000065578,C1320000063397,C1320000067513,C1320000064001,C1320000066422,C1320000064244,C1320000066663,C1320000068603,C1320000068606,C1320000067740,C1320000032151,C1320000067502,C1320000062054,C1320000066412,C1320000067500,C1320000062056,C1320000052278,C1320000064021,C1320000065594,C1320000062083,C1320000065595,C1320000057965,C1320000062085,C1320000062082,C1320000057726,C1320000034562,C1320000067538,C1320000066447,C1320000066689,C1320000066204,C1320000063176,C1320000064026,C1320000065357,C1320000064023,C1320000057960,C1320000065597,C1320000068625,C1320000059918,C1320000057732,C1320000064252,C1320000065583,C1320000067762,C1320000054223,C1320000064253,C1320000065342,C1320000065584,C1320000067760,C1320000065582,C1320000065349,C1320000063169,C1320000067527,C1320000065106,C1320000065343,C1320000052282,C1320000065109,C1320000067795,C1320000064044,C1320000065375,C1320000064041,C1320000065130,C1320000067791,C1320000063192,C1320000066229,C1320000067559,C1320000066467,C1320000067313,C1320000067797,C1320000067312,C1320000068402,C1320000068405,C1320000045526,C1320000060906,C1320000064274,C1320000057998,C1320000057997,C1320000058843,C1320000059937,C1320000062091,C1320000065360,C1320000065127,C1320000065367,C1320000066457,C1320000065368,C1320000057510,C1320000067785,C1320000045538,C1320000045536,C1320000057886,C1320000064187,C1320000063097,C1320000065032,C1320000067693,C1320000065036,C1320000061913,C1320000060809,C1320000068531,C1320000058503,C1320000063085,C1320000066353,C1320000066110,C1320000059836,C1320000058741,C1320000067689,C1320000059831,C1320000063088,C1320000055232,C1320000058982,C1320000065267,C1320000068536,C1320000058998,C1320000066387,C1320000066386,C1320000059601,C1320000065053,C1320000065295,C1320000066385,C1320000066384,C1320000065293,C1320000033535,C1320000058993,C1320000064190,C1320000057435,C1320000057437,C1320000065043,C1320000066373,C1320000033525,C1320000055494,C1320000067225,C1320000061924,C1320000067490,C1320000061949,C1320000066167,C1320000067014,C1320000067255,C1320000057448,C1320000067495,C1320000066163,C1320000066161,C1320000060861,C1320000059620,C1320000061959,C1320000061712,C1320000031329,C1320000049832,C1320000068333,C1320000065066,C1320000067003,C1320000059876,C1320000067484,C1320000067483,C1320000031566,C1320000058782,C1320000066159,C1320000059630,C1320000067247,C1320000066157,C1320000061703,C1320000068578,C1320000066181,C1320000065092,C1320000068122,C1320000066189,C1320000067276,C1320000066184,C1320000062820,C1320000068369,C1320000060407,C1320000063910,C1320000061734,C1320000063911,C1320000065081,C1320000068350,C1320000068593,C1320000045011,C1320000068113,C1320000065089,C1320000058563,C1320000066179,C1320000068116,C1320000062810,C1320000060635,C1320000063900,C1320000043087,C1320000057481,C1320000057483,C1320000058335,C1320000067059,C1320000061755,C1320000061512,C1320000063935,C1320000061999,C1320000066192,C1320000033948,C1320000067042,C1320000060416,C1320000061748,C1320000061747,C1320000061749,C1320000063922,C1320000068167,C1320000051964,C1320000060442,C1320000061774,C1320000062863,C1320000062628,C1320000063719,C1320000063958,C1320000063714,C1320000063715,C1320000061537,C1320000062868,C1320000061778,C1320000068393,C1320000050885,C1320000068394,C1320000050883,C1320000068155,C1320000052828,C1320000058127,C1320000059211,C1320000062617,C1320000047237,C1320000060434,C1320000063701,C1320000067094,C1320000068184,C1320000025058,C1320000067091,C1320000050890,C1320000068180,C1320000061553,C1320000062884,C1320000063732,C1320000065911,C1320000063972,C1320000063973,C1320000065916,C1320000062409,C1320000061315,C1320000057040,C1320000060469,C1320000064824,C1320000065913,C1320000067080,C1320000068171,C1320000060694,C1320000061784,C1320000060696,C1320000061782,C1320000062635,C1320000061306,C1320000061789,C1320000063511,C1320000063754,C1320000060486,C1320000060488,C1320000058398,C1320000058399,C1320000065937,C1320000063517,C1320000051771,C1320000052867,C1320000062895,C1320000063743,C1320000063742,C1320000065928,C1320000063504,C1320000065926,C1320000062417,C1320000063506,C1320000058160}'::text[]))
16. 2.231 259.708 ↓ 0.0 0 1

Nested Loop (cost=3.14..24,953.29 rows=2 width=22) (actual time=259.708..259.708 rows=0 loops=1)

  • Join Filter: ((bca.charge_id)::text = (bcc_1.charge_id)::text)
17. 1.657 70.637 ↓ 10.5 5,190 1

Hash Join (cost=2.57..24,065.37 rows=494 width=54) (actual time=0.090..70.637 rows=5,190 loops=1)

  • Hash Cond: ((b.code_type)::text = (msct.code_type)::text)
18. 6.039 68.963 ↓ 1.1 5,192 1

Nested Loop (cost=0.56..24,045.30 rows=4,926 width=60) (actual time=0.052..68.963 rows=5,192 loops=1)

19. 0.620 0.620 ↓ 1.0 5,192 1

Seq Scan on bill_charge_attachment bca (cost=0.00..257.40 rows=5,180 width=44) (actual time=0.006..0.620 rows=5,192 loops=1)

20. 62.304 62.304 ↑ 1.0 1 5,192

Index Scan using bill_charge_pkey on bill_charge b (cost=0.56..4.59 rows=1 width=16) (actual time=0.012..0.012 rows=1 loops=5,192)

  • Index Cond: ((charge_id)::text = (bca.charge_id)::text)
  • Filter: (status <> 'X'::bpchar)
21. 0.005 0.017 ↑ 1.0 3 1

Hash (cost=1.91..1.91 rows=3 width=10) (actual time=0.017..0.017 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
22. 0.012 0.012 ↑ 1.0 3 1

Seq Scan on mrd_supported_code_types msct (cost=0.00..1.91 rows=3 width=10) (actual time=0.011..0.012 rows=3 loops=1)

  • Filter: (attachment_required = 'Y'::bpchar)
  • Rows Removed by Filter: 25
23. 186.840 186.840 ↓ 0.0 0 5,190

Index Scan using bill_charge_claim_charge_id on bill_charge_claim bcc_1 (cost=0.56..1.76 rows=1 width=24) (actual time=0.036..0.036 rows=0 loops=5,190)

  • Index Cond: ((charge_id)::text = (b.charge_id)::text)
  • Filter: ((claim_id)::text = ANY ('{C1320000062566,C1320000064982,C1320000062321,C1320000063652,C1320000063419,C1320000061238,C1320000063658,C1320000064506,C1320000063659,C1320000068093,C1320000058066,C1320000065822,C1320000063400,C1320000064734,C1320000066911,C1320000062556,C1320000066910,C1320000063885,C1320000064974,C1320000063881,C1320000066919,C1320000049118,C1320000062316,C1320000063404,C1320000062317,C1320000063889,C1320000064978,C1320000050597,C1320000040315,C1320000062587,C1320000062102,C1320000061015,C1320000061258,C1320000062347,C1320000066940,C1320000061012,C1320000066708,C1320000066707,C1320000063437,C1320000041402,C1320000064768,C1320000065615,C1320000062570,C1320000062575,C1320000061247,C1320000062336,C1320000060396,C1320000063427,C1320000064517,C1320000061007,C1320000062579,C1320000063668,C1320000063429,C1320000063690,C1320000063692,C1320000040337,C1320000064304,C1320000064305,C1320000066724,C1320000068905,C1320000065633,C1320000063699,C1320000062121,C1320000062123,C1320000063211,C1320000065872,C1320000059181,C1320000065639,C1320000064309,C1320000064548,C1320000066727,C1320000067816,C1320000062113,C1320000067802,C1320000063689,C1320000063446,C1320000065623,C1320000066711,C1320000066953,C1320000063683,C1320000065862,C1320000062593,C1320000065621,C1320000062354,C1320000063201,C1320000064530,C1320000059194,C1320000029912,C1320000053664,C1320000063471,C1320000063236,C1320000063479,C1320000067833,C1320000063474,C1320000064564,C1320000065896,C1320000063234,C1320000066741,C1320000066983,C1320000064563,C1320000066982,C1320000064329,C1320000065418,C1320000055616,C1320000062372,C1320000062371,C1320000048083,C1320000062377,C1320000063224,C1320000064558,C1320000064313,C1320000066976,C1320000065403,C1320000067822,C1320000062132,C1320000061044,C1320000063223,C1320000064559,C1320000066979,C1320000052358,C1320000062161,C1320000063250,C1320000064582,C1320000061074,C1320000063493,C1320000065670,C1320000063490,C1320000064348,C1320000065437,C1320000046917,C1320000063257,C1320000064107,C1320000062166,C1320000065674,C1320000067851,C1320000066529,C1320000063480,C1320000062394,C1320000054786,C1320000063240,C1320000058904,C1320000065668,C1320000066516,C1320000036893,C1320000065669,C1320000066515,C1320000066756,C1320000067845,C1320000061064,C1320000062154,C1320000065422,C1320000067601,C1320000064334,C1320000066753,C1320000063487,C1320000064331,C1320000062397,C1320000063244,C1320000065428,C1320000066541,C1320000066540,C1320000067870,C1320000054799,C1320000065690,C1320000065216,C1320000063036,C1320000066543,C1320000051283,C1320000068720,C1320000068723,C1320000068725,C1320000066309,C1320000066530,C1320000058925,C1320000068717,C1320000067624,C1320000063265,C1320000066776,C1320000067865,C1320000063264,C1320000064114,C1320000036870,C1320000063266,C1320000066773,C1320000052381,C1320000065473,C1320000067652,C1320000064382,C1320000054338,C1320000063050,C1320000067658,C1320000063298,C1320000066325,C1320000065478,C1320000067896,C1320000063057,C1320000066564,C1320000068506,C1320000057852,C1320000063282,C1320000064132,C1320000019289,C1320000062196,C1320000063043,C1320000063285,C1320000066550,C1320000063284,C1320000064372,C1320000067880,C1320000067407,C1320000063048,C1320000066317,C1320000064378,C1320000066795,C1320000054354,C1320000057622,C1320000064164,C1320000065495,C1320000066101,C1320000067674,C1320000065496,C1320000066584,C1320000058710,C1320000066341,C1320000065010,C1320000066106,C1320000066348,C1320000054593,C1320000054352,C1320000065255,C1320000054353,C1320000065498,C1320000066102,C1320000068529,C1320000068510,C1320000035746,C1320000067420,C1320000067662,C1320000067660,C1320000057878,C1320000065481,C1320000066339,C1320000058720,C1320000066577,C1320000067424,C1320000065002,C1320000067665,C1320000064156,C1320000052079,C1320000068662,C1320000064063,C1320000067573,C1320000032343,C1320000057766,C1320000066482,C1320000055107,C1320000057526,C1320000058851,C1320000066248,C1320000065156,C1320000066246,C1320000066245,C1320000024966,C1320000068426,C1320000060942,C1320000060929,C1320000056445,C1320000058624,C1320000067564,C1320000058867,C1320000065386,C1320000067321,C1320000065383,C1320000066231,C1320000064050,C1320000067560,C1320000065140,C1320000066239,C1320000067568,C1320000049919,C1320000066477,C1320000067323,C1320000068656,C1320000068658,C1320000036927,C1320000057787,C1320000066266,C1320000064085,C1320000067352,C1320000067118,C1320000066028,C1320000066268,C1320000067599,C1320000065179,C1320000060725,C1320000060967,C1320000047744,C1320000060962,C1320000060963,C1320000045574,C1320000060948,C1320000066255,C1320000066253,C1320000067100,C1320000064075,C1320000064072,C1320000067581,C1320000066491,C1320000067346,C1320000060951,C1320000068439,C1320000048603,C1320000060712,C1320000066046,C1320000066287,C1320000065196,C1320000066044,C1320000058414,C1320000059506,C1320000056474,C1320000058653,C1320000066047,C1320000066289,C1320000067378,C1320000060746,C1320000061836,C1320000028038,C1320000068211,C1320000066277,C1320000066034,C1320000067123,C1320000033620,C1320000066033,C1320000056009,C1320000065183,C1320000067362,C1320000065181,C1320000059992,C1320000059996,C1320000067125,C1320000068457,C1320000062910,C1320000068487,C1320000066066,C1320000067397,C1320000066065,C1320000056492,C1320000062940,C1320000066069,C1320000068489,C1320000060769,C1320000068006,C1320000060529,C1320000068008,C1320000061612,C1320000060525,C1320000062929,C1320000058207,C1320000059536,C1320000059771,C1320000060751,C1320000056025,C1320000059531,C1320000060759,C1320000068238,C1320000062932,C1320000066087,C1320000063810,C1320000063813,C1320000058690,C1320000068014,C1320000067167,C1320000066074,C1320000067161,C1320000062710,C1320000062952,C1320000059312,C1320000061868,C1320000063807,C1320000060539,C1320000049756,C1320000061865,C1320000061864,C1320000061867,C1320000062714,C1320000068283,C1320000068282,C1320000061894,C1320000062740,C1320000056057,C1320000062748,C1320000060324,C1320000060567,C1320000062986,C1320000060326,C1320000064922,C1320000066092,C1320000051850,C1320000048441,C1320000048200,C1320000066097,C1320000066094,C1320000064917,C1320000062737,C1320000063829,C1320000064913,C1320000063825,C1320000027110,C1320000050535,C1320000063611,C1320000060106,C1320000063616,C1320000051631,C1320000068057,C1320000062752,C1320000061665,C1320000061664,C1320000062753,C1320000057178,C1320000058268,C1320000063849,C1320000059350,C1320000061424,C1320000061666,C1320000063602,C1320000060579,C1320000062758,C1320000063604,C1320000063632,C1320000064964,C1320000061695,C1320000062300,C1320000066900,C1320000058031,C1320000063634,C1320000063874,C1320000060360,C1320000061210,C1320000063630,C1320000065817,C1320000064729,C1320000063636,C1320000060369,C1320000066902,C1320000061685,C1320000062776,C1320000063862,C1320000063622,C1320000059138,C1320000064950,C1320000065809,C1320000063625,C1320000059029,C1320000061112,C1320000062445,C1320000064622,C1320000065953,C1320000063531,C1320000061110,C1320000062683,C1320000064629,C1320000065958,C1320000063778,C1320000064867,C1320000065956,C1320000066804,C1320000055914,C1319000712624,C1320000051310,C1320000063763,C1320000059278,C1320000063529,C1320000064618,C1320000063769,C1320000062460,C1320000058198,C1320000067913,C1320000058199,C1320000064888,C1320000067912,C1320000063557,C1320000063796,C1320000064643,C1320000062467,C1320000063314,C1320000060283,C1320000062220,C1320000065972,C1320000060284,C1320000061372,C1320000060285,C1320000063311,C1320000063792,C1320000061132,C1320000062228,C1320000061138,C1320000052666,C1320000052422,C1320000062691,C1320000051579,C1320000062697,C1320000064635,C1320000060278,C1320000065963,C1320000062456,C1320000063545,C1320000064633,C1320000061364,C1320000063300,C1320000063542,C1320000062216,C1320000063305,C1320000064636,C1320000055705,C1320000054855,C1320000065514,C1320000062245,C1320000067934,C1320000062005,C1320000062489,C1320000065994,C1320000065995,C1320000062485,C1320000065758,C1320000066606,C1320000040469,C1320000060056,C1320000063566,C1320000064656,C1320000066834,C1320000062237,C1320000060052,C1320000063564,C1320000064651,C1320000065982,C1320000064658,C1320000065989,C1320000051363,C1320000063351,C1320000063593,C1320000062028,C1320000065535,C1320000067712,C1320000064685,C1320000063110,C1320000065533,C1320000067951,C1320000065773,C1320000066861,C1320000067950,C1320000068800,C1320000053799,C1320000056828,C1320000053312,C1320000040240,C1320000063580,C1320000065525,C1320000061167,C1320000064679,C1320000066856,C1320000066855,C1320000063347,C1320000064674,C1320000066611,C1320000066853,C1320000063341,C1320000063102,C1320000064672,C1320000043511,C1320000067708,C1320000063349,C1320000066616,C1320000066858,C1320000063370,C1320000067737,C1320000065798,C1320000067735,C1320000066403,C1320000063375,C1320000064223,C1320000066402,C1320000062043,C1320000063374,C1320000066643,C1320000067732,C1320000068821,C1320000068824,C1320000065318,C1320000068825,C1320000057939,C1320000039807,C1320000038716,C1320000037629,C1320000054665,C1320000062036,C1320000064456,C1320000065545,C1320000066876,C1320000065544,C1320000062035,C1320000060099,C1320000065542,C1320000043533,C1320000067969,C1320000034108,C1320000063150,C1320000063392,C1320000065331,C1320000063391,C1320000064249,C1320000067759,C1320000062069,C1320000065339,C1320000064247,C1320000065578,C1320000063397,C1320000067513,C1320000064001,C1320000066422,C1320000064244,C1320000066663,C1320000068603,C1320000068606,C1320000067740,C1320000032151,C1320000067502,C1320000062054,C1320000066412,C1320000067500,C1320000062056,C1320000052278,C1320000064021,C1320000065594,C1320000062083,C1320000065595,C1320000057965,C1320000062085,C1320000062082,C1320000057726,C1320000034562,C1320000067538,C1320000066447,C1320000066689,C1320000066204,C1320000063176,C1320000064026,C1320000065357,C1320000064023,C1320000057960,C1320000065597,C1320000068625,C1320000059918,C1320000057732,C1320000064252,C1320000065583,C1320000067762,C1320000054223,C1320000064253,C1320000065342,C1320000065584,C1320000067760,C1320000065582,C1320000065349,C1320000063169,C1320000067527,C1320000065106,C1320000065343,C1320000052282,C1320000065109,C1320000067795,C1320000064044,C1320000065375,C1320000064041,C1320000065130,C1320000067791,C1320000063192,C1320000066229,C1320000067559,C1320000066467,C1320000067313,C1320000067797,C1320000067312,C1320000068402,C1320000068405,C1320000045526,C1320000060906,C1320000064274,C1320000057998,C1320000057997,C1320000058843,C1320000059937,C1320000062091,C1320000065360,C1320000065127,C1320000065367,C1320000066457,C1320000065368,C1320000057510,C1320000067785,C1320000045538,C1320000045536,C1320000057886,C1320000064187,C1320000063097,C1320000065032,C1320000067693,C1320000065036,C1320000061913,C1320000060809,C1320000068531,C1320000058503,C1320000063085,C1320000066353,C1320000066110,C1320000059836,C1320000058741,C1320000067689,C1320000059831,C1320000063088,C1320000055232,C1320000058982,C1320000065267,C1320000068536,C1320000058998,C1320000066387,C1320000066386,C1320000059601,C1320000065053,C1320000065295,C1320000066385,C1320000066384,C1320000065293,C1320000033535,C1320000058993,C1320000064190,C1320000057435,C1320000057437,C1320000065043,C1320000066373,C1320000033525,C1320000055494,C1320000067225,C1320000061924,C1320000067490,C1320000061949,C1320000066167,C1320000067014,C1320000067255,C1320000057448,C1320000067495,C1320000066163,C1320000066161,C1320000060861,C1320000059620,C1320000061959,C1320000061712,C1320000031329,C1320000049832,C1320000068333,C1320000065066,C1320000067003,C1320000059876,C1320000067484,C1320000067483,C1320000031566,C1320000058782,C1320000066159,C1320000059630,C1320000067247,C1320000066157,C1320000061703,C1320000068578,C1320000066181,C1320000065092,C1320000068122,C1320000066189,C1320000067276,C1320000066184,C1320000062820,C1320000068369,C1320000060407,C1320000063910,C1320000061734,C1320000063911,C1320000065081,C1320000068350,C1320000068593,C1320000045011,C1320000068113,C1320000065089,C1320000058563,C1320000066179,C1320000068116,C1320000062810,C1320000060635,C1320000063900,C1320000043087,C1320000057481,C1320000057483,C1320000058335,C1320000067059,C1320000061755,C1320000061512,C1320000063935,C1320000061999,C1320000066192,C1320000033948,C1320000067042,C1320000060416,C1320000061748,C1320000061747,C1320000061749,C1320000063922,C1320000068167,C1320000051964,C1320000060442,C1320000061774,C1320000062863,C1320000062628,C1320000063719,C1320000063958,C1320000063714,C1320000063715,C1320000061537,C1320000062868,C1320000061778,C1320000068393,C1320000050885,C1320000068394,C1320000050883,C1320000068155,C1320000052828,C1320000058127,C1320000059211,C1320000062617,C1320000047237,C1320000060434,C1320000063701,C1320000067094,C1320000068184,C1320000025058,C1320000067091,C1320000050890,C1320000068180,C1320000061553,C1320000062884,C1320000063732,C1320000065911,C1320000063972,C1320000063973,C1320000065916,C1320000062409,C1320000061315,C1320000057040,C1320000060469,C1320000064824,C1320000065913,C1320000067080,C1320000068171,C1320000060694,C1320000061784,C1320000060696,C1320000061782,C1320000062635,C1320000061306,C1320000061789,C1320000063511,C1320000063754,C1320000060486,C1320000060488,C1320000058398,C1320000058399,C1320000065937,C1320000063517,C1320000051771,C1320000052867,C1320000062895,C1320000063743,C1320000063742,C1320000065928,C1320000063504,C1320000065926,C1320000062417,C1320000063506,C1320000058160}'::text[]))
  • Rows Removed by Filter: 1