explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NZEo

Settings
# exclusive inclusive rows x rows loops node
1. 1,431.509 18,211,183.792 ↑ 1,674.8 67,058 1

Hash Left Join (cost=319,984.75..309,404,937,198.99 rows=112,311,123 width=329) (actual time=100,239.765..18,211,183.792 rows=67,058 loops=1)

  • Hash Cond: (("UAT EMI Central$Cust_ Ledger Entry_1"."Document No_")::text = ("UAT EMI Central$Sales Cr_Memo Header"."No_")::text)
  • Buffers: shared hit=36,623,032 read=690,614, temp read=366,144,084 written=18,334
  • I/O Timings: read=53,061.245
  • PL/pgSQL function billing_calculator.calculate_all_sales_invoice16() line 8 at FOR over SELECT rows2020-09-11 13:06:36 UTC [1347]: [105-1] user=postgres,db=dih_uat,app=DBeaver 5.3.1 - Main,client=172.16.8.211 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp1347.0", size 202342402020-09-11 13:06:36 UTC [1347]: [106-1] user=postgres,db=dih_uat,app=DBeaver 5.3.1 - Main,client=172.16.8.211 CONTEXT: PL/pgSQL function billing_calculator.get_all_sales_invoice16_documents() line 4 at RETURN QUERY
  • PL/pgSQL function billing_calculator.calculate_all_sales_invoice16() line 8 at FOR over SELECT rows2020-09-11 13:06:36 UTC [1347]: [107-1] user=postgres,db=dih_uat,app=DBeaver 5.3.1 - Main,client=172.16.8.211 STATEMENT: select * from billing_calculator.calculate_all_sales_invoice16()2020-09-11 13:06:36 UTC [1347]: [108-1] user=postgres,db=dih_uat,app=DBeaver 5.3.1 - Main,client=172.16.8.211 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp1347.32", size 447201872020-09-11 13:06:36 UTC [1347]: [109-1] user=postgres,db=dih_uat,app=DBeaver 5.3.1 - Main,client=172.16.8.211 CONTEXT: PL/pgSQL function billing_calculator.get_all_sales_invoice16_documents() line 4 at RETURN QUERY
  • PL/pgSQL function billing_calculator.calculate_all_sales_invoice16() line 8 at FOR over SELECT rows2020-09-11 13:06:36 UTC [1347]: [110-1] user=postgres,db=dih_uat,app=DBeaver 5.3.1 - Main,client=172.16.8.211 STATEMENT: select * from billing_calculator.calculate_all_sales_invoice16()2020-09-11 13:06:36 UTC [1347]: [111-1] user=postgres,db=dih_uat,app=DBeaver 5.3.1 - Main,client=172.16.8.211 LOG: duration: 12.831 ms plan:
  • Query Text: delete from billing.document d where d."number" = rec."No_
2.          

Initplan (for Hash Left Join)

3. 3.618 3.618 ↑ 1.0 1 1

Seq Scan on "Company" (cost=0.00..1.20 rows=1 width=4) (actual time=3.339..3.618 rows=1 loops=1)

  • Filter: (("Name")::text = 'UAT EMI Central'::text)
  • Rows Removed by Filter: 15
  • Buffers: shared read=1
  • I/O Timings: read=3.331
4. 8,582,384.891 18,202,759.227 ↑ 121.4 67,058 1

Nested Loop Left Join (cost=319,874.68..54,803,668,290.60 rows=8,141,437 width=414) (actual time=100,193.649..18,202,759.227 rows=67,058 loops=1)

  • Join Filter: ((ah1cle."Document No_")::text = ("UAT EMI Central$Cust_ Ledger Entry_1"."Document No_")::text)
  • Rows Removed by Join Filter: 109,516,242,106
  • Buffers: shared hit=34,787,234 read=686,128, temp read=366,144,084 written=18,334
  • I/O Timings: read=52,837.811
5. 374.227 357,853.970 ↑ 121.4 67,058 1

Hash Left Join (cost=319,872.63..54,447,885,137.21 rows=8,141,437 width=382) (actual time=47,371.269..357,853.970 rows=67,058 loops=1)

  • Hash Cond: ("UAT EMI Central$Cust_ Ledger Entry_1"."Entry No_" = ahcle."Cust_ Ledger Entry No_")
  • Buffers: shared hit=5,444,761 read=59,146, temp read=12,864 written=12,874
  • I/O Timings: read=21,498.083
6. 147.686 347,171.251 ↑ 121.4 67,058 1

Hash Left Join (cost=169,945.39..54,447,713,385.83 rows=8,141,437 width=354) (actual time=37,067.857..347,171.251 rows=67,058 loops=1)

  • Hash Cond: (("UAT EMI Central$Cust_ Ledger Entry"."Document No_")::text = (adwsr."Document No_")::text)
  • Buffers: shared hit=5,444,761 read=21,011, temp read=2,470 written=2,480
  • I/O Timings: read=16,487.216
7. 205.221 346,994.632 ↑ 121.4 67,058 1

Merge Left Join (cost=169,772.92..54,447,691,389.22 rows=8,141,437 width=353) (actual time=37,047.184..346,994.632 rows=67,058 loops=1)

  • Merge Cond: (("UAT EMI Central$Sales Invoice Header"."No_")::text = ("UAT EMI Central$Sales Invoice Line"."Document No_")::text)
  • Buffers: shared hit=5,444,757 read=21,001, temp read=2,470 written=2,480
  • I/O Timings: read=16,467.245
8. 161.352 344,083.612 ↑ 121.4 67,058 1

Merge Left Join (cost=3,102.53..54,447,414,512.48 rows=8,141,437 width=257) (actual time=36,378.618..344,083.612 rows=67,058 loops=1)

  • Merge Cond: (("UAT EMI Central$Cust_ Ledger Entry"."Document No_")::text = ("UAT EMI Central$Posted Document Web Info"."Document No_")::text)
  • Buffers: shared hit=5,444,756 read=18,839
  • I/O Timings: read=16,218.961
9. 232.611 343,359.808 ↑ 121.4 67,058 1

Merge Left Join (cost=3,101.06..54,447,241,214.11 rows=8,141,437 width=249) (actual time=36,309.357..343,359.808 rows=67,058 loops=1)

  • Merge Cond: (("UAT EMI Central$Sales Invoice Header"."No_")::text = ("UAT EMI Central$Cust_ Ledger Entry_2"."Document No_")::text)
  • Buffers: shared hit=5,444,141 read=17,331
  • I/O Timings: read=16,040.211
10. 144.595 324,158.225 ↑ 121.4 67,058 1

Nested Loop Left Join (cost=3,099.13..78,367,973.88 rows=8,141,437 width=217) (actual time=23,618.648..324,158.225 rows=67,058 loops=1)

  • Buffers: shared hit=3,617,560 read=4,247
  • I/O Timings: read=767.137
11. 151.368 323,477.166 ↑ 35.9 67,058 1

Nested Loop Left Join (cost=3,098.70..71,841,530.04 rows=2,407,170 width=186) (actual time=23,618.629..323,477.166 rows=67,058 loops=1)

  • Buffers: shared hit=3,617,560 read=4,247
  • I/O Timings: read=767.137
12. 142.777 322,856.392 ↑ 35.9 67,058 1

Nested Loop Left Join (cost=3,098.27..70,413,373.28 rows=2,407,170 width=161) (actual time=23,604.442..322,856.392 rows=67,058 loops=1)

  • Join Filter: (('EMI Central'::text) = ('EMI Central'::text))
  • Rows Removed by Join Filter: 448
  • Buffers: shared hit=3,416,427 read=4,200
  • I/O Timings: read=706.938
13. 181.333 321,238.339 ↑ 35.9 67,058 1

Nested Loop (cost=3,098.12..67,207,448.51 rows=2,407,170 width=183) (actual time=23,581.671..321,238.339 rows=67,058 loops=1)

  • Join Filter: (('EMI Central'::text) = ('EMI Central'::text))
  • Rows Removed by Join Filter: 268,232
  • Buffers: shared hit=2,879,497 read=4,098
  • I/O Timings: read=606.345
14. 278.630 320,989.948 ↑ 1,435.9 67,058 1

Nested Loop (cost=3,098.12..59,985,932.98 rows=96,286,806 width=157) (actual time=23,581.225..320,989.948 rows=67,058 loops=1)

  • Buffers: shared hit=2,879,497 read=4,093
  • I/O Timings: read=605.533
15. 297.848 314,573.318 ↑ 1.0 122,760 1

Nested Loop Left Join (cost=3,097.69..16,841,435.57 rows=122,760 width=83) (actual time=121.296..314,573.318 rows=122,760 loops=1)

  • Buffers: shared hit=379,267 read=2,129
  • I/O Timings: read=407.828
16. 207,184.528 313,416.150 ↑ 1.0 122,760 1

Nested Loop Left Join (cost=3,097.40..16,803,293.91 rows=122,760 width=77) (actual time=116.807..313,416.150 rows=122,760 loops=1)

  • Join Filter: ((outerlim."Customer No_")::text = ("UAT EMI Central$Sales Invoice Header"."Bill-to Customer No_")::text)
  • Rows Removed by Join Filter: 2,308,747,321
  • Buffers: shared hit=11,010 read=1,846
  • I/O Timings: read=202.821
17. 146.593 535.262 ↑ 1.0 122,760 1

Merge Append (cost=1.60..8,785.69 rows=122,760 width=71) (actual time=42.533..535.262 rows=122,760 loops=1)

  • Sort Key: "UAT EMI Central$Sales Invoice Header"."No_
  • Buffers: shared hit=11,007 read=1,655
  • I/O Timings: read=164.447
18. 303.532 303.532 ↑ 1.0 105,738 1

Index Scan using "UAT_EMI_Central$Sales_Invoice_Header_No__IDX" on "UAT EMI Central$Sales Invoice Header" (cost=0.42..6,009.56 rows=105,738 width=71) (actual time=12.216..303.532 rows=105,738 loops=1)

  • Buffers: shared hit=10,950 read=1,423
  • I/O Timings: read=123.029
19. 27.355 27.355 ↑ 1.0 4,072 1

Index Scan using "UAT WAG BE$Sales_Invoice_Header_No__IDX" on "UAT WAG BE$Sales Invoice Header" (cost=0.28..181.89 rows=4,072 width=72) (actual time=8.117..27.355 rows=4,072 loops=1)

  • Buffers: shared hit=10 read=56
  • I/O Timings: read=16.633
20. 16.105 16.105 ↑ 1.0 3,120 1

