| # | exclusive | inclusive | rows x | rows | loops | node |
|---|---|---|---|---|---|---|
| 1. | 59.426 | 718.804 | ↓ 0.0 | 0 | 1 |
→
Merge Full Join (cost=19492.44..22481.36 rows=24155 width=0) (actual time=718.804..718.804 rows=0 loops=1)
|
| 2. | 44.488 | 346.780 | ↑ 1.1 | 22617 | 1 |
→
Sort (cost=10573.53..10634.22 rows=24276 width=64) (actual time=341.603..346.780 rows=22617 loops=1)
|
| 3. | 166.764 | 302.292 | ↑ 1.1 | 22617 | 1 |
→
Subquery Scan pmst (cost=6617.37..7891.86 rows=24276 width=64) (actual time=99.076..302.292 rows=22617 loops=1) |
| 4. | 27.143 | 135.528 | ↑ 1.1 | 22617 | 1 |
→
GroupAggregate (cost=6617.37..7649.10 rows=24276 width=64) (actual time=99.042..135.528 rows=22617 loops=1) |
| 5. | 52.703 | 108.385 | ↓ 1.0 | 24822 | 1 |
→
Sort (cost=6617.37..6678.06 rows=24276 width=64) (actual time=99.027..108.385 rows=24822 loops=1)
|
| 6. | 34.824 | 55.682 | ↓ 1.0 | 24822 | 1 |
→
Hash Join (cost=1487.75..3935.70 rows=24276 width=64) (actual time=13.528..55.682 rows=24822 loops=1)
|
| 7. | 7.369 | 7.369 | ↑ 1.0 | 37187 | 1 |
→
Seq Scan on pugyimozgassubtetel pmt (cost=0.00..1693.87 rows=37187 width=60) (actual time=0.011..7.369 rows=37187 loops=1) |
| 8. | 4.054 | 13.489 | ↓ 1.2 | 10534 | 1 |
→
Hash (cost=1373.85..1373.85 rows=9112 width=8) (actual time=13.489..13.489 rows=10534 loops=1) |
| 9. | 9.435 | 9.435 | ↓ 1.2 | 10534 | 1 |
→
Seq Scan on pugyimozgasfej pmf (cost=0.00..1373.85 rows=9112 width=8) (actual time=0.010..9.435 rows=10534 loops=1)
|
| 10. | 4.707 | 312.598 | ↓ 1.1 | 22617 | 1 |
→
Materialize (cost=8918.91..9168.96 rows=20004 width=64) (actual time=302.270..312.598 rows=22617 loops=1) |
| 11. | 44.874 | 307.891 | ↓ 1.1 | 22617 | 1 |
→
Sort (cost=8918.91..8968.92 rows=20004 width=64) (actual time=302.264..307.891 rows=22617 loops=1)
|
| 12. | 166.480 | 263.017 | ↓ 1.1 | 22617 | 1 |
→
Subquery Scan pu (cost=5687.12..6737.33 rows=20004 width=64) (actual time=62.871..263.017 rows=22617 loops=1) |
| 13. | 25.259 | 96.537 | ↓ 1.1 | 22617 | 1 |
→
GroupAggregate (cost=5687.12..6537.29 rows=20004 width=64) (actual time=62.836..96.537 rows=22617 loops=1) |
| 14. | 38.265 | 71.278 | ↓ 1.2 | 23104 | 1 |
→
Sort (cost=5687.12..5737.13 rows=20004 width=64) (actual time=62.821..71.278 rows=23104 loops=1)
|
| 15. | 20.779 | 33.013 | ↓ 1.2 | 23104 | 1 |
→
Hash Join (cost=1487.75..3505.53 rows=20004 width=64) (actual time=7.281..33.013 rows=23104 loops=1)
|
| 16. | 4.985 | 4.985 | ↑ 1.0 | 30642 | 1 |
→
Seq Scan on pugyimozgastetel pmt (cost=0.00..1396.42 rows=30642 width=60) (actual time=0.014..4.985 rows=30642 loops=1) |
| 17. | 2.029 | 7.249 | ↓ 1.2 | 10534 | 1 |
→
Hash (cost=1373.85..1373.85 rows=9112 width=8) (actual time=7.249..7.249 rows=10534 loops=1) |
| 18. | 5.220 | 5.220 | ↓ 1.2 | 10534 | 1 |
→
Seq Scan on pugyimozgasfej pmf (cost=0.00..1373.85 rows=9112 width=8) (actual time=0.011..5.220 rows=10534 loops=1)
|
" {MERGEJOIN "
" :startup_cost 19492.44 "
" :total_cost 22481.36 "
" :plan_rows 24155 "
" :plan_width 0 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {CONST "
" :consttype 23 "
" :consttypmod -1 "
" :constlen 4 "
" :constbyval true "
" :constisnull false "
" :constvalue 4 [ 0 0 0 0 ]"
" }"
" :resno 1 "
" :resname ?column? "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" )"
" :qual ("
" {OPEXPR "
" :opno 671 "
" :opfuncid 294 "
" :opresulttype 16 "
" :opretset false "
" :args ("
" {COALESCE "
" :coalescetype 701 "
" :args ("
" {VAR "
" :varno 65001 "
" :varattno 11 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 11"
" }"
" {CONST "
" :consttype 701 "
" :consttypmod -1 "
" :constlen 8 "
" :constbyval false "
" :constisnull false "
" :constvalue 8 [ 0 0 0 0 0 0 0 0 ]"
" }"
" )"
" }"
" {COALESCE "
" :coalescetype 701 "
" :args ("
" {VAR "
" :varno 65000 "
" :varattno 11 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 11"
" }"
" {CONST "
" :consttype 701 "
" :consttypmod -1 "
" :constlen 8 "
" :constbyval false "
" :constisnull false "
" :constvalue 8 [ 0 0 0 0 0 0 0 0 ]"
" }"
" )"
" }"
" )"
" }"
" )"
" :lefttree "
" {SORT "
" :startup_cost 10573.53 "
" :total_cost 10634.22 "
" :plan_rows 24276 "
" :plan_width 64 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 2"
" }"
" :resno 2 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 3"
" }"
" :resno 3 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 4 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 4"
" }"
" :resno 4 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 5 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 5"
" }"
" :resno 5 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 6 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 6"
" }"
" :resno 6 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 7 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 7"
" }"
" :resno 7 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 8 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 8"
" }"
" :resno 8 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 9 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 9"
" }"
" :resno 9 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 10 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 10"
" }"
" :resno 10 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 11 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 11"
" }"
" :resno 11 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 12 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 12 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 13 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 13 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 14 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 14 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 15 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 15 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 16 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 16 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 17 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 17 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 18 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 18 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" )"
" :qual <> "
" :lefttree "
" {SUBQUERYSCAN "
" :startup_cost 6617.37 "
" :total_cost 7891.86 "
" :plan_rows 24276 "
" :plan_width 64 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 1 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 1 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 2"
" }"
" :resno 2 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 1 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 3"
" }"
" :resno 3 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 1 "
" :varattno 4 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 4"
" }"
" :resno 4 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 1 "
" :varattno 5 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 5"
" }"
" :resno 5 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 1 "
" :varattno 6 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 6"
" }"
" :resno 6 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 1 "
" :varattno 7 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 7"
" }"
" :resno 7 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 1 "
" :varattno 8 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 8"
" }"
" :resno 8 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 1 "
" :varattno 9 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 9"
" }"
" :resno 9 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 1 "
" :varattno 10 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 10"
" }"
" :resno 10 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 1 "
" :varattno 11 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 11"
" }"
" :resno 11 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {COALESCE "
" :coalescetype 23 "
" :args ("
" {VAR "
" :varno 1 "
" :varattno 4 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 4"
" }"
" {CONST "
" :consttype 23 "
" :consttypmod -1 "
" :constlen 4 "
" :constbyval true "
" :constisnull false "
" :constvalue 4 [ 0 0 0 0 ]"
" }"
" )"
" }"
" :resno 12 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {COALESCE "
" :coalescetype 1700 "
" :args ("
" {FUNCEXPR "
" :funcid 1707 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 0 "
" :args ("
" {FUNCEXPR "
" :funcid 1743 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 1 "
" :args ("
" {VAR "
" :varno 1 "
" :varattno 5 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 5"
" }"
" )"
" }"
" {CONST "
" :consttype 23 "
" :consttypmod -1 "
" :constlen 4 "
" :constbyval true "
" :constisnull false "
" :constvalue 4 [ 4 0 0 0 ]"
" }"
" )"
" }"
" {CONST "
" :consttype 1700 "
" :consttypmod -1 "
" :constlen -1 "
" :constbyval false "
" :constisnull false "
" :constvalue 8 [ 32 0 0 0 0 0 0 0 ]"
" }"
" )"
" }"
" :resno 13 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {COALESCE "
" :coalescetype 1700 "
" :args ("
" {FUNCEXPR "
" :funcid 1707 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 0 "
" :args ("
" {FUNCEXPR "
" :funcid 1743 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 1 "
" :args ("
" {VAR "
" :varno 1 "
" :varattno 6 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 6"
" }"
" )"
" }"
" {CONST "
" :consttype 23 "
" :consttypmod -1 "
" :constlen 4 "
" :constbyval true "
" :constisnull false "
" :constvalue 4 [ 4 0 0 0 ]"
" }"
" )"
" }"
" {CONST "
" :consttype 1700 "
" :consttypmod -1 "
" :constlen -1 "
" :constbyval false "
" :constisnull false "
" :constvalue 8 [ 32 0 0 0 0 0 0 0 ]"
" }"
" )"
" }"
" :resno 14 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {COALESCE "
" :coalescetype 1700 "
" :args ("
" {FUNCEXPR "
" :funcid 1707 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 0 "
" :args ("
" {FUNCEXPR "
" :funcid 1743 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 1 "
" :args ("
" {VAR "
" :varno 1 "
" :varattno 7 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 7"
" }"
" )"
" }"
" {CONST "
" :consttype 23 "
" :consttypmod -1 "
" :constlen 4 "
" :constbyval true "
" :constisnull false "
" :constvalue 4 [ 4 0 0 0 ]"
" }"
" )"
" }"
" {CONST "
" :consttype 1700 "
" :consttypmod -1 "
" :constlen -1 "
" :constbyval false "
" :constisnull false "
" :constvalue 8 [ 32 0 0 0 0 0 0 0 ]"
" }"
" )"
" }"
" :resno 15 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {COALESCE "
" :coalescetype 23 "
" :args ("
" {VAR "
" :varno 1 "
" :varattno 8 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 8"
" }"
" {CONST "
" :consttype 23 "
" :consttypmod -1 "
" :constlen 4 "
" :constbyval true "
" :constisnull false "
" :constvalue 4 [ 0 0 0 0 ]"
" }"
" )"
" }"
" :resno 16 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {COALESCE "
" :coalescetype 1700 "
" :args ("
" {FUNCEXPR "
" :funcid 1707 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 0 "
" :args ("
" {FUNCEXPR "
" :funcid 1743 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 1 "
" :args ("
" {VAR "
" :varno 1 "
" :varattno 9 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 9"
" }"
" )"
" }"
" {CONST "
" :consttype 23 "
" :consttypmod -1 "
" :constlen 4 "
" :constbyval true "
" :constisnull false "
" :constvalue 4 [ 4 0 0 0 ]"
" }"
" )"
" }"
" {CONST "
" :consttype 1700 "
" :consttypmod -1 "
" :constlen -1 "
" :constbyval false "
" :constisnull false "
" :constvalue 8 [ 32 0 0 0 0 0 0 0 ]"
" }"
" )"
" }"
" :resno 17 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {COALESCE "
" :coalescetype 23 "
" :args ("
" {VAR "
" :varno 1 "
" :varattno 10 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 10"
" }"
" {CONST "
" :consttype 23 "
" :consttypmod -1 "
" :constlen 4 "
" :constbyval true "
" :constisnull false "
" :constvalue 4 [ 0 0 0 0 ]"
" }"
" )"
" }"
" :resno 18 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" )"
" :qual <> "
" :lefttree <> "
" :righttree <> "
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" :scanrelid 1 "
" :subplan "
" {AGG "
" :startup_cost 6617.37 "
" :total_cost 7649.10 "
" :plan_rows 24276 "
" :plan_width 64 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 4 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname pmfid "
" :ressortgroupref 1 "
" :resorigtbl 108958767 "
" :resorigcol 1 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 4"
" }"
" :resno 2 "
" :resname cikkid "
" :ressortgroupref 2 "
" :resorigtbl 108958778 "
" :resorigcol 4 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 4 "
" :varoattno 5"
" }"
" :resno 3 "
" :resname dokumentumtipusid "
" :ressortgroupref 0 "
" :resorigtbl 108958767 "
" :resorigcol 5 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 4 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 22"
" }"
" :resno 4 "
" :resname mennyegysegid "
" :ressortgroupref 4 "
" :resorigtbl 108958778 "
" :resorigcol 22 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 5 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 23"
" }"
" :resno 5 "
" :resname eladafakulcs "
" :ressortgroupref 5 "
" :resorigtbl 108958778 "
" :resorigcol 23 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 6 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 24"
" }"
" :resno 6 "
" :resname eladlistaar "
" :ressortgroupref 6 "
" :resorigtbl 108958778 "
" :resorigcol 24 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 7 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 25"
" }"
" :resno 7 "
" :resname eladlistaarelszdeviza "
" :ressortgroupref 7 "
" :resorigtbl 108958778 "
" :resorigcol 25 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 8 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 26"
" }"
" :resno 8 "
" :resname elszamolodevizaid "
" :ressortgroupref 8 "
" :resorigtbl 108958778 "
" :resorigcol 26 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 9 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 27"
" }"
" :resno 9 "
" :resname engedmeny "
" :ressortgroupref 9 "
" :resorigtbl 108958778 "
" :resorigcol 27 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 10 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 28"
" }"
" :resno 10 "
" :resname eladafakulcsid "
" :ressortgroupref 10 "
" :resorigtbl 108958778 "
" :resorigcol 28 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {AGGREF "
" :aggfnoid 2111 "
" :aggtype 701 "
" :args ("
" {VAR "
" :varno 65001 "
" :varattno 11 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 21"
" }"
" )"
" :agglevelsup 0 "
" :aggstar false "
" :aggdistinct false"
" }"
" :resno 11 "
" :resname mennyiseg "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 4 "
" :varoattno 5"
" }"
" :resno 12 "
" :resname <> "
" :ressortgroupref 3 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" )"
" :qual <> "
" :lefttree "
" {SORT "
" :startup_cost 6617.37 "
" :total_cost 6678.06 "
" :plan_rows 24276 "
" :plan_width 64 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 4 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 4"
" }"
" :resno 2 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 4 "
" :varoattno 5"
" }"
" :resno 3 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 4 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 22"
" }"
" :resno 4 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 5 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 23"
" }"
" :resno 5 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 6 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 24"
" }"
" :resno 6 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 7 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 25"
" }"
" :resno 7 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 8 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 26"
" }"
" :resno 8 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 9 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 27"
" }"
" :resno 9 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 10 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 28"
" }"
" :resno 10 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 11 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 21"
" }"
" :resno 11 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" )"
" :qual <> "
" :lefttree "
" {HASHJOIN "
" :startup_cost 1487.75 "
" :total_cost 3935.70 "
" :plan_rows 24276 "
" :plan_width 64 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65000 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 4 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 4 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 4"
" }"
" :resno 2 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65000 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 4 "
" :varoattno 5"
" }"
" :resno 3 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 22 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 22"
" }"
" :resno 4 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 23 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 23"
" }"
" :resno 5 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 24 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 24"
" }"
" :resno 6 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 25 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 25"
" }"
" :resno 7 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 26 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 26"
" }"
" :resno 8 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 27 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 27"
" }"
" :resno 9 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 28 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 28"
" }"
" :resno 10 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 21 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 21"
" }"
" :resno 11 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" )"
" :qual <> "
" :lefttree "
" {SEQSCAN "
" :startup_cost 0.00 "
" :total_cost 1693.87 "
" :plan_rows 37187 "
" :plan_width 60 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 2"
" }"
" :resno 2 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 3"
" }"
" :resno 3 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 4 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 4"
" }"
" :resno 4 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 5 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 5"
" }"
" :resno 5 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 6 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 6"
" }"
" :resno 6 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 7 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 7"
" }"
" :resno 7 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 8 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 8"
" }"
" :resno 8 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 9 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 9"
" }"
" :resno 9 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 10 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 10"
" }"
" :resno 10 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 11 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 11"
" }"
" :resno 11 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 12 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 12"
" }"
" :resno 12 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 13 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 13"
" }"
" :resno 13 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 14 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 14"
" }"
" :resno 14 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 15 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 15"
" }"
" :resno 15 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 16 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 16"
" }"
" :resno 16 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 17 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 17"
" }"
" :resno 17 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 18 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 18"
" }"
" :resno 18 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 19 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 19"
" }"
" :resno 19 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 20 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 20"
" }"
" :resno 20 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 21 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 21"
" }"
" :resno 21 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 22 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 22"
" }"
" :resno 22 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 23 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 23"
" }"
" :resno 23 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 24 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 24"
" }"
" :resno 24 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 25 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 25"
" }"
" :resno 25 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 26 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 26"
" }"
" :resno 26 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 27 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 27"
" }"
" :resno 27 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 28 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 28"
" }"
" :resno 28 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 29 "
" :vartype 1114 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 29"
" }"
" :resno 29 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 5 "
" :varattno 30 "
" :vartype 25 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 30"
" }"
" :resno 30 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" )"
" :qual <> "
" :lefttree <> "
" :righttree <> "
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" :scanrelid 5"
" }"
" :righttree "
" {HASH "
" :startup_cost 1373.85 "
" :total_cost 1373.85 "
" :plan_rows 9112 "
" :plan_width 8 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 4 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 4 "
" :varoattno 5"
" }"
" :resno 2 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" )"
" :qual <> "
" :lefttree "
" {SEQSCAN "
" :startup_cost 0.00 "
" :total_cost 1373.85 "
" :plan_rows 9112 "
" :plan_width 8 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 4 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 4 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 4 "
" :varattno 5 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 4 "
" :varoattno 5"
" }"
" :resno 2 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" )"
" :qual ("
" {SCALARARRAYOPEXPR "
" :opno 96 "
" :opfuncid 65 "
" :useOr true "
" :args ("
" {VAR "
" :varno 4 "
" :varattno 5 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 4 "
" :varoattno 5"
" }"
" {CONST "
" :consttype 1007 "
" :consttypmod -1 "
" :constlen -1 "
" :constbyval false "
" :constisnull false "
" :constvalue 80 [ 64 1 0 0 1 0 0 0 0 0 0 0 23 0 0"
" 0 14 0 0 0 1 0 0 0 36 0 0 0 39 0 0 0 7 0 0 0 9 "
" 0 0 0 38 0 0 0 63 0 0 0 59 0 0 0 50 0 0 0 51 0 0"
" 0 41 0 0 0 62 0 0 0 58 0 0 0 86 0 0 0 40 0 0 0 "
" ]"
" }"
" )"
" }"
" )"
" :lefttree <> "
" :righttree <> "
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" :scanrelid 4"
" }"
" :righttree <> "
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" }"
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" :jointype 0 "
" :joinqual <> "
" :hashclauses ("
" {OPEXPR "
" :opno 96 "
" :opfuncid 65 "
" :opresulttype 16 "
" :opretset false "
" :args ("
" {VAR "
" :varno 65001 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 5 "
" :varoattno 2"
" }"
" {VAR "
" :varno 65000 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 4 "
" :varoattno 1"
" }"
" )"
" }"
" )"
" }"
" :righttree <> "
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" :numCols 10 "
" :sortColIdx 1 2 3 4 5 6 7 8 9 10 "
" :sortOperators 97 97 97 97 672 672 672 97 672 97 "
" :nullsFirst false false false false false false false false fal"
" se false"
" }"
" :righttree <> "
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" :aggstrategy 1 "
" :numCols 10 "
" :grpColIdx 1 2 3 4 5 6 7 8 9 10 "
" :grpOperators 96 96 96 96 670 670 670 96 670 96 "
" :numGroups 24276"
" }"
" :subrtable <>"
" }"
" :righttree <> "
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" :numCols 10 "
" :sortColIdx 1 2 3 12 13 14 15 16 17 18 "
" :sortOperators 97 97 97 97 1754 1754 1754 97 1754 97 "
" :nullsFirst false false false false false false false false false false"
" }"
" :righttree "
" {MATERIAL "
" :startup_cost 8918.91 "
" :total_cost 9168.96 "
" :plan_rows 20004 "
" :plan_width 64 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 2"
" }"
" :resno 2 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 3"
" }"
" :resno 3 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 4 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 4"
" }"
" :resno 4 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 5 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 5"
" }"
" :resno 5 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 6 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 6"
" }"
" :resno 6 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 7 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 7"
" }"
" :resno 7 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 8 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 8"
" }"
" :resno 8 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 9 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 9"
" }"
" :resno 9 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 10 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 10"
" }"
" :resno 10 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 11 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 11"
" }"
" :resno 11 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 12 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 12 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 13 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 13 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 14 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 14 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 15 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 15 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 16 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 16 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 17 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 17 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 18 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 18 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" )"
" :qual <> "
" :lefttree "
" {SORT "
" :startup_cost 8918.91 "
" :total_cost 8968.92 "
" :plan_rows 20004 "
" :plan_width 64 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 2"
" }"
" :resno 2 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 3"
" }"
" :resno 3 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 4 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 4"
" }"
" :resno 4 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 5 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 5"
" }"
" :resno 5 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 6 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 6"
" }"
" :resno 6 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 7 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 7"
" }"
" :resno 7 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 8 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 8"
" }"
" :resno 8 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 9 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 9"
" }"
" :resno 9 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 10 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 10"
" }"
" :resno 10 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 11 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 11"
" }"
" :resno 11 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 12 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 12 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 13 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 13 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 14 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 14 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 15 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 15 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 16 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 16 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 17 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 17 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 18 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" :resno 18 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" )"
" :qual <> "
" :lefttree "
" {SUBQUERYSCAN "
" :startup_cost 5687.12 "
" :total_cost 6737.33 "
" :plan_rows 20004 "
" :plan_width 64 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 2 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 2 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 2"
" }"
" :resno 2 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 2 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 3"
" }"
" :resno 3 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 2 "
" :varattno 4 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 4"
" }"
" :resno 4 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 2 "
" :varattno 5 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 5"
" }"
" :resno 5 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 2 "
" :varattno 6 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 6"
" }"
" :resno 6 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 2 "
" :varattno 7 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 7"
" }"
" :resno 7 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 2 "
" :varattno 8 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 8"
" }"
" :resno 8 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 2 "
" :varattno 9 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 9"
" }"
" :resno 9 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 2 "
" :varattno 10 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 10"
" }"
" :resno 10 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 2 "
" :varattno 11 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 11"
" }"
" :resno 11 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {COALESCE "
" :coalescetype 23 "
" :args ("
" {VAR "
" :varno 2 "
" :varattno 4 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 4"
" }"
" {CONST "
" :consttype 23 "
" :consttypmod -1 "
" :constlen 4 "
" :constbyval true "
" :constisnull false "
" :constvalue 4 [ 0 0 0 0 ]"
" }"
" )"
" }"
" :resno 12 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {COALESCE "
" :coalescetype 1700 "
" :args ("
" {FUNCEXPR "
" :funcid 1707 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 0 "
" :args ("
" {FUNCEXPR "
" :funcid 1743 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 1 "
" :args ("
" {VAR "
" :varno 2 "
" :varattno 5 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 5"
" }"
" )"
" }"
" {CONST "
" :consttype 23 "
" :consttypmod -1 "
" :constlen 4 "
" :constbyval true "
" :constisnull false "
" :constvalue 4 [ 4 0 0 0 ]"
" }"
" )"
" }"
" {CONST "
" :consttype 1700 "
" :consttypmod -1 "
" :constlen -1 "
" :constbyval false "
" :constisnull false "
" :constvalue 8 [ 32 0 0 0 0 0 0 0 ]"
" }"
" )"
" }"
" :resno 13 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {COALESCE "
" :coalescetype 1700 "
" :args ("
" {FUNCEXPR "
" :funcid 1707 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 0 "
" :args ("
" {FUNCEXPR "
" :funcid 1743 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 1 "
" :args ("
" {VAR "
" :varno 2 "
" :varattno 6 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 6"
" }"
" )"
" }"
" {CONST "
" :consttype 23 "
" :consttypmod -1 "
" :constlen 4 "
" :constbyval true "
" :constisnull false "
" :constvalue 4 [ 4 0 0 0 ]"
" }"
" )"
" }"
" {CONST "
" :consttype 1700 "
" :consttypmod -1 "
" :constlen -1 "
" :constbyval false "
" :constisnull false "
" :constvalue 8 [ 32 0 0 0 0 0 0 0 ]"
" }"
" )"
" }"
" :resno 14 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {COALESCE "
" :coalescetype 1700 "
" :args ("
" {FUNCEXPR "
" :funcid 1707 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 0 "
" :args ("
" {FUNCEXPR "
" :funcid 1743 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 1 "
" :args ("
" {VAR "
" :varno 2 "
" :varattno 7 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 7"
" }"
" )"
" }"
" {CONST "
" :consttype 23 "
" :consttypmod -1 "
" :constlen 4 "
" :constbyval true "
" :constisnull false "
" :constvalue 4 [ 4 0 0 0 ]"
" }"
" )"
" }"
" {CONST "
" :consttype 1700 "
" :consttypmod -1 "
" :constlen -1 "
" :constbyval false "
" :constisnull false "
" :constvalue 8 [ 32 0 0 0 0 0 0 0 ]"
" }"
" )"
" }"
" :resno 15 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {COALESCE "
" :coalescetype 23 "
" :args ("
" {VAR "
" :varno 2 "
" :varattno 8 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 8"
" }"
" {CONST "
" :consttype 23 "
" :consttypmod -1 "
" :constlen 4 "
" :constbyval true "
" :constisnull false "
" :constvalue 4 [ 0 0 0 0 ]"
" }"
" )"
" }"
" :resno 16 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {COALESCE "
" :coalescetype 1700 "
" :args ("
" {FUNCEXPR "
" :funcid 1707 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 0 "
" :args ("
" {FUNCEXPR "
" :funcid 1743 "
" :funcresulttype 1700 "
" :funcretset false "
" :funcformat 1 "
" :args ("
" {VAR "
" :varno 2 "
" :varattno 9 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 9"
" }"
" )"
" }"
" {CONST "
" :consttype 23 "
" :consttypmod -1 "
" :constlen 4 "
" :constbyval true "
" :constisnull false "
" :constvalue 4 [ 4 0 0 0 ]"
" }"
" )"
" }"
" {CONST "
" :consttype 1700 "
" :consttypmod -1 "
" :constlen -1 "
" :constbyval false "
" :constisnull false "
" :constvalue 8 [ 32 0 0 0 0 0 0 0 ]"
" }"
" )"
" }"
" :resno 17 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" {TARGETENTRY "
" :expr "
" {COALESCE "
" :coalescetype 23 "
" :args ("
" {VAR "
" :varno 2 "
" :varattno 10 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 10"
" }"
" {CONST "
" :consttype 23 "
" :consttypmod -1 "
" :constlen 4 "
" :constbyval true "
" :constisnull false "
" :constvalue 4 [ 0 0 0 0 ]"
" }"
" )"
" }"
" :resno 18 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" )"
" :qual <> "
" :lefttree <> "
" :righttree <> "
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" :scanrelid 2 "
" :subplan "
" {AGG "
" :startup_cost 5687.12 "
" :total_cost 6537.29 "
" :plan_rows 20004 "
" :plan_width 64 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 7 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname pmfid "
" :ressortgroupref 1 "
" :resorigtbl 108958767 "
" :resorigcol 1 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 3"
" }"
" :resno 2 "
" :resname cikkid "
" :ressortgroupref 2 "
" :resorigtbl 108958792 "
" :resorigcol 3 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 7 "
" :varoattno 5"
" }"
" :resno 3 "
" :resname dokumentumtipusid "
" :ressortgroupref 0 "
" :resorigtbl 108958767 "
" :resorigcol 5 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 4 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 19"
" }"
" :resno 4 "
" :resname mennyegysegid "
" :ressortgroupref 4 "
" :resorigtbl 108958792 "
" :resorigcol 19 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 5 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 20"
" }"
" :resno 5 "
" :resname eladafakulcs "
" :ressortgroupref 5 "
" :resorigtbl 108958792 "
" :resorigcol 20 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 6 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 21"
" }"
" :resno 6 "
" :resname eladlistaar "
" :ressortgroupref 6 "
" :resorigtbl 108958792 "
" :resorigcol 21 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 7 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 22"
" }"
" :resno 7 "
" :resname eladlistaarelszdeviza "
" :ressortgroupref 7 "
" :resorigtbl 108958792 "
" :resorigcol 22 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 8 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 23"
" }"
" :resno 8 "
" :resname elszamolodevizaid "
" :ressortgroupref 8 "
" :resorigtbl 108958792 "
" :resorigcol 23 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 9 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 24"
" }"
" :resno 9 "
" :resname engedmeny "
" :ressortgroupref 9 "
" :resorigtbl 108958792 "
" :resorigcol 24 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 10 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 25"
" }"
" :resno 10 "
" :resname eladafakulcsid "
" :ressortgroupref 10 "
" :resorigtbl 108958792 "
" :resorigcol 25 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {AGGREF "
" :aggfnoid 2111 "
" :aggtype 701 "
" :args ("
" {VAR "
" :varno 65001 "
" :varattno 11 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 18"
" }"
" )"
" :agglevelsup 0 "
" :aggstar false "
" :aggdistinct false"
" }"
" :resno 11 "
" :resname mennyiseg "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 7 "
" :varoattno 5"
" }"
" :resno 12 "
" :resname <> "
" :ressortgroupref 3 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk true"
" }"
" )"
" :qual <> "
" :lefttree "
" {SORT "
" :startup_cost 5687.12 "
" :total_cost 5737.13 "
" :plan_rows 20004 "
" :plan_width 64 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 7 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 3"
" }"
" :resno 2 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 7 "
" :varoattno 5"
" }"
" :resno 3 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 4 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 19"
" }"
" :resno 4 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 5 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 20"
" }"
" :resno 5 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 6 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 21"
" }"
" :resno 6 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 7 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 22"
" }"
" :resno 7 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 8 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 23"
" }"
" :resno 8 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 9 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 24"
" }"
" :resno 9 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 10 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 25"
" }"
" :resno 10 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 11 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 18"
" }"
" :resno 11 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" )"
" :qual <> "
" :lefttree "
" {HASHJOIN "
" :startup_cost 1487.75 "
" :total_cost 3505.53 "
" :plan_rows 20004 "
" :plan_width 64 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65000 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 7 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 3"
" }"
" :resno 2 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65000 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 7 "
" :varoattno 5"
" }"
" :resno 3 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 19 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 19"
" }"
" :resno 4 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 20 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 20"
" }"
" :resno 5 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 21 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 21"
" }"
" :resno 6 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 22 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 22"
" }"
" :resno 7 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 23 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 23"
" }"
" :resno 8 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 24 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 24"
" }"
" :resno 9 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 25 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 25"
" }"
" :resno 10 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 18 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 18"
" }"
" :resno 11 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" )"
" :qual <> "
" :lefttree "
" {SEQSCAN "
" :startup_cost 0.00 "
" :total_cost 1396.42 "
" :plan_rows 30642 "
" :plan_width 60 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 2"
" }"
" :resno 2 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 3"
" }"
" :resno 3 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 4 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 4"
" }"
" :resno 4 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 5 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 5"
" }"
" :resno 5 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 6 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 6"
" }"
" :resno 6 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 7 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 7"
" }"
" :resno 7 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 8 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 8"
" }"
" :resno 8 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 9 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 9"
" }"
" :resno 9 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 10 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 10"
" }"
" :resno 10 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 11 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 11"
" }"
" :resno 11 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 12 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 12"
" }"
" :resno 12 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 13 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 13"
" }"
" :resno 13 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 14 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 14"
" }"
" :resno 14 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 15 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 15"
" }"
" :resno 15 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 16 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 16"
" }"
" :resno 16 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 17 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 17"
" }"
" :resno 17 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 18 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 18"
" }"
" :resno 18 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 19 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 19"
" }"
" :resno 19 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 20 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 20"
" }"
" :resno 20 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 21 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 21"
" }"
" :resno 21 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 22 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 22"
" }"
" :resno 22 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 23 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 23"
" }"
" :resno 23 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 24 "
" :vartype 701 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 24"
" }"
" :resno 24 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 25 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 25"
" }"
" :resno 25 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 26 "
" :vartype 1114 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 26"
" }"
" :resno 26 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 27 "
" :vartype 25 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 27"
" }"
" :resno 27 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 8 "
" :varattno 28 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 28"
" }"
" :resno 28 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" )"
" :qual <> "
" :lefttree <> "
" :righttree <> "
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" :scanrelid 8"
" }"
" :righttree "
" {HASH "
" :startup_cost 1373.85 "
" :total_cost 1373.85 "
" :plan_rows 9112 "
" :plan_width 8 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 7 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 65001 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 7 "
" :varoattno 5"
" }"
" :resno 2 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" )"
" :qual <> "
" :lefttree "
" {SEQSCAN "
" :startup_cost 0.00 "
" :total_cost 1373.85 "
" :plan_rows 9112 "
" :plan_width 8 "
" :targetlist ("
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 7 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 7 "
" :varoattno 1"
" }"
" :resno 1 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" {TARGETENTRY "
" :expr "
" {VAR "
" :varno 7 "
" :varattno 5 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 7 "
" :varoattno 5"
" }"
" :resno 2 "
" :resname <> "
" :ressortgroupref 0 "
" :resorigtbl 0 "
" :resorigcol 0 "
" :resjunk false"
" }"
" )"
" :qual ("
" {SCALARARRAYOPEXPR "
" :opno 96 "
" :opfuncid 65 "
" :useOr true "
" :args ("
" {VAR "
" :varno 7 "
" :varattno 5 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 7 "
" :varoattno 5"
" }"
" {CONST "
" :consttype 1007 "
" :consttypmod -1 "
" :constlen -1 "
" :constbyval false "
" :constisnull false "
" :constvalue 80 [ 64 1 0 0 1 0 0 0 0 0 0 0 23 "
" 0 0 0 14 0 0 0 1 0 0 0 36 0 0 0 39 0 0 0 7 0 "
" 0 0 9 0 0 0 38 0 0 0 63 0 0 0 59 0 0 0 50 0 0"
" 0 51 0 0 0 41 0 0 0 62 0 0 0 58 0 0 0 86 0 0"
" 0 40 0 0 0 ]"
" }"
" )"
" }"
" )"
" :lefttree <> "
" :righttree <> "
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" :scanrelid 7"
" }"
" :righttree <> "
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" }"
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" :jointype 0 "
" :joinqual <> "
" :hashclauses ("
" {OPEXPR "
" :opno 96 "
" :opfuncid 65 "
" :opresulttype 16 "
" :opretset false "
" :args ("
" {VAR "
" :varno 65001 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 8 "
" :varoattno 2"
" }"
" {VAR "
" :varno 65000 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 7 "
" :varoattno 1"
" }"
" )"
" }"
" )"
" }"
" :righttree <> "
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" :numCols 10 "
" :sortColIdx 1 2 3 4 5 6 7 8 9 10 "
" :sortOperators 97 97 97 97 672 672 672 97 672 97 "
" :nullsFirst false false false false false false false false "
" false false"
" }"
" :righttree <> "
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" :aggstrategy 1 "
" :numCols 10 "
" :grpColIdx 1 2 3 4 5 6 7 8 9 10 "
" :grpOperators 96 96 96 96 670 670 670 96 670 96 "
" :numGroups 20004"
" }"
" :subrtable <>"
" }"
" :righttree <> "
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" :numCols 10 "
" :sortColIdx 1 2 3 12 13 14 15 16 17 18 "
" :sortOperators 97 97 97 97 1754 1754 1754 97 1754 97 "
" :nullsFirst false false false false false false false false false fal"
" se"
" }"
" :righttree <> "
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" }"
" :initPlan <> "
" :extParam (b)"
" :allParam (b)"
" :jointype 2 "
" :joinqual <> "
" :mergeclauses ("
" {OPEXPR "
" :opno 96 "
" :opfuncid 65 "
" :opresulttype 16 "
" :opretset false "
" :args ("
" {VAR "
" :varno 65001 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 1"
" }"
" {VAR "
" :varno 65000 "
" :varattno 1 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 1"
" }"
" )"
" }"
" {OPEXPR "
" :opno 96 "
" :opfuncid 65 "
" :opresulttype 16 "
" :opretset false "
" :args ("
" {VAR "
" :varno 65001 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 2"
" }"
" {VAR "
" :varno 65000 "
" :varattno 2 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 2"
" }"
" )"
" }"
" {OPEXPR "
" :opno 96 "
" :opfuncid 65 "
" :opresulttype 16 "
" :opretset false "
" :args ("
" {VAR "
" :varno 65001 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 1 "
" :varoattno 3"
" }"
" {VAR "
" :varno 65000 "
" :varattno 3 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 2 "
" :varoattno 3"
" }"
" )"
" }"
" {OPEXPR "
" :opno 96 "
" :opfuncid 65 "
" :opresulttype 16 "
" :opretset false "
" :args ("
" {VAR "
" :varno 65001 "
" :varattno 12 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" {VAR "
" :varno 65000 "
" :varattno 12 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" )"
" }"
" {OPEXPR "
" :opno 1752 "
" :opfuncid 1718 "
" :opresulttype 16 "
" :opretset false "
" :args ("
" {VAR "
" :varno 65001 "
" :varattno 13 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" {VAR "
" :varno 65000 "
" :varattno 13 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" )"
" }"
" {OPEXPR "
" :opno 1752 "
" :opfuncid 1718 "
" :opresulttype 16 "
" :opretset false "
" :args ("
" {VAR "
" :varno 65001 "
" :varattno 14 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" {VAR "
" :varno 65000 "
" :varattno 14 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" )"
" }"
" {OPEXPR "
" :opno 1752 "
" :opfuncid 1718 "
" :opresulttype 16 "
" :opretset false "
" :args ("
" {VAR "
" :varno 65001 "
" :varattno 15 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" {VAR "
" :varno 65000 "
" :varattno 15 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" )"
" }"
" {OPEXPR "
" :opno 96 "
" :opfuncid 65 "
" :opresulttype 16 "
" :opretset false "
" :args ("
" {VAR "
" :varno 65001 "
" :varattno 16 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" {VAR "
" :varno 65000 "
" :varattno 16 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" )"
" }"
" {OPEXPR "
" :opno 1752 "
" :opfuncid 1718 "
" :opresulttype 16 "
" :opretset false "
" :args ("
" {VAR "
" :varno 65001 "
" :varattno 17 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" {VAR "
" :varno 65000 "
" :varattno 17 "
" :vartype 1700 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" )"
" }"
" {OPEXPR "
" :opno 96 "
" :opfuncid 65 "
" :opresulttype 16 "
" :opretset false "
" :args ("
" {VAR "
" :varno 65001 "
" :varattno 18 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" {VAR "
" :varno 65000 "
" :varattno 18 "
" :vartype 23 "
" :vartypmod -1 "
" :varlevelsup 0 "
" :varnoold 0 "
" :varoattno 0"
" }"
" )"
" }"
" )"
" :mergeFamilies 1976 1976 1976 1976 1988 1988 1988 1976 1988 1976 "
" :mergeStrategies 1 1 1 1 1 1 1 1 1 1 "
" :mergeNullsFirst 0 0 0 0 0 0 0 0 0 0"
" }"
""
"Merge Full Join (cost=19492.44..22481.36 rows=24155 width=0) (actual time=718.804..718.804 rows=0 loops=1)"
" Merge Cond: ((pmst.pmfid = pu.pmfid) AND (pmst.cikkid = pu.cikkid) AND (pmst.dokumentumtipusid = pu.dokumentumtipusid) AND ((COALESCE(pmst.mennyegysegid, 0)) = (COALESCE(pu.mennyegysegid, 0))) AND ((COALESCE(round((pmst.eladafakulcs)::numeric, 4), 0::numeric)) = (COALESCE(round((pu.eladafakulcs)::numeric, 4), 0::numeric))) AND ((COALESCE(round((pmst.eladlistaar)::numeric, 4), 0::numeric)) = (COALESCE(round((pu.eladlistaar)::numeric, 4), 0::numeric))) AND ((COALESCE(round((pmst.eladlistaarelszdeviza)::numeric, 4), 0::numeric)) = (COALESCE(round((pu.eladlistaarelszdeviza)::numeric, 4), 0::numeric))) AND ((COALESCE(pmst.elszamolodevizaid, 0)) = (COALESCE(pu.elszamolodevizaid, 0))) AND ((COALESCE(round((pmst.engedmeny)::numeric, 4), 0::numeric)) = (COALESCE(round((pu.engedmeny)::numeric, 4), 0::numeric))) AND ((COALESCE(pmst.eladafakulcsid, 0)) = (COALESCE(pu.eladafakulcsid, 0))))"
" Filter: (COALESCE(pmst.mennyiseg, 0::double precision) <> COALESCE(pu.mennyiseg, 0::double precision))"
" -> Sort (cost=10573.53..10634.22 rows=24276 width=64) (actual time=341.603..346.780 rows=22617 loops=1)"
" Sort Key: pmst.pmfid, pmst.cikkid, pmst.dokumentumtipusid, (COALESCE(pmst.mennyegysegid, 0)), (COALESCE(round((pmst.eladafakulcs)::numeric, 4), 0::numeric)), (COALESCE(round((pmst.eladlistaar)::numeric, 4), 0::numeric)), (COALESCE(round((pmst.eladlistaarelszdeviza)::numeric, 4), 0::numeric)), (COALESCE(pmst.elszamolodevizaid, 0)), (COALESCE(round((pmst.engedmeny)::numeric, 4), 0::numeric)), (COALESCE(pmst.eladafakulcsid, 0))"
" Sort Method: external sort Disk: 2928kB"
" -> Subquery Scan pmst (cost=6617.37..7891.86 rows=24276 width=64) (actual time=99.076..302.292 rows=22617 loops=1)"
" -> GroupAggregate (cost=6617.37..7649.10 rows=24276 width=64) (actual time=99.042..135.528 rows=22617 loops=1)"
" -> Sort (cost=6617.37..6678.06 rows=24276 width=64) (actual time=99.027..108.385 rows=24822 loops=1)"
" Sort Key: pmf.id, pmt.cikkid, pmf.dokumentumtipusid, pmt.mennyegysegid, pmt.eladafakulcs, pmt.eladlistaar, pmt.eladlistaarelszdeviza, pmt.elszamolodevizaid, pmt.engedmeny, pmt.eladafakulcsid"
" Sort Method: external merge Disk: 2128kB"
" -> Hash Join (cost=1487.75..3935.70 rows=24276 width=64) (actual time=13.528..55.682 rows=24822 loops=1)"
" Hash Cond: (pmt.pugyimozgasfejid = pmf.id)"
" -> Seq Scan on pugyimozgassubtetel pmt (cost=0.00..1693.87 rows=37187 width=60) (actual time=0.011..7.369 rows=37187 loops=1)"
" -> Hash (cost=1373.85..1373.85 rows=9112 width=8) (actual time=13.489..13.489 rows=10534 loops=1)"
" -> Seq Scan on pugyimozgasfej pmf (cost=0.00..1373.85 rows=9112 width=8) (actual time=0.010..9.435 rows=10534 loops=1)"
" Filter: (dokumentumtipusid = ANY ('{36,39,7,9,38,63,59,50,51,41,62,58,86,40}'::integer[]))"
" -> Materialize (cost=8918.91..9168.96 rows=20004 width=64) (actual time=302.270..312.598 rows=22617 loops=1)"
" -> Sort (cost=8918.91..8968.92 rows=20004 width=64) (actual time=302.264..307.891 rows=22617 loops=1)"
" Sort Key: pu.pmfid, pu.cikkid, pu.dokumentumtipusid, (COALESCE(pu.mennyegysegid, 0)), (COALESCE(round((pu.eladafakulcs)::numeric, 4), 0::numeric)), (COALESCE(round((pu.eladlistaar)::numeric, 4), 0::numeric)), (COALESCE(round((pu.eladlistaarelszdeviza)::numeric, 4), 0::numeric)), (COALESCE(pu.elszamolodevizaid, 0)), (COALESCE(round((pu.engedmeny)::numeric, 4), 0::numeric)), (COALESCE(pu.eladafakulcsid, 0))"
" Sort Method: external sort Disk: 2928kB"
" -> Subquery Scan pu (cost=5687.12..6737.33 rows=20004 width=64) (actual time=62.871..263.017 rows=22617 loops=1)"
" -> GroupAggregate (cost=5687.12..6537.29 rows=20004 width=64) (actual time=62.836..96.537 rows=22617 loops=1)"
" -> Sort (cost=5687.12..5737.13 rows=20004 width=64) (actual time=62.821..71.278 rows=23104 loops=1)"
" Sort Key: pmf.id, pmt.cikkid, pmf.dokumentumtipusid, pmt.mennyegysegid, pmt.eladafakulcs, pmt.eladlistaar, pmt.eladlistaarelszdeviza, pmt.elszamolodevizaid, pmt.engedmeny, pmt.eladafakulcsid"
" Sort Method: external merge Disk: 1984kB"
" -> Hash Join (cost=1487.75..3505.53 rows=20004 width=64) (actual time=7.281..33.013 rows=23104 loops=1)"
" Hash Cond: (pmt.pugyimozgasfejid = pmf.id)"
" -> Seq Scan on pugyimozgastetel pmt (cost=0.00..1396.42 rows=30642 width=60) (actual time=0.014..4.985 rows=30642 loops=1)"
" -> Hash (cost=1373.85..1373.85 rows=9112 width=8) (actual time=7.249..7.249 rows=10534 loops=1)"
" -> Seq Scan on pugyimozgasfej pmf (cost=0.00..1373.85 rows=9112 width=8) (actual time=0.011..5.220 rows=10534 loops=1)"
" Filter: (dokumentumtipusid = ANY ('{36,39,7,9,38,63,59,50,51,41,62,58,86,40}'::integer[]))"
"Total runtime: 726.201 ms"
| node type | count | sum of times | % of query |
|---|---|---|---|
| GroupAggregate | 2 | 52.402 ms | 7.3 % |
| Hash | 2 | 6.083 ms | 0.8 % |
| Hash Join | 2 | 55.603 ms | 7.7 % |
| Materialize | 1 | 4.707 ms | 0.7 % |
| Merge Full Join | 1 | 59.426 ms | 8.3 % |
| Seq Scan | 4 | 27.009 ms | 3.8 % |
| Sort | 4 | 180.330 ms | 25.1 % |
| Subquery Scan pmst | 1 | 166.764 ms | 23.2 % |
| Subquery Scan pu | 1 | 166.480 ms | 23.2 % |
| Table name | Scan count | Total time | % of query |
|---|---|---|---|
| scan type | count | sum of times | % of table |
| pugyimozgasfej | 2 | 14.655 ms | 2.0 % |
| Seq Scan | 2 | 14.655 ms | 100.0 % |
| pugyimozgassubtetel | 1 | 7.369 ms | 1.0 % |
| Seq Scan | 1 | 7.369 ms | 100.0 % |
| pugyimozgastetel | 1 | 4.985 ms | 0.7 % |
| Seq Scan | 1 | 4.985 ms | 100.0 % |