Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kMpWO-0003Xz-KS for pgadmin-hackers@arkaria.postgresql.org; Mon, 28 Sep 2020 09:32:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kMpWN-0002jT-GU for pgadmin-hackers@arkaria.postgresql.org; Mon, 28 Sep 2020 09:32:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kMpWN-0002jM-A8 for pgadmin-hackers@lists.postgresql.org; Mon, 28 Sep 2020 09:32:35 +0000 Received: from mail-ej1-x62c.google.com ([2a00:1450:4864:20::62c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kMpWK-0003np-1B for pgadmin-hackers@postgresql.org; Mon, 28 Sep 2020 09:32:34 +0000 Received: by mail-ej1-x62c.google.com with SMTP id u21so7601422eja.2 for ; Mon, 28 Sep 2020 02:32:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=C3ZGq/VuMJfQInbwrrxErt+9roXDyOGtpIvv2ftXul0=; b=aq7rQXDacqIwXiSzMXYopwofZxbLnmzR8KgEZY/qRKbGLIcf/aNJBzHaXbzeW2QDNa wevYMuvJ7lTowyHo4RGYYcW3mrZ0DrAcC1lnhyryn8BEFazJJ1tsb7LjGus+uf5eRkK/ B0cA20yWFelRcTs9rdYXvChnlYkAi4GKlUtC5bH+ZFFR+fmC6VcIL7jYsR+FEEwgb1C2 O2xfKNL024jre2zhQNOhMxR06zmiyCKTrfni+lpuFsZX01WNWs/hzy08Q2GJzabEUwJR PqhULIbFZeNL+Um6BNS35AGUBp4pJplx/XO/+TitthkUHOvYQxWaaO4ZgvNgFO4SFgrI /wgA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=C3ZGq/VuMJfQInbwrrxErt+9roXDyOGtpIvv2ftXul0=; b=Czn3URnOiPU1d6uCVjTxvHYbY3fPtmHaDyr/jXVfJl2VYqtiqBFQM2boH8VDNyLGaV aPrGsT+nVum3VajjRkuGr2fajxpY57ReUASBA2nfQCyTiBkXJK9wP+iqbxl3KrmEr0Bz tyKC95zO0JohW6LOwwB8v1qG2U+4U2sZ/NicktHw+JhcXe791Nxc1dcPrvaql8UQdwFb ukXp3PYvK7nGD0MlyaFcUDx6MF0s+ClB77PtkJ5akJdwsk2eWW4ANtyxfg8gdIaVjv2n Uxa5U9nhpo3GVtHEbgZ57mcE/fjnf9gGiigSrNaorr6zjrv2pfi/SGC0458cPsOKH4QI pyPg== X-Gm-Message-State: AOAM531EPTlnsjrsBwyeGJbqwrKJFowpoQLKYdAQiY2s6wTsHJzHr5Ou lCnTsA0FQk05hlB6eJCvP06H1L6/QrFYhnxzm0qjahpmfOSx/b5DIOQbEi6RCmTM2Fl6S9/d2BE 1S30TqH8dQtPSmdnrSQLMVagy9KiJopku98QKWw4+fNQG5JlncNZh4GJcV8GPGYbOVX1N+Kn0hl SiLJRDcVE5QzvHJlxUcUnhukN3pUmbARMVvZrrbj+/iNN2d88raTkzC1UgnlW44UT5Tw== X-Google-Smtp-Source: ABdhPJxZKYmBqn71AqNtfm4FbJu78/jcHlgPvoSW3a2xDM4+NFda+d5VVrnSUmMprKa8ccoQRG+9tfqOA4/TyK5+gN4= X-Received: by 2002:a17:906:4107:: with SMTP id j7mr778877ejk.533.1601285550430; Mon, 28 Sep 2020 02:32:30 -0700 (PDT) MIME-Version: 1.0 From: Aditya Toshniwal Date: Mon, 28 Sep 2020 15:01:54 +0530 Message-ID: Subject: [pgAdmin][RM4806] Add info to empty explain tab To: pgadmin-hackers Content-Type: multipart/mixed; boundary="0000000000006b114005b05c5855" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000006b114005b05c5855 Content-Type: multipart/alternative; boundary="0000000000006b113e05b05c5853" --0000000000006b113e05b05c5853 Content-Type: text/plain; charset="UTF-8" Hi Hackers, Attached is the patch to add a useful message when the explain plan is not used and is empty. I've also added a message for the data output tab. Please review. -- Thanks, Aditya Toshniwal pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* "Don't Complain about Heat, Plant a TREE" --0000000000006b113e05b05c5853 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,

Attached is the patch to add a useful=C2=A0mes= sage when the explain plan is not used and is empty. I've also added a = message for the data output tab.

Please review.

--=
Thanks,
Aditya Toshniwal=
pgAdmin hacker=C2=A0| Sr. Software Engineer<= font size=3D"2" color=3D"#000000"> | edbpostgres.com
X-Attachment-Id: f_kfmc1puj0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL3N0YXRpYy9zY3NzL19wZ2FkbWluLnN0eWxlLnNjc3Mg Yi93ZWIvcGdhZG1pbi9zdGF0aWMvc2Nzcy9fcGdhZG1pbi5zdHlsZS5zY3NzCmluZGV4IDJiZDRk NWExOS4uNTJmOTYxNzBiIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9zdGF0aWMvc2Nzcy9fcGdh ZG1pbi5zdHlsZS5zY3NzCisrKyBiL3dlYi9wZ2FkbWluL3N0YXRpYy9zY3NzL19wZ2FkbWluLnN0 eWxlLnNjc3MKQEAgLTI4Nyw2ICsyODcsNyBAQAogICAgIG1hcmdpbi10b3A6IDI1cHggIWltcG9y dGFudDsKICAgICBwb3NpdGlvbjogcmVsYXRpdmU7CiAgICAgdGV4dC1hbGlnbjogY2VudGVyOwor ICAgIGZvbnQtc2l6ZTogJGZvbnQtc2l6ZS1iYXNlOwogCiAgICAgJjpiZWZvcmUgewogICAgICAg ICBmb250LWZhbWlseTogJGZvbnQtZmFtaWx5LWljb247CmRpZmYgLS1naXQgYS93ZWIvcGdhZG1p bi90b29scy9zcWxlZGl0b3Ivc3RhdGljL2pzL3NxbGVkaXRvci5qcyBiL3dlYi9wZ2FkbWluL3Rv b2xzL3NxbGVkaXRvci9zdGF0aWMvanMvc3FsZWRpdG9yLmpzCmluZGV4IGRkZDlhZDcwMS4uYjRl ZTI5ZTUwIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi90b29scy9zcWxlZGl0b3Ivc3RhdGljL2pz L3NxbGVkaXRvci5qcworKysgYi93ZWIvcGdhZG1pbi90b29scy9zcWxlZGl0b3Ivc3RhdGljL2pz L3NxbGVkaXRvci5qcwpAQCAtNzYsNiArNzYsMTQgQEAgZGVmaW5lKCd0b29scy5xdWVyeXRvb2wn LCBbCiAKICAgdmFyIGlzX3F1ZXJ5X3J1bm5pbmcgPSBmYWxzZTsKIAorICBjb25zdCBFTVBUWV9E QVRBX09VVFBVVF9DT05URU5UID0gJzxkaXYgcm9sZT0ic3RhdHVzIiBjbGFzcz0icGctcGFuZWwt bWVzc2FnZSI+JyArCisgICAgZ2V0dGV4dCgnTm8gZGF0YSBvdXRwdXQuIEV4ZWN1dGUgYSBxdWVy eSB0byBnZXQgb3V0cHV0LicpICsKKyAgJzwvZGl2Pic7CisKKyAgY29uc3QgRU1QVFlfRVhQTEFJ Tl9DT05URU5UID0gJzxkaXYgcm9sZT0ic3RhdHVzIiBjbGFzcz0icGctcGFuZWwtbWVzc2FnZSI+ JyArCisgICAgZ2V0dGV4dCgnVXNlIEV4cGxhaW4vRXhwbGFpbiBhbmFseXplIGJ1dHRvbiB0byBn ZW5lcmF0ZSB0aGUgcGxhbiBmb3IgYSBxdWVyeS4gQWx0ZXJuYXRpdmVseSwgeW91IGNhbiBhbHNv IGV4ZWN1dGUgIkVYUExBSU4gKEZPUk1BVCBKU09OKSBbUVVFUlldIi4nKSArCisgICc8L2Rpdj4n OworCiAgIC8vIERlZmluaW5nIEJhY2tib25lIHZpZXcgZm9yIHRoZSBzcWwgZ3JpZC4KICAgdmFy IFNRTEVkaXRvclZpZXcgPSBCYWNrYm9uZS5WaWV3LmV4dGVuZCh7CiAgICAgaW5pdGlhbGl6ZTog ZnVuY3Rpb24ob3B0cykgewpAQCAtMjUxLDcgKzI1OSw3IEBAIGRlZmluZSgndG9vbHMucXVlcnl0 b29sJywgWwogICAgICAgICBpc0Nsb3NlYWJsZTogZmFsc2UsCiAgICAgICAgIGlzUHJpdmF0ZTog dHJ1ZSwKICAgICAgICAgZXh0cmFDbGFzc2VzOiAnaGlkZS12ZXJ0aWNhbC1zY3JvbGxiYXInLAot ICAgICAgICBjb250ZW50OiAnPGRpdiBpZCA9ImRhdGFncmlkIiBjbGFzcz0ic3FsLWVkaXRvci1n cmlkLWNvbnRhaW5lciB0ZXh0LTEyIiB0YWJpbmRleD0iMCI+PC9kaXY+JywKKyAgICAgICAgY29u dGVudDogYDxkaXYgaWQgPSJkYXRhZ3JpZCIgY2xhc3M9InNxbC1lZGl0b3ItZ3JpZC1jb250YWlu ZXIgdGV4dC0xMiIgdGFiaW5kZXg9IjAiPiR7RU1QVFlfREFUQV9PVVRQVVRfQ09OVEVOVH08L2Rp dj5gLAogICAgICAgfSk7CiAKICAgICAgIHZhciBleHBsYWluID0gbmV3IHBnQWRtaW4uQnJvd3Nl ci5QYW5lbCh7CkBAIC0yNjEsNyArMjY5LDcgQEAgZGVmaW5lKCd0b29scy5xdWVyeXRvb2wnLCBb CiAgICAgICAgIGhlaWdodDogJzEwMCUnLAogICAgICAgICBpc0Nsb3NlYWJsZTogZmFsc2UsCiAg ICAgICAgIGlzUHJpdmF0ZTogdHJ1ZSwKLSAgICAgICAgY29udGVudDogJzxkaXYgY2xhc3M9InNx bC1lZGl0b3ItZXhwbGFpbiIgdGFiaW5kZXg9IjAiPjwvZGl2PicsCisgICAgICAgIGNvbnRlbnQ6 IGA8ZGl2IGNsYXNzPSJzcWwtZWRpdG9yLWV4cGxhaW4gcGctZWwtY29udGFpbmVyIiB0YWJpbmRl eD0iMCI+JHtFTVBUWV9FWFBMQUlOX0NPTlRFTlR9PC9kaXY+YCwKICAgICAgIH0pOwogCiAgICAg ICB2YXIgbWVzc2FnZXMgPSBuZXcgcGdBZG1pbi5Ccm93c2VyLlBhbmVsKHsKQEAgLTI2NTgsNyAr MjY2Niw3IEBAIGRlZmluZSgndG9vbHMucXVlcnl0b29sJywgWwogICAgICAgICBzZWxmLmNoYW5n ZWRNb2RlbHMgPSBbXTsKICAgICAgICAgc2VsZi5oYXNfb2lkcyA9IGRhdGEuaGFzX29pZHM7CiAg ICAgICAgIHNlbGYub2lkcyA9IGRhdGEub2lkczsKLSAgICAgICAgJCgnLnNxbC1lZGl0b3ItZXhw bGFpbicpLmVtcHR5KCk7CisgICAgICAgICQoJy5zcWwtZWRpdG9yLWV4cGxhaW4nKS5odG1sKEVN UFRZX0VYUExBSU5fQ09OVEVOVCk7CiAgICAgICAgIHNlbGYuZXhwbGFpbl9wbGFuID0gZmFsc2U7 CiAKICAgICAgICAgLyogSWYgb2JqZWN0IGRvbid0IGhhdmUgcHJpbWFyeSBrZXlzIHRoZW4gc2V0 IHRoZQo= --0000000000006b114005b05c5855--