Index Scan using "UAT WAG ES$Sales_Invoice_Header_No__IDX" on "UAT WAG ES$Sales Invoice Header" (cost=0.28..136.11 rows=3,120 width=72) (actual time=6.775..16.105 rows=3,120 loops=1)

  • Buffers: shared hit=20 read=43
  • I/O Timings: read=7.346
21. 32.272 32.272 ↑ 1.0 9,300 1

Index Scan using "UAT WAG FR$Sales_Invoice_Header_No__IDX" on "UAT WAG FR$Sales Invoice Header" (cost=0.29..381.91 rows=9,300 width=72) (actual time=7.640..32.272 rows=9,300 loops=1)

  • Buffers: shared hit=23 read=124
  • I/O Timings: read=9.538
22. 9.405 9.405 ↑ 1.0 530 1

Index Scan using "UAT_WAG_CZ$Sales_Invoice_Header_No__IDX" on "UAT WAG CZ$Sales Invoice Header" (cost=0.28..37.16 rows=530 width=72) (actual time=7.783..9.405 rows=530 loops=1)

  • Buffers: shared hit=4 read=9
  • I/O Timings: read=7.902
23. 105,624.415 105,696.360 ↓ 2.1 18,808 122,760

Materialize (cost=3,095.81..4,645.81 rows=9,118 width=12) (actual time=0.001..0.861 rows=18,808 loops=122,760)

  • Buffers: shared hit=3 read=191
  • I/O Timings: read=38.373
24. 2.995 71.945 ↓ 2.1 18,808 1

Subquery Scan on outerlim (cost=3,095.81..4,600.22 rows=9,118 width=12) (actual time=53.598..71.945 rows=18,808 loops=1)

  • Filter: (outerlim.rn <= 1)
  • Rows Removed by Filter: 8,545
  • Buffers: shared hit=3 read=191
  • I/O Timings: read=38.373
25. 12.816 68.950 ↑ 1.0 27,353 1

WindowAgg (cost=3,095.81..4,258.31 rows=27,353 width=126) (actual time=53.596..68.950 rows=27,353 loops=1)

  • Buffers: shared hit=3 read=191
  • I/O Timings: read=38.373
26. 12.552 56.134 ↑ 1.0 27,353 1

Sort (cost=3,095.81..3,164.19 rows=27,353 width=16) (actual time=53.584..56.134 rows=27,353 loops=1)

  • Sort Key: lim."Customer No_", (CASE WHEN ((lim."Behaviour Code")::text = 'EW_ONE'::text) THEN 1 WHEN ((lim."Behaviour Code")::text = 'EW_FLEET'::text) THEN 2 WHEN ((lim."Behaviour Code")::text = 'EW_VECTOR_HAULIER'::text) THEN 3 WHEN ((lim."Behaviour Code")::text = 'EW_EASY_FUEL'::text) THEN 4 WHEN ((lim."Behaviour Code")::text = 'EW_EASY_TOLL'::text) THEN 5 WHEN ((lim."Behaviour Code")::text = 'EWMC'::text) THEN 6 WHEN ((lim."Behaviour Code")::text = 'EW_ONE'::text) THEN 7 WHEN ((lim."Behaviour Code")::text = 'EW_VECTOR_FORWARDER'::text) THEN 8 WHEN ((lim."Behaviour Code")::text = 'PRINCIP'::text) THEN 9 ELSE NULL::integer END)
  • Sort Method: quicksort Memory: 2,894kB
  • Buffers: shared hit=3 read=191
  • I/O Timings: read=38.373
27. 43.582 43.582 ↑ 1.0 27,353 1

Seq Scan on "Limit" lim (cost=0.00..1,079.97 rows=27,353 width=16) (actual time=5.394..43.582 rows=27,353 loops=1)

  • Buffers: shared read=191
  • I/O Timings: read=38.373
28. 859.320 859.320 ↑ 1.0 1 122,760

Index Scan using "Customer_pkey" on "Customer" cus (cost=0.29..0.31 rows=1 width=18) (actual time=0.007..0.007 rows=1 loops=122,760)

  • Index Cond: (("UAT EMI Central$Sales Invoice Header"."Bill-to Customer No_")::text = ("No_")::text)
  • Buffers: shared hit=368,257 read=283
  • I/O Timings: read=205.007
29. 613.800 6,138.000 ↑ 5.0 1 122,760

Append (cost=0.43..351.40 rows=5 width=74) (actual time=0.030..0.050 rows=1 loops=122,760)

  • Buffers: shared hit=2,500,230 read=1,964
  • I/O Timings: read=197.705
30. 1,267.354 3,069.000 ↑ 1.0 1 122,760

Index Scan using "UAT_EMI_Central$Cust_Ledger_Entry_Document_No__IDX" on "UAT EMI Central$Cust_ Ledger Entry" (cost=0.43..151.08 rows=1 width=74) (actual time=0.025..0.025 rows=1 loops=122,760)

  • Index Cond: (("Document No_")::text = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)) AND CASE WHEN ((SubPlan 10) > 1) THEN CASE WHEN ('EMI Central'::text = 'EMI Central'::text) THEN true ELSE false END ELSE true END)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1,281,859 read=1,913
  • I/O Timings: read=189.028
31.          

SubPlan (for Index Scan using "UAT_EMI_Central$Cust_Ledger_Entry_Document_No__IDX" on "UAT EMI Central$Cust_ Ledger Entry")

32. 245.679 1,801.646 ↑ 1.0 1 81,893

Aggregate (cost=49.74..49.75 rows=1 width=8) (actual time=0.022..0.022 rows=1 loops=81,893)

  • Buffers: shared hit=1,012,935 read=313
  • I/O Timings: read=4.035
33. 491.358 1,555.967 ↑ 7.0 1 81,893

Append (cost=0.43..49.72 rows=7 width=0) (actual time=0.006..0.019 rows=1 loops=81,893)

  • Buffers: shared hit=1,012,935 read=313
  • I/O Timings: read=4.035
34. 409.465 409.465 ↑ 3.0 1 81,893

Index Only Scan using "UAT_EMI_Central$Cust_Ledger_Entry_Document_No__IDX" on "UAT EMI Central$Cust_ Ledger Entry" "UAT EMI Central$Cust_ Ledger Entry_6" (cost=0.43..16.48 rows=3 width=0) (actual time=0.005..0.005 rows=1 loops=81,893)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 79,826
  • Buffers: shared hit=325,897 read=124
  • I/O Timings: read=1.651
35. 163.786 163.786 ↓ 0.0 0 81,893

Index Only Scan using "UAT WAG BE$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG BE$Cust_ Ledger Entry" "UAT WAG BE$Cust_ Ledger Entry_6" (cost=0.29..8.30 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=81,893)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 7,276
  • Buffers: shared hit=171,084 read=32
  • I/O Timings: read=0.295
36. 163.786 163.786 ↓ 0.0 0 81,893

Index Only Scan using "UAT WAG ES$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG ES$Cust_ Ledger Entry" "UAT WAG ES$Cust_ Ledger Entry_6" (cost=0.29..8.30 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=81,893)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 6,073
  • Buffers: shared hit=169,858 read=45
  • I/O Timings: read=0.734
37. 163.786 163.786 ↓ 0.0 0 81,893

Index Only Scan using "UAT WAG FR$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG FR$Cust_ Ledger Entry" "UAT WAG FR$Cust_ Ledger Entry_6" (cost=0.29..8.30 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=81,893)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 17,887
  • Buffers: shared hit=181,697 read=112
  • I/O Timings: read=1.356
38. 163.786 163.786 ↓ 0.0 0 81,893

Index Only Scan using "UAT_WAG_CZ$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG CZ$Cust_ Ledger Entry" "UAT WAG CZ$Cust_ Ledger Entry_6" (cost=0.28..8.29 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=81,893)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 609
  • Buffers: shared hit=164,399
39. 736.560 736.560 ↓ 0.0 0 122,760

Index Scan using "UAT WAG BE$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG BE$Cust_ Ledger Entry" (cost=0.29..50.08 rows=1 width=73) (actual time=0.006..0.006 rows=0 loops=122,760)

  • Index Cond: (("Document No_")::text = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)) AND CASE WHEN ((SubPlan 10) > 1) THEN CASE WHEN ('WAG BE'::text = 'EMI Central'::text) THEN true ELSE false END ELSE true END)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=301,702 read=19
  • I/O Timings: read=0.323
40. 491.040 491.040 ↓ 0.0 0 122,760

Index Scan using "UAT WAG ES$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG ES$Cust_ Ledger Entry" (cost=0.29..50.07 rows=1 width=73) (actual time=0.004..0.004 rows=0 loops=122,760)

  • Index Cond: (("Document No_")::text = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)) AND CASE WHEN ((SubPlan 10) > 1) THEN CASE WHEN ('WAG ES'::text = 'EMI Central'::text) THEN true ELSE false END ELSE true END)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=289,067 read=9
  • I/O Timings: read=0.537
41. 859.320 859.320 ↓ 0.0 0 122,760

Index Scan using "UAT WAG FR$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG FR$Cust_ Ledger Entry" (cost=0.29..50.09 rows=1 width=73) (actual time=0.007..0.007 rows=0 loops=122,760)

  • Index Cond: (("Document No_")::text = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)) AND CASE WHEN ((SubPlan 10) > 1) THEN CASE WHEN ('WAG FR'::text = 'EMI Central'::text) THEN true ELSE false END ELSE true END)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=375,115 read=15
  • I/O Timings: read=3.930
42. 368.280 368.280 ↓ 0.0 0 122,760

