explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EQ4D

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 4,634.999 ↓ 0.0 0 1

GroupAggregate (cost=318,646.89..318,647.02 rows=2 width=54) (actual time=4,634.999..4,634.999 rows=0 loops=1)

  • Group Key: bcc.claim_id
2. 0.016 4,634.996 ↓ 0.0 0 1

Sort (cost=318,646.89..318,646.90 rows=2 width=22) (actual time=4,634.996..4,634.996 rows=0 loops=1)

  • Sort Key: bcc.claim_id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.049 4,634.980 ↓ 0.0 0 1

Append (cost=2.26..318,646.88 rows=2 width=22) (actual time=4,634.979..4,634.980 rows=0 loops=1)

4. 0.003 3,931.931 ↓ 0.0 0 1

Nested Loop (cost=2.26..293,883.12 rows=1 width=22) (actual time=3,931.931..3,931.931 rows=0 loops=1)

  • Join Filter: ((bc.charge_id)::text = (bcc.charge_id)::text)
5. 0.002 3,931.928 ↓ 0.0 0 1

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

6. 0.002 3,931.926 ↓ 0.0 0 1

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

7. 36.261 3,931.924 ↓ 0.0 0 1

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

8. 14.471 14.471 ↑ 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.009..14.471 rows=69,307 loops=1)

9. 3,881.192 3,881.192 ↓ 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.056..0.056 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.39 rows=1 width=24) (never executed)

  • Index Cond: ((charge_id)::text = (bac.charge_id)::text)
  • Filter: ((claim_id)::text = ANY ('{C0120000060325,C0120000068290,C0120000059216,C0120000068170,C0120000061894,C0120000063950,C0120000067088,C0120000059690,C0120000057151,C0120000057272,C0120000059576,C0120000056186,C0120000063709,C0120000057033,C0120000065907,C0120000061529,C0120000063947,C0120000061645,C0120000059447,C0120000059448,C0120000030804,C0120000060553,C0120000062971,C0120000068186,C0120000059563,C0120000059684,C0120000058593,C0120000059323,C0120000064703,C0120000064946,C0120000063819,C0120000061317,C0120000063855,C0120000063852,C0120000067182,C0120000068153,C0120000068031,C0120000068273,C0120000066097,C0120000053938,C0120000057296,C0120000057172,C0120000059236,C0120000062519,C0120000062517,C0120000063848,C0120000030820,C0120000060339,C0120000062636,C0120000062999,C0120000061784,C0120000062632,C0120000068282,C0120000053924,C0120000067196,C0120000068288,C0120000059343,C0120000058371,C0120000058136,C0120000057045,C0120000059017,C0120000060369,C0120000062664,C0120000054929,C0120000062660,C0120000030708,C0120000064976,C0120000064614,C0120000064857,C0120000066916,C0120000030720,C0120000063749,C0120000062659,C0120000060116,C0120000061687,C0120000053941,C0120000060478,C0120000061564,C0120000063984,C0120000031811,C0120000053827,C0120000061561,C0120000031814,C0120000064984,C0120000065952,C0120000064745,C0120000065714,C0120000064506,C0120000058156,C0120000066809,C0120000053973,C0120000068192,C0120000062566,C0120000031827,C0120000030734,C0120000053859,C0120000030978,C0120000057098,C0120000065801,C0120000058063,C0120000064715,C0120000064958,C0120000059153,C0120000062559,C0120000062316,C0120000053721,C0120000062433,C0120000054934,C0120000063641,C0120000031954,C0120000030746,C0120000057084,C0120000066906,C0120000031601,C0120000063437,C0120000053877,C0120000061257,C0120000063797,C0120000054966,C0120000063674,C0120000065980,C0120000064893,C0120000059173,C0120000064894,C0120000065621,C0120000066831,C0120000065866,C0120000066954,C0120000064415,C0120000067806,C0120000067805,C0120000059053,C0120000059298,C0120000031975,C0120000062694,C0120000030767,C0120000063782,C0120000061482,C0120000066721,C0120000067814,C0120000066969,C0120000030652,C0120000062009,C0120000054621,C0120000053776,C0120000030898,C0120000061393,C0120000062120,C0120000031748,C0120000062361,C0120000063571,C0120000067900,C0120000064757,C0120000065969,C0120000066819,C0120000031993,C0120000062597,C0120000062233,C0120000063561,C0120000064763,C0120000064764,C0120000066941,C0120000058092,C0120000064404,C0120000066704,C0120000064407,C0120000066947,C0120000059185,C0120000064409,C0120000066707,C0120000067917,C0120000054400,C0120000030670,C0120000030792,C0120000062028,C0120000062027,C0120000063236,C0120000063478,C0120000063477,C0120000066630,C0120000064333,C0120000066513,C0120000067602,C0120000065303,C0120000067964,C0120000068811,C0120000066636,C0120000065668,C0120000067845,C0120000068816,C0120000054870,C0120000055602,C0120000030683,C0120000063228,C0120000056937,C0120000063467,C0120000055729,C0120000060071,C0120000066520,C0120000066883,C0120000065311,C0120000066403,C0120000066524,C0120000064104,C0120000067854,C0120000065678,C0120000066768,C0120000066889,C0120000067735,C0120000067738,C0120000065439,C0120000067616,C0120000031546,C0120000030692,C0120000054424,C0120000031309,C0120000062047,C0120000031308,C0120000066610,C0120000066731,C0120000067941,C0120000066974,C0120000066735,C0120000066856,C0120000064799,C0120000066613,C0120000064679,C0120000065768,C0120000066979,C0120000064317,C0120000064438,C0120000064318,C0120000065407,C0120000066739,C0120000042207,C0120000031796,C0120000054531,C0120000049064,C0120000056831,C0120000054537,C0120000056837,C0120000056958,C0120000062035,C0120000031679,C0120000031559,C0120000057809,C0120000063120,C0120000065650,C0120000066500,C0120000066621,C0120000064201,C0120000067951,C0120000064565,C0120000066986,C0120000066622,C0120000066628,C0120000066509,C0120000056863,C0120000055896,C0120000031682,C0120000055777,C0120000057712,C0120000063159,C0120000062069,C0120000062186,C0120000066672,C0120000065341,C0120000067642,C0120000062062,C0120000067885,C0120000062180,C0120000066678,C0120000065349,C0120000068617,C0120000031578,C0120000031331,C0120000066680,C0120000063143,C0120000066683,C0120000062173,C0120000067531,C0120000067773,C0120000062171,C0120000062292,C0120000066445,C0120000066566,C0120000068865,C0120000061080,C0120000067538,C0120000066328,C0120000057733,C0120000031467,C0120000055795,C0120000063176,C0120000065681,C0120000062086,C0120000066770,C0120000066531,C0120000022757,C0120000066772,C0120000065565,C0120000065688,C0120000066416,C0120000066417,C0120000066538,C0120000054461,C0120000057843,C0120000057842,C0120000056872,C0120000057720,C0120000056873,C0120000059904,C0120000057726,C0120000066780,C0120000062197,C0120000065693,C0120000067870,C0120000063042,C0120000064001,C0120000067754,C0120000067514,C0120000067634,C0120000067999,C0120000056991,C0120000054488,C0120000056424,C0120000057511,C0120000031249,C0120000058720,C0120000054127,C0120000055217,C0120000057517,C0120000058969,C0120000031244,C0120000031486,C0120000066590,C0120000065261,C0120000068771,C0120000065263,C0120000067321,C0120000063076,C0120000064054,C0120000066473,C0120000068530,C0120000067202,C0120000067444,C0120000066596,C0120000064179,C0120000066598,C0120000068537,C0120000063070,C0120000068418,C0120000068419,C0120000055210,C0120000059923,C0120000031259,C0120000055200,C0120000057742,C0120000057620,C0120000032222,C0120000055204,C0120000055446,C0120000065272,C0120000066361,C0120000064184,C0120000067694,C0120000067334,C0120000068423,C0120000062095,C0120000065156,C0120000065398,C0120000067696,C0120000068785,C0120000067336,C0120000062093,C0120000067219,C0120000056564,C0120000057774,C0120000031266,C0120000066691,C0120000065120,C0120000065483,C0120000068751,C0120000044104,C0120000065485,C0120000067785,C0120000067545,C0120000064036,C0120000065005,C0120000065247,C0120000066216,C0120000067307,C0120000063090,C0120000067306,C0120000068637,C0120000031261,C0120000067429,C0120000054260,C0120000054380,C0120000054140,C0120000057772,C0120000031380,C0120000056440,C0120000056798,C0120000057886,C0120000056796,C0120000057528,C0120000058614,C0120000066580,C0120000067550,C0120000041064,C0120000067670,C0120000064284,C0120000066220,C0120000066341,C0120000066584,C0120000068883,C0120000065132,C0120000065253,C0120000067430,C0120000068640,C0120000068885,C0120000064166,C0120000067795,C0120000066104,C0120000067676,C0120000067558,C0120000067436,C0120000067319,C0120000058972,C0120000054371,C0120000053079,C0120000057433,C0120000061934,C0120000056229,C0120000057438,C0120000032015,C0120000067480,C0120000058409,C0120000064095,C0120000065063,C0120000066394,C0120000067362,C0120000064098,C0120000066155,C0120000067243,C0120000068455,C0120000067006,C0120000067127,C0120000067129,C0120000067009,C0120000056577,C0120000056215,C0120000055365,C0120000057786,C0120000057664,C0120000060955,C0120000054039,C0120000055129,C0120000058518,C0120000059963,C0120000057305,C0120000059603,C0120000067371,C0120000068581,C0120000068465,C0120000066166,C0120000066046,C0120000067378,C0120000068466,C0120000053184,C0120000056211,C0120000054153,C0120000055241,C0120000056330,C0120000058668,C0120000055038,C0120000064190,C0120000060982,C0120000067460,C0120000067581,C0120000067462,C0120000068551,C0120000064195,C0120000064196,C0120000066133,C0120000067342,C0120000067463,C0120000066256,C0120000068312,C0120000067226,C0120000067348,C0120000067469,C0120000067229,C0120000031065,C0120000058663,C0120000056242,C0120000057330,C0120000057203,C0120000061823,C0120000055028,C0120000061940,C0120000059867,C0120000067470,C0120000068561,C0120000065296,C0120000066386,C0120000067111,C0120000067358,C0120000065059,C0120000067359,C0120000068209,C0120000056591,C0120000055264,C0120000055265,C0120000054176,C0120000031193,C0120000060648,C0120000061858,C0120000061979,C0120000058447,C0120000062704,C0120000056147,C0120000056268,C0120000058324,C0120000059413,C0120000046343,C0120000068375,C0120000068253,C0120000067169,C0120000031084,C0120000054083,C0120000056023,C0120000061728,C0120000031099,C0120000057108,C0120000059888,C0120000060752,C0120000067172,C0120000067293,C0120000061961,C0120000066084,C0120000068383,C0120000067175,C0120000067298,C0120000068266,C0120000055280,C0120000054077,C0120000058431,C0120000054076,C0120000057220,C0120000058225,C0120000060669,C0120000061758,C0120000061511,C0120000062963,C0120000066171,C0120000066297,C0120000068475,C0120000066299,C0120000068114,C0120000067027,C0120000068118,C0120000057494,C0120000057372,C0120000057135,C0120000063808,C0120000057374,C0120000057126,C0120000062715,C0120000058698,C0120000063803,C0120000062710,C0120000068360,C0120000067396,C0120000067277,C0120000067279,C0120000057363}'::text[]))
16. 2.050 703.000 ↓ 0.0 0 1

Nested Loop (cost=3.14..24,763.70 rows=1 width=22) (actual time=703.000..703.000 rows=0 loops=1)

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

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

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

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

19. 2.269 2.269 ↓ 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.025..2.269 rows=5,192 loops=1)

20. 254.408 254.408 ↑ 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.049..0.049 rows=1 loops=5,192)

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

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

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

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

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

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

  • Index Cond: ((charge_id)::text = (b.charge_id)::text)
  • Filter: ((claim_id)::text = ANY ('{C0120000060325,C0120000068290,C0120000059216,C0120000068170,C0120000061894,C0120000063950,C0120000067088,C0120000059690,C0120000057151,C0120000057272,C0120000059576,C0120000056186,C0120000063709,C0120000057033,C0120000065907,C0120000061529,C0120000063947,C0120000061645,C0120000059447,C0120000059448,C0120000030804,C0120000060553,C0120000062971,C0120000068186,C0120000059563,C0120000059684,C0120000058593,C0120000059323,C0120000064703,C0120000064946,C0120000063819,C0120000061317,C0120000063855,C0120000063852,C0120000067182,C0120000068153,C0120000068031,C0120000068273,C0120000066097,C0120000053938,C0120000057296,C0120000057172,C0120000059236,C0120000062519,C0120000062517,C0120000063848,C0120000030820,C0120000060339,C0120000062636,C0120000062999,C0120000061784,C0120000062632,C0120000068282,C0120000053924,C0120000067196,C0120000068288,C0120000059343,C0120000058371,C0120000058136,C0120000057045,C0120000059017,C0120000060369,C0120000062664,C0120000054929,C0120000062660,C0120000030708,C0120000064976,C0120000064614,C0120000064857,C0120000066916,C0120000030720,C0120000063749,C0120000062659,C0120000060116,C0120000061687,C0120000053941,C0120000060478,C0120000061564,C0120000063984,C0120000031811,C0120000053827,C0120000061561,C0120000031814,C0120000064984,C0120000065952,C0120000064745,C0120000065714,C0120000064506,C0120000058156,C0120000066809,C0120000053973,C0120000068192,C0120000062566,C0120000031827,C0120000030734,C0120000053859,C0120000030978,C0120000057098,C0120000065801,C0120000058063,C0120000064715,C0120000064958,C0120000059153,C0120000062559,C0120000062316,C0120000053721,C0120000062433,C0120000054934,C0120000063641,C0120000031954,C0120000030746,C0120000057084,C0120000066906,C0120000031601,C0120000063437,C0120000053877,C0120000061257,C0120000063797,C0120000054966,C0120000063674,C0120000065980,C0120000064893,C0120000059173,C0120000064894,C0120000065621,C0120000066831,C0120000065866,C0120000066954,C0120000064415,C0120000067806,C0120000067805,C0120000059053,C0120000059298,C0120000031975,C0120000062694,C0120000030767,C0120000063782,C0120000061482,C0120000066721,C0120000067814,C0120000066969,C0120000030652,C0120000062009,C0120000054621,C0120000053776,C0120000030898,C0120000061393,C0120000062120,C0120000031748,C0120000062361,C0120000063571,C0120000067900,C0120000064757,C0120000065969,C0120000066819,C0120000031993,C0120000062597,C0120000062233,C0120000063561,C0120000064763,C0120000064764,C0120000066941,C0120000058092,C0120000064404,C0120000066704,C0120000064407,C0120000066947,C0120000059185,C0120000064409,C0120000066707,C0120000067917,C0120000054400,C0120000030670,C0120000030792,C0120000062028,C0120000062027,C0120000063236,C0120000063478,C0120000063477,C0120000066630,C0120000064333,C0120000066513,C0120000067602,C0120000065303,C0120000067964,C0120000068811,C0120000066636,C0120000065668,C0120000067845,C0120000068816,C0120000054870,C0120000055602,C0120000030683,C0120000063228,C0120000056937,C0120000063467,C0120000055729,C0120000060071,C0120000066520,C0120000066883,C0120000065311,C0120000066403,C0120000066524,C0120000064104,C0120000067854,C0120000065678,C0120000066768,C0120000066889,C0120000067735,C0120000067738,C0120000065439,C0120000067616,C0120000031546,C0120000030692,C0120000054424,C0120000031309,C0120000062047,C0120000031308,C0120000066610,C0120000066731,C0120000067941,C0120000066974,C0120000066735,C0120000066856,C0120000064799,C0120000066613,C0120000064679,C0120000065768,C0120000066979,C0120000064317,C0120000064438,C0120000064318,C0120000065407,C0120000066739,C0120000042207,C0120000031796,C0120000054531,C0120000049064,C0120000056831,C0120000054537,C0120000056837,C0120000056958,C0120000062035,C0120000031679,C0120000031559,C0120000057809,C0120000063120,C0120000065650,C0120000066500,C0120000066621,C0120000064201,C0120000067951,C0120000064565,C0120000066986,C0120000066622,C0120000066628,C0120000066509,C0120000056863,C0120000055896,C0120000031682,C0120000055777,C0120000057712,C0120000063159,C0120000062069,C0120000062186,C0120000066672,C0120000065341,C0120000067642,C0120000062062,C0120000067885,C0120000062180,C0120000066678,C0120000065349,C0120000068617,C0120000031578,C0120000031331,C0120000066680,C0120000063143,C0120000066683,C0120000062173,C0120000067531,C0120000067773,C0120000062171,C0120000062292,C0120000066445,C0120000066566,C0120000068865,C0120000061080,C0120000067538,C0120000066328,C0120000057733,C0120000031467,C0120000055795,C0120000063176,C0120000065681,C0120000062086,C0120000066770,C0120000066531,C0120000022757,C0120000066772,C0120000065565,C0120000065688,C0120000066416,C0120000066417,C0120000066538,C0120000054461,C0120000057843,C0120000057842,C0120000056872,C0120000057720,C0120000056873,C0120000059904,C0120000057726,C0120000066780,C0120000062197,C0120000065693,C0120000067870,C0120000063042,C0120000064001,C0120000067754,C0120000067514,C0120000067634,C0120000067999,C0120000056991,C0120000054488,C0120000056424,C0120000057511,C0120000031249,C0120000058720,C0120000054127,C0120000055217,C0120000057517,C0120000058969,C0120000031244,C0120000031486,C0120000066590,C0120000065261,C0120000068771,C0120000065263,C0120000067321,C0120000063076,C0120000064054,C0120000066473,C0120000068530,C0120000067202,C0120000067444,C0120000066596,C0120000064179,C0120000066598,C0120000068537,C0120000063070,C0120000068418,C0120000068419,C0120000055210,C0120000059923,C0120000031259,C0120000055200,C0120000057742,C0120000057620,C0120000032222,C0120000055204,C0120000055446,C0120000065272,C0120000066361,C0120000064184,C0120000067694,C0120000067334,C0120000068423,C0120000062095,C0120000065156,C0120000065398,C0120000067696,C0120000068785,C0120000067336,C0120000062093,C0120000067219,C0120000056564,C0120000057774,C0120000031266,C0120000066691,C0120000065120,C0120000065483,C0120000068751,C0120000044104,C0120000065485,C0120000067785,C0120000067545,C0120000064036,C0120000065005,C0120000065247,C0120000066216,C0120000067307,C0120000063090,C0120000067306,C0120000068637,C0120000031261,C0120000067429,C0120000054260,C0120000054380,C0120000054140,C0120000057772,C0120000031380,C0120000056440,C0120000056798,C0120000057886,C0120000056796,C0120000057528,C0120000058614,C0120000066580,C0120000067550,C0120000041064,C0120000067670,C0120000064284,C0120000066220,C0120000066341,C0120000066584,C0120000068883,C0120000065132,C0120000065253,C0120000067430,C0120000068640,C0120000068885,C0120000064166,C0120000067795,C0120000066104,C0120000067676,C0120000067558,C0120000067436,C0120000067319,C0120000058972,C0120000054371,C0120000053079,C0120000057433,C0120000061934,C0120000056229,C0120000057438,C0120000032015,C0120000067480,C0120000058409,C0120000064095,C0120000065063,C0120000066394,C0120000067362,C0120000064098,C0120000066155,C0120000067243,C0120000068455,C0120000067006,C0120000067127,C0120000067129,C0120000067009,C0120000056577,C0120000056215,C0120000055365,C0120000057786,C0120000057664,C0120000060955,C0120000054039,C0120000055129,C0120000058518,C0120000059963,C0120000057305,C0120000059603,C0120000067371,C0120000068581,C0120000068465,C0120000066166,C0120000066046,C0120000067378,C0120000068466,C0120000053184,C0120000056211,C0120000054153,C0120000055241,C0120000056330,C0120000058668,C0120000055038,C0120000064190,C0120000060982,C0120000067460,C0120000067581,C0120000067462,C0120000068551,C0120000064195,C0120000064196,C0120000066133,C0120000067342,C0120000067463,C0120000066256,C0120000068312,C0120000067226,C0120000067348,C0120000067469,C0120000067229,C0120000031065,C0120000058663,C0120000056242,C0120000057330,C0120000057203,C0120000061823,C0120000055028,C0120000061940,C0120000059867,C0120000067470,C0120000068561,C0120000065296,C0120000066386,C0120000067111,C0120000067358,C0120000065059,C0120000067359,C0120000068209,C0120000056591,C0120000055264,C0120000055265,C0120000054176,C0120000031193,C0120000060648,C0120000061858,C0120000061979,C0120000058447,C0120000062704,C0120000056147,C0120000056268,C0120000058324,C0120000059413,C0120000046343,C0120000068375,C0120000068253,C0120000067169,C0120000031084,C0120000054083,C0120000056023,C0120000061728,C0120000031099,C0120000057108,C0120000059888,C0120000060752,C0120000067172,C0120000067293,C0120000061961,C0120000066084,C0120000068383,C0120000067175,C0120000067298,C0120000068266,C0120000055280,C0120000054077,C0120000058431,C0120000054076,C0120000057220,C0120000058225,C0120000060669,C0120000061758,C0120000061511,C0120000062963,C0120000066171,C0120000066297,C0120000068475,C0120000066299,C0120000068114,C0120000067027,C0120000068118,C0120000057494,C0120000057372,C0120000057135,C0120000063808,C0120000057374,C0120000057126,C0120000062715,C0120000058698,C0120000063803,C0120000062710,C0120000068360,C0120000067396,C0120000067277,C0120000067279,C0120000057363}'::text[]))
  • Rows Removed by Filter: 1