Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [
- {
- "Plan": {
- "Node Type": "Unique",
- "Parallel Aware": false,
- "Startup Cost": 4722.96,
- "Total Cost": 5160.76,
- "Plan Rows": 3980,
- "Plan Width": 300,
- "Actual Startup Time": 5938.802,
- "Actual Total Time": 6088.501,
- "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": 191109,
- "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": 7436,
- "Temp Written Blocks": 7412,
- "Plans": [
- {
- "Node Type": "Sort",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 4722.96,
- "Total Cost": 4732.91,
- "Plan Rows": 3980,
- "Plan Width": 300,
- "Actual Startup Time": 5938.800,
- "Actual Total Time": 5963.109,
- "Actual Rows": 65446,
- "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": "external merge",
- "Sort Space Used": 13376,
- "Sort Space Type": "Disk",
- "Shared Hit Blocks": 191109,
- "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": 7436,
- "Temp Written Blocks": 7412,
- "Plans": [
- {
- "Node Type": "Hash Join",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 4060.23,
- "Total Cost": 4484.98,
- "Plan Rows": 3980,
- "Plan Width": 300,
- "Actual Startup Time": 3935.217,
- "Actual Total Time": 4278.094,
- "Actual Rows": 65446,
- "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"],
- "Inner Unique": false,
- "Hash Cond": "(phdrug_phdrugpicture.drug_id = phdrug_phdrug.id)",
- "Shared Hit Blocks": 191109,
- "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": 5764,
- "Temp Written Blocks": 5736,
- "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": 0.492,
- "Actual Total Time": 3.658,
- "Actual Rows": 13608,
- "Actual Loops": 1,
- "Output": ["phdrug_phdrugpicture.id", "phdrug_phdrugpicture.is_main", "phdrug_phdrugpicture.drug_id", "phdrug_phdrugpicture.uuid", "phdrug_phdrugpicture.picture"],
- "Filter": "phdrug_phdrugpicture.is_main",
- "Rows Removed by Filter": 684,
- "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": 3981.21,
- "Total Cost": 3981.21,
- "Plan Rows": 6322,
- "Plan Width": 304,
- "Actual Startup Time": 3931.011,
- "Actual Total Time": 3931.011,
- "Actual Rows": 70317,
- "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", "monetary_drugprice.drug_id"],
- "Hash Buckets": 32768,
- "Original Hash Buckets": 8192,
- "Hash Batches": 8,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 3841,
- "Shared Hit Blocks": 190918,
- "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": 3333,
- "Temp Written Blocks": 5001,
- "Plans": [
- {
- "Node Type": "Hash Join",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 2438.48,
- "Total Cost": 3981.21,
- "Plan Rows": 6322,
- "Plan Width": 304,
- "Actual Startup Time": 1733.864,
- "Actual Total Time": 3023.826,
- "Actual Rows": 70317,
- "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", "monetary_drugprice.drug_id"],
- "Inner Unique": true,
- "Hash Cond": "(monetary_drugprice.pricelist_id = monetary_pricelistcountry.pricelist_id)",
- "Shared Hit Blocks": 190918,
- "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": 3333,
- "Temp Written Blocks": 3319,
- "Plans": [
- {
- "Node Type": "Hash Join",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 2425.13,
- "Total Cost": 3908.42,
- "Plan Rows": 22262,
- "Plan Width": 320,
- "Actual Startup Time": 1733.724,
- "Actual Total Time": 2898.626,
- "Actual Rows": 809541,
- "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", "monetary_drugprice.drug_id", "monetary_drugprice.pricelist_id", "monetary_pricelist.id", "monetary_pricelistdestinations.pricelist_id", "courier_carrier_pricelists.pricelist_id"],
- "Inner Unique": false,
- "Hash Cond": "(courier_carrier_pricelists.carrier_id = courier_carrier.id)",
- "Shared Hit Blocks": 190911,
- "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": 3333,
- "Temp Written Blocks": 3319,
- "Plans": [
- {
- "Node Type": "Hash Join",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 2294.99,
- "Total Cost": 3499.66,
- "Plan Rows": 14932,
- "Plan Width": 324,
- "Actual Startup Time": 1732.851,
- "Actual Total Time": 2596.214,
- "Actual Rows": 464508,
- "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", "monetary_drugprice.drug_id", "monetary_drugprice.pricelist_id", "monetary_pricelist.id", "monetary_pricelistdestinations.pricelist_id", "courier_carrier_pricelists.pricelist_id", "courier_carrier_pricelists.carrier_id"],
- "Inner Unique": false,
- "Hash Cond": "(phdrug_phdrug.id = monetary_drugprice.drug_id)",
- "Shared Hit Blocks": 190866,
- "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": 3333,
- "Temp Written Blocks": 3319,
- "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": 0.582,
- "Actual Total Time": 15.668,
- "Actual Rows": 21616,
- "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"],
- "Filter": "phdrug_phdrug.active",
- "Rows Removed by Filter": 2,
- "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": 2106.64,
- "Total Cost": 2106.64,
- "Plan Rows": 15068,
- "Plan Width": 24,
- "Actual Startup Time": 1723.702,
- "Actual Total Time": 1723.702,
- "Actual Rows": 464508,
- "Actual Loops": 1,
- "Output": ["monetary_drugprice.drug_id", "monetary_drugprice.pricelist_id", "monetary_pricelist.id", "monetary_pricelistdestinations.pricelist_id", "courier_carrier_pricelists.pricelist_id", "courier_carrier_pricelists.carrier_id"],
- "Hash Buckets": 65536,
- "Original Hash Buckets": 16384,
- "Hash Batches": 8,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 3585,
- "Shared Hit Blocks": 190270,
- "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": 2192,
- "Plans": [
- {
- "Node Type": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Inner",
- "Startup Cost": 5.60,
- "Total Cost": 2106.64,
- "Plan Rows": 15068,
- "Plan Width": 24,
- "Actual Startup Time": 1.283,
- "Actual Total Time": 528.170,
- "Actual Rows": 464508,
- "Actual Loops": 1,
- "Output": ["monetary_drugprice.drug_id", "monetary_drugprice.pricelist_id", "monetary_pricelist.id", "monetary_pricelistdestinations.pricelist_id", "courier_carrier_pricelists.pricelist_id", "courier_carrier_pricelists.carrier_id"],
- "Inner Unique": false,
- "Shared Hit Blocks": 190270,
- "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": 34.26,
- "Plan Rows": 6,
- "Plan Width": 16,
- "Actual Startup Time": 1.266,
- "Actual Total Time": 3.080,
- "Actual Rows": 106,
- "Actual Loops": 1,
- "Output": ["monetary_pricelist.id", "monetary_pricelistdestinations.pricelist_id", "courier_carrier_pricelists.pricelist_id", "courier_carrier_pricelists.carrier_id"],
- "Inner Unique": true,
- "Shared Hit Blocks": 644,
- "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": 1.254,
- "Actual Total Time": 2.367,
- "Actual Rows": 106,
- "Actual Loops": 1,
- "Output": ["monetary_pricelist.id", "monetary_pricelist.manager_id", "monetary_pricelistdestinations.pricelist_id", "courier_carrier_pricelists.pricelist_id", "courier_carrier_pricelists.carrier_id"],
- "Inner Unique": true,
- "Join Filter": "(monetary_pricelistdestinations.pricelist_id = monetary_pricelist.id)",
- "Rows Removed by Join Filter": 0,
- "Shared Hit Blocks": 326,
- "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": 1.231,
- "Actual Total Time": 1.436,
- "Actual Rows": 161,
- "Actual Loops": 1,
- "Output": ["monetary_pricelistdestinations.pricelist_id", "courier_carrier_pricelists.pricelist_id", "courier_carrier_pricelists.carrier_id"],
- "Inner Unique": false,
- "Hash Cond": "(monetary_pricelistdestinations.pricelist_id = courier_carrier_pricelists.pricelist_id)",
- "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": "monetary_pricelistdestinations",
- "Startup Cost": 0.00,
- "Total Cost": 5.15,
- "Plan Rows": 46,
- "Plan Width": 4,
- "Actual Startup Time": 0.501,
- "Actual Total Time": 0.550,
- "Actual Rows": 46,
- "Actual Loops": 1,
- "Output": ["monetary_pricelistdestinations.id", "monetary_pricelistdestinations.uuid", "monetary_pricelistdestinations.mdk_org_object_id", "monetary_pricelistdestinations.to_public", "monetary_pricelistdestinations.to_all_pharmacies", "monetary_pricelistdestinations.to_all_insurances", "monetary_pricelistdestinations.pricelist_id", "monetary_pricelistdestinations.to_organization_customer_id"],
- "Filter": "monetary_pricelistdestinations.to_public",
- "Rows Removed by Filter": 169,
- "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": 0.701,
- "Actual Total Time": 0.701,
- "Actual Rows": 167,
- "Actual Loops": 1,
- "Output": ["courier_carrier_pricelists.pricelist_id", "courier_carrier_pricelists.carrier_id"],
- "Hash Buckets": 1024,
- "Original Hash Buckets": 1024,
- "Hash Batches": 1,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 15,
- "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": "courier_carrier_pricelists",
- "Startup Cost": 0.00,
- "Total Cost": 2.67,
- "Plan Rows": 167,
- "Plan Width": 8,
- "Actual Startup Time": 0.596,
- "Actual Total Time": 0.635,
- "Actual Rows": 167,
- "Actual Loops": 1,
- "Output": ["courier_carrier_pricelists.pricelist_id", "courier_carrier_pricelists.carrier_id"],
- "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": "monetary_pricelist",
- "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": 161,
- "Output": ["monetary_pricelist.id", "monetary_pricelist.uuid", "monetary_pricelist.name", "monetary_pricelist.mdk_object_id", "monetary_pricelist.active", "monetary_pricelist.expires", "monetary_pricelist.datestart", "monetary_pricelist.dateend", "monetary_pricelist.is_from_mdk_db", "monetary_pricelist.manager_id", "monetary_pricelist.mdk_manager_object_id", "monetary_pricelist.international_trade_export"],
- "Index Cond": "(monetary_pricelist.id = courier_carrier_pricelists.pricelist_id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(monetary_pricelist.active AND ((NOT monetary_pricelist.expires) OR (monetary_pricelist.expires AND ((timezone('UTC'::text, monetary_pricelist.datestart))::date <= '2020-05-01'::date) AND ((timezone('UTC'::text, monetary_pricelist.dateend))::date >= '2020-05-01'::date))))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 322,
- "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": "organization_organization",
- "Startup Cost": 0.27,
- "Total Cost": 0.68,
- "Plan Rows": 1,
- "Plan Width": 4,
- "Actual Startup Time": 0.005,
- "Actual Total Time": 0.005,
- "Actual Rows": 1,
- "Actual Loops": 106,
- "Output": ["organization_organization.id", "organization_organization.uuid", "organization_organization.organization_type", "organization_organization.mdk_object_id", "organization_organization.medika_connect_token", "organization_organization.theparent_id", "organization_organization.active", "organization_organization.person_id", "organization_organization.address", "organization_organization.business_line", "organization_organization.colony", "organization_organization.country", "organization_organization.email", "organization_organization.image_header", "organization_organization.legal_name", "organization_organization.logo", "organization_organization.phone", "organization_organization.postal_code", "organization_organization.public_name", "organization_organization.tax_id", "organization_organization.town", "organization_organization.web_page", "organization_organization.is_mdk_profile", "organization_organization.configuration_id", "organization_organization.phone2", "organization_organization.preferred_language_id", "organization_organization.is_global_group"],
- "Index Cond": "(organization_organization.id = monetary_pricelist.manager_id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(organization_organization.active AND (organization_organization.organization_type = 2))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 318,
- "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": "monetary_drugprice",
- "Startup Cost": 0.42,
- "Total Cost": 319.30,
- "Plan Rows": 2610,
- "Plan Width": 8,
- "Actual Startup Time": 0.008,
- "Actual Total Time": 3.806,
- "Actual Rows": 4382,
- "Actual Loops": 106,
- "Output": ["monetary_drugprice.id", "monetary_drugprice.mdk_object_id", "monetary_drugprice.is_from_mdk_db", "monetary_drugprice.pvp_currency", "monetary_drugprice.pvp", "monetary_drugprice.pharmacy_price_currency", "monetary_drugprice.pharmacy_price", "monetary_drugprice.base_currency", "monetary_drugprice.base", "monetary_drugprice.no_tax_price_currency", "monetary_drugprice.no_tax_price", "monetary_drugprice.system_no_tax_price_currency", "monetary_drugprice.system_no_tax_price", "monetary_drugprice.all_included_price_currency", "monetary_drugprice.all_included_price", "monetary_drugprice.system_all_included_price_currency", "monetary_drugprice.system_all_included_price", "monetary_drugprice.margin", "monetary_drugprice.stock", "monetary_drugprice.drug_id", "monetary_drugprice.pricelist_id", "monetary_drugprice.uuid", "monetary_drugprice.offer", "monetary_drugprice.mdk_pricing_id", "monetary_drugprice.system_all_included_price_rate", "monetary_drugprice.system_no_tax_price_rate", "monetary_drugprice.all_included_price_before", "monetary_drugprice.all_included_price_before_currency", "monetary_drugprice.no_tax_price_before", "monetary_drugprice.no_tax_price_before_currency", "monetary_drugprice.system_all_included_price_before", "monetary_drugprice.system_all_included_price_before_currency", "monetary_drugprice.system_all_included_price_before_rate", "monetary_drugprice.system_no_tax_price_before", "monetary_drugprice.system_no_tax_price_before_currency", "monetary_drugprice.system_no_tax_price_before_rate", "monetary_drugprice.calculated_base", "monetary_drugprice.calculated_base_currency", "monetary_drugprice.system_calculated_base", "monetary_drugprice.system_calculated_base_currency", "monetary_drugprice.system_calculated_base_rate"],
- "Index Cond": "(monetary_drugprice.pricelist_id = monetary_pricelist.id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(monetary_drugprice.stock > 0)",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 189626,
- "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": 0.858,
- "Actual Total Time": 0.858,
- "Actual Rows": 82,
- "Actual Loops": 1,
- "Output": ["courier_carrier.id", "courier_carrierdelivery.carrier_id"],
- "Hash Buckets": 1024,
- "Original Hash Buckets": 1024,
- "Hash Batches": 1,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 12,
- "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": "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": 0.729,
- "Actual Total Time": 0.836,
- "Actual Rows": 82,
- "Actual Loops": 1,
- "Output": ["courier_carrier.id", "courier_carrierdelivery.carrier_id"],
- "Inner Unique": true,
- "Hash Cond": "(courier_carrierdelivery.carrier_id = courier_carrier.id)",
- "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": "Bitmap Heap Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Relation Name": "courier_carrierdelivery",
- "Schema": "public",
- "Alias": "courier_carrierdelivery",
- "Startup Cost": 9.23,
- "Total Cost": 125.66,
- "Plan Rows": 82,
- "Plan Width": 4,
- "Actual Startup Time": 0.035,
- "Actual Total Time": 0.103,
- "Actual Rows": 82,
- "Actual Loops": 1,
- "Output": ["courier_carrierdelivery.id", "courier_carrierdelivery.uuid", "courier_carrierdelivery.dst_country", "courier_carrierdelivery.postal_code", "courier_carrierdelivery.carrier_id", "courier_carrierdelivery.exclude_code_range_lower", "courier_carrierdelivery.exclude_code_range_upper", "courier_carrierdelivery.postal_code_range_lower", "courier_carrierdelivery.postal_code_range_upper", "courier_carrierdelivery.external_service_id", "courier_carrierdelivery.mdk_object_id", "courier_carrierdelivery.ignore_country_filter"],
- "Recheck Cond": "(((courier_carrierdelivery.dst_country)::text = 'MX'::text) OR courier_carrierdelivery.ignore_country_filter)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "(((courier_carrierdelivery.dst_country)::text = 'MX'::text) OR courier_carrierdelivery.ignore_country_filter)",
- "Rows Removed by Filter": 0,
- "Exact Heap Blocks": 38,
- "Lossy Heap Blocks": 0,
- "Shared Hit Blocks": 43,
- "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.027,
- "Actual Total Time": 0.027,
- "Actual Rows": 0,
- "Actual Loops": 1,
- "Shared Hit Blocks": 5,
- "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.021,
- "Actual Total Time": 0.022,
- "Actual Rows": 78,
- "Actual Loops": 1,
- "Index Cond": "((courier_carrierdelivery.dst_country)::text = 'MX'::text)",
- "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": "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.005,
- "Actual Total Time": 0.005,
- "Actual Rows": 4,
- "Actual Loops": 1,
- "Index Cond": "(courier_carrierdelivery.ignore_country_filter = true)",
- "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
- }
- ]
- }
- ]
- },
- {
- "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": 0.681,
- "Actual Total Time": 0.681,
- "Actual Rows": 55,
- "Actual Loops": 1,
- "Output": ["courier_carrier.id"],
- "Hash Buckets": 1024,
- "Original Hash Buckets": 1024,
- "Hash Batches": 1,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 10,
- "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": "courier_carrier",
- "Startup Cost": 0.00,
- "Total Cost": 2.55,
- "Plan Rows": 55,
- "Plan Width": 4,
- "Actual Startup Time": 0.654,
- "Actual Total Time": 0.663,
- "Actual Rows": 55,
- "Actual Loops": 1,
- "Output": ["courier_carrier.id"],
- "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
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- },
- {
- "Node Type": "Hash",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Startup Cost": 12.18,
- "Total Cost": 12.18,
- "Plan Rows": 94,
- "Plan Width": 4,
- "Actual Startup Time": 0.089,
- "Actual Total Time": 0.089,
- "Actual Rows": 94,
- "Actual Loops": 1,
- "Output": ["monetary_pricelistcountry.pricelist_id"],
- "Hash Buckets": 1024,
- "Original Hash Buckets": 1024,
- "Hash Batches": 1,
- "Original Hash Batches": 1,
- "Peak Memory Usage": 12,
- "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 Heap Scan",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Relation Name": "monetary_pricelistcountry",
- "Schema": "public",
- "Alias": "monetary_pricelistcountry",
- "Startup Cost": 5.00,
- "Total Cost": 12.18,
- "Plan Rows": 94,
- "Plan Width": 4,
- "Actual Startup Time": 0.053,
- "Actual Total Time": 0.068,
- "Actual Rows": 94,
- "Actual Loops": 1,
- "Output": ["monetary_pricelistcountry.pricelist_id"],
- "Recheck Cond": "((monetary_pricelistcountry.country)::text = 'MX'::text)",
- "Rows Removed by Index Recheck": 0,
- "Exact Heap Blocks": 4,
- "Lossy Heap Blocks": 0,
- "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": "Outer",
- "Parallel Aware": false,
- "Index Name": "monetary_pricelistcountry_country_pricelist_id_be9ca8b0_uniq",
- "Startup Cost": 0.00,
- "Total Cost": 4.98,
- "Plan Rows": 94,
- "Plan Width": 0,
- "Actual Startup Time": 0.044,
- "Actual Total Time": 0.044,
- "Actual Rows": 94,
- "Actual Loops": 1,
- "Index Cond": "((monetary_pricelistcountry.country)::text = 'MX'::text)",
- "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
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- },
- "Planning Time": 53.994,
- "Triggers": [
- ],
- "Execution Time": 6102.252
- }
- ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement