Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [
- {
- "Plan": {
- "Node Type": "Unique",
- "Parallel Aware": false,
- "Startup Cost": 22654.03,
- "Total Cost": 23091.72,
- "Plan Rows": 3979,
- "Plan Width": 300,
- "Actual Startup Time": 1062.427,
- "Actual Total Time": 1076.112,
- "Actual Rows": 9378,
- "Actual Loops": 1,
- "Output": ["phdrug_phdrug.id", "phdrug_phdrug.uuid", "phdrug_phdrug.default_description", "phdrug_phdrug.alternative_description", "phdrug_phdrug.ean", "phdrug_phdrug.mirror_ean", "phdrug_phdrug.parent_ean", "phdrug_phdrug.reg_num", "phdrug_phdrug.medika_code", "phdrug_phdrug.atc_iv", "phdrug_phdrug.product_type", "phdrug_phdrug.fraction", "phdrug_phdrug.active", "phdrug_phdrug.loyal", "phdrug_phdrug.patent", "phdrug_phdrug.chronics", "phdrug_phdrug.recipe", "phdrug_phdrug.deal", "phdrug_phdrug.specialized", "phdrug_phdrug.armored", "phdrug_phdrug.top_hight_speciality", "phdrug_phdrug.top_generic", "phdrug_phdrug.hight_speciality", "phdrug_phdrug.temp_8_15", "phdrug_phdrug.temp_15_25", "phdrug_phdrug.temp_2_8", "phdrug_phdrug.temp_less_15", "phdrug_phdrug.new", "phdrug_phdrug.mdk_internal_code", "phdrug_phdrug.mdk_single_id", "phdrug_phdrug.mdk_object_id", "phdrug_phdrug.is_from_mdk_db", "phdrug_phdrug.top", "phdrug_phdrug.laboratory_name", "phdrug_phdrug.laboratory_alternative_name", "phdrug_phdrug.imported", "phdrug_phdrug.imported_country", "phdrug_phdrug.laboratory_id", "phdrug_phdrug.specialty", "phdrug_phdrug.dimension_id", "phdrug_phdrug.featured", "phdrug_phdrug.top_ae_rank", "phdrug_phdrug.top_farma_rank"],
- "Shared Hit Blocks": 66704,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 1197,
- "Temp Written Blocks": 1191,
- "Plans": [
- {
- "Node Type": "Sort",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 22654.03,
- "Total Cost": 22663.97,
- "Plan Rows": 3979,
- "Plan Width": 300,
- "Actual Startup Time": 1062.424,
- "Actual Total Time": 1064.511,
- "Actual Rows": 9564,
- "Actual Loops": 1,
- "Output": ["phdrug_phdrug.id", "phdrug_phdrug.uuid", "phdrug_phdrug.default_description", "phdrug_phdrug.alternative_description", "phdrug_phdrug.ean", "phdrug_phdrug.mirror_ean", "phdrug_phdrug.parent_ean", "phdrug_phdrug.reg_num", "phdrug_phdrug.medika_code", "phdrug_phdrug.atc_iv", "phdrug_phdrug.product_type", "phdrug_phdrug.fraction", "phdrug_phdrug.active", "phdrug_phdrug.loyal", "phdrug_phdrug.patent", "phdrug_phdrug.chronics", "phdrug_phdrug.recipe", "phdrug_phdrug.deal", "phdrug_phdrug.specialized", "phdrug_phdrug.armored", "phdrug_phdrug.top_hight_speciality", "phdrug_phdrug.top_generic", "phdrug_phdrug.hight_speciality", "phdrug_phdrug.temp_8_15", "phdrug_phdrug.temp_15_25", "phdrug_phdrug.temp_2_8", "phdrug_phdrug.temp_less_15", "phdrug_phdrug.new", "phdrug_phdrug.mdk_internal_code", "phdrug_phdrug.mdk_single_id", "phdrug_phdrug.mdk_object_id", "phdrug_phdrug.is_from_mdk_db", "phdrug_phdrug.top", "phdrug_phdrug.laboratory_name", "phdrug_phdrug.laboratory_alternative_name", "phdrug_phdrug.imported", "phdrug_phdrug.imported_country", "phdrug_phdrug.laboratory_id", "phdrug_phdrug.specialty", "phdrug_phdrug.dimension_id", "phdrug_phdrug.featured", "phdrug_phdrug.top_ae_rank", "phdrug_phdrug.top_farma_rank"],
- "Sort Key": ["phdrug_phdrug.id", "phdrug_phdrug.default_description", "phdrug_phdrug.uuid", "phdrug_phdrug.alternative_description", "phdrug_phdrug.ean", "phdrug_phdrug.mirror_ean", "phdrug_phdrug.parent_ean", "phdrug_phdrug.reg_num", "phdrug_phdrug.medika_code", "phdrug_phdrug.atc_iv", "phdrug_phdrug.product_type", "phdrug_phdrug.fraction", "phdrug_phdrug.active", "phdrug_phdrug.loyal", "phdrug_phdrug.patent", "phdrug_phdrug.chronics", "phdrug_phdrug.recipe", "phdrug_phdrug.deal", "phdrug_phdrug.specialized", "phdrug_phdrug.armored", "phdrug_phdrug.top_hight_speciality", "phdrug_phdrug.top_generic", "phdrug_phdrug.hight_speciality", "phdrug_phdrug.temp_8_15", "phdrug_phdrug.temp_15_25", "phdrug_phdrug.temp_2_8", "phdrug_phdrug.temp_less_15", "phdrug_phdrug.new", "phdrug_phdrug.mdk_internal_code", "phdrug_phdrug.mdk_single_id", "phdrug_phdrug.mdk_object_id", "phdrug_phdrug.is_from_mdk_db", "phdrug_phdrug.top", "phdrug_phdrug.laboratory_name", "phdrug_phdrug.laboratory_alternative_name", "phdrug_phdrug.imported", "phdrug_phdrug.imported_country", "phdrug_phdrug.laboratory_id", "phdrug_phdrug.specialty", "phdrug_phdrug.dimension_id", "phdrug_phdrug.featured", "phdrug_phdrug.top_ae_rank", "phdrug_phdrug.top_farma_rank"],
- "Sort Method": "quicksort",
- "Sort Space Used": 2957,
- "Sort Space Type": "Memory",
- "Shared Hit Blocks": 66704,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 1197,
- "Temp Written Blocks": 1191,
- "Plans": [
- {
- "Node Type": "Gather",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 4425.85,
- "Total Cost": 22416.12,
- "Plan Rows": 3979,
- "Plan Width": 300,
- "Actual Startup Time": 295.296,
- "Actual Total Time": 1034.659,
- "Actual Rows": 9564,
- "Actual Loops": 1,
- "Output": ["phdrug_phdrug.id", "phdrug_phdrug.uuid", "phdrug_phdrug.default_description", "phdrug_phdrug.alternative_description", "phdrug_phdrug.ean", "phdrug_phdrug.mirror_ean", "phdrug_phdrug.parent_ean", "phdrug_phdrug.reg_num", "phdrug_phdrug.medika_code", "phdrug_phdrug.atc_iv", "phdrug_phdrug.product_type", "phdrug_phdrug.fraction", "phdrug_phdrug.active", "phdrug_phdrug.loyal", "phdrug_phdrug.patent", "phdrug_phdrug.chronics", "phdrug_phdrug.recipe", "phdrug_phdrug.deal", "phdrug_phdrug.specialized", "phdrug_phdrug.armored", "phdrug_phdrug.top_hight_speciality", "phdrug_phdrug.top_generic", "phdrug_phdrug.hight_speciality", "phdrug_phdrug.temp_8_15", "phdrug_phdrug.temp_15_25", "phdrug_phdrug.temp_2_8", "phdrug_phdrug.temp_less_15", "phdrug_phdrug.new", "phdrug_phdrug.mdk_internal_code", "phdrug_phdrug.mdk_single_id", "phdrug_phdrug.mdk_object_id", "phdrug_phdrug.is_from_mdk_db", "phdrug_phdrug.top", "phdrug_phdrug.laboratory_name", "phdrug_phdrug.laboratory_alternative_name", "phdrug_phdrug.imported", "phdrug_phdrug.imported_country", "phdrug_phdrug.laboratory_id", "phdrug_phdrug.specialty", "phdrug_phdrug.dimension_id", "phdrug_phdrug.featured", "phdrug_phdrug.top_ae_rank", "phdrug_phdrug.top_farma_rank"],
- "Workers Planned": 2,
- "Workers Launched": 2,
- "Single Copy": false,
- "Shared Hit Blocks": 66704,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 1197,
- "Temp Written Blocks": 1191,
- "Plans": [
- {
- "Node Type": "Hash Join",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Semi",
- "Startup Cost": 3425.85,
- "Total Cost": 21018.22,
- "Plan Rows": 1658,
- "Plan Width": 300,
- "Actual Startup Time": 400.832,
- "Actual Total Time": 898.269,
- "Actual Rows": 3188,
- "Actual Loops": 3,
- "Output": ["phdrug_phdrug.id", "phdrug_phdrug.uuid", "phdrug_phdrug.default_description", "phdrug_phdrug.alternative_description", "phdrug_phdrug.ean", "phdrug_phdrug.mirror_ean", "phdrug_phdrug.parent_ean", "phdrug_phdrug.reg_num", "phdrug_phdrug.medika_code", "phdrug_phdrug.atc_iv", "phdrug_phdrug.product_type", "phdrug_phdrug.fraction", "phdrug_phdrug.active", "phdrug_phdrug.loyal", "phdrug_phdrug.patent", "phdrug_phdrug.chronics", "phdrug_phdrug.recipe", "phdrug_phdrug.deal", "phdrug_phdrug.specialized", "phdrug_phdrug.armored", "phdrug_phdrug.top_hight_speciality", "phdrug_phdrug.top_generic", "phdrug_phdrug.hight_speciality", "phdrug_phdrug.temp_8_15", "phdrug_phdrug.temp_15_25", "phdrug_phdrug.temp_2_8", "phdrug_phdrug.temp_less_15", "phdrug_phdrug.new", "phdrug_phdrug.mdk_internal_code", "phdrug_phdrug.mdk_single_id", "phdrug_phdrug.mdk_object_id", "phdrug_phdrug.is_from_mdk_db", "phdrug_phdrug.top", "phdrug_phdrug.laboratory_name", "phdrug_phdrug.laboratory_alternative_name", "phdrug_phdrug.imported", "phdrug_phdrug.imported_country", "phdrug_phdrug.laboratory_id", "phdrug_phdrug.specialty", "phdrug_phdrug.dimension_id", "phdrug_phdrug.featured", "phdrug_phdrug.top_ae_rank", "phdrug_phdrug.top_farma_rank"],
- "Inner Unique": false,
- "Hash Cond": "(monetary_drugprice.id = u0.id)",
- "Shared Hit Blocks": 66704,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 1197,
- "Temp Written Blocks": 1191,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 437.053,
- "Actual Total Time": 829.745,
- "Actual Rows": 3543,
- "Actual Loops": 1,
- "Shared Hit Blocks": 22118,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 390,
- "Temp Written Blocks": 388
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 472.404,
- "Actual Total Time": 863.947,
- "Actual Rows": 3555,
- "Actual Loops": 1,
- "Shared Hit Blocks": 21417,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 355,
- "Temp Written Blocks": 353
- }
- ],
- "Plans": [
- {
- "Node Type": "Hash Join",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 2410.54,
- "Total Cost": 19721.51,
- "Plan Rows": 100171,
- "Plan Width": 304,
- "Actual Startup Time": 175.871,
- "Actual Total Time": 653.146,
- "Actual Rows": 114200,
- "Actual Loops": 3,
- "Output": ["phdrug_phdrug.id", "phdrug_phdrug.uuid", "phdrug_phdrug.default_description", "phdrug_phdrug.alternative_description", "phdrug_phdrug.ean", "phdrug_phdrug.mirror_ean", "phdrug_phdrug.parent_ean", "phdrug_phdrug.reg_num", "phdrug_phdrug.medika_code", "phdrug_phdrug.atc_iv", "phdrug_phdrug.product_type", "phdrug_phdrug.fraction", "phdrug_phdrug.active", "phdrug_phdrug.loyal", "phdrug_phdrug.patent", "phdrug_phdrug.chronics", "phdrug_phdrug.recipe", "phdrug_phdrug.deal", "phdrug_phdrug.specialized", "phdrug_phdrug.armored", "phdrug_phdrug.top_hight_speciality", "phdrug_phdrug.top_generic", "phdrug_phdrug.hight_speciality", "phdrug_phdrug.temp_8_15", "phdrug_phdrug.temp_15_25", "phdrug_phdrug.temp_2_8", "phdrug_phdrug.temp_less_15", "phdrug_phdrug.new", "phdrug_phdrug.mdk_internal_code", "phdrug_phdrug.mdk_single_id", "phdrug_phdrug.mdk_object_id", "phdrug_phdrug.is_from_mdk_db", "phdrug_phdrug.top", "phdrug_phdrug.laboratory_name", "phdrug_phdrug.laboratory_alternative_name", "phdrug_phdrug.imported", "phdrug_phdrug.imported_country", "phdrug_phdrug.laboratory_id", "phdrug_phdrug.specialty", "phdrug_phdrug.dimension_id", "phdrug_phdrug.featured", "phdrug_phdrug.top_ae_rank", "phdrug_phdrug.top_farma_rank", "monetary_drugprice.id"],
- "Inner Unique": false,
- "Hash Cond": "(monetary_drugprice.drug_id = phdrug_phdrug.id)",
- "Shared Hit Blocks": 14701,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 1197,
- "Temp Written Blocks": 1191,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 180.717,
- "Actual Total Time": 628.174,
- "Actual Rows": 109652,
- "Actual Loops": 1,
- "Shared Hit Blocks": 4767,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 390,
- "Temp Written Blocks": 388
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 192.399,
- "Actual Total Time": 541.398,
- "Actual Rows": 90548,
- "Actual Loops": 1,
- "Shared Hit Blocks": 4066,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 355,
- "Temp Written Blocks": 353
- }
- ],
- "Plans": [
- {
- "Node Type": "Seq Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": true,
- "Relation Name": "monetary_drugprice",
- "Schema": "public",
- "Alias": "monetary_drugprice",
- "Startup Cost": 0.00,
- "Total Cost": 13906.00,
- "Plan Rows": 160600,
- "Plan Width": 8,
- "Actual Startup Time": 0.011,
- "Actual Total Time": 105.030,
- "Actual Rows": 128480,
- "Actual Loops": 3,
- "Output": ["monetary_drugprice.drug_id", "monetary_drugprice.id"],
- "Shared Hit Blocks": 12300,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.006,
- "Actual Total Time": 99.437,
- "Actual Rows": 124367,
- "Actual Loops": 1,
- "Shared Hit Blocks": 3960,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.014,
- "Actual Total Time": 67.784,
- "Actual Rows": 101114,
- "Actual Loops": 1,
- "Shared Hit Blocks": 3259,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ]
- },
- {
- "Node Type": "Hash",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Startup Cost": 1695.45,
- "Total Cost": 1695.45,
- "Plan Rows": 13607,
- "Plan Width": 304,
- "Actual Startup Time": 173.454,
- "Actual Total Time": 173.454,
- "Actual Rows": 13608,
- "Actual Loops": 3,
- "Output": ["phdrug_phdrug.id", "phdrug_phdrug.uuid", "phdrug_phdrug.default_description", "phdrug_phdrug.alternative_description", "phdrug_phdrug.ean", "phdrug_phdrug.mirror_ean", "phdrug_phdrug.parent_ean", "phdrug_phdrug.reg_num", "phdrug_phdrug.medika_code", "phdrug_phdrug.atc_iv", "phdrug_phdrug.product_type", "phdrug_phdrug.fraction", "phdrug_phdrug.active", "phdrug_phdrug.loyal", "phdrug_phdrug.patent", "phdrug_phdrug.chronics", "phdrug_phdrug.recipe", "phdrug_phdrug.deal", "phdrug_phdrug.specialized", "phdrug_phdrug.armored", "phdrug_phdrug.top_hight_speciality", "phdrug_phdrug.top_generic", "phdrug_phdrug.hight_speciality", "phdrug_phdrug.temp_8_15", "phdrug_phdrug.temp_15_25", "phdrug_phdrug.temp_2_8", "phdrug_phdrug.temp_less_15", "phdrug_phdrug.new", "phdrug_phdrug.mdk_internal_code", "phdrug_phdrug.mdk_single_id", "phdrug_phdrug.mdk_object_id", "phdrug_phdrug.is_from_mdk_db", "phdrug_phdrug.top", "phdrug_phdrug.laboratory_name", "phdrug_phdrug.laboratory_alternative_name", "phdrug_phdrug.imported", "phdrug_phdrug.imported_country", "phdrug_phdrug.laboratory_id", "phdrug_phdrug.specialty", "phdrug_phdrug.dimension_id", "phdrug_phdrug.featured", "phdrug_phdrug.top_ae_rank", "phdrug_phdrug.top_farma_rank", "phdrug_phdrugpicture.drug_id"],
- "Hash Buckets": 16384,
- "Original Hash Buckets": 16384,
- "Hash Batches": 2,
- "Original Hash Batches": 2,
- "Peak Memory Usage": 1691,
- "Shared Hit Blocks": 2361,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 543,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 178.753,
- "Actual Total Time": 178.753,
- "Actual Rows": 13608,
- "Actual Loops": 1,
- "Shared Hit Blocks": 787,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 181
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 189.074,
- "Actual Total Time": 189.074,
- "Actual Rows": 13608,
- "Actual Loops": 1,
- "Shared Hit Blocks": 787,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 181
- }
- ],
- "Plans": [
- {
- "Node Type": "Hash Join",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 504.02,
- "Total Cost": 1695.45,
- "Plan Rows": 13607,
- "Plan Width": 304,
- "Actual Startup Time": 13.918,
- "Actual Total Time": 56.456,
- "Actual Rows": 13608,
- "Actual Loops": 3,
- "Output": ["phdrug_phdrug.id", "phdrug_phdrug.uuid", "phdrug_phdrug.default_description", "phdrug_phdrug.alternative_description", "phdrug_phdrug.ean", "phdrug_phdrug.mirror_ean", "phdrug_phdrug.parent_ean", "phdrug_phdrug.reg_num", "phdrug_phdrug.medika_code", "phdrug_phdrug.atc_iv", "phdrug_phdrug.product_type", "phdrug_phdrug.fraction", "phdrug_phdrug.active", "phdrug_phdrug.loyal", "phdrug_phdrug.patent", "phdrug_phdrug.chronics", "phdrug_phdrug.recipe", "phdrug_phdrug.deal", "phdrug_phdrug.specialized", "phdrug_phdrug.armored", "phdrug_phdrug.top_hight_speciality", "phdrug_phdrug.top_generic", "phdrug_phdrug.hight_speciality", "phdrug_phdrug.temp_8_15", "phdrug_phdrug.temp_15_25", "phdrug_phdrug.temp_2_8", "phdrug_phdrug.temp_less_15", "phdrug_phdrug.new", "phdrug_phdrug.mdk_internal_code", "phdrug_phdrug.mdk_single_id", "phdrug_phdrug.mdk_object_id", "phdrug_phdrug.is_from_mdk_db", "phdrug_phdrug.top", "phdrug_phdrug.laboratory_name", "phdrug_phdrug.laboratory_alternative_name", "phdrug_phdrug.imported", "phdrug_phdrug.imported_country", "phdrug_phdrug.laboratory_id", "phdrug_phdrug.specialty", "phdrug_phdrug.dimension_id", "phdrug_phdrug.featured", "phdrug_phdrug.top_ae_rank", "phdrug_phdrug.top_farma_rank", "phdrug_phdrugpicture.drug_id"],
- "Inner Unique": false,
- "Hash Cond": "(phdrug_phdrug.id = phdrug_phdrugpicture.drug_id)",
- "Shared Hit Blocks": 2361,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 9.075,
- "Actual Total Time": 57.250,
- "Actual Rows": 13608,
- "Actual Loops": 1,
- "Shared Hit Blocks": 787,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 14.480,
- "Actual Total Time": 61.236,
- "Actual Rows": 13608,
- "Actual Loops": 1,
- "Shared Hit Blocks": 787,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ],
- "Plans": [
- {
- "Node Type": "Seq Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Relation Name": "phdrug_phdrug",
- "Schema": "public",
- "Alias": "phdrug_phdrug",
- "Startup Cost": 0.00,
- "Total Cost": 812.18,
- "Plan Rows": 21616,
- "Plan Width": 300,
- "Actual Startup Time": 1.524,
- "Actual Total Time": 24.249,
- "Actual Rows": 21616,
- "Actual Loops": 3,
- "Output": ["phdrug_phdrug.id", "phdrug_phdrug.uuid", "phdrug_phdrug.default_description", "phdrug_phdrug.alternative_description", "phdrug_phdrug.ean", "phdrug_phdrug.mirror_ean", "phdrug_phdrug.parent_ean", "phdrug_phdrug.reg_num", "phdrug_phdrug.medika_code", "phdrug_phdrug.atc_iv", "phdrug_phdrug.product_type", "phdrug_phdrug.fraction", "phdrug_phdrug.active", "phdrug_phdrug.loyal", "phdrug_phdrug.patent", "phdrug_phdrug.chronics", "phdrug_phdrug.recipe", "phdrug_phdrug.deal", "phdrug_phdrug.specialized", "phdrug_phdrug.armored", "phdrug_phdrug.top_hight_speciality", "phdrug_phdrug.top_generic", "phdrug_phdrug.hight_speciality", "phdrug_phdrug.temp_8_15", "phdrug_phdrug.temp_15_25", "phdrug_phdrug.temp_2_8", "phdrug_phdrug.temp_less_15", "phdrug_phdrug.new", "phdrug_phdrug.mdk_internal_code", "phdrug_phdrug.mdk_single_id", "phdrug_phdrug.mdk_object_id", "phdrug_phdrug.is_from_mdk_db", "phdrug_phdrug.top", "phdrug_phdrug.laboratory_name", "phdrug_phdrug.laboratory_alternative_name", "phdrug_phdrug.imported", "phdrug_phdrug.imported_country", "phdrug_phdrug.laboratory_id", "phdrug_phdrug.specialty", "phdrug_phdrug.dimension_id", "phdrug_phdrug.featured", "phdrug_phdrug.top_ae_rank", "phdrug_phdrug.top_farma_rank"],
- "Filter": "phdrug_phdrug.active",
- "Rows Removed by Filter": 2,
- "Shared Hit Blocks": 1788,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 1.674,
- "Actual Total Time": 28.812,
- "Actual Rows": 21616,
- "Actual Loops": 1,
- "Shared Hit Blocks": 596,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 2.267,
- "Actual Total Time": 26.652,
- "Actual Rows": 21616,
- "Actual Loops": 1,
- "Shared Hit Blocks": 596,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ]
- },
- {
- "Node Type": "Hash",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Startup Cost": 333.92,
- "Total Cost": 333.92,
- "Plan Rows": 13608,
- "Plan Width": 4,
- "Actual Startup Time": 12.151,
- "Actual Total Time": 12.151,
- "Actual Rows": 13608,
- "Actual Loops": 3,
- "Output": ["phdrug_phdrugpicture.drug_id"],
- "Hash Buckets": 16384,
- "Original Hash Buckets": 16384,
- "Hash Batches": 1,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 607,
- "Shared Hit Blocks": 573,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 7.256,
- "Actual Total Time": 7.256,
- "Actual Rows": 13608,
- "Actual Loops": 1,
- "Shared Hit Blocks": 191,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 11.914,
- "Actual Total Time": 11.914,
- "Actual Rows": 13608,
- "Actual Loops": 1,
- "Shared Hit Blocks": 191,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ],
- "Plans": [
- {
- "Node Type": "Seq Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Relation Name": "phdrug_phdrugpicture",
- "Schema": "public",
- "Alias": "phdrug_phdrugpicture",
- "Startup Cost": 0.00,
- "Total Cost": 333.92,
- "Plan Rows": 13608,
- "Plan Width": 4,
- "Actual Startup Time": 1.004,
- "Actual Total Time": 6.059,
- "Actual Rows": 13608,
- "Actual Loops": 3,
- "Output": ["phdrug_phdrugpicture.drug_id"],
- "Filter": "phdrug_phdrugpicture.is_main",
- "Rows Removed by Filter": 684,
- "Shared Hit Blocks": 573,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.989,
- "Actual Total Time": 3.696,
- "Actual Rows": 13608,
- "Actual Loops": 1,
- "Shared Hit Blocks": 191,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 1.485,
- "Actual Total Time": 6.513,
- "Actual Rows": 13608,
- "Actual Loops": 1,
- "Shared Hit Blocks": 191,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Hash",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Startup Cost": 935.56,
- "Total Cost": 935.56,
- "Plan Rows": 6380,
- "Plan Width": 4,
- "Actual Startup Time": 189.618,
- "Actual Total Time": 189.618,
- "Actual Rows": 70317,
- "Actual Loops": 3,
- "Output": ["u0.id"],
- "Hash Buckets": 131072,
- "Original Hash Buckets": 8192,
- "Hash Batches": 1,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 3497,
- "Shared Hit Blocks": 51915,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 150.629,
- "Actual Total Time": 150.629,
- "Actual Rows": 70317,
- "Actual Loops": 1,
- "Shared Hit Blocks": 17307,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 279.748,
- "Actual Total Time": 279.748,
- "Actual Rows": 70317,
- "Actual Loops": 1,
- "Shared Hit Blocks": 17307,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ],
- "Plans": [
- {
- "Node Type": "Hash Join",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 136.02,
- "Total Cost": 935.56,
- "Plan Rows": 6380,
- "Plan Width": 4,
- "Actual Startup Time": 5.651,
- "Actual Total Time": 149.854,
- "Actual Rows": 70317,
- "Actual Loops": 3,
- "Output": ["u0.id"],
- "Inner Unique": false,
- "Hash Cond": "(u4.carrier_id = u5.id)",
- "Shared Hit Blocks": 51915,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 5.552,
- "Actual Total Time": 117.737,
- "Actual Rows": 70317,
- "Actual Loops": 1,
- "Shared Hit Blocks": 17307,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 6.895,
- "Actual Total Time": 222.750,
- "Actual Rows": 70317,
- "Actual Loops": 1,
- "Shared Hit Blocks": 17307,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ],
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 5.88,
- "Total Cost": 725.57,
- "Plan Rows": 4279,
- "Plan Width": 8,
- "Actual Startup Time": 3.969,
- "Actual Total Time": 109.297,
- "Actual Rows": 40266,
- "Actual Loops": 3,
- "Output": ["u0.id", "u4.carrier_id"],
- "Inner Unique": false,
- "Shared Hit Blocks": 51776,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 3.406,
- "Actual Total Time": 84.984,
- "Actual Rows": 40266,
- "Actual Loops": 1,
- "Shared Hit Blocks": 17260,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 4.756,
- "Actual Total Time": 163.851,
- "Actual Rows": 40266,
- "Actual Loops": 1,
- "Shared Hit Blocks": 17260,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ],
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 5.45,
- "Total Cost": 34.78,
- "Plan Rows": 2,
- "Plan Width": 20,
- "Actual Startup Time": 3.929,
- "Actual Total Time": 5.444,
- "Actual Rows": 22,
- "Actual Loops": 3,
- "Output": ["u1.id", "u2.pricelist_id", "u4.pricelist_id", "u4.carrier_id", "u7.pricelist_id"],
- "Inner Unique": true,
- "Shared Hit Blocks": 1884,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 3.355,
- "Actual Total Time": 4.720,
- "Actual Rows": 22,
- "Actual Loops": 1,
- "Shared Hit Blocks": 629,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 4.701,
- "Actual Total Time": 6.254,
- "Actual Rows": 22,
- "Actual Loops": 1,
- "Shared Hit Blocks": 629,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ],
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 5.18,
- "Total Cost": 32.05,
- "Plan Rows": 4,
- "Plan Width": 24,
- "Actual Startup Time": 3.882,
- "Actual Total Time": 5.260,
- "Actual Rows": 22,
- "Actual Loops": 3,
- "Output": ["u1.id", "u1.manager_id", "u2.pricelist_id", "u4.pricelist_id", "u4.carrier_id", "u7.pricelist_id"],
- "Inner Unique": true,
- "Shared Hit Blocks": 1684,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 3.301,
- "Actual Total Time": 4.577,
- "Actual Rows": 22,
- "Actual Loops": 1,
- "Shared Hit Blocks": 562,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 4.626,
- "Actual Total Time": 6.021,
- "Actual Rows": 22,
- "Actual Loops": 1,
- "Shared Hit Blocks": 562,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ],
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 4.91,
- "Total Cost": 25.42,
- "Plan Rows": 13,
- "Plan Width": 20,
- "Actual Startup Time": 3.559,
- "Actual Total Time": 4.316,
- "Actual Rows": 106,
- "Actual Loops": 3,
- "Output": ["u1.id", "u1.manager_id", "u2.pricelist_id", "u4.pricelist_id", "u4.carrier_id"],
- "Inner Unique": true,
- "Join Filter": "(u2.pricelist_id = u1.id)",
- "Rows Removed by Join Filter": 0,
- "Shared Hit Blocks": 980,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 2.852,
- "Actual Total Time": 3.533,
- "Actual Rows": 106,
- "Actual Loops": 1,
- "Shared Hit Blocks": 327,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 4.132,
- "Actual Total Time": 5.011,
- "Actual Rows": 106,
- "Actual Loops": 1,
- "Shared Hit Blocks": 327,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ],
- "Plans": [
- {
- "Node Type": "Hash Join",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 4.76,
- "Total Cost": 10.73,
- "Plan Rows": 36,
- "Plan Width": 12,
- "Actual Startup Time": 3.518,
- "Actual Total Time": 3.655,
- "Actual Rows": 161,
- "Actual Loops": 3,
- "Output": ["u2.pricelist_id", "u4.pricelist_id", "u4.carrier_id"],
- "Inner Unique": false,
- "Hash Cond": "(u2.pricelist_id = u4.pricelist_id)",
- "Shared Hit Blocks": 12,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 2.817,
- "Actual Total Time": 2.965,
- "Actual Rows": 161,
- "Actual Loops": 1,
- "Shared Hit Blocks": 4,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 4.073,
- "Actual Total Time": 4.210,
- "Actual Rows": 161,
- "Actual Loops": 1,
- "Shared Hit Blocks": 4,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ],
- "Plans": [
- {
- "Node Type": "Seq Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Relation Name": "monetary_pricelistdestinations",
- "Schema": "public",
- "Alias": "u2",
- "Startup Cost": 0.00,
- "Total Cost": 5.15,
- "Plan Rows": 46,
- "Plan Width": 4,
- "Actual Startup Time": 1.996,
- "Actual Total Time": 2.046,
- "Actual Rows": 46,
- "Actual Loops": 3,
- "Output": ["u2.id", "u2.uuid", "u2.mdk_org_object_id", "u2.to_public", "u2.to_all_pharmacies", "u2.to_all_insurances", "u2.pricelist_id", "u2.to_organization_customer_id"],
- "Filter": "u2.to_public",
- "Rows Removed by Filter": 169,
- "Shared Hit Blocks": 9,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 1.374,
- "Actual Total Time": 1.441,
- "Actual Rows": 46,
- "Actual Loops": 1,
- "Shared Hit Blocks": 3,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 2.332,
- "Actual Total Time": 2.368,
- "Actual Rows": 46,
- "Actual Loops": 1,
- "Shared Hit Blocks": 3,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ]
- },
- {
- "Node Type": "Hash",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Startup Cost": 2.67,
- "Total Cost": 2.67,
- "Plan Rows": 167,
- "Plan Width": 8,
- "Actual Startup Time": 1.484,
- "Actual Total Time": 1.484,
- "Actual Rows": 167,
- "Actual Loops": 3,
- "Output": ["u4.pricelist_id", "u4.carrier_id"],
- "Hash Buckets": 1024,
- "Original Hash Buckets": 1024,
- "Hash Batches": 1,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 15,
- "Shared Hit Blocks": 3,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 1.423,
- "Actual Total Time": 1.423,
- "Actual Rows": 167,
- "Actual Loops": 1,
- "Shared Hit Blocks": 1,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 1.712,
- "Actual Total Time": 1.712,
- "Actual Rows": 167,
- "Actual Loops": 1,
- "Shared Hit Blocks": 1,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ],
- "Plans": [
- {
- "Node Type": "Seq Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Relation Name": "courier_carrier_pricelists",
- "Schema": "public",
- "Alias": "u4",
- "Startup Cost": 0.00,
- "Total Cost": 2.67,
- "Plan Rows": 167,
- "Plan Width": 8,
- "Actual Startup Time": 1.413,
- "Actual Total Time": 1.439,
- "Actual Rows": 167,
- "Actual Loops": 3,
- "Output": ["u4.pricelist_id", "u4.carrier_id"],
- "Shared Hit Blocks": 3,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 1.358,
- "Actual Total Time": 1.389,
- "Actual Rows": 167,
- "Actual Loops": 1,
- "Shared Hit Blocks": 1,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 1.624,
- "Actual Total Time": 1.648,
- "Actual Rows": 167,
- "Actual Loops": 1,
- "Shared Hit Blocks": 1,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ]
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "monetary_pricelist_pkey",
- "Relation Name": "monetary_pricelist",
- "Schema": "public",
- "Alias": "u1",
- "Startup Cost": 0.15,
- "Total Cost": 0.40,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 483,
- "Output": ["u1.id", "u1.uuid", "u1.name", "u1.mdk_object_id", "u1.active", "u1.expires", "u1.datestart", "u1.dateend", "u1.is_from_mdk_db", "u1.manager_id", "u1.mdk_manager_object_id", "u1.international_trade_export"],
- "Index Cond": "(u1.id = u4.pricelist_id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(u1.active AND ((NOT u1.expires) OR (u1.expires AND ((timezone('UTC'::text, u1.datestart))::date <= '2020-05-01'::date) AND ((timezone('UTC'::text, u1.dateend))::date >= '2020-05-01'::date))))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 968,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 161,
- "Shared Hit Blocks": 323,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 1,
- "Actual Loops": 161,
- "Shared Hit Blocks": 323,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Index Only Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "monetary_pricelistcountry_country_pricelist_id_be9ca8b0_uniq",
- "Relation Name": "monetary_pricelistcountry",
- "Schema": "public",
- "Alias": "u7",
- "Startup Cost": 0.28,
- "Total Cost": 0.51,
- "Plan Rows": 1,
- "Plan Width": 4,
- "Actual Startup Time": 0.008,
- "Actual Total Time": 0.008,
- "Actual Rows": 0,
- "Actual Loops": 318,
- "Output": ["u7.country", "u7.pricelist_id"],
- "Index Cond": "((u7.country = 'MX'::text) AND (u7.pricelist_id = u1.id))",
- "Rows Removed by Index Recheck": 0,
- "Heap Fetches": 22,
- "Shared Hit Blocks": 704,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.008,
- "Actual Total Time": 0.008,
- "Actual Rows": 0,
- "Actual Loops": 106,
- "Shared Hit Blocks": 235,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.009,
- "Actual Total Time": 0.009,
- "Actual Rows": 0,
- "Actual Loops": 106,
- "Shared Hit Blocks": 235,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "organization_organization_pkey",
- "Relation Name": "organization_organization",
- "Schema": "public",
- "Alias": "u3",
- "Startup Cost": 0.27,
- "Total Cost": 0.68,
- "Plan Rows": 1,
- "Plan Width": 4,
- "Actual Startup Time": 0.006,
- "Actual Total Time": 0.006,
- "Actual Rows": 1,
- "Actual Loops": 66,
- "Output": ["u3.id", "u3.uuid", "u3.organization_type", "u3.mdk_object_id", "u3.medika_connect_token", "u3.theparent_id", "u3.active", "u3.person_id", "u3.address", "u3.business_line", "u3.colony", "u3.country", "u3.email", "u3.image_header", "u3.legal_name", "u3.logo", "u3.phone", "u3.postal_code", "u3.public_name", "u3.tax_id", "u3.town", "u3.web_page", "u3.is_mdk_profile", "u3.configuration_id", "u3.phone2", "u3.preferred_language_id", "u3.is_global_group"],
- "Index Cond": "(u3.id = u1.manager_id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(u3.active AND (u3.organization_type = 2))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 200,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.005,
- "Actual Total Time": 0.005,
- "Actual Rows": 1,
- "Actual Loops": 22,
- "Shared Hit Blocks": 67,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.006,
- "Actual Total Time": 0.006,
- "Actual Rows": 1,
- "Actual Loops": 22,
- "Shared Hit Blocks": 67,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Index Scan",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "monetary_drugprice_pricelist_id_1ce160ce",
- "Relation Name": "monetary_drugprice",
- "Schema": "public",
- "Alias": "u0",
- "Startup Cost": 0.42,
- "Total Cost": 319.30,
- "Plan Rows": 2610,
- "Plan Width": 8,
- "Actual Startup Time": 0.010,
- "Actual Total Time": 3.867,
- "Actual Rows": 1830,
- "Actual Loops": 66,
- "Output": ["u0.id", "u0.mdk_object_id", "u0.is_from_mdk_db", "u0.pvp_currency", "u0.pvp", "u0.pharmacy_price_currency", "u0.pharmacy_price", "u0.base_currency", "u0.base", "u0.no_tax_price_currency", "u0.no_tax_price", "u0.system_no_tax_price_currency", "u0.system_no_tax_price", "u0.all_included_price_currency", "u0.all_included_price", "u0.system_all_included_price_currency", "u0.system_all_included_price", "u0.margin", "u0.stock", "u0.drug_id", "u0.pricelist_id", "u0.uuid", "u0.offer", "u0.mdk_pricing_id", "u0.system_all_included_price_rate", "u0.system_no_tax_price_rate", "u0.all_included_price_before", "u0.all_included_price_before_currency", "u0.no_tax_price_before", "u0.no_tax_price_before_currency", "u0.system_all_included_price_before", "u0.system_all_included_price_before_currency", "u0.system_all_included_price_before_rate", "u0.system_no_tax_price_before", "u0.system_no_tax_price_before_currency", "u0.system_no_tax_price_before_rate", "u0.calculated_base", "u0.calculated_base_currency", "u0.system_calculated_base", "u0.system_calculated_base_currency", "u0.system_calculated_base_rate"],
- "Index Cond": "(u0.pricelist_id = u1.id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(u0.stock > 0)",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 49892,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.012,
- "Actual Total Time": 3.058,
- "Actual Rows": 1830,
- "Actual Loops": 22,
- "Shared Hit Blocks": 16631,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.011,
- "Actual Total Time": 6.023,
- "Actual Rows": 1830,
- "Actual Loops": 22,
- "Shared Hit Blocks": 16631,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Hash",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Startup Cost": 129.12,
- "Total Cost": 129.12,
- "Plan Rows": 82,
- "Plan Width": 8,
- "Actual Startup Time": 1.666,
- "Actual Total Time": 1.666,
- "Actual Rows": 82,
- "Actual Loops": 3,
- "Output": ["u5.id", "u6.carrier_id"],
- "Hash Buckets": 1024,
- "Original Hash Buckets": 1024,
- "Hash Batches": 1,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 12,
- "Shared Hit Blocks": 139,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 2.132,
- "Actual Total Time": 2.132,
- "Actual Rows": 82,
- "Actual Loops": 1,
- "Shared Hit Blocks": 47,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 2.121,
- "Actual Total Time": 2.121,
- "Actual Rows": 82,
- "Actual Loops": 1,
- "Shared Hit Blocks": 47,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ],
- "Plans": [
- {
- "Node Type": "Hash Join",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 12.46,
- "Total Cost": 129.12,
- "Plan Rows": 82,
- "Plan Width": 8,
- "Actual Startup Time": 1.294,
- "Actual Total Time": 1.625,
- "Actual Rows": 82,
- "Actual Loops": 3,
- "Output": ["u5.id", "u6.carrier_id"],
- "Inner Unique": true,
- "Hash Cond": "(u6.carrier_id = u5.id)",
- "Shared Hit Blocks": 139,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 1.660,
- "Actual Total Time": 2.091,
- "Actual Rows": 82,
- "Actual Loops": 1,
- "Shared Hit Blocks": 47,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 1.655,
- "Actual Total Time": 2.065,
- "Actual Rows": 82,
- "Actual Loops": 1,
- "Shared Hit Blocks": 47,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ],
- "Plans": [
- {
- "Node Type": "Bitmap Heap Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Relation Name": "courier_carrierdelivery",
- "Schema": "public",
- "Alias": "u6",
- "Startup Cost": 9.23,
- "Total Cost": 125.66,
- "Plan Rows": 82,
- "Plan Width": 4,
- "Actual Startup Time": 0.127,
- "Actual Total Time": 0.408,
- "Actual Rows": 82,
- "Actual Loops": 3,
- "Output": ["u6.id", "u6.uuid", "u6.dst_country", "u6.postal_code", "u6.carrier_id", "u6.exclude_code_range_lower", "u6.exclude_code_range_upper", "u6.postal_code_range_lower", "u6.postal_code_range_upper", "u6.external_service_id", "u6.mdk_object_id", "u6.ignore_country_filter"],
- "Recheck Cond": "(((u6.dst_country)::text = 'MX'::text) OR u6.ignore_country_filter)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(((u6.dst_country)::text = 'MX'::text) OR u6.ignore_country_filter)",
- "Rows Removed by Filter": 0,
- "Exact Heap Blocks": 38,
- "Lossy Heap Blocks": 0,
- "Shared Hit Blocks": 133,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.140,
- "Actual Total Time": 0.526,
- "Actual Rows": 82,
- "Actual Loops": 1,
- "Shared Hit Blocks": 45,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.171,
- "Actual Total Time": 0.510,
- "Actual Rows": 82,
- "Actual Loops": 1,
- "Shared Hit Blocks": 45,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ],
- "Plans": [
- {
- "Node Type": "BitmapOr",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 9.23,
- "Total Cost": 9.23,
- "Plan Rows": 82,
- "Plan Width": 0,
- "Actual Startup Time": 0.110,
- "Actual Total Time": 0.110,
- "Actual Rows": 0,
- "Actual Loops": 3,
- "Shared Hit Blocks": 19,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.124,
- "Actual Total Time": 0.124,
- "Actual Rows": 0,
- "Actual Loops": 1,
- "Shared Hit Blocks": 7,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.149,
- "Actual Total Time": 0.149,
- "Actual Rows": 0,
- "Actual Loops": 1,
- "Shared Hit Blocks": 7,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ],
- "Plans": [
- {
- "Node Type": "Bitmap Index Scan",
- "Parent Relationship": "Member",
- "Parallel Aware": false,
- "Index Name": "drugtransaction_carrierdelivery_dst_country_21a1a714_like",
- "Startup Cost": 0.00,
- "Total Cost": 4.87,
- "Plan Rows": 78,
- "Plan Width": 0,
- "Actual Startup Time": 0.092,
- "Actual Total Time": 0.092,
- "Actual Rows": 78,
- "Actual Loops": 3,
- "Index Cond": "((u6.dst_country)::text = 'MX'::text)",
- "Shared Hit Blocks": 11,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.104,
- "Actual Total Time": 0.104,
- "Actual Rows": 78,
- "Actual Loops": 1,
- "Shared Hit Blocks": 4,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.122,
- "Actual Total Time": 0.122,
- "Actual Rows": 78,
- "Actual Loops": 1,
- "Shared Hit Blocks": 4,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ]
- },
- {
- "Node Type": "Bitmap Index Scan",
- "Parent Relationship": "Member",
- "Parallel Aware": false,
- "Index Name": "courier_carrierdelivery_ignore_country_filter_b490c58f",
- "Startup Cost": 0.00,
- "Total Cost": 4.32,
- "Plan Rows": 4,
- "Plan Width": 0,
- "Actual Startup Time": 0.016,
- "Actual Total Time": 0.016,
- "Actual Rows": 4,
- "Actual Loops": 3,
- "Index Cond": "(u6.ignore_country_filter = true)",
- "Shared Hit Blocks": 8,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.019,
- "Actual Total Time": 0.019,
- "Actual Rows": 4,
- "Actual Loops": 1,
- "Shared Hit Blocks": 3,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.025,
- "Actual Total Time": 0.025,
- "Actual Rows": 4,
- "Actual Loops": 1,
- "Shared Hit Blocks": 3,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ]
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Hash",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Startup Cost": 2.55,
- "Total Cost": 2.55,
- "Plan Rows": 55,
- "Plan Width": 4,
- "Actual Startup Time": 1.152,
- "Actual Total Time": 1.152,
- "Actual Rows": 55,
- "Actual Loops": 3,
- "Output": ["u5.id"],
- "Hash Buckets": 1024,
- "Original Hash Buckets": 1024,
- "Hash Batches": 1,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 10,
- "Shared Hit Blocks": 6,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 1.505,
- "Actual Total Time": 1.506,
- "Actual Rows": 55,
- "Actual Loops": 1,
- "Shared Hit Blocks": 2,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 1.467,
- "Actual Total Time": 1.467,
- "Actual Rows": 55,
- "Actual Loops": 1,
- "Shared Hit Blocks": 2,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ],
- "Plans": [
- {
- "Node Type": "Seq Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Relation Name": "courier_carrier",
- "Schema": "public",
- "Alias": "u5",
- "Startup Cost": 0.00,
- "Total Cost": 2.55,
- "Plan Rows": 55,
- "Plan Width": 4,
- "Actual Startup Time": 1.089,
- "Actual Total Time": 1.102,
- "Actual Rows": 55,
- "Actual Loops": 3,
- "Output": ["u5.id"],
- "Shared Hit Blocks": 6,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 1.404,
- "Actual Total Time": 1.422,
- "Actual Rows": 55,
- "Actual Loops": 1,
- "Shared Hit Blocks": 2,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 1.433,
- "Actual Total Time": 1.445,
- "Actual Rows": 55,
- "Actual Loops": 1,
- "Shared Hit Blocks": 2,
- "Shared Read Blocks": 0,
- "Shared Dirtied Blocks": 0,
- "Shared Written Blocks": 0,
- "Local Hit Blocks": 0,
- "Local Read Blocks": 0,
- "Local Dirtied Blocks": 0,
- "Local Written Blocks": 0,
- "Temp Read Blocks": 0,
- "Temp Written Blocks": 0
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- },
- "Planning Time": 87.046,
- "Triggers": [
- ],
- "Execution Time": 1077.930
- }
- ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement