Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

explain.c

Blame
    • Tom Lane's avatar
      97c4ee94
      Include the target table in EXPLAIN output for ModifyTable nodes. · 97c4ee94
      Tom Lane authored
      Per discussion, this seems important for plans involving writable CTEs,
      since there can now be more than one ModifyTable node in the plan.
      
      To retain the same formatting as for target tables of scan nodes, we
      show only one target table, which will be the parent table in case of
      an UPDATE or DELETE on an inheritance tree.  Individual child tables
      can be determined by inspecting the child plan trees if needed.
      97c4ee94
      History
      Include the target table in EXPLAIN output for ModifyTable nodes.
      Tom Lane authored
      Per discussion, this seems important for plans involving writable CTEs,
      since there can now be more than one ModifyTable node in the plan.
      
      To retain the same formatting as for target tables of scan nodes, we
      show only one target table, which will be the parent table in case of
      an UPDATE or DELETE on an inheritance tree.  Individual child tables
      can be determined by inspecting the child plan trees if needed.