Dear PostgreSQL Hackers,
This patch adds the ability to log the types of parameters used in queries
when detailed query logging is enabled. Currently, detailed logging only
shows the parameter values, which often requires further investigation or
asking the client to determine the data types. This enhancement will
significantly aid in debugging problematic queries, especially when data
type mismatches are suspected.
The patch modifies the detailed logging output to include the data type of
each parameter, making it easier to understand the context of the query and
diagnose potential issues without additional communication overhead.
Here's an example of the new logging format:
```
2025-02-10 21:05:42.622 +07 [3702286] LOG: duration: 0.008 ms execute P_1:
SELECT
u.username,
u.email,
r.role_name,
o.order_date,
p.product_name,
oi.quantity,
ur.role_id,
(p.price * oi.quantity) AS total_price
FROM
users u
JOIN
user_roles ur ON u.user_id = ur.user_id
JOIN
roles r ON ur.role_id = r.role_id
JOIN
orders o ON u.user_id = o.user_id
JOIN
order_items oi ON o.order_id = oi.order_id
JOIN
products p ON oi.product_id = p.product_id
where ur.role_id = $1
and u.user_id = $2
and oi.order_id = $3::bigint
ORDER BY
o.order_date;
2025-02-10 21:05:42.622 +07 [3702286] DETAIL: Parameters: $1 =
(integer)'11', $2 = (integer)'86', $3 = (bigint)'14'
```
As you can see, the DETAIL log message now includes the data type in
parentheses before the parameter value.
I believe this addition will greatly improve the usefulness of detailed
query logging. I welcome your feedback and suggestions.
Thank you for your time and consideration.
Best regards,
Stepan Neretin
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=Edge"/>
<title>Log in - PPG Jira</title>
<meta name="application-name" content="JIRA" data-name="jira" data-version="9.15.2"><meta name="ajs-server-scheme" content="https">
<meta name="ajs-server-port" content="443">
<meta name="ajs-server-name" content="jira.postgrespro.ru">
<meta name="ajs-behind-proxy" content="null">
<meta name="ajs-base-url" content="https://jira.postgrespro.ru";>
<meta name="ajs-dev-mode" content="false">
<meta name="ajs-context-path" content="">
<meta name="ajs-version-number" content="9.15.2">
<meta name="ajs-build-number" content="9150002">
<meta name="ajs-is-beta" content="false">
<meta name="ajs-is-rc" content="false">
<meta name="ajs-is-snapshot" content="false">
<meta name="ajs-is-milestone" content="false">
<meta name="ajs-remote-user" content="">
<meta name="ajs-remote-user-fullname" content="">
<meta name="ajs-user-locale" content="en_US">
<meta name="ajs-user-locale-group-separator" content=",">
<meta name="ajs-app-title" content="PPG Jira">
<meta name="ajs-keyboard-shortcuts-enabled" content="true">
<meta name="ajs-keyboard-accesskey-modifier" content="Alt+Shift">
<meta name="ajs-enabled-dark-features" content="["com.atlassian.jira.agile.darkfeature.editable.detailsview","com.atlassian.jira.description.bulkedit.enabled","nps.survey.inline.dialog","com.atlassian.jira.agile.darkfeature.edit.closed.sprint.enabled","jira.plugin.devstatus.phasetwo","jira.frother.reporter.field","atlassian.rest.xsrf.legacy.enabled","jira.issue.status.lozenge","com.atlassian.jira.projects.issuenavigator","jira.plugin.devstatus.phasetwo.enabled","com.atlassian.jira.config.PDL","atlassian.aui.raphael.disabled","crowd.sync.nested.groups.group.membership.changes.batching.enabled","app-switcher.new","frother.assignee.field","com.atlassian.jira.projects.ProjectCentricNavigation.Switch","sd.internal.base.off.thread.on.completion.events.enabled","jira.onboarding.cyoa","com.atlassian.jira.agile.darkfeature.kanplan.enabled","sd.slavalue.record.updated.date.enabled","com.atlassian.jira.projects.sidebar.DEFER_RESOURCES","com.atlassian.jira.config.ProjectConfig.MENU","com.atlassian.jira.agile.darkfeature.kanplan.epics.and.versions.enabled","com.atlassian.jira.agile.darkfeature.sprint.goal.enabled","jira.zdu.admin-updates-ui","jira.zdu.jmx-monitoring","sd.sla.improved.rendering.enabled","sd.canned.responses.enabled","mail.batching.enabled","sd.new.settings.sidebar.location.disabled","crowd.event.transformer.directory.manager.cache","jira.zdu.cluster-upgrade-state","com.atlassian.jira.email.templates.readFromJiraHome","com.atlassian.jira.agile.darkfeature.splitissue","crowd.sync.delete.user.memberships.batching.enabled","com.atlassian.jira.config.CoreFeatures.LICENSE_ROLES_ENABLED","jira.export.csv.enabled"]">
<meta name="ajs-in-admin-mode" content="false">
<meta name="ajs-is-sysadmin" content="false">
<meta name="ajs-is-admin" content="false">
<meta name="ajs-outgoing-mail-enabled" content="true">
<meta name="ajs-archiving-enabled" content="true">
<meta name="ajs-date-relativize" content="true">
<meta name="ajs-date-time" content="HH:mm">
<meta name="ajs-date-day" content="EEEE HH:mm">
<meta name="ajs-date-dmy" content="dd/MMM/yy">
<meta name="ajs-date-complete" content="dd MMM YYYY HH:mm">
<meta name="ajs-use-iso8601" content="false">
<script type="text/javascript">var AJS=AJS||{};AJS.debug=true;</script>
<meta id="atlassian-token" name="atlassian-token" content="BWOS-CFHM-0RCA-UZW8_443dd8a378041c85c6f82439240ce0cec1d5d478_lout">
<link rel="shortcut icon" href="/s/-te3dmd/9150002/1x20kqa/_/images/fav-jsw.png">
<link rel="search" type="application/opensearchdescription+xml" href="/osd.jsp" title="Log in - PPG Jira"/>
<style>
html:not([data-theme]),
html[data-color-mode="dark"][data-theme~="dark:light"],
html[data-color-mode="light"][data-theme~="light:light"],
html[data-color-mode="light"][data-theme~="light:original"] {
--jira-color-gadgetcolor1: #205081;
--jira-color-gadgetcolor2: #de350b;
--jira-color-gadgetcolor3: #ff8b00;
--jira-color-gadgetcolor4: #00875a;
--jira-color-gadgetcolor5: #00a3bf;
--jira-color-gadgetcolor6: #6554c0;
--jira-color-gadgetcolor7: #5e6c84;
--jira-color-heroButtonBaseBGColour: #3572B0;
--jira-color-heroButtonTextColour: #deebff;
--jira-color-menuBackgroundColour: #ebecf0;
--jira-color-menuSeparatorColour: #dfe1e6;
--jira-color-menuTxtColour: #42526e;
--jira-color-textActiveLinkColour: #0065ff;
--jira-color-textHeadingColour: #172b4d;
--jira-color-textLinkColour: #3572B0;
--jira-color-topBackgroundColour: #205081;
--jira-color-topHighlightColor: #3572B0;
--jira-color-topSeparatorBackgroundColor: #2e3d54;
--jira-color-topTextHighlightColor: #deebff;
--jira-color-topTxtColour: #deebff;
}
html[data-color-mode="dark"] {
--jira-color-gadgetcolor1: var(--ds-background-brand-bold);
--jira-color-gadgetcolor2: var(--ds-background-danger-bold);
--jira-color-gadgetcolor3: var(--ds-background-accent-orange-subtler-pressed);
--jira-color-gadgetcolor4: var(--ds-background-accent-green-bolder-hovered);
--jira-color-gadgetcolor5: var(--ds-background-accent-teal-bolder);
--jira-color-gadgetcolor6: var(--ds-background-accent-purple-bolder-hovered);
--jira-color-gadgetcolor7: var(--ds-background-accent-gray-bolder);
--jira-color-heroButtonBaseBGColour: var(--ds-background-brand-bold);
--jira-color-heroButtonTextColour: var(--ds-text-inverse);
--jira-color-menuBackgroundColour: var(--ds-surface-overlay-hovered);
--jira-color-menuSeparatorColour: var(--ds-border);
--jira-color-menuTxtColour: var(--ds-text-subtlest);
--jira-color-textActiveLinkColour: var(--ds-link-pressed);
--jira-color-textHeadingColour: var(--ds-text);
--jira-color-textLinkColour: var(--ds-link);
--jira-color-topBackgroundColour: var(--ds-surface);
--jira-color-topHighlightColor: var(--ds-surface-hovered);
--jira-color-topSeparatorBackgroundColor: var(--ds-border);
--jira-color-topTextHighlightColor: var(--ds-text-subtle);
--jira-color-topTxtColour: var(--ds-text-subtle);
}
</style>
<script>window.contextPath = '';</script>
<script data-wrm-key="com.atlassian.plugins.atlassian-plugins-webresource-rest:data-collector-perf-observer,jira.webresources:resource-phase-checkpoint-init" data-wrm-batch-type="resource" data-initially-rendered>
window.__resourcePhaseCheckpointResolvers={resolveDeferPhaseCheckpoint:null,resolveInteractionPhaseCheckpoint:null};if(window.performance&&window.performance.mark){window.DeferScripts||(window.DeferScripts={});window.DeferScripts.totalClicks=0;window.DeferScripts.totalKeydowns=0;window.DeferScripts.clickListener=function(){"use strict";window.DeferScripts.totalClicks+=1};window.addEventListener("click",window.DeferScripts.clickListener);window.DeferScripts.keydownListener=function(){"use strict";window.DeferScripts.totalKeydowns+=1};window.addEventListener("keydown",window.DeferScripts.keydownListener)}window.resourcePhaseCheckpoint=Object.freeze({defer:new Promise((function(e){"use strict";window.__resourcePhaseCheckpointResolvers.resolveDeferPhaseCheckpoint=e})),interaction:new Promise((function(e){"use strict";window.__resourcePhaseCheckpointResolvers.resolveInteractionPhaseCheckpoint=e}))});Object.freeze(window.__resourcePhaseCheckpointResolvers);
!function(){"use strict";if("PerformanceObserver"in window){const r=[];window.__observedResources=r;const i=e=>"script"===e?"script":"css";new PerformanceObserver((n=>{n.getEntries().filter((({initiatorType:r,name:i})=>{const n="script"===r||e(r,i),s=new URL(location.href).origin===new URL(i).origin;return n&&s})).forEach((({name:e,transferSize:n,encodedBodySize:s,initiatorType:o})=>{r.push([n,s,e,i(o)])}))})).observe({type:"resource"})}const e=(e,r)=>"link"===e&&"css"===r.split(".").pop()}();
</script>
<script>
window.WRM=window.WRM||{};window.WRM._unparsedData=window.WRM._unparsedData||{};window.WRM._unparsedErrors=window.WRM._unparsedErrors||{};
WRM._unparsedData["com.onresolve.jira.groovy.groovyrunner:behaviours-translations.behaviours-translations-data-provider"]="{\u0022field.title.missing.value\u0022:\u0022You must enter a value for this field\u0022}";
WRM._unparsedData["jira.core:default-comment-security-level-data.DefaultCommentSecurityLevelHelpLink"]="{\u0022extraClasses\u0022:\u0022default-comment-level-help\u0022,\u0022title\u0022:\u0022Commenting on an Issue\u0022,\u0022url\u0022:\u0022https://docs.atlassian.com/jira/jcore-docs-0915/Editing+and+collaborating+on+issues#Editingandcollaboratingonissues-restrictacomment\u0022,\u0022isLocal\u0022:false}";;
WRM._unparsedData["jira.core:feature-flags-data.feature-flag-data"]="{\u0022enabled-feature-keys\u0022:[\u0022com.atlassian.jira.agile.darkfeature.editable.detailsview\u0022,\u0022com.atlassian.jira.description.bulkedit.enabled\u0022,\u0022nps.survey.inline.dialog\u0022,\u0022com.atlassian.jira.agile.darkfeature.edit.closed.sprint.enabled\u0022,\u0022jira.plugin.devstatus.phasetwo\u0022,\u0022jira.frother.reporter.field\u0022,\u0022atlassian.rest.xsrf.legacy.enabled\u0022,\u0022jira.issue.status.lozenge\u0022,\u0022com.atlassian.jira.projects.issuenavigator\u0022,\u0022jira.plugin.devstatus.phasetwo.enabled\u0022,\u0022com.atlassian.jira.config.PDL\u0022,\u0022atlassian.aui.raphael.disabled\u0022,\u0022crowd.sync.nested.groups.group.membership.changes.batching.enabled\u0022,\u0022app-switcher.new\u0022,\u0022frother.assignee.field\u0022,\u0022com.atlassian.jira.projects.ProjectCentricNavigation.Switch\u0022,\u0022sd.internal.base.off.thread.on.completion.events.enabled\u0022,\u0022jira.onboarding.cyoa\u0022,\u0022com.atlassian.jira.agile.darkfeature.kanplan.enabled\u0022,\u0022sd.slavalue.record.updated.date.enabled\u0022,\u0022com.atlassian.jira.projects.sidebar.DEFER_RESOURCES\u0022,\u0022com.atlassian.jira.config.ProjectConfig.MENU\u0022,\u0022com.atlassian.jira.agile.darkfeature.kanplan.epics.and.versions.enabled\u0022,\u0022com.atlassian.jira.agile.darkfeature.sprint.goal.enabled\u0022,\u0022jira.zdu.admin-updates-ui\u0022,\u0022jira.zdu.jmx-monitoring\u0022,\u0022sd.sla.improved.rendering.enabled\u0022,\u0022sd.canned.responses.enabled\u0022,\u0022mail.batching.enabled\u0022,\u0022sd.new.settings.sidebar.location.disabled\u0022,\u0022crowd.event.transformer.directory.manager.cache\u0022,\u0022jira.zdu.cluster-upgrade-state\u0022,\u0022com.atlassian.jira.email.templates.readFromJiraHome\u0022,\u0022com.atlassian.jira.agile.darkfeature.splitissue\u0022,\u0022crowd.sync.delete.user.memberships.batching.enabled\u0022,\u0022com.atlassian.jira.config.CoreFeatures.LICENSE_ROLES_ENABLED\u0022,\u0022jira.export.csv.enabled\u0022],\u0022feature-flag-states\u0022:{\u0022com.atlassian.jira.use.same.site.none.for.xsrf.token.cookie\u0022:true,\u0022com.atlassian.jira.leaked.all.anonymous.access\u0022:true,\u0022com.atlassian.jira.in.product.diagnostics.extended.logging\u0022:false,\u0022com.atlassian.jira.agile.darkfeature.handle.ug.usernames\u0022:true,\u0022com.atlassian.jira.security.rest.menu.anonymous.access.denied\u0022:true,\u0022com.atlassian.jira.mailHandlerImapMessageQueryLegacy\u0022:false,\u0022com.atlassian.diagnostics.scheduler.monitor\u0022:true,\u0022com.atlassian.jira.webhookEventsAsyncProcessing\u0022:false,\u0022jira.customfields.dual.list.box\u0022:true,\u0022com.atlassian.jira.serAllowShareWithNonMember\u0022:true,\u0022com.atlassian.troubleshooting.healthcheck.jira.license.limit\u0022:false,\u0022com.atlassian.jira.diagnostics.perflog\u0022:true,\u0022com.atlassian.jira.dbr\u0022:true,\u0022com.atlassian.jira.bc.user.search.MeasuringUserPickerSearchService\u0022:false,\u0022com.atlassian.jira.agile.darkfeature.legacy.epic.picker\u0022:false,\u0022com.atlassian.jira.issuetable.move.links.hidden\u0022:true,\u0022jira.renderer.consider.variable.format\u0022:true,\u0022jira.no.frother.multiuserpicker.field\u0022:false,\u0022com.atlassian.jira.plugin.issuenavigator.jql.autocomplete.eagerlyLoaded\u0022:false,\u0022com.atlassian.jira.user.dbIdBasedKeyGenerationStrategy\u0022:true,\u0022com.atlassian.portfolio.dcBundling\u0022:true,\u0022com.atlassian.jira.rest.enable.new.session.creation.endpoint\u0022:true,\u0022com.atlassian.jira.description.bulkedit\u0022:true,\u0022com.atlassian.jira.sharedEntityEditRights\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.sprint.goal\u0022:true,\u0022com.atlassian.jira.thumbnailsDeferredGeneration\u0022:true,\u0022jira.cluster.monitoring.show.offline.nodes\u0022:true,\u0022com.atlassian.jira.projects.ProjectCentricNavigation.ProjectShortcutOrder\u0022:true,\u0022com.atlassian.jira.commentReactions\u0022:true,\u0022data.pipeline.feature.jira.issue.links.export\u0022:true,\u0022com.atlassian.jira.web.action.admin.integrity.checker.task.cleanup\u0022:true,\u0022com.atlassian.jira.custom.csv.escaper\u0022:true,\u0022com.atlassian.jira.fixedCommentDeletionNotifications\u0022:true,\u0022com.atlassian.jira.allThumbnailsDeferred\u0022:false,\u0022com.atlassian.jira.plugin.issuenavigator.filtersUxImprovment\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.kanplan.epics.and.versions\u0022:true,\u0022com.atlassian.jira.jsd.mobile\u0022:true,\u0022jira.customfields.cleanup.identification\u0022:true,\u0022data.pipeline.feature.jira.all.exportable.custom.fields\u0022:true,\u0022com.atlassian.jira.in.product.diagnostics.wip\u0022:false,\u0022com.atlassian.jira.defaultValuesForSystemFields\u0022:true,\u0022jira.dc.cleanup.cluser.tasks\u0022:true,\u0022jira.customfields.bulk.delete\u0022:true,\u0022mail.batching.override.core\u0022:true,\u0022com.atlassian.jira.issues.archiving.filters\u0022:false,\u0022jira.users.and.roles.page.in.react\u0022:true,\u0022jira.security.csp.sandbox\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.synced.sprints\u0022:false,\u0022com.atlassian.jira.agile.darkfeature.velocity.chart.ui\u0022:true,\u0022com.atlassian.jira.initialwatchers\u0022:false,\u0022com.atlassian.jira.returnDefaultAvatarsForBrokenAvatars\u0022:true,\u0022com.atlassian.jira.theme.switcher\u0022:false,\u0022com.atlassian.jira.agile.darkfeature.sprint.auto.management\u0022:true,\u0022jira.jql.suggestrecentfields\u0022:false,\u0022com.atlassian.jira.gdpr.rtbf\u0022:true,\u0022com.atlassian.jira.ignoreBrowseUsersPermissionsInUserPickers\u0022:true,\u0022com.atlassian.jira.issue.comments.updateIssueObjectBeforeEventTrigger\u0022:true,\u0022com.atlassian.jira.security.xsrf.session.token\u0022:true,\u0022com.atlassian.jira.rest.search.filter.user.input.preserve\u0022:true,\u0022com.atlassian.jira.security.project.admin.revoke.with.application.access\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.optimistic.transitions\u0022:true,\u0022com.atlassian.jiranomenclature\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.kanplan\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.boards.find.on.board\u0022:true,\u0022com.atlassian.diagnostics.http.monitor\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.future.sprint.dates\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.complete.sprint.in.backlog\u0022:true,\u0022jira.customfields.paginated.ui\u0022:true,\u0022com.atlassian.jira.filtersAndDashboardsShareableWithAllGroupsAndRoles\u0022:true,\u0022com.atlassian.jira.in.product.diagnostics\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.edit.closed.sprint\u0022:true,\u0022jira.create.linked.issue\u0022:true,\u0022jira.customfields.configure.modern.ui\u0022:false,\u0022com.atlassian.jira.backups.storage.configurable\u0022:false,\u0022jira.sal.host.connect.accessor.existing.transaction.will.create.transactions\u0022:true,\u0022com.atlassian.jira.advanced.audit.log\u0022:true,\u0022com.atlassian.jira.security.csv.export.injection.protection\u0022:true,\u0022jira.quick.search\u0022:true,\u0022external.links.new.window\u0022:true,\u0022jira.jql.smartautoselectfirst\u0022:false,\u0022jira.jql.membersof.ignoreGlobalPermissionsForAnonymous\u0022:false,\u0022jira.create.linked.issue.show.all.fields\u0022:true,\u0022data.pipeline.feature.jira.issue.history.export\u0022:true,\u0022jira.webactions.request.method.recognition\u0022:true,\u0022jira.richeditor.bidi.warning\u0022:true,\u0022atlassian.cdn.static.assets\u0022:true,\u0022com.atlassian.jira.lazyload.activity.tabs\u0022:true,\u0022mail.batching\u0022:true,\u0022com.atlassian.jira.safeguards\u0022:true,\u0022com.atlassian.jira.issue.index.db.filter.out.archive.issues\u0022:true,\u0022com.atlassian.jira.xml.deserializerAllowlist\u0022:true,\u0022com.atlassian.jira.privateEntitiesEditable\u0022:true,\u0022com.atlassian.jira.cfoIncludeArchivedIssuesAndAlwaysKeepContext\u0022:true,\u0022jira.priorities.per.project.edit.default\u0022:false,\u0022com.atlassian.jira.projectArchivedIssuesAreMarkedInIssueTable\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.issues.in.epic.details.view\u0022:true,\u0022com.atlassian.jira.attachments.storage.configurable\u0022:false,\u0022com.atlassian.jira.plugin.issuenavigator.anonymousPreventCfData\u0022:false,\u0022jira.priorities.per.project.jsd\u0022:true,\u0022com.atlassian.jira.safeguards.email.notifications\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.rapid.boards.bands\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.flexible.boards\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.sprint.picker.allsprints.suggestion\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.epic.validate.visibility\u0022:true,\u0022data.pipeline.feature.jira.issue.rank.export\u0022:true,\u0022data.pipeline.feature.jira.jsm.approvals.export\u0022:true,\u0022jira.dc.lock.leasing\u0022:true,\u0022com.atlassian.jira.accessibility.personal.settings\u0022:true,\u0022mail.batching.create.section.cf\u0022:true,\u0022com.atlassian.jira.send.email.notifications.to.user.without.application.access\u0022:false,\u0022com.atlassian.mail.server.managers.hostname.verification\u0022:true,\u0022jira.importer.skip.subtask.if.parent.already.exists\u0022:true,\u0022com.atlassian.diagnostics.monitors\u0022:true,\u0022com.atlassian.jira.upgrade.startup.fix.index\u0022:true,\u0022com.atlassian.jira.cacheResource\u0022:false,\u0022com.atlassian.jira.pin.comments\u0022:true,\u0022jira.redirect.anonymous.404.errors\u0022:true,\u0022com.atlassian.jira.issuetable.draggable\u0022:true,\u0022data.pipeline.feature.jira.jsm.canned.responses.export\u0022:true,\u0022com.atlassian.diagnostics.operating.system.monitor\u0022:false,\u0022com.atlassian.jira.attachments.generate.unique.suffix\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.kanban.hide.old.done.issues\u0022:true,\u0022jira.version.based.node.reindex.service\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.backlog.showmore\u0022:true,\u0022com.atlassian.diagnostics.database.monitor\u0022:true,\u0022com.atlassian.jira.quick.search.mode.settable\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.sprint.plan\u0022:false,\u0022com.atlassian.diagnostics.garbage.collection.monitor\u0022:true,\u0022jira.jql.membersof.ignoreGlobalPermissionsForLoggedUsers\u0022:false,\u0022com.atlassian.jira.safeguards.work.in.progress\u0022:false,\u0022com.atlassian.jira.commentStickyFooter\u0022:true,\u0022com.atlassian.jira.security.LegacyJiraTypeResolver.WARN_ONLY\u0022:false,\u0022data.pipeline.feature.jira.schema.version.2\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.burnupchart\u0022:true,\u0022sd.internal.base.off.thread.on.completion.events\u0022:true,\u0022com.atlassian.jira.issues.archiving.browse\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.velocity.sprint.picker\u0022:false,\u0022jira.instrumentation.laas\u0022:false,\u0022com.atlassian.jira.security.ChartUtils.browse.projects.permission.check\u0022:false,\u0022com.atlassian.jira.security.text.gadget.output.sanitization\u0022:true,\u0022data.pipeline.feature.jira.jsm.kb.stats.events.export\u0022:true,\u0022mail.batching.user.notification\u0022:true,\u0022com.atlassian.diagnostics.jql.monitor\u0022:true,\u0022com.atlassian.portfolio.permission.check.for.permissions\u0022:true,\u0022com.atlassian.jira.agile.darkfeature.dataonpageload\u0022:true,\u0022com.atlassian.jira.issue.watchers.filterUsersWithoutProjectAccess\u0022:true,\u0022jira.webactions.request.method.dependent.xsrf.checks\u0022:true,\u0022data.pipeline.feature.jira.archived.issue.export\u0022:false,\u0022com.atlassian.jira.projects.per.project.permission.query\u0022:true,\u0022com.atlassian.jira.issues.archiving\u0022:true,\u0022jira.priorities.per.project\u0022:true,\u0022index.use.snappy\u0022:true}}";
WRM._unparsedData["jira.core:terminology-data.terminology"]="{\u0022terminologyEntries\u0022:[{\u0022originalName\u0022:\u0022sprint\u0022,\u0022originalNamePlural\u0022:\u0022sprints\u0022,\u0022newName\u0022:\u0022sprint\u0022,\u0022newNamePlural\u0022:\u0022sprints\u0022,\u0022isDefault\u0022:true},{\u0022originalName\u0022:\u0022epic\u0022,\u0022originalNamePlural\u0022:\u0022epics\u0022,\u0022newName\u0022:\u0022epic\u0022,\u0022newNamePlural\u0022:\u0022epics\u0022,\u0022isDefault\u0022:true}],\u0022isTerminologyActive\u0022:false}";
WRM._unparsedData["com.atlassian.plugins.helptips.jira-help-tips:help-tip-manager.JiraHelpTipData"]="{\u0022anonymous\u0022:true}";
WRM._unparsedData["jira.core:avatar-picker-data.data"]="{}";
WRM._unparsedData["jira.request.correlation-id"]="\u0022d4ae7a74444a84\u0022";
WRM._unparsedData["com.atlassian.analytics.analytics-client:programmatic-analytics-init.programmatic-analytics-data-provider"]="false";
WRM._unparsedData["com.atlassian.plugins.atlassian-plugins-webresource-plugin:context-path.context-path"]="\u0022\u0022";
WRM._unparsedData["com.atlassian.analytics.analytics-client:policy-update-init.policy-update-data-provider"]="false";
WRM._unparsedData["com.onresolve.jira.groovy.groovyrunner:web-item-response-renderer.web-item-actions-data-provider"]="[]";
WRM._unparsedData["com.atlassian.jira.jira-header-plugin:newsletter-signup-tip-init.newsletterSignup"]="{\u0022signupDescription\u0022:\u0022Get updates, inspiration and best practices from the team behind Jira.\u0022,\u0022formUrl\u0022:\u0022https://www.atlassian.com/apis/exact-target/{0}/subscribe?mailingListId=1401671\u0022,\u0022signupTitle\u0022:\u0022Sign up!\u0022,\u0022signupId\u0022:\u0022newsletter-signup-tip\u0022,\u0022showNewsletterTip\u0022:false}";
WRM._unparsedData["jira.core:dateFormatProvider.allFormats"]="{\u0022dateFormats\u0022:{\u0022meridiem\u0022:[\u0022AM\u0022,\u0022PM\u0022],\u0022eras\u0022:[\u0022BC\u0022,\u0022AD\u0022],\u0022months\u0022:[\u0022January\u0022,\u0022February\u0022,\u0022March\u0022,\u0022April\u0022,\u0022May\u0022,\u0022June\u0022,\u0022July\u0022,\u0022August\u0022,\u0022September\u0022,\u0022October\u0022,\u0022November\u0022,\u0022December\u0022],\u0022monthsShort\u0022:[\u0022Jan\u0022,\u0022Feb\u0022,\u0022Mar\u0022,\u0022Apr\u0022,\u0022May\u0022,\u0022Jun\u0022,\u0022Jul\u0022,\u0022Aug\u0022,\u0022Sep\u0022,\u0022Oct\u0022,\u0022Nov\u0022,\u0022Dec\u0022],\u0022weekdaysShort\u0022:[\u0022Sun\u0022,\u0022Mon\u0022,\u0022Tue\u0022,\u0022Wed\u0022,\u0022Thu\u0022,\u0022Fri\u0022,\u0022Sat\u0022],\u0022weekdays\u0022:[\u0022Sunday\u0022,\u0022Monday\u0022,\u0022Tuesday\u0022,\u0022Wednesday\u0022,\u0022Thursday\u0022,\u0022Friday\u0022,\u0022Saturday\u0022]},\u0022lookAndFeelFormats\u0022:{\u0022relativize\u0022:\u0022true\u0022,\u0022time\u0022:\u0022HH:mm\u0022,\u0022day\u0022:\u0022EEEE HH:mm\u0022,\u0022dmy\u0022:\u0022dd/MMM/yy\u0022,\u0022complete\u0022:\u0022dd MMM YYYY HH:mm\u0022}}";
WRM._unparsedData["com.atlassian.jira.jira-header-plugin:dismissedFlags.flags"]="{\u0022dismissed\u0022:[]}";
WRM._unparsedData["com.atlassian.jira.project-templates-plugin:project-templates-plugin-resources.ptAnalyticsData"]="{\u0022instanceCreatedDate\u0022:\u00222015-04-02\u0022}";
WRM._unparsedData["jira.core:user-message-flags-data.adminLockout"]="{}";
if(window.WRM._dataArrived)window.WRM._dataArrived();</script>
<link rel="stylesheet" href="/s/1dc49810a0694f6cec3ba758de94a496-CDN/-te3dmd/9150002/1x20kqa/7f3c8af49a90f4abcf682a0d538a2a81/_/download/contextbatch/css/_super,-com.atlassian.plugins.atlassian-plugins-webresource-rest:data-collector-perf-observer,-jira.webresources:resource-phase-checkpoint-init/batch.css" data-wrm-key="_super,-com.atlassian.plugins.atlassian-plugins-webresource-rest:data-collector-perf-observer,-jira.webresources:resource-phase-checkpoint-init" data-wrm-batch-type="context" media="all">
<link rel="stylesheet" href="/s/35a139852ac62a8deb5c5c5d841d7569-CDN/-te3dmd/9150002/1x20kqa/0c040d12554d14a7453e151a31ea6a64/_/download/contextbatch/css/atl.general,jira.general,jira.global,-_super/batch.css?agile_global_admin_condition=true&jag=true" data-wrm-key="atl.general,jira.general,jira.global,-_super" data-wrm-batch-type="context" media="all">
<link rel="stylesheet" href="/s/29bd2d5767c7bcb33684daacf2d3c73c-CDN/-te3dmd/9150002/1x20kqa/6e3fa1f1dde09665fc1bc3b582882989/_/download/contextbatch/css/jira.login,-_super/batch.css" data-wrm-key="jira.login,-_super" data-wrm-batch-type="context" media="all">
<link rel="stylesheet" href="/s/f281d58aaac56624fc4ae3807474bac6-CDN/-te3dmd/9150002/1x20kqa/f391145287ad065b4b2ce7231230a545/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css" data-wrm-key="jira.global.look-and-feel,-_super" data-wrm-batch-type="context" media="all">
<link rel="stylesheet" href="/s/29bd2d5767c7bcb33684daacf2d3c73c-CDN/-te3dmd/9150002/1x20kqa/1.0/_/download/batch/jira.webresources:captcha/jira.webresources:captcha.css" data-wrm-key="jira.webresources:captcha" data-wrm-batch-type="resource" media="all">
<script src="/s/2a852aedef6b31ab796253bb4886c932-CDN/-te3dmd/9150002/1x20kqa/7f3c8af49a90f4abcf682a0d538a2a81/_/download/contextbatch/js/_super,-com.atlassian.plugins.atlassian-plugins-webresource-rest:data-collector-perf-observer,-jira.webresources:resource-phase-checkpoint-init/batch.js?locale=en-US" data-wrm-key="_super,-com.atlassian.plugins.atlassian-plugins-webresource-rest:data-collector-perf-observer,-jira.webresources:resource-phase-checkpoint-init" data-wrm-batch-type="context" data-initially-rendered></script>
<script src="/s/ad451fd8be4ed1dbcd3a6edc8f712427-CDN/-te3dmd/9150002/1x20kqa/0c040d12554d14a7453e151a31ea6a64/_/download/contextbatch/js/atl.general,jira.general,jira.global,-_super/batch.js?agile_global_admin_condition=true&jag=true&locale=en-US" data-wrm-key="atl.general,jira.general,jira.global,-_super" data-wrm-batch-type="context" data-initially-rendered></script>
<script src="/s/c2cbe7420676e3d43a23ec5846f549a1-CDN/-te3dmd/9150002/1x20kqa/33df0255045b83909ed9f03560e4ddae/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US" data-wrm-key="atl.global,-_super" data-wrm-batch-type="context" data-initially-rendered></script>
<script src="/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-te3dmd/9150002/1x20kqa/1.0/_/download/batch/jira.webresources:captcha/jira.webresources:captcha.js" data-wrm-key="jira.webresources:captcha" data-wrm-batch-type="resource" data-initially-rendered></script>
<script type="module">WRM.requireLazily(["wr!com.atlassian.plugins.atlassian-plugins-webresource-rest:data-collector-async"])</script>
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="decorator" content="login" />
</head>
<body id="jira" class="aui-layout aui-theme-default page-type-login " data-version="9.15.2">
<div id="page">
<header id="header" role="banner">
<a class="aui-skip-link" href="/login.jsp?os_destination=%2Fsecure%2Fattachment%2F111382%2F111382_diff.patch">Log in</a><a class="aui-skip-link" href="#main">Skip to main content</a><a class="aui-skip-link" href="#sidebar">Skip to sidebar</a><nav class="aui-header aui-dropdown2-trigger-group" aria-label="Site"><div class="aui-header-inner"><div class="aui-header-before"><button class=" aui-dropdown2-trigger app-switcher-trigger aui-dropdown2-trigger-arrowless" aria-controls="app-switcher" aria-haspopup="true" role="button" data-aui-trigger href="#app-switcher"><span class="aui-icon aui-icon-small aui-iconfont-appswitcher">Linked Applications</span></button><div id="app-switcher" class="aui-dropdown2 aui-style-default" role="menu" hidden data-is-user-admin="false" data-is-switcher="true"><div class="app-switcher-loading">Loading…</div></div></div><div class="aui-header-primary"><span id="logo" class="aui-header-logo aui-header-logo-custom"><a href="https://jira.postgrespro.ru/secure/MyJiraHome.jspa"; aria-label="Go to home page"><img src="/s/-te3dmd/9150002/1x20kqa/_/jira-logo-scaled.png" alt="PPG Jira" /></a></span><ul class='aui-nav'><li><a role="button" href="/secure/Dashboard.jspa" class=" aui-nav-link aui-dropdown2-trigger jira-dropdown2-ajax" id="home_link" aria-haspopup="true" aria-controls="home_link-content" title="View and manage your dashboards" accesskey="d" elementtiming="app-header" data-aui-extra-classes>Dashboards</a><ul class="aui-dropdown2 aui-style-default" id="home_link-content" data-aui-dropdown2-ajax-key="home_link"></ul></li><script>performance.mark("app-header");</script>
</ul></div><div class="aui-header-secondary"><ul class='aui-nav'>
<li id="quicksearch-menu">
<form action="/secure/QuickSearch.jspa" method="get" id="quicksearch" class="aui-quicksearch dont-default-focus ajs-dirty-warning-exempt">
<input id="quickSearchInput" aria-live="polite" role="searchbox" autocomplete="off" class="search" type="text" title="Search" placeholder="Search" name="searchString" accessKey="q" />
<input type="submit" class="hidden" value="Search">
</form>
</li>
<li><a class="jira-feedback-plugin" role="button" aria-label="Feedback" aria-haspopup="true" id="jira-header-feedback-link" href="#" ><span class="aui-icon aui-icon-small aui-iconfont-feedback">Give feedback to Atlassian</span></a></li>
<li id="system-help-menu">
<a class="aui-nav-link aui-dropdown2-trigger aui-dropdown2-trigger-arrowless"
id="help_menu"
aria-label="Help"
aria-haspopup="true"
aria-owns="system-help-menu-content"
href="/secure/ViewKeyboardShortcuts!default.jspa"
target="_blank" rel="noopener noreferrer" title="Help"
>
<span class="aui-icon aui-icon-small aui-iconfont-question-filled">Help</span>
</a>
<div id="system-help-menu-content" class="aui-dropdown2 aui-style-default">
<div class="aui-dropdown2-section">
<ul id="jira-help" class="aui-list-truncate">
<li>
<a id="keyshortscuthelp" class="aui-nav-link " title="Get more information about Jira's Keyboard Shortcuts" href="/secure/ViewKeyboardShortcuts!default.jspa" target="_blank" >Keyboard Shortcuts</a>
</li>
<li>
<a id="view_about" class="aui-nav-link " title="Get more information about Jira" href="/secure/AboutPage.jspa" >About Jira</a>
</li>
<li>
<a id="view_credits" class="aui-nav-link " title="See who did what" href="/secure/credits/AroundTheWorld!default.jspa" target="_blank" >Jira Credits</a>
</li>
</ul>
</div>
</div>
</li>
<li id="user-options">
<a class="aui-nav-link login-link" href="/login.jsp?os_destination=%2Fsecure%2Fattachment%2F111382%2F111382_diff.patch">Log In</a>
<div id="user-options-content" class="aui-dropdown2 aui-style-default">
<div class="aui-dropdown2-section">
</div>
<div class="aui-dropdown2-section">
</div>
</div>
</li>
</ul></div></div><!-- .aui-header-inner--><aui-header-end></aui-header-end></nav><!-- .aui-header -->
</header>
<div id="content">
<div class="aui-page-panel" ><div class="aui-page-panel-inner">
<main role="main" id="main" class="aui-page-panel-content" >
<header class="aui-page-header"><div class="aui-page-header-inner"><div class="aui-page-header-main">
<h1>Welcome to PPG Jira</h1>
</div></div></header>
<form action="/login.jsp"
class="aui"
id="login-form"
method="post">
<div class="form-body">
<div class="aui-message aui-message-warning">
<p>You must log in to access this page.</p>
<p>
If you think you shouldn't get this message, please contact your Jira administrators.
</p>
</div>
<div class="aui-group jira-login-method">
<div class="aui-item jira-login-item">
<div class="field-group">
<label accesskey="u" for="login-form-username"><u>U</u>sername</label>
<input class="text medium-field" id="login-form-username" name="os_username" type="text" aria-describedby="login-form-error" value="" />
</div>
<div class="field-group">
<label accesskey="p" for="login-form-password" id="passwordlabel"><u>P</u>assword</label>
<input id="login-form-password" class="text medium-field" name="os_password" type="password" />
</div>
<fieldset class="group ">
<div class="checkbox">
<input class="checkbox" id="login-form-remember-me" name="os_cookie" type="checkbox" value="true" />
<label for="login-form-remember-me" accesskey="r"><u>R</u>emember my login on this computer</label>
</div>
</fieldset> <!-- // .group -->
<div id="sign-up-hint" class="field-group">
Not a member? To request an account, please contact your Jira administrators.
</div>
</div>
</div>
<div class="hidden"
>
<input
name="os_destination"
type="hidden"
value="/secure/attachment/111382/111382_diff.patch"
/>
</div>
<div class="hidden"
>
<input
name="user_role"
type="hidden"
/>
</div>
<div class="hidden"
>
<input
name="atl_token"
type="hidden"
/>
</div>
</div>
<div class="buttons-container form-footer">
<div class="buttons">
<button
accesskey="s"
class="aui-button aui-button-primary"
id="login-form-submit"
name="login"
title="Press Alt+Shift+s to submit this form"
type="submit"
value="Log In"
>
Log In
</button>
<a
accesskey="`"
class="aui-button aui-button-link cancel"
href="/secure/ForgotLoginDetails.jspa"
id="login-form-cancel"
title="Press Alt+Shift+` to cancel"
>Can't access your account?</a>
</div>
</div>
</form> <!-- // .aui #login-form -->
</main>
</div></div>
</div>
<footer id="footer" role="contentinfo">
<section class="footer-body">
<ul class="atlassian-footer">
<li>
Atlassian Jira <a class="seo-link" rel="nofollow" href="https://www.atlassian.com/software/jira";>Project Management Software</a>
</li>
<li>
<a id="about-link" rel="nofollow" href="/secure/AboutPage.jspa/secure/AboutPage.jspa">About Jira</a>
</li>
<li>
<a id="footer-report-problem-link" rel="nofollow" href="/secure/CreateIssue!default.jspa">Report a problem</a>
</li>
</ul>
<p class="atlassian-footer">
<span class="licensemessage">
</span>
</p>
<div id="footer-logo"><a rel="nofollow" href="http://www.atlassian.com/";>Atlassian</a></div>
</section>
<fieldset class="hidden parameters">
<input type="hidden" title="loggedInUser" value="">
<input type="hidden" title="ajaxTimeout" value="The call to the Jira server did not complete within the timeout period. We are unsure of the result of this operation.">
<input type="hidden" title="JiraVersion" value="9.15.2" />
<input type="hidden" title="ajaxUnauthorised" value="You are not authorized to perform this operation. Please log in.">
<input type="hidden" title="baseURL" value="https://jira.postgrespro.ru"; />
<input type="hidden" title="ajaxCommsError" value="The Jira server could not be contacted. This may be a temporary glitch or the server may be down. ">
<input type="hidden" title="ajaxServerError" value="The Jira server was contacted but has returned an error response. We are unsure of the result of this operation.">
<input type="hidden" title="ajaxErrorCloseDialog" value="Close this dialog and press refresh in your browser">
<input type="hidden" title="ajaxErrorDialogHeading" value="Communications Breakdown">
<input type="hidden" title="dirtyMessage" value="You have entered new data on this page. If you navigate away from this page without first saving your data, the changes will be lost.">
<input type="hidden" title="dirtyDialogMessage" value="You have entered new data in this dialog. If you navigate away from this dialog without first saving your data, the changes will be lost. Click cancel to return to the dialog.">
<input type="hidden" title="keyType" value="Type">
<input type="hidden" title="keyThen" value="then">
<input type="hidden" title="dblClickToExpand" value="Double click to expand">
<input type="hidden" title="actions" value="Actions">
<input type="hidden" title="removeItem" value="Remove">
<input type="hidden" title="workflow" value="Workflow">
<input type="hidden" title="labelNew" value="New Label">
<input type="hidden" title="issueActionsHint" value="Begin typing for available operations or press down to see all">
<input type="hidden" title="closelink" value="Close">
<input type="hidden" title="dotOperations" value="Operations">
<input type="hidden" title="dotLoading" value="Loading...">
<input type="hidden" title="frotherSuggestions" value="Suggestions">
<input type="hidden" title="frotherNomatches" value="No Matches">
<input type="hidden" title="multiselectVersionsError" value="{0} is not a valid version.">
<input type="hidden" title="multiselectComponentsError" value="{0} is not a valid component.">
<input type="hidden" title="multiselectGenericError" value="The value {0} is invalid.">
</fieldset>
</footer>
</div>
<script>
window.WRM=window.WRM||{};window.WRM._unparsedData=window.WRM._unparsedData||{};window.WRM._unparsedErrors=window.WRM._unparsedErrors||{};
WRM._unparsedData["keyboardShortcutsUrl"]="\u0022/rest/api/1.0/shortcuts/9150002/78e4066442c633f4f127a69371b9bae9/shortcuts\u0022";
if(window.WRM._dataArrived)window.WRM._dataArrived();</script>
<script src="/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-te3dmd/9150002/1x20kqa/9c10c8a3d20c751f96a47d5566e02c11/_/download/contextbatch/js/jira.webresources:resource-phase-checkpoint-hit,-_super/batch.js" data-wrm-key="jira.webresources:resource-phase-checkpoint-hit,-_super" data-wrm-batch-type="context" data-initially-rendered defer></script>
</body>
</html>