Index Scan using "UAT_WAG_CZ$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG CZ$Cust_ Ledger Entry" (cost=0.28..50.06 rows=1 width=73) (actual time=0.003..0.003 rows=0 loops=122,760)

  • Index Cond: (("Document No_")::text = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Filter: (("Document Type" = 2) AND (("Document Date")::date >= (CURRENT_DATE - '2 years'::interval)) AND CASE WHEN ((SubPlan 10) > 1) THEN CASE WHEN ('WAG CZ'::text = 'EMI Central'::text) THEN true ELSE false END ELSE true END)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=252,487 read=8
  • I/O Timings: read=3.888
43. 63.146 67.058 ↑ 1.0 5 67,058

Materialize (cost=0.00..5.10 rows=5 width=90) (actual time=0.000..0.001 rows=5 loops=67,058)

  • Buffers: shared read=5
  • I/O Timings: read=0.812
44. 2.269 3.912 ↑ 1.0 5 1

Append (cost=0.00..5.08 rows=5 width=90) (actual time=0.441..3.912 rows=5 loops=1)

  • Buffers: shared read=5
  • I/O Timings: read=0.812
45. 0.647 0.647 ↑ 1.0 1 1

Seq Scan on "UAT EMI Central$General Ledger Setup" (cost=0.00..1.01 rows=1 width=90) (actual time=0.441..0.647 rows=1 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=0.432
46. 0.314 0.314 ↑ 1.0 1 1

Seq Scan on "UAT WAG BE$General Ledger Setup" (cost=0.00..1.01 rows=1 width=90) (actual time=0.113..0.314 rows=1 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=0.107
47. 0.260 0.260 ↑ 1.0 1 1

Seq Scan on "UAT WAG ES$General Ledger Setup" (cost=0.00..1.01 rows=1 width=90) (actual time=0.085..0.260 rows=1 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=0.079
48. 0.276 0.276 ↑ 1.0 1 1

Seq Scan on "UAT WAG FR$General Ledger Setup" (cost=0.00..1.01 rows=1 width=90) (actual time=0.109..0.276 rows=1 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=0.103
49. 0.146 0.146 ↑ 1.0 1 1

Seq Scan on "UAT WAG CZ$General Ledger Setup" (cost=0.00..1.01 rows=1 width=90) (actual time=0.096..0.146 rows=1 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=0.091
50. 469.406 1,475.276 ↓ 0.0 0 67,058

Append (cost=0.15..1.27 rows=5 width=42) (actual time=0.021..0.022 rows=0 loops=67,058)

  • Buffers: shared hit=536,930 read=102
  • I/O Timings: read=100.593
51. 134.116 134.116 ↓ 0.0 0 67,058

Index Scan using "UAT EMI Central$SCP Assignment History_pkey" on "UAT EMI Central$SCP Assignment History" (cost=0.15..0.17 rows=1 width=68) (actual time=0.002..0.002 rows=0 loops=67,058)

  • Index Cond: ("Customer Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Filter: ("Skipped" = 0)
  • Buffers: shared hit=67,057 read=1
  • I/O Timings: read=0.005
52. 268.232 268.232 ↓ 0.0 0 67,058

Index Scan using "UAT WAG BE$SCP Assignment History_pkey" on "UAT WAG BE$SCP Assignment History" (cost=0.28..0.30 rows=1 width=42) (actual time=0.004..0.004 rows=0 loops=67,058)

  • Index Cond: ("Customer Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Filter: ("Skipped" = 0)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=134,216 read=25
  • I/O Timings: read=34.119
53. 201.174 201.174 ↓ 0.0 0 67,058

Index Scan using "UAT WAG ES$SCP Assignment History_pkey" on "UAT WAG ES$SCP Assignment History" (cost=0.28..0.30 rows=1 width=42) (actual time=0.003..0.003 rows=0 loops=67,058)

  • Index Cond: ("Customer Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Filter: ("Skipped" = 0)
  • Buffers: shared hit=134,282 read=26
  • I/O Timings: read=27.218
54. 268.232 268.232 ↓ 0.0 0 67,058

Index Scan using "UAT WAG FR$SCP Assignment History_pkey" on "UAT WAG FR$SCP Assignment History" (cost=0.29..0.31 rows=1 width=42) (actual time=0.004..0.004 rows=0 loops=67,058)

  • Index Cond: ("Customer Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Filter: ("Skipped" = 0)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=134,230 read=47
  • I/O Timings: read=38.901
55. 134.116 134.116 ↓ 0.0 0 67,058

Index Scan using "UAT WAG CZ$SCP Assignment History_pkey" on "UAT WAG CZ$SCP Assignment History" (cost=0.14..0.17 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=67,058)

  • Index Cond: ("Customer Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Filter: ("Skipped" = 0)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=67,145 read=3
  • I/O Timings: read=0.350
56. 469.406 469.406 ↓ 0.0 0 67,058

Index Scan using assignment_history_source_customer_entry_no__idx on "Assignment History" ap (cost=0.42..0.58 rows=1 width=25) (actual time=0.007..0.007 rows=0 loops=67,058)

  • Index Cond: (("Source Customer Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_") AND ("Source Company ID" = $12))
  • Buffers: shared hit=201,133 read=46
  • I/O Timings: read=56.868
57. 469.406 536.464 ↓ 0.0 0 67,058

Append (cost=0.43..2.66 rows=5 width=35) (actual time=0.008..0.008 rows=0 loops=67,058)

58. 67.058 67.058 ↓ 0.0 0 67,058

Index Scan using "UAT EMI Central$Cust_ Ledger Entry_pkey" on "UAT EMI Central$Cust_ Ledger Entry" "UAT EMI Central$Cust_ Ledger Entry_1" (cost=0.43..1.41 rows=1 width=35) (actual time=0.001..0.001 rows=0 loops=67,058)

  • Index Cond: ("Entry No_" = ap."New Customer Ledger Entry No_")
59. 0.000 0.000 ↓ 0.0 0 67,058

Index Scan using "UAT WAG BE$Cust_ Ledger Entry_pkey" on "UAT WAG BE$Cust_ Ledger Entry" "UAT WAG BE$Cust_ Ledger Entry_1" (cost=0.29..0.31 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=67,058)

  • Index Cond: ("Entry No_" = ap."New Customer Ledger Entry No_")
60. 0.000 0.000 ↓ 0.0 0 67,058

Index Scan using "UAT WAG ES$Cust_ Ledger Entry_pkey" on "UAT WAG ES$Cust_ Ledger Entry" "UAT WAG ES$Cust_ Ledger Entry_1" (cost=0.29..0.31 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=67,058)

  • Index Cond: ("Entry No_" = ap."New Customer Ledger Entry No_")
61. 0.000 0.000 ↓ 0.0 0 67,058

Index Scan using "UAT WAG FR$Cust_ Ledger Entry_pkey" on "UAT WAG FR$Cust_ Ledger Entry" "UAT WAG FR$Cust_ Ledger Entry_1" (cost=0.29..0.32 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=67,058)

  • Index Cond: ("Entry No_" = ap."New Customer Ledger Entry No_")
62. 0.000 0.000 ↓ 0.0 0 67,058

Index Scan using "UAT WAG CZ$Cust_ Ledger Entry_pkey" on "UAT WAG CZ$Cust_ Ledger Entry" "UAT WAG CZ$Cust_ Ledger Entry_1" (cost=0.28..0.29 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=67,058)

  • Index Cond: ("Entry No_" = ap."New Customer Ledger Entry No_")
63. 903.721 18,968.972 ↓ 360.0 72,000 1

GroupAggregate (cost=1.93..54,368,771,469.76 rows=200 width=47) (actual time=52.933..18,968.972 rows=72,000 loops=1)

  • Group Key: "UAT EMI Central$Cust_ Ledger Entry_2"."Document No_
  • Buffers: shared hit=1,826,581 read=13,084
  • I/O Timings: read=15,273.074
64. 132.744 18,065.251 ↑ 129,537,014.3 81,204 1

Nested Loop (cost=1.93..1,774,152,940.68 rows=10,518,923,705,217 width=26) (actual time=41.343..18,065.251 rows=81,204 loops=1)

  • Buffers: shared hit=1,826,581 read=13,084
  • I/O Timings: read=15,273.074
65. 69.922 13,736.091 ↑ 12,440.2 72,352 1

Nested Loop (cost=1.50..1,185,829.13 rows=900,074,932 width=23) (actual time=36.273..13,736.091 rows=72,352 loops=1)

  • Buffers: shared hit=951,976 read=10,023
  • I/O Timings: read=12,047.856
66. 36.540 7,432.934 ↑ 8.3 109,355 1

Merge Append (cost=1.08..87,009.94 rows=907,233 width=23) (actual time=11.557..7,432.934 rows=109,355 loops=1)

  • Sort Key: "UAT EMI Central$Cover Letter Line"."Source Document No_
  • Buffers: shared hit=80,895 read=5,468
  • I/O Timings: read=7,197.988
67. 7,395.401 7,395.401 ↑ 8.3 109,355 1

Index Scan using "UAT_EMI_Central$Cover_Letter_Line_Source_Document_No_IDX" on "UAT EMI Central$Cover Letter Line" (cost=0.43..71,733.68 rows=907,225 width=23) (actual time=11.545..7,395.401 rows=109,355 loops=1)

  • Filter: ("Source Document Type" = 0)
  • Rows Removed by Filter: 2,398
  • Buffers: shared hit=80,891 read=5,468
  • I/O Timings: read=7,197.988
68. 0.184 0.184 ↓ 0.0 0 1

Index Scan using "UAT_WAG_BE$Cover_Letter_Line_Source_Document_No_IDX" on "UAT WAG BE$Cover Letter Line" (cost=0.15..51.85 rows=2 width=116) (actual time=0.004..0.184 rows=0 loops=1)

  • Filter: ("Source Document Type" = 0)
  • Buffers: shared hit=1
69. 0.353 0.353 ↓ 0.0 0 1

Index Scan using "UAT_WAG_ES$Cover_Letter_Line_Source_Document_No_IDX" on "UAT WAG ES$Cover Letter Line" (cost=0.15..51.85 rows=2 width=116) (actual time=0.003..0.353 rows=0 loops=1)

  • Filter: ("Source Document Type" = 0)
  • Buffers: shared hit=1
70. 0.173 0.173 ↓ 0.0 0 1

Index Scan using "UAT_WAG_FR$Cover_Letter_Line_Source_Document_No_IDX" on "UAT WAG FR$Cover Letter Line" (cost=0.15..51.85 rows=2 width=116) (actual time=0.002..0.173 rows=0 loops=1)

  • Filter: ("Source Document Type" = 0)
  • Buffers: shared hit=1
71. 0.283 0.283 ↓ 0.0 0 1

Index Scan using "UAT_WAG_CZ$Cover_Letter_Line_Source_Document_No_IDX" on "UAT WAG CZ$Cover Letter Line" (cost=0.15..51.85 rows=2 width=116) (actual time=0.002..0.283 rows=0 loops=1)

  • Filter: ("Source Document Type" = 0)
  • Buffers: shared hit=1
72. 328.069 6,233.235 ↑ 5.0 1 109,355

Append (cost=0.42..1.16 rows=5 width=11) (actual time=0.050..0.057 rows=1 loops=109,355)

  • Buffers: shared hit=871,081 read=4,555
  • I/O Timings: read=4,849.867
73. 5,467.750 5,467.750 ↑ 1.0 1 109,355

Index Scan using "UAT EMI Central$Cover Letter Header_pkey" on "UAT EMI Central$Cover Letter Header" (cost=0.42..0.47 rows=1 width=11) (actual time=0.049..0.050 rows=1 loops=109,355)

  • Index Cond: (("No_")::text = ("UAT EMI Central$Cover Letter Line"."Document No_")::text)
  • Filter: ("Fictive" = 0)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=433,669 read=4,551
  • I/O Timings: read=4,849.838
74. 109.354 109.354 ↓ 0.0 0 109,354

Index Scan using "UAT WAG BE$Cover Letter Header_pkey" on "UAT WAG BE$Cover Letter Header" (cost=0.15..0.17 rows=1 width=58) (actual time=0.001..0.001 rows=0 loops=109,354)

  • Index Cond: (("No_")::text = ("UAT EMI Central$Cover Letter Line"."Document No_")::text)
  • Filter: ("Fictive" = 0)
  • Buffers: shared hit=109,353 read=1
  • I/O Timings: read=0.009
75. 109.354 109.354 ↓ 0.0 0 109,354

Index Scan using "UAT WAG ES$Cover Letter Header_pkey" on "UAT WAG ES$Cover Letter Header" (cost=0.15..0.17 rows=1 width=58) (actual time=0.001..0.001 rows=0 loops=109,354)

  • Index Cond: (("No_")::text = ("UAT EMI Central$Cover Letter Line"."Document No_")::text)
  • Filter: ("Fictive" = 0)
  • Buffers: shared hit=109,353 read=1
  • I/O Timings: read=0.007
76. 109.354 109.354 ↓ 0.0 0 109,354

Index Scan using "UAT WAG FR$Cover Letter Header_pkey" on "UAT WAG FR$Cover Letter Header" (cost=0.15..0.17 rows=1 width=58) (actual time=0.001..0.001 rows=0 loops=109,354)

  • Index Cond: (("No_")::text = ("UAT EMI Central$Cover Letter Line"."Document No_")::text)
  • Filter: ("Fictive" = 0)
  • Buffers: shared hit=109,353 read=1
  • I/O Timings: read=0.007
77. 109.354 109.354 ↓ 0.0 0 109,354

Index Scan using "UAT WAG CZ$Cover Letter Header_pkey" on "UAT WAG CZ$Cover Letter Header" (cost=0.15..0.17 rows=1 width=58) (actual time=0.001..0.001 rows=0 loops=109,354)

  • Index Cond: (("No_")::text = ("UAT EMI Central$Cover Letter Line"."Document No_")::text)
  • Filter: ("Fictive" = 0)
  • Buffers: shared hit=109,353 read=1
  • I/O Timings: read=0.007
78. 289.414 4,196.416 ↑ 7.0 1 72,352

Append (cost=0.43..1.90 rows=7 width=15) (actual time=0.048..0.058 rows=1 loops=72,352)

  • Buffers: shared hit=874,605 read=3,061
  • I/O Timings: read=3,225.218
79. 3,472.896 3,472.896 ↑ 3.0 1 72,352

Index Only Scan using "UAT_EMI_Central$Cust_Ledger_Entry_Document_No__IDX" on "UAT EMI Central$Cust_ Ledger Entry" "UAT EMI Central$Cust_ Ledger Entry_2" (cost=0.43..0.66 rows=3 width=15) (actual time=0.048..0.048 rows=1 loops=72,352)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Cover Letter Line"."Source Document No_")::text)
  • Heap Fetches: 72,385
  • Buffers: shared hit=287,042 read=2,929
  • I/O Timings: read=3,223.557
80. 144.702 144.702 ↓ 0.0 0 72,351

Index Only Scan using "UAT WAG BE$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG BE$Cust_ Ledger Entry" "UAT WAG BE$Cust_ Ledger Entry_2" (cost=0.29..0.30 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=72,351)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Cover Letter Line"."Source Document No_")::text)
  • Heap Fetches: 1,207
  • Buffers: shared hit=145,870 read=49
  • I/O Timings: read=0.511
81. 72.351 72.351 ↓ 0.0 0 72,351

Index Only Scan using "UAT WAG ES$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG ES$Cust_ Ledger Entry" "UAT WAG ES$Cust_ Ledger Entry_2" (cost=0.29..0.30 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=72,351)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Cover Letter Line"."Source Document No_")::text)
  • Heap Fetches: 2,788
  • Buffers: shared hit=147,501 read=11
  • I/O Timings: read=0.112
82. 144.702 144.702 ↓ 0.0 0 72,351

Index Only Scan using "UAT WAG FR$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG FR$Cust_ Ledger Entry" "UAT WAG FR$Cust_ Ledger Entry_2" (cost=0.29..0.31 rows=1 width=16) (actual time=0.001..0.002 rows=0 loops=72,351)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Cover Letter Line"."Source Document No_")::text)
  • Heap Fetches: 4,805
  • Buffers: shared hit=149,479 read=64
  • I/O Timings: read=0.908
83. 72.351 72.351 ↓ 0.0 0 72,351

Index Only Scan using "UAT_WAG_CZ$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG CZ$Cust_ Ledger Entry" "UAT WAG CZ$Cust_ Ledger Entry_2" (cost=0.28..0.29 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=72,351)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Cover Letter Line"."Source Document No_")::text)
  • Heap Fetches: 19
  • Buffers: shared hit=144,713 read=8
  • I/O Timings: read=0.131
84. 147.531 562.452 ↓ 607.2 121,446 1

GroupAggregate (cost=1.47..71,527.91 rows=200 width=19) (actual time=37.860..562.452 rows=121,446 loops=1)

  • Group Key: "UAT EMI Central$Posted Document Web Info"."Document No_
  • Buffers: shared hit=615 read=1,508
  • I/O Timings: read=178.751
85. 85.148 414.921 ↑ 7.1 131,465 1

Merge Append (cost=1.47..66,843.80 rows=936,423 width=11) (actual time=37.850..414.921 rows=131,465 loops=1)

  • Sort Key: "UAT EMI Central$Posted Document Web Info"."Document No_
  • Buffers: shared hit=615 read=1,508
  • I/O Timings: read=178.751
86. 263.522 263.522 ↑ 7.6 121,175 1

Index Scan using "UAT EMI Central$Posted Document Web Info_pkey" on "UAT EMI Central$Posted Document Web Info" (cost=0.43..50,685.62 rows=926,133 width=11) (actual time=13.182..263.522 rows=121,175 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Filter: ("Send Electronically" = 1)
  • Buffers: shared hit=527 read=1,386
  • I/O Timings: read=132.631
87. 18.342 18.342 ↑ 1.0 1,408 1

Index Scan using "UAT WAG BE$Posted Document Web Info_pkey" on "UAT WAG BE$Posted Document Web Info" (cost=0.28..86.94 rows=1,408 width=14) (actual time=8.566..18.342 rows=1,408 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Filter: ("Send Electronically" = 1)
  • Buffers: shared hit=35 read=17
  • I/O Timings: read=15.730
88. 22.868 22.868 ↑ 1.0 2,915 1

Index Scan using "UAT WAG ES$Posted Document Web Info_pkey" on "UAT WAG ES$Posted Document Web Info" (cost=0.28..172.21 rows=2,915 width=14) (actual time=8.600..22.868 rows=2,915 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Filter: ("Send Electronically" = 1)
  • Buffers: shared hit=4 read=35
  • I/O Timings: read=17.257
89. 24.088 24.088 ↑ 1.0 5,777 1

Index Scan using "UAT WAG FR$Posted Document Web Info_pkey" on "UAT WAG FR$Posted Document Web Info" (cost=0.28..327.07 rows=5,777 width=14) (actual time=7.243..24.088 rows=5,777 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Filter: ("Send Electronically" = 1)
  • Buffers: shared hit=14 read=67
  • I/O Timings: read=12.840
90. 0.953 0.953 ↑ 1.0 190 1

Index Scan using "UAT WAG CZ$Posted Document Web Info_pkey" on "UAT WAG CZ$Posted Document Web Info" (cost=0.14..18.26 rows=190 width=14) (actual time=0.254..0.953 rows=190 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Filter: ("Send Electronically" = 1)
  • Buffers: shared hit=35 read=3
  • I/O Timings: read=0.293
91. 1,878.624 2,705.799 ↓ 611.3 122,258 1

GroupAggregate (cost=166,670.39..175,106.28 rows=200 width=109) (actual time=614.775..2,705.799 rows=122,258 loops=1)

  • Group Key: "UAT EMI Central$Sales Invoice Line"."Document No_
  • Buffers: shared hit=1 read=2,162, temp read=2,470 written=2,480
  • I/O Timings: read=248.284
92. 373.308 827.175 ↑ 1.0 258,904 1

Sort (cost=166,670.39..167,318.92 rows=259,412 width=572) (actual time=614.736..827.175 rows=258,904 loops=1)

  • Sort Key: "UAT EMI Central$Sales Invoice Line"."Document No_
  • Sort Method: external merge Disk: 19,760kB
  • Buffers: shared hit=1 read=2,162, temp read=2,470 written=2,480
  • I/O Timings: read=248.284
93. 64.880 453.867 ↑ 1.0 259,412 1

Hash Left Join (cost=32.43..10,342.91 rows=259,412 width=572) (actual time=22.193..453.867 rows=259,412 loops=1)

  • Hash Cond: (("UAT EMI Central$Sales Invoice Line"."Posting Location")::text = (pl."Code")::text)
  • Buffers: shared hit=1 read=2,162
  • I/O Timings: read=248.284
94. 71.924 383.063 ↑ 1.0 259,412 1

Hash Left Join (cost=28.19..9,643.29 rows=259,412 width=564) (actual time=17.255..383.063 rows=259,412 loops=1)

  • Hash Cond: (("UAT EMI Central$Sales Invoice Line"."Article No_")::text = (ab."No_")::text)
  • Buffers: shared hit=1 read=2,161
  • I/O Timings: read=243.421
95. 23.157 293.965 ↑ 1.0 259,412 1

Append (cost=0.00..6,048.18 rows=259,412 width=28) (actual time=4.949..293.965 rows=259,412 loops=1)

  • Buffers: shared read=2,157
  • I/O Timings: read=231.611
96. 217.913 217.913 ↑ 1.0 229,105 1

Seq Scan on "UAT EMI Central$Sales Invoice Line" (cost=0.00..4,198.05 rows=229,105 width=28) (actual time=4.948..217.913 rows=229,105 loops=1)

  • Buffers: shared read=1,907
  • I/O Timings: read=183.897
97. 11.084 11.084 ↑ 1.0 5,339 1

Seq Scan on "UAT WAG BE$Sales Invoice Line" (cost=0.00..98.39 rows=5,339 width=29) (actual time=4.030..11.084 rows=5,339 loops=1)

  • Buffers: shared read=45
  • I/O Timings: read=10.095
98. 10.353 10.353 ↑ 1.0 4,302 1

Seq Scan on "UAT WAG ES$Sales Invoice Line" (cost=0.00..79.02 rows=4,302 width=29) (actual time=3.912..10.353 rows=4,302 loops=1)

  • Buffers: shared read=36
  • I/O Timings: read=9.440
99. 23.420 23.420 ↑ 1.0 18,588 1

Seq Scan on "UAT WAG FR$Sales Invoice Line" (cost=0.00..339.88 rows=18,588 width=29) (actual time=4.221..23.420 rows=18,588 loops=1)

  • Buffers: shared read=154
  • I/O Timings: read=20.617
100. 8.038 8.038 ↑ 1.0 2,078 1

Seq Scan on "UAT WAG CZ$Sales Invoice Line" (cost=0.00..35.78 rows=2,078 width=21) (actual time=3.945..8.038 rows=2,078 loops=1)

  • Buffers: shared read=15
  • I/O Timings: read=7.562
101. 0.663 17.174 ↑ 1.0 536 1

Hash (cost=21.49..21.49 rows=536 width=536) (actual time=12.293..17.174 rows=536 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 39kB
  • Buffers: shared hit=1 read=4
  • I/O Timings: read=11.810
102. 1.114 16.511 ↑ 1.0 536 1

Hash Left Join (cost=5.76..21.49 rows=536 width=536) (actual time=8.057..16.511 rows=536 loops=1)

  • Hash Cond: (ab."Transaction Type ID" = ac."ID")
  • Buffers: shared hit=1 read=4
  • I/O Timings: read=11.810
103. 8.199 8.199 ↑ 1.0 536 1

Seq Scan on "Article" ab (cost=0.00..8.36 rows=536 width=13) (actual time=3.945..8.199 rows=536 loops=1)

  • Buffers: shared read=3
  • I/O Timings: read=7.827
104. 0.547 7.198 ↑ 1.0 79 1

Hash (cost=4.78..4.78 rows=79 width=523) (actual time=4.098..7.198 rows=79 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=1 read=1
  • I/O Timings: read=3.983
105. 1.285 6.651 ↑ 1.0 79 1

Hash Left Join (cost=1.90..4.78 rows=79 width=523) (actual time=4.036..6.651 rows=79 loops=1)

  • Hash Cond: ((ac."NAV4 Business Area")::text = (sc.service)::text)
  • Buffers: shared hit=1 read=1
  • I/O Timings: read=3.983
106. 0.333 0.333 ↑ 1.0 79 1

Seq Scan on "Transaction Types" ac (cost=0.00..1.79 rows=79 width=7) (actual time=0.007..0.333 rows=79 loops=1)

  • Buffers: shared hit=1
107. 0.745 5.033 ↑ 1.0 40 1

Hash (cost=1.40..1.40 rows=40 width=1,032) (actual time=4.010..5.033 rows=40 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared read=1
  • I/O Timings: read=3.983
108. 4.288 4.288 ↑ 1.0 40 1

Seq Scan on service_category sc (cost=0.00..1.40 rows=40 width=1,032) (actual time=3.991..4.288 rows=40 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=3.983
109. 0.751 5.924 ↑ 1.0 144 1

Hash (cost=2.44..2.44 rows=144 width=8) (actual time=4.918..5.924 rows=144 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
  • Buffers: shared read=1
  • I/O Timings: read=4.863
110. 5.173 5.173 ↑ 1.0 144 1

Seq Scan on "Posting Location" pl (cost=0.00..2.44 rows=144 width=8) (actual time=4.872..5.173 rows=144 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=4.863
111. 0.812 28.933 ↓ 3.3 658 1

Hash (cost=169.97..169.97 rows=200 width=28) (actual time=20.664..28.933 rows=658 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 48kB
  • Buffers: shared hit=4 read=10
  • I/O Timings: read=19.972
112. 0.888 28.121 ↓ 3.3 658 1

Subquery Scan on adwsr (cost=165.97..169.97 rows=200 width=28) (actual time=20.411..28.121 rows=658 loops=1)

  • Buffers: shared hit=4 read=10
  • I/O Timings: read=19.972
113. 0.944 27.233 ↓ 3.3 658 1

HashAggregate (cost=165.97..167.97 rows=200 width=28) (actual time=20.409..27.233 rows=658 loops=1)

  • Group Key: "UAT EMI Central$WEB Documents ShowHide"."Document No_
  • Buffers: shared hit=4 read=10
  • I/O Timings: read=19.972
114. 2.184 26.289 ↑ 1.0 658 1

Append (cost=17.38..157.55 rows=674 width=14) (actual time=19.890..26.289 rows=658 loops=1)

  • Buffers: shared hit=4 read=10
  • I/O Timings: read=19.972
115. 8.178 20.987 ↑ 1.0 658 1

Bitmap Heap Scan on "UAT EMI Central$WEB Documents ShowHide" (cost=17.38..103.61 rows=658 width=13) (actual time=19.888..20.987 rows=658 loops=1)

  • Recheck Cond: ("Table ID" = 112)
  • Heap Blocks: exact=5
  • Buffers: shared read=10
  • I/O Timings: read=19.972
116. 12.809 12.809 ↑ 1.0 658 1

Bitmap Index Scan on "UAT EMI Central$WEB Documents ShowHide_pkey" (cost=0.00..17.22 rows=658 width=0) (actual time=12.438..12.809 rows=658 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Buffers: shared read=5
  • I/O Timings: read=12.373
117. 0.738 0.973 ↓ 0.0 0 1

Bitmap Heap Scan on "UAT WAG BE$WEB Documents ShowHide" (cost=4.18..12.64 rows=4 width=60) (actual time=0.004..0.973 rows=0 loops=1)

  • Recheck Cond: ("Table ID" = 112)
  • Buffers: shared hit=1
118. 0.235 0.235 ↓ 0.0 0 1

Bitmap Index Scan on "UAT WAG BE$WEB Documents ShowHide_pkey" (cost=0.00..4.18 rows=4 width=0) (actual time=0.004..0.235 rows=0 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Buffers: shared hit=1
119. 0.398 0.693 ↓ 0.0 0 1

Bitmap Heap Scan on "UAT WAG ES$WEB Documents ShowHide" (cost=4.18..12.64 rows=4 width=60) (actual time=0.006..0.693 rows=0 loops=1)

  • Recheck Cond: ("Table ID" = 112)
  • Buffers: shared hit=1
120. 0.295 0.295 ↓ 0.0 0 1

Bitmap Index Scan on "UAT WAG ES$WEB Documents ShowHide_pkey" (cost=0.00..4.18 rows=4 width=0) (actual time=0.005..0.295 rows=0 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Buffers: shared hit=1
121. 0.542 0.719 ↓ 0.0 0 1

Bitmap Heap Scan on "UAT WAG FR$WEB Documents ShowHide" (cost=4.18..12.64 rows=4 width=60) (actual time=0.004..0.719 rows=0 loops=1)

  • Recheck Cond: ("Table ID" = 112)
  • Buffers: shared hit=1
122. 0.177 0.177 ↓ 0.0 0 1

Bitmap Index Scan on "UAT WAG FR$WEB Documents ShowHide_pkey" (cost=0.00..4.18 rows=4 width=0) (actual time=0.002..0.177 rows=0 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Buffers: shared hit=1
123. 0.478 0.733 ↓ 0.0 0 1

Bitmap Heap Scan on "UAT WAG CZ$WEB Documents ShowHide" (cost=4.18..12.64 rows=4 width=60) (actual time=0.002..0.733 rows=0 loops=1)

  • Recheck Cond: ("Table ID" = 112)
  • Buffers: shared hit=1
124. 0.255 0.255 ↓ 0.0 0 1

Bitmap Index Scan on "UAT WAG CZ$WEB Documents ShowHide_pkey" (cost=0.00..4.18 rows=4 width=0) (actual time=0.001..0.255 rows=0 loops=1)

  • Index Cond: ("Table ID" = 112)
  • Buffers: shared hit=1
125. 432.827 10,308.492 ↓ 11,621.6 2,324,325 1

Hash (cost=149,924.74..149,924.74 rows=200 width=36) (actual time=10,303.385..10,308.492 rows=2,324,325 loops=1)

  • Buckets: 131,072 (originally 1024) Batches: 32 (originally 1) Memory Usage: 3,878kB
  • Buffers: shared read=38,135, temp written=7,749
  • I/O Timings: read=5,010.867
126. 262.069 9,875.665 ↓ 11,621.6 2,324,325 1

Subquery Scan on ahcle (cost=149,920.24..149,924.74 rows=200 width=36) (actual time=8,315.399..9,875.665 rows=2,324,325 loops=1)

  • Buffers: shared read=38,135
  • I/O Timings: read=5,010.867
127. 3,632.349 9,613.596 ↓ 11,621.6 2,324,325 1

HashAggregate (cost=149,920.24..149,922.74 rows=200 width=36) (actual time=8,315.398..9,613.596 rows=2,324,325 loops=1)

  • Group Key: "UAT EMI Central$Detailed Cust_ Ledg_ Entry"."Cust_ Ledger Entry No_
  • Buffers: shared read=38,135
  • I/O Timings: read=5,010.867
128. 379.266 5,981.247 ↓ 1.0 5,589,963 1

Append (cost=0.00..121,973.93 rows=5,589,262 width=10) (actual time=8.756..5,981.247 rows=5,589,963 loops=1)

  • Buffers: shared read=38,135
  • I/O Timings: read=5,010.867
129. 5,503.214 5,503.214 ↓ 1.0 5,509,880 1

Seq Scan on "UAT EMI Central$Detailed Cust_ Ledg_ Entry" (cost=0.00..92,669.79 rows=5,509,179 width=10) (actual time=8.756..5,503.214 rows=5,509,880 loops=1)

  • Buffers: shared read=37,578
  • I/O Timings: read=4,922.309
130. 24.984 24.984 ↑ 1.0 19,462 1

Seq Scan on "UAT WAG BE$Detailed Cust_ Ledg_ Entry" (cost=0.00..330.62 rows=19,462 width=10) (actual time=4.097..24.984 rows=19,462 loops=1)

  • Buffers: shared read=136
  • I/O Timings: read=22.462
131. 19.732 19.732 ↑ 1.0 14,954 1

Seq Scan on "UAT WAG ES$Detailed Cust_ Ledg_ Entry" (cost=0.00..253.54 rows=14,954 width=10) (actual time=3.727..19.732 rows=14,954 loops=1)

  • Buffers: shared read=104
  • I/O Timings: read=17.496
132. 49.535 49.535 ↑ 1.0 44,813 1

Seq Scan on "UAT WAG FR$Detailed Cust_ Ledg_ Entry" (cost=0.00..759.13 rows=44,813 width=10) (actual time=3.954..49.535 rows=44,813 loops=1)

  • Buffers: shared read=311
  • I/O Timings: read=44.234
133. 4.516 4.516 ↑ 1.0 854 1

Seq Scan on "UAT WAG CZ$Detailed Cust_ Ledg_ Entry" (cost=0.00..14.54 rows=854 width=9) (actual time=4.093..4.516 rows=854 loops=1)

  • Buffers: shared read=6
  • I/O Timings: read=4.366
134. 9,210,320.411 9,262,520.366 ↓ 8,165.8 1,633,157 67,058

Materialize (cost=2.05..331,479,748.76 rows=200 width=47) (actual time=0.007..138.127 rows=1,633,157 loops=67,058)

  • Buffers: shared hit=29,342,473 read=626,982, temp read=366,131,220 written=5,460
  • I/O Timings: read=31,339.728
135. 229.493 52,199.955 ↓ 8,165.8 1,633,157 1

Subquery Scan on ah1cle (cost=2.05..331,479,747.76 rows=200 width=47) (actual time=70.364..52,199.955 rows=1,633,157 loops=1)

  • Buffers: shared hit=29,342,473 read=626,982
  • I/O Timings: read=31,339.728
136. 2,101.965 51,970.462 ↓ 8,165.8 1,633,157 1

GroupAggregate (cost=2.05..331,479,745.76 rows=200 width=47) (actual time=70.363..51,970.462 rows=1,633,157 loops=1)

  • Group Key: "UAT EMI Central$Cust_ Ledger Entry_3"."Document No_
  • Buffers: shared hit=29,342,473 read=626,982
  • I/O Timings: read=31,339.728
137. 1,721.072 49,868.497 ↑ 11,556.2 5,652,365 1

Nested Loop (cost=2.05..4,879,043.25 rows=65,320,140,001 width=21) (actual time=40.275..49,868.497 rows=5,652,365 loops=1)

  • Buffers: shared hit=29,342,473 read=626,982
  • I/O Timings: read=31,339.728
138. 442.082 20,099.297 ↑ 1.0 2,337,344 1

Merge Append (cost=1.62..235,876.37 rows=2,337,344 width=19) (actual time=29.013..20,099.297 rows=2,337,344 loops=1)

  • Sort Key: "UAT EMI Central$Cust_ Ledger Entry_3"."Document No_
  • Buffers: shared hit=309,740 read=136,161
  • I/O Timings: read=18,812.518
139. 19,405.575 19,405.575 ↑ 1.0 2,288,785 1

Index Scan using "UAT_EMI_Central$Cust_Ledger_Entry_Document_No__IDX" on "UAT EMI Central$Cust_ Ledger Entry" "UAT EMI Central$Cust_ Ledger Entry_3" (cost=0.43..193,920.70 rows=2,288,785 width=19) (actual time=0.022..19,405.575 rows=2,288,785 loops=1)

  • Buffers: shared hit=309,074 read=135,175
  • I/O Timings: read=18,573.008
140. 98.222 98.222 ↑ 1.0 11,772 1

Index Scan using "UAT WAG BE$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG BE$Cust_ Ledger Entry" "UAT WAG BE$Cust_ Ledger Entry_3" (cost=0.29..851.92 rows=11,772 width=20) (actual time=6.780..98.222 rows=11,772 loops=1)

  • Buffers: shared hit=41 read=252
  • I/O Timings: read=95.284
141. 25.104 25.104 ↑ 1.0 9,038 1

Index Scan using "UAT WAG ES$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG ES$Cust_ Ledger Entry" "UAT WAG ES$Cust_ Ledger Entry_3" (cost=0.29..485.38 rows=9,038 width=20) (actual time=6.393..25.104 rows=9,038 loops=1)

  • Buffers: shared hit=34 read=174
  • I/O Timings: read=22.589
142. 115.445 115.445 ↑ 1.0 27,057 1

Index Scan using "UAT WAG FR$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG FR$Cust_ Ledger Entry" "UAT WAG FR$Cust_ Ledger Entry_3" (cost=0.29..1,730.06 rows=27,057 width=20) (actual time=7.023..115.445 rows=27,057 loops=1)

  • Buffers: shared hit=548 read=541
  • I/O Timings: read=109.085
143. 12.869 12.869 ↑ 1.0 692 1

Index Scan using "UAT_WAG_CZ$Cust_Ledger_Entry_Document_No__IDX" on "UAT WAG CZ$Cust_ Ledger Entry" "UAT WAG CZ$Cust_ Ledger Entry_3" (cost=0.28..65.81 rows=692 width=18) (actual time=8.791..12.869 rows=692 loops=1)

  • Buffers: shared hit=43 read=19
  • I/O Timings: read=12.552
144. 0.000 28,048.128 ↑ 5.0 2 2,337,344

Append (cost=0.43..1.89 rows=10 width=10) (actual time=0.006..0.012 rows=2 loops=2,337,344)

  • Buffers: shared hit=29,032,733 read=490,821
  • I/O Timings: read=12,527.210
145. 18,698.752 18,698.752 ↑ 1.5 2 2,337,344

Index Scan using "UAT_EMI_Central$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT EMI Central$Detailed Cust_ Ledg_ Entry" "UAT EMI Central$Detailed Cust_ Ledg_ Entry_1" (cost=0.43..0.58 rows=3 width=10) (actual time=0.006..0.008 rows=2 loops=2,337,344)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_3"."Entry No_")
  • Buffers: shared hit=10,234,416 read=488,664
  • I/O Timings: read=12,438.261
146. 2,337.344 2,337.344 ↓ 0.0 0 2,337,344

Index Scan using "UAT WAG BE$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG BE$Detailed Cust_ Ledg_ Entry" "UAT WAG BE$Detailed Cust_ Ledg_ Entry_1" (cost=0.29..0.32 rows=2 width=10) (actual time=0.001..0.001 rows=0 loops=2,337,344)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_3"."Entry No_")
  • Buffers: shared hit=4,699,933 read=499
  • I/O Timings: read=24.743
147. 2,337.344 2,337.344 ↓ 0.0 0 2,337,344

Index Scan using "UAT WAG ES$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG ES$Detailed Cust_ Ledg_ Entry" "UAT WAG ES$Detailed Cust_ Ledg_ Entry_1" (cost=0.29..0.32 rows=2 width=10) (actual time=0.001..0.001 rows=0 loops=2,337,344)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_3"."Entry No_")
  • Buffers: shared hit=4,698,405 read=541
  • I/O Timings: read=15.876
148. 2,337.344 2,337.344 ↓ 0.0 0 2,337,344

Index Scan using "UAT WAG FR$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG FR$Detailed Cust_ Ledg_ Entry" "UAT WAG FR$Detailed Cust_ Ledg_ Entry_1" (cost=0.29..0.33 rows=2 width=10) (actual time=0.001..0.001 rows=0 loops=2,337,344)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_3"."Entry No_")
  • Buffers: shared hit=4,723,532 read=1,080
  • I/O Timings: read=44.310
149. 2,337.344 2,337.344 ↓ 0.0 0 2,337,344

Index Scan using "UAT_WAG_CZ$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG CZ$Detailed Cust_ Ledg_ Entry" "UAT WAG CZ$Detailed Cust_ Ledg_ Entry_1" (cost=0.28..0.29 rows=1 width=9) (actual time=0.001..0.001 rows=0 loops=2,337,344)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_3"."Entry No_")
  • Buffers: shared hit=4,676,447 read=37
  • I/O Timings: read=4.020
150. 0.707 40.324 ↑ 1.2 2,379 1

Hash (cost=74.39..74.39 rows=2,759 width=30) (actual time=37.030..40.324 rows=2,379 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 146kB
  • Buffers: shared read=23
  • I/O Timings: read=36.189
151. 2.066 39.617 ↑ 1.2 2,379 1

Append (cost=0.00..74.39 rows=2,759 width=30) (actual time=9.026..39.617 rows=2,379 loops=1)

  • Buffers: shared read=23
  • I/O Timings: read=36.189
152. 18.515 18.515 ↑ 1.0 2,359 1

Seq Scan on "UAT EMI Central$Sales Cr_Memo Header" (cost=0.00..43.59 rows=2,359 width=16) (actual time=9.026..18.515 rows=2,359 loops=1)

  • Buffers: shared read=20
  • I/O Timings: read=18.063
153. 0.607 0.607 ↑ 1.0 11 1

Seq Scan on "UAT WAG BE$Sales Cr_Memo Header" (cost=0.00..1.11 rows=11 width=116) (actual time=0.374..0.607 rows=11 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=0.368
154. 9.626 9.626 ↑ 1.0 3 1

Seq Scan on "UAT WAG ES$Sales Cr_Memo Header" (cost=0.00..1.03 rows=3 width=116) (actual time=9.476..9.626 rows=3 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=9.471
155. 8.485 8.485 ↑ 1.0 6 1

Seq Scan on "UAT WAG FR$Sales Cr_Memo Header" (cost=0.00..1.06 rows=6 width=116) (actual time=8.297..8.485 rows=6 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=8.287
156. 0.318 0.318 ↓ 0.0 0 1

Seq Scan on "UAT WAG CZ$Sales Cr_Memo Header" (cost=0.00..13.80 rows=380 width=116) (actual time=0.004..0.318 rows=0 loops=1)

157. 0.002 12.829 ↓ 0.0 0 1

Delete on document d (cost=0.42..8.44 rows=1 width=6) (actual time=12.829..12.829 rows=0 loops=1)

  • Buffers: shared read=3
  • I/O Timings: read=12.801
158. 12.827 12.827 ↓ 0.0 0 1

Index Scan using document_uq on document d (cost=0.42..8.44 rows=1 width=6) (actual time=12.827..12.827 rows=0 loops=1)

  • Index Cond: ((number)::text = '1804001000001'::text)
  • Buffers: shared read=3
  • I/O Timings: read=12.801
159.          

SubPlan (for Hash Left Join)

160. 1,499.876 1,499.876 ↑ 1.0 1 65,212

Index Scan using "Limit_pkey" on "Limit" li (cost=0.29..8.30 rows=1 width=6) (actual time=0.022..0.023 rows=1 loops=65,212)

  • Index Cond: ("ID" = "UAT EMI Central$Cust_ Ledger Entry"."Limit ID")
  • Buffers: shared hit=195,776 read=181
  • I/O Timings: read=93.850
161. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=32) (never executed)

162. 261.115 1,566.690 ↑ 1.0 1 52,223

Aggregate (cost=5.11..5.12 rows=1 width=8) (actual time=0.030..0.030 rows=1 loops=52,223)

  • Buffers: shared hit=261,110 read=5
  • I/O Timings: read=0.668
163. 678.899 1,305.575 ↓ 0.0 0 52,223

Append (cost=0.00..5.10 rows=5 width=0) (actual time=0.025..0.025 rows=0 loops=52,223)

  • Buffers: shared hit=261,110 read=5
  • I/O Timings: read=0.668
164. 208.892 208.892 ↓ 0.0 0 52,223

Seq Scan on "UAT EMI Central$Billing Cycle Setup" (cost=0.00..1.01 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=52,223)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=52,222 read=1
  • I/O Timings: read=0.135
165. 104.446 104.446 ↓ 0.0 0 52,223

Seq Scan on "UAT WAG BE$Billing Cycle Setup" (cost=0.00..1.01 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=52,223)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=52,222 read=1
  • I/O Timings: read=0.113
166. 104.446 104.446 ↓ 0.0 0 52,223

Seq Scan on "UAT WAG ES$Billing Cycle Setup" (cost=0.00..1.01 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=52,223)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=52,222 read=1
  • I/O Timings: read=0.172
167. 104.446 104.446 ↓ 0.0 0 52,223

Seq Scan on "UAT WAG FR$Billing Cycle Setup" (cost=0.00..1.01 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=52,223)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=52,222 read=1
  • I/O Timings: read=0.124
168. 104.446 104.446 ↓ 0.0 0 52,223

Seq Scan on "UAT WAG CZ$Billing Cycle Setup" (cost=0.00..1.01 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=52,223)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=52,222 read=1
  • I/O Timings: read=0.124
169. 0.846 64.390 ↑ 1.0 1 94

Aggregate (cost=1,321.86..1,321.87 rows=1 width=32) (actual time=0.664..0.685 rows=1 loops=94)

  • Buffers: shared hit=3,014 read=15
  • I/O Timings: read=54.262
170. 0.680 63.544 ↑ 65,208.0 3 94

Nested Loop (cost=0.86..343.74 rows=195,624 width=10) (actual time=0.313..0.676 rows=3 loops=94)

  • Buffers: shared hit=3,014 read=15
  • I/O Timings: read=54.262
171. 1.222 58.468 ↑ 3.5 2 94

Append (cost=0.43..49.72 rows=7 width=4) (actual time=0.298..0.622 rows=2 loops=94)

  • Buffers: shared hit=1,117 read=11
  • I/O Timings: read=54.236
172. 27.918 27.918 ↑ 1.5 2 94

Index Only Scan using "UAT_EMI_Central$Cust_Ledger_Entry_Document_No1__IDX" on "UAT EMI Central$Cust_ Ledger Entry" "UAT EMI Central$Cust_ Ledger Entry_4" (cost=0.43..16.48 rows=3 width=4) (actual time=0.296..0.297 rows=2 loops=94)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 157
  • Buffers: shared hit=373 read=3
  • I/O Timings: read=26.794
173. 0.658 0.658 ↓ 0.0 0 94

Index Only Scan using "UAT WAG BE$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG BE$Cust_ Ledger Entry" "UAT WAG BE$Cust_ Ledger Entry_4" (cost=0.29..8.30 rows=1 width=4) (actual time=0.006..0.007 rows=0 loops=94)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=186 read=2
  • I/O Timings: read=0.161
174. 0.658 0.658 ↓ 0.0 0 94

Index Only Scan using "UAT WAG ES$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG ES$Cust_ Ledger Entry" "UAT WAG ES$Cust_ Ledger Entry_4" (cost=0.29..8.30 rows=1 width=4) (actual time=0.006..0.007 rows=0 loops=94)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=186 read=2
  • I/O Timings: read=0.175
175. 23.312 23.312 ↓ 0.0 0 94

Index Only Scan using "UAT WAG FR$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG FR$Cust_ Ledger Entry" "UAT WAG FR$Cust_ Ledger Entry_4" (cost=0.29..8.30 rows=1 width=4) (actual time=0.248..0.248 rows=0 loops=94)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=186 read=2
  • I/O Timings: read=22.873
176. 4.700 4.700 ↓ 0.0 0 94

Index Only Scan using "UAT_WAG_CZ$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG CZ$Cust_ Ledger Entry" "UAT WAG CZ$Cust_ Ledger Entry_4" (cost=0.28..8.29 rows=1 width=4) (actual time=0.050..0.050 rows=0 loops=94)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=186 read=2
  • I/O Timings: read=4.234
177. 1.256 4.396 ↑ 5.0 2 157

Append (cost=0.43..41.90 rows=10 width=14) (actual time=0.007..0.028 rows=2 loops=157)

  • Buffers: shared hit=1,897 read=4
  • I/O Timings: read=0.026
178. 1.256 1.256 ↑ 1.5 2 157

Index Scan using "UAT_EMI_Central$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT EMI Central$Detailed Cust_ Ledg_ Entry" "UAT EMI Central$Detailed Cust_ Ledg_ Entry_2" (cost=0.43..8.64 rows=3 width=14) (actual time=0.007..0.008 rows=2 loops=157)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_4"."Entry No_")
  • Buffers: shared hit=641 read=4
  • I/O Timings: read=0.026
179. 0.471 0.471 ↓ 0.0 0 157

Index Scan using "UAT WAG BE$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG BE$Detailed Cust_ Ledg_ Entry" "UAT WAG BE$Detailed Cust_ Ledg_ Entry_2" (cost=0.29..8.42 rows=2 width=14) (actual time=0.003..0.003 rows=0 loops=157)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_4"."Entry No_")
  • Buffers: shared hit=314
180. 0.471 0.471 ↓ 0.0 0 157

Index Scan using "UAT WAG ES$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG ES$Detailed Cust_ Ledg_ Entry" "UAT WAG ES$Detailed Cust_ Ledg_ Entry_2" (cost=0.29..10.02 rows=2 width=14) (actual time=0.003..0.003 rows=0 loops=157)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_4"."Entry No_")
  • Buffers: shared hit=314
181. 0.471 0.471 ↓ 0.0 0 157

Index Scan using "UAT WAG FR$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG FR$Detailed Cust_ Ledg_ Entry" "UAT WAG FR$Detailed Cust_ Ledg_ Entry_2" (cost=0.29..8.76 rows=2 width=14) (actual time=0.003..0.003 rows=0 loops=157)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_4"."Entry No_")
  • Buffers: shared hit=314
182. 0.471 0.471 ↓ 0.0 0 157

Index Scan using "UAT_WAG_CZ$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG CZ$Detailed Cust_ Ledg_ Entry" "UAT WAG CZ$Detailed Cust_ Ledg_ Entry_2" (cost=0.28..6.01 rows=1 width=13) (actual time=0.002..0.003 rows=0 loops=157)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_4"."Entry No_")
  • Buffers: shared hit=314
183. 602.676 2,946.416 ↑ 1.0 1 66,964

Aggregate (cost=44.24..44.25 rows=1 width=32) (actual time=0.044..0.044 rows=1 loops=66,964)

  • Buffers: shared hit=834,508 read=4,262
  • I/O Timings: read=38.465
184. 401.784 2,343.740 ↑ 5.0 2 66,964

Append (cost=0.43..44.19 rows=10 width=10) (actual time=0.012..0.035 rows=2 loops=66,964)

  • Buffers: shared hit=834,508 read=4,262
  • I/O Timings: read=38.465
185. 870.532 870.532 ↑ 1.5 2 66,964

Index Scan using "UAT_EMI_Central$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT EMI Central$Detailed Cust_ Ledg_ Entry" "UAT EMI Central$Detailed Cust_ Ledg_ Entry_3" (cost=0.43..8.64 rows=3 width=10) (actual time=0.010..0.013 rows=2 loops=66,964)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=293,791 read=4,097
  • I/O Timings: read=37.172
186. 334.820 334.820 ↓ 0.0 0 66,964

Index Scan using "UAT WAG BE$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG BE$Detailed Cust_ Ledg_ Entry" "UAT WAG BE$Detailed Cust_ Ledg_ Entry_3" (cost=0.29..8.42 rows=2 width=10) (actual time=0.005..0.005 rows=0 loops=66,964)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=135,896 read=50
  • I/O Timings: read=0.330
187. 267.856 267.856 ↓ 0.0 0 66,964

Index Scan using "UAT WAG ES$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG ES$Detailed Cust_ Ledg_ Entry" "UAT WAG ES$Detailed Cust_ Ledg_ Entry_3" (cost=0.29..10.02 rows=2 width=10) (actual time=0.004..0.004 rows=0 loops=66,964)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=134,881 read=28
  • I/O Timings: read=0.227
188. 267.856 267.856 ↓ 0.0 0 66,964

Index Scan using "UAT WAG FR$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG FR$Detailed Cust_ Ledg_ Entry" "UAT WAG FR$Detailed Cust_ Ledg_ Entry_3" (cost=0.29..8.76 rows=2 width=10) (actual time=0.004..0.004 rows=0 loops=66,964)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=135,547 read=83
  • I/O Timings: read=0.698
189. 200.892 200.892 ↓ 0.0 0 66,964

Index Scan using "UAT_WAG_CZ$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG CZ$Detailed Cust_ Ledg_ Entry" "UAT WAG CZ$Detailed Cust_ Ledg_ Entry_3" (cost=0.28..8.29 rows=1 width=9) (actual time=0.003..0.003 rows=0 loops=66,964)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=134,393 read=4
  • I/O Timings: read=0.038
190. 43.866 285.129 ↑ 1.0 1 21,933

Aggregate (cost=5.11..5.12 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=21,933)

  • Buffers: shared hit=109,665
191. 131.598 241.263 ↓ 0.0 0 21,933

Append (cost=0.00..5.10 rows=5 width=0) (actual time=0.011..0.011 rows=0 loops=21,933)

  • Buffers: shared hit=109,665
192. 21.933 21.933 ↓ 0.0 0 21,933

Seq Scan on "UAT EMI Central$Billing Cycle Setup" "UAT EMI Central$Billing Cycle Setup_1" (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=21,933)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=21,933
193. 21.933 21.933 ↓ 0.0 0 21,933

Seq Scan on "UAT WAG BE$Billing Cycle Setup" "UAT WAG BE$Billing Cycle Setup_1" (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=21,933)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=21,933
194. 21.933 21.933 ↓ 0.0 0 21,933

Seq Scan on "UAT WAG ES$Billing Cycle Setup" "UAT WAG ES$Billing Cycle Setup_1" (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=21,933)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=21,933
195. 21.933 21.933 ↓ 0.0 0 21,933

Seq Scan on "UAT WAG FR$Billing Cycle Setup" "UAT WAG FR$Billing Cycle Setup_1" (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=21,933)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=21,933
196. 21.933 21.933 ↓ 0.0 0 21,933

Seq Scan on "UAT WAG CZ$Billing Cycle Setup" "UAT WAG CZ$Billing Cycle Setup_1" (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=21,933)

  • Filter: ((("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Invoice Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=21,933
197. 0.474 5.688 ↑ 1.0 1 79

Aggregate (cost=832.80..832.81 rows=1 width=32) (actual time=0.044..0.072 rows=1 loops=79)

  • Buffers: shared hit=2,535
198. 0.626 5.214 ↑ 65,208.0 3 79

Nested Loop (cost=0.86..343.74 rows=195,624 width=6) (actual time=0.013..0.066 rows=3 loops=79)

  • Buffers: shared hit=2,535
199. 1.027 2.212 ↑ 3.5 2 79

Append (cost=0.43..49.72 rows=7 width=4) (actual time=0.005..0.028 rows=2 loops=79)

  • Buffers: shared hit=948
200. 0.395 0.395 ↑ 1.5 2 79

Index Only Scan using "UAT_EMI_Central$Cust_Ledger_Entry_Document_No1__IDX" on "UAT EMI Central$Cust_ Ledger Entry" "UAT EMI Central$Cust_ Ledger Entry_5" (cost=0.43..16.48 rows=3 width=4) (actual time=0.004..0.005 rows=2 loops=79)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 132
  • Buffers: shared hit=316
201. 0.237 0.237 ↓ 0.0 0 79

Index Only Scan using "UAT WAG BE$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG BE$Cust_ Ledger Entry" "UAT WAG BE$Cust_ Ledger Entry_5" (cost=0.29..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=79)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=158
202. 0.158 0.158 ↓ 0.0 0 79

Index Only Scan using "UAT WAG ES$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG ES$Cust_ Ledger Entry" "UAT WAG ES$Cust_ Ledger Entry_5" (cost=0.29..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=79)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=158
203. 0.237 0.237 ↓ 0.0 0 79

Index Only Scan using "UAT WAG FR$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG FR$Cust_ Ledger Entry" "UAT WAG FR$Cust_ Ledger Entry_5" (cost=0.29..8.30 rows=1 width=4) (actual time=0.002..0.003 rows=0 loops=79)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=158
204. 0.158 0.158 ↓ 0.0 0 79

Index Only Scan using "UAT_WAG_CZ$Cust_Ledger_Entry_Document_No1__IDX" on "UAT WAG CZ$Cust_ Ledger Entry" "UAT WAG CZ$Cust_ Ledger Entry_5" (cost=0.28..8.29 rows=1 width=4) (actual time=0.001..0.002 rows=0 loops=79)

  • Index Cond: ("Document No_" = ("UAT EMI Central$Sales Invoice Header"."No_")::text)
  • Heap Fetches: 0
  • Buffers: shared hit=158
205. 1.056 2.376 ↑ 5.0 2 132

Append (cost=0.43..41.90 rows=10 width=10) (actual time=0.003..0.018 rows=2 loops=132)

  • Buffers: shared hit=1,587
206. 0.396 0.396 ↑ 1.5 2 132

Index Scan using "UAT_EMI_Central$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT EMI Central$Detailed Cust_ Ledg_ Entry" "UAT EMI Central$Detailed Cust_ Ledg_ Entry_4" (cost=0.43..8.64 rows=3 width=10) (actual time=0.002..0.003 rows=2 loops=132)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_5"."Entry No_")
  • Buffers: shared hit=531
207. 0.264 0.264 ↓ 0.0 0 132

Index Scan using "UAT WAG BE$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG BE$Detailed Cust_ Ledg_ Entry" "UAT WAG BE$Detailed Cust_ Ledg_ Entry_4" (cost=0.29..8.42 rows=2 width=10) (actual time=0.001..0.002 rows=0 loops=132)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_5"."Entry No_")
  • Buffers: shared hit=264
208. 0.264 0.264 ↓ 0.0 0 132

Index Scan using "UAT WAG ES$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG ES$Detailed Cust_ Ledg_ Entry" "UAT WAG ES$Detailed Cust_ Ledg_ Entry_4" (cost=0.29..10.02 rows=2 width=10) (actual time=0.001..0.002 rows=0 loops=132)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_5"."Entry No_")
  • Buffers: shared hit=264
209. 0.264 0.264 ↓ 0.0 0 132

Index Scan using "UAT WAG FR$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG FR$Detailed Cust_ Ledg_ Entry" "UAT WAG FR$Detailed Cust_ Ledg_ Entry_4" (cost=0.29..8.76 rows=2 width=10) (actual time=0.001..0.002 rows=0 loops=132)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_5"."Entry No_")
  • Buffers: shared hit=264
210. 0.132 0.132 ↓ 0.0 0 132

Index Scan using "UAT_WAG_CZ$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG CZ$Detailed Cust_ Ledg_ Entry" "UAT WAG CZ$Detailed Cust_ Ledg_ Entry_4" (cost=0.28..6.01 rows=1 width=9) (actual time=0.001..0.001 rows=0 loops=132)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry_5"."Entry No_")
  • Buffers: shared hit=264
211. 142.024 568.096 ↑ 1.0 1 35,506

Aggregate (cost=44.22..44.23 rows=1 width=32) (actual time=0.016..0.016 rows=1 loops=35,506)

  • Buffers: shared hit=429,190
212. 177.530 426.072 ↑ 10.0 1 35,506

Append (cost=0.43..44.19 rows=10 width=6) (actual time=0.004..0.012 rows=1 loops=35,506)

  • Buffers: shared hit=429,190
213. 106.518 106.518 ↑ 3.0 1 35,506

Index Scan using "UAT_EMI_Central$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT EMI Central$Detailed Cust_ Ledg_ Entry" "UAT EMI Central$Detailed Cust_ Ledg_ Entry_5" (cost=0.43..8.64 rows=3 width=6) (actual time=0.002..0.003 rows=1 loops=35,506)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=142,936
214. 35.506 35.506 ↓ 0.0 0 35,506

Index Scan using "UAT WAG BE$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG BE$Detailed Cust_ Ledg_ Entry" "UAT WAG BE$Detailed Cust_ Ledg_ Entry_5" (cost=0.29..8.42 rows=2 width=6) (actual time=0.001..0.001 rows=0 loops=35,506)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=71,581
215. 35.506 35.506 ↓ 0.0 0 35,506

Index Scan using "UAT WAG ES$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG ES$Detailed Cust_ Ledg_ Entry" "UAT WAG ES$Detailed Cust_ Ledg_ Entry_5" (cost=0.29..10.02 rows=2 width=6) (actual time=0.001..0.001 rows=0 loops=35,506)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=71,518
216. 35.506 35.506 ↓ 0.0 0 35,506

Index Scan using "UAT WAG FR$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG FR$Detailed Cust_ Ledg_ Entry" "UAT WAG FR$Detailed Cust_ Ledg_ Entry_5" (cost=0.29..8.76 rows=2 width=6) (actual time=0.001..0.001 rows=0 loops=35,506)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=71,785
217. 35.506 35.506 ↓ 0.0 0 35,506

Index Scan using "UAT_WAG_CZ$Detailed_Cust_Ledg_Entry_Cust_Ledger_Entry_No__" on "UAT WAG CZ$Detailed Cust_ Ledg_ Entry" "UAT WAG CZ$Detailed Cust_ Ledg_ Entry_5" (cost=0.28..8.29 rows=1 width=5) (actual time=0.001..0.001 rows=0 loops=35,506)

  • Index Cond: ("Cust_ Ledger Entry No_" = "UAT EMI Central$Cust_ Ledger Entry"."Entry No_")
  • Buffers: shared hit=71,370
218. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=5.11..5.12 rows=1 width=8) (never executed)

219. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..5.10 rows=5 width=0) (never executed)

220. 0.000 0.000 ↓ 0.0 0

Seq Scan on "UAT EMI Central$Billing Cycle Setup" "UAT EMI Central$Billing Cycle Setup_2" (cost=0.00..1.01 rows=1 width=0) (never executed)

  • Filter: ((("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
221. 0.000 0.000 ↓ 0.0 0

Seq Scan on "UAT WAG BE$Billing Cycle Setup" "UAT WAG BE$Billing Cycle Setup_2" (cost=0.00..1.01 rows=1 width=0) (never executed)

  • Filter: ((("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
222. 0.000 0.000 ↓ 0.0 0

Seq Scan on "UAT WAG ES$Billing Cycle Setup" "UAT WAG ES$Billing Cycle Setup_2" (cost=0.00..1.01 rows=1 width=0) (never executed)

  • Filter: ((("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
223. 0.000 0.000 ↓ 0.0 0

Seq Scan on "UAT WAG FR$Billing Cycle Setup" "UAT WAG FR$Billing Cycle Setup_2" (cost=0.00..1.01 rows=1 width=0) (never executed)

  • Filter: ((("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))
224. 0.000 0.000 ↓ 0.0 0

Seq Scan on "UAT WAG CZ$Billing Cycle Setup" "UAT WAG CZ$Billing Cycle Setup_2" (cost=0.00..1.01 rows=1 width=0) (never executed)

  • Filter: ((("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI TRX Invoicing Group")::text) OR (("UAT EMI Central$Sales Cr_Memo Header"."Invoicing Group")::text = ("NI Cancel TRX Invoicing Group")::text))2020-09-11 13:06:36 UTC [1347]: [104-1] user=postgres,db=dih_uat,app=DBeaver 5.3.1 - Main,client=172.16.8.211 CONTEXT: PL/pgSQL function billing_calculator.get_all_sales_invoice16_documents() line 4 at RETURN QUERY