From Code to Community: Sponsoring The Perl and Raku Conference 2025 Learn more

DEPESZ / Pg-Explain-2.8 / t / 63-rows-removed-by.d / plan-4.yaml 

            

              
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

              
- Plan: 
    Node Type: "ModifyTable"
    Operation: "Insert"
    Parallel Aware: false
    Async Capable: false
    Relation Name: "test"
    Alias: "test"
    Startup Cost: 0.00
    Total Cost: 0.01
    Plan Rows: 0
    Plan Width: 0
    Actual Startup Time: 0.230
    Actual Total Time: 0.232
    Actual Rows: 0
    Actual Loops: 1
    Conflict Resolution: "UPDATE"
    Conflict Arbiter Indexes: 
      - "test_pkey"
    Conflict Filter: "(excluded.id > 1)"
    Rows Removed by Conflict Filter: 1
    Tuples Inserted: 0
    Conflicting Tuples: 1
    Plans: 
      - Node Type: "Result"
        Parent Relationship: "Outer"
        Parallel Aware: false
        Async Capable: false
        Startup Cost: 0.00
        Total Cost: 0.01
        Plan Rows: 1
        Plan Width: 36
        Actual Startup Time: 0.003
        Actual Total Time: 0.004
        Actual Rows: 1
        Actual Loops: 1
  Planning Time: 0.446
  Triggers: 
  Execution Time: 0.343