Explain PostgreSQL / Plan Visualizer

2025-05-22 11:15:28.362

73a09ae1-950e-9326-77a6-eda644d0b49e

2.516 ms

сообщить о проблеме

tilemap | piechart

node, ms

tree, ms

rows

RRbF

loops

node

11′935.333

59′349.609

148′286

итоговые результаты (624B = rows=78 x width=8)

81.764

11′935.333

▲

Gather

7.730

59′267.845

▲

-> Nested Loop

2.330

59′260.115

▼

-> Parallel Hash Join

1.165

80.805

990

▼

-> Hash Join

.136

18.260

990

▼

-> Parallel Append

13.600

660

▼

129′155

99.5%

-> Parallel Seq Scan on "tBrokerDocStateLinks_0001" st_2

3.027

2′364

100.0%

-> Parallel Seq Scan on "tBrokerDocStateLinks_0000" st_1

1.492

330

▼

15′222

97.9%

-> Parallel Seq Scan on "tBrokerDocStateLinks_0002" st_3

-> Parallel Seq Scan on "tBrokerDocStateLinks_0003" st_4

-> Parallel Seq Scan on "tBrokerDocStateLinks_0004" st_5

-> Parallel Seq Scan on "tBrokerDocStateLinks_0005" st_6

-> Parallel Seq Scan on "tBrokerDocStateLinks_0006" st_7

-> Parallel Seq Scan on "tBrokerDocStateLinks_0007" st_8

-> Parallel Seq Scan on "tBrokerDocStateLinks_0008" st_9

-> Parallel Seq Scan on "tBrokerDocStateLinks_0009" st_10

-> Parallel Seq Scan on "tBrokerDocStateLinks_0010" st_11

.001

-> Parallel Seq Scan on "tBrokerDocStateLinks_0011" st_12

-> Parallel Seq Scan on "tBrokerDocStateLinks_0012" st_13

-> Parallel Seq Scan on "tBrokerDocStateLinks_0013" st_14

.001

-> Parallel Seq Scan on "tBrokerDocStateLinks_0014" st_15

-> Parallel Seq Scan on "tBrokerDocStateLinks_0015" st_16

-> Parallel Seq Scan on "tBrokerDocStateLinks_0016" st_17

-> Parallel Seq Scan on "tBrokerDocStateLinks_0017" st_18

-> Parallel Seq Scan on "tBrokerDocStateLinks_0018" st_19

-> Parallel Seq Scan on "tBrokerDocStateLinks_0019" st_20

-> Parallel Seq Scan on "tBrokerDocStateLinks_0020" st_21

-> Parallel Seq Scan on "tBrokerDocStateLinks_0021" st_22

-> Parallel Seq Scan on "tBrokerDocStateLinks_0022" st_23

-> Parallel Seq Scan on "tBrokerDocStateLinks_0023" st_24

-> Parallel Seq Scan on "tBrokerDocStateLinks_0024" st_25

.001

-> Parallel Seq Scan on "tBrokerDocStateLinks_0025" st_26

-> Parallel Seq Scan on "tBrokerDocStateLinks_0026" st_27

-> Parallel Seq Scan on "tBrokerDocStateLinks_0027" st_28

-> Parallel Seq Scan on "tBrokerDocStateLinks_0028" st_29

-> Parallel Seq Scan on "tBrokerDocStateLinks_0029" st_30

-> Parallel Seq Scan on "tBrokerDocStateLinks_0030" st_31

-> Parallel Seq Scan on "tBrokerDocStateLinks_0031" st_32

-> Parallel Seq Scan on "tBrokerDocStateLinks_0032" st_33

.001

-> Parallel Seq Scan on "tBrokerDocStateLinks_0033" st_34

-> Parallel Seq Scan on "tBrokerDocStateLinks_0034" st_35

-> Parallel Seq Scan on "tBrokerDocStateLinks_0035" st_36

-> Parallel Seq Scan on "tBrokerDocStateLinks_0036" st_37

-> Parallel Seq Scan on "tBrokerDocStateLinks_0037" st_38

-> Parallel Seq Scan on "tBrokerDocStateLinks_0038" st_39

-> Parallel Seq Scan on "tBrokerDocStateLinks_0039" st_40

.001

-> Parallel Seq Scan on "tBrokerDocStateLinks_0040" st_41

29.865

61.380

253′370

-> Hash

31.515

253′370

-> Seq Scan on "tBrokerDocs" d

1′218.220

59′176.980

672′245

▲

-> Parallel Hash

1′948.243

57′958.760

672′245

▲

-> Parallel Append

1′268.689

26′652

▲

197

0.7%

-> Parallel Index Scan using "tAuctionAttributeValues_0061_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0061" av_43

1′209.842

25′875

▲

0.0%

-> Parallel Index Scan using "tAuctionAttributeValues_0050_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0050" av_32

1′195.565

25′217

▲

-> Parallel Index Scan using "tAuctionAttributeValues_0015_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0015" av_16

1′157.434

24′457

▲

0.0%

-> Parallel Index Scan using "tAuctionAttributeValues_0013_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0013" av_14

992.880

24′714

▲

0.1%

-> Parallel Index Scan using "tAuctionAttributeValues_0051_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0051" av_33

1′029.494

24′296

▲

-> Parallel Index Scan using "tAuctionAttributeValues_0012_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0012" av_13

874.548

22′771

▲

152

0.7%

-> Parallel Index Scan using "tAuctionAttributeValues_0053_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0053" av_35

784.319

18′977

▲

-> Parallel Index Scan using "tAuctionAttributeValues_0000_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0000" av_1

986.472

22′966

▲

-> Parallel Index Scan using "tAuctionAttributeValues_0011_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0011" av_12

1′063.893

23′119

▲

-> Parallel Index Scan using "tAuctionAttributeValues_0014_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0014" av_15

932.872

23′497

▲

156

0.7%

-> Parallel Index Scan using "tAuctionAttributeValues_0054_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0054" av_36

799.104

22′399

▲

-> Parallel Index Scan using "tAuctionAttributeValues_0010_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0010" av_11

1′015.512

22′220

▲

119

0.5%

-> Parallel Index Scan using "tAuctionAttributeValues_0055_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0055" av_37

1′375.963

25′470

▲

-> Parallel Index Scan using "tAuctionAttributeValues_0016_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0016" av_17

882.339

18′030

▲

0.5%

-> Parallel Index Scan using "tAuctionAttributeValues_0059_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0059" av_41

1′397.922

24′828

▲

154

0.6%

-> Parallel Index Scan using "tAuctionAttributeValues_0063_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0063" av_45

4′810.620

24′104

▲

200

0.8%

-> Parallel Index Scan using "tAuctionAttributeValues_0062_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0062" av_44

4′177.270

20′429

▲

107

0.5%

-> Parallel Index Scan using "tAuctionAttributeValues_0060_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0060" av_42

3′934.613

28′661

▲

-> Parallel Index Scan using "tAuctionAttributeValues_0009_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0009" av_10

4′289.705

26′280

▲

-> Parallel Index Scan using "tAuctionAttributeValues_0003_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0003" av_4

3′605.396

24′184

▲

-> Parallel Index Scan using "tAuctionAttributeValues_0008_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0008" av_9

2′637.355

18′516

▲

-> Parallel Index Scan using "tAuctionAttributeValues_0004_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0004" av_5

3′094.945

19′205

▲

0.5%

-> Parallel Index Scan using "tAuctionAttributeValues_0057_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0057" av_39

2′957.409

17′841

▲

-> Parallel Index Scan using "tAuctionAttributeValues_0006_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0006" av_7

3′052.202

18′816

▲

0.0%

-> Parallel Index Scan using "tAuctionAttributeValues_0007_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0007" av_8

2′420.458

15′446

▲

0.0%

-> Parallel Index Scan using "tAuctionAttributeValues_0005_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0005" av_6

3′440.149

17′729

▲

166

0.9%

-> Parallel Index Scan using "tAuctionAttributeValues_0058_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0058" av_40

623.547

16′034

▲

0.5%

-> Parallel Index Scan using "tAuctionAttributeValues_0052_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0052" av_34

Gather  (cost=59′900.35..63′881.33 rows=16 width=8) (actual time=11′867.910..11′935.333 rows=78 loops=1)
  Workers Planned: 4
  Workers Launched: 4
  ->  Nested Loop  (cost=58′900.35..62′879.73 rows=4 width=8) (actual time=11′849.897..11′853.569 rows=16 loops=5)
        ->  Parallel Hash Join  (cost=58′899.91..62′670.62 rows=123 width=12) (actual time=11′849.730..11′852.023 rows=16 loops=5)
              Hash Cond: (d."tBD_Auction" = av."tAAV_Auction")
              ->  Hash Join  (cost=1′983.77..5′626.24 rows=3′010 width=8) (actual time=12.476..16.161 rows=198 loops=5)
                    Hash Cond: (st."tBDSL_Doc" = d."tBD_ID")
                    ->  Parallel Append  (cost=0.00..3′634.60 rows=3′000 width=4) (actual time=0.039..3.652 rows=198 loops=5)
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0001" st_2  (cost=0.00..2′741.27 rows=6′254 width=4) (actual time=0.161..2.720 rows=132 loops=5)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                                Rows Removed by Filter: 25′831
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0000" st_1  (cost=0.00..540.36 rows=1 width=4) (actual time=0.317..1.009 rows=0 loops=3)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                                Rows Removed by Filter: 788
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0002" st_3  (cost=0.00..337.97 rows=805 width=4) (actual time=0.014..0.746 rows=165 loops=2)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                                Rows Removed by Filter: 7′611
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0003" st_4  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0004" st_5  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0005" st_6  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0006" st_7  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0007" st_8  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0008" st_9  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0009" st_10  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0010" st_11  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0011" st_12  (cost=0.00..0.00 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0012" st_13  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0013" st_14  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0014" st_15  (cost=0.00..0.00 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0015" st_16  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0016" st_17  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0017" st_18  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0018" st_19  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0019" st_20  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0020" st_21  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0021" st_22  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0022" st_23  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0023" st_24  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0024" st_25  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0025" st_26  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.001 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0026" st_27  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0027" st_28  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0028" st_29  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0029" st_30  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0030" st_31  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0031" st_32  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0032" st_33  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0033" st_34  (cost=0.00..0.00 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0034" st_35  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0035" st_36  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0036" st_37  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0037" st_38  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0038" st_39  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0039" st_40  (cost=0.00..0.00 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                          ->  Parallel Seq Scan on "tBrokerDocStateLinks_0040" st_41  (cost=0.00..0.00 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                                Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
                    ->  Hash  (cost=1′351.12..1′351.12 rows=50′612 width=8) (actual time=12.276..12.276 rows=50′674 loops=5)
                          Buckets: 65′536  Batches: 1  Memory Usage: 2492kB
                          ->  Seq Scan on "tBrokerDocs" d  (cost=0.00..1′351.12 rows=50′612 width=8) (actual time=0.017..6.303 rows=50′674 loops=5)
              ->  Parallel Hash  (cost=56′794.61..56′794.61 rows=9′723 width=4) (actual time=11′835.386..11′835.396 rows=134′449 loops=5)
                    Buckets: 1′048′576 (originally 65′536)  Batches: 1 (originally 1)  Memory Usage: 42272kB
                    ->  Parallel Append  (cost=0.56..56′794.61 rows=9′723 width=4) (actual time=0.058..11′591.752 rows=134′449 loops=5)
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0061_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0061" av_43  (cost=0.56..1′100.51 rows=227 width=4) (actual time=0.042..1′268.689 rows=26′652 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 197
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0050_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0050" av_32  (cost=0.56..2′410.43 rows=932 width=4) (actual time=0.060..1′209.842 rows=25′875 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 9
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0015_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0015" av_16  (cost=0.56..2′260.88 rows=896 width=4) (actual time=0.071..1′195.565 rows=25′217 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0013_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0013" av_14  (cost=0.56..2′248.81 rows=895 width=4) (actual time=0.075..1′157.434 rows=24′457 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 6
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0051_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0051" av_33  (cost=0.56..2′132.03 rows=829 width=4) (actual time=0.067..992.880 rows=24′714 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 13
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0012_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0012" av_13  (cost=0.56..2′058.40 rows=822 width=4) (actual time=0.050..1′029.494 rows=24′296 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0053_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0053" av_35  (cost=0.56..2′024.03 rows=789 width=4) (actual time=0.038..874.548 rows=22′771 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 152
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0000_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0000" av_1  (cost=0.56..2′020.62 rows=877 width=4) (actual time=0.067..784.319 rows=18′977 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0011_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0011" av_12  (cost=0.56..2′013.16 rows=847 width=4) (actual time=0.066..986.472 rows=22′966 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0014_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0014" av_15  (cost=0.56..2′011.91 rows=797 width=4) (actual time=0.035..1′063.893 rows=23′119 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0054_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0054" av_36  (cost=0.56..2′006.43 rows=789 width=4) (actual time=0.054..932.872 rows=23′497 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 156
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0010_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0010" av_11  (cost=0.56..1′991.12 rows=847 width=4) (actual time=0.028..799.104 rows=22′399 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0055_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0055" av_37  (cost=0.56..1′970.93 rows=762 width=4) (actual time=0.060..1′015.512 rows=22′220 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 119
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0016_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0016" av_17  (cost=0.56..1′961.13 rows=776 width=4) (actual time=0.082..1′375.963 rows=25′470 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0059_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0059" av_41  (cost=0.56..1′417.04 rows=472 width=4) (actual time=0.088..882.339 rows=18′030 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 91
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0063_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0063" av_45  (cost=0.56..1′393.75 rows=455 width=4) (actual time=0.075..1′397.922 rows=24′828 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 154
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0062_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0062" av_44  (cost=0.56..1′291.60 rows=384 width=4) (actual time=1.239..4′810.620 rows=24′104 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 200
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0060_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0060" av_42  (cost=0.56..1′253.27 rows=317 width=4) (actual time=1.089..4′177.270 rows=20′429 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 107
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0009_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0009" av_10  (cost=0.56..2′535.55 rows=1′132 width=4) (actual time=1.587..3′934.613 rows=28′661 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0003_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0003" av_4  (cost=0.56..2′353.00 rows=1′159 width=4) (actual time=2.235..4′289.705 rows=26′280 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0008_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0008" av_9  (cost=0.56..2′149.83 rows=972 width=4) (actual time=0.776..1′802.698 rows=12′092 loops=2)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0004_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0004" av_5  (cost=0.56..1′917.45 rows=878 width=4) (actual time=1.364..2′637.355 rows=18′516 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0057_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0057" av_39  (cost=0.56..1′821.45 rows=666 width=4) (actual time=0.533..618.989 rows=3′841 loops=5)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 19
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0006_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0006" av_7  (cost=0.56..1′688.61 rows=764 width=4) (actual time=0.640..985.803 rows=5′947 loops=3)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0007_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0007" av_8  (cost=0.56..1′572.49 rows=704 width=4) (actual time=0.799..1′526.101 rows=9′408 loops=2)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 0
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0005_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0005" av_6  (cost=0.56..1′550.41 rows=751 width=4) (actual time=1.562..2′420.458 rows=15′446 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 1
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0058_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0058" av_40  (cost=0.56..1′465.27 rows=519 width=4) (actual time=1.189..3′440.149 rows=17′729 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 166
                          ->  Parallel Index Scan using "tAuctionAttributeValues_0052_tAAV_Attribute_tAAV_Float_idx" on "tAuctionAttributeValues_0052" av_34  (cost=0.56..1′458.14 rows=605 width=4) (actual time=0.023..623.547 rows=16′034 loops=1)
                                Index Cond: (("tAAV_Attribute" = 1′010) AND ("tAAV_Float" > '15000000'::numeric) AND ("tAAV_Float" < '40000000'::numeric))
                                Filter: (("tAAV_Terminator" IS NULL) AND ("tAAV_EndRelevance" > now()))
                                Rows Removed by Filter: 79

-- "tBDSL_State" :: integer(=) \| "tBDSL_EndRelevance" :: timestamp with time zone(>) CREATE INDEX CONCURRENTLY "~tBrokerDocStateLinks_0001-1f90fe3a" ON "tBrokerDocStateLinks_0001"( "tBDSL_State" , "tBDSL_EndRelevance" ) WHERE "tBDSL_Terminator" IS NULL;	5
-- "tBDSL_EndRelevance" :: timestamp with time zone(>) CREATE INDEX CONCURRENTLY "~tBrokerDocStateLinks_0001-f4919bb3" ON "tBrokerDocStateLinks_0001"("tBDSL_EndRelevance") WHERE "tBDSL_State" = 10 AND "tBDSL_Terminator" IS NULL;	5
-- "tBDSL_State" :: integer(=) \| "tBDSL_EndRelevance" :: timestamp with time zone(>) CREATE INDEX CONCURRENTLY "~tBrokerDocStateLinks_0000-1f90fe3a" ON "tBrokerDocStateLinks_0000"( "tBDSL_State" , "tBDSL_EndRelevance" ) WHERE "tBDSL_Terminator" IS NULL;	6
-- "tBDSL_EndRelevance" :: timestamp with time zone(>) CREATE INDEX CONCURRENTLY "~tBrokerDocStateLinks_0000-f4919bb3" ON "tBrokerDocStateLinks_0000"("tBDSL_EndRelevance") WHERE "tBDSL_State" = 10 AND "tBDSL_Terminator" IS NULL;	6
-- "tBDSL_State" :: integer(=) \| "tBDSL_EndRelevance" :: timestamp with time zone(>) CREATE INDEX CONCURRENTLY "~tBrokerDocStateLinks_0002-1f90fe3a" ON "tBrokerDocStateLinks_0002"( "tBDSL_State" , "tBDSL_EndRelevance" ) WHERE "tBDSL_Terminator" IS NULL;	7
-- "tBDSL_EndRelevance" :: timestamp with time zone(>) CREATE INDEX CONCURRENTLY "~tBrokerDocStateLinks_0002-f4919bb3" ON "tBrokerDocStateLinks_0002"("tBDSL_EndRelevance") WHERE "tBDSL_State" = 10 AND "tBDSL_Terminator" IS NULL;	7

Parallel Seq Scan on "tBrokerDocStateLinks_0001" st_2  (cost=0.00..2′741.27 rows=6′254 width=4) (actual time=0.161..2.720 rows=132 loops=5)
  Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
  Rows Removed by Filter: 25′831

-- "tBDSL_State" :: integer(=) | "tBDSL_EndRelevance" :: timestamp with time zone(>)
CREATE INDEX CONCURRENTLY "~tBrokerDocStateLinks_0001-1f90fe3a"
  ON "tBrokerDocStateLinks_0001"(
    "tBDSL_State"
  , "tBDSL_EndRelevance"
  )
  WHERE
    "tBDSL_Terminator" IS NULL;

-- "tBDSL_EndRelevance" :: timestamp with time zone(>)
CREATE INDEX CONCURRENTLY "~tBrokerDocStateLinks_0001-f4919bb3"
  ON "tBrokerDocStateLinks_0001"("tBDSL_EndRelevance")
  WHERE
    "tBDSL_State" = 10 AND
    "tBDSL_Terminator" IS NULL;

Parallel Seq Scan on "tBrokerDocStateLinks_0000" st_1  (cost=0.00..540.36 rows=1 width=4) (actual time=0.317..1.009 rows=0 loops=3)
  Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
  Rows Removed by Filter: 788

-- "tBDSL_State" :: integer(=) | "tBDSL_EndRelevance" :: timestamp with time zone(>)
CREATE INDEX CONCURRENTLY "~tBrokerDocStateLinks_0000-1f90fe3a"
  ON "tBrokerDocStateLinks_0000"(
    "tBDSL_State"
  , "tBDSL_EndRelevance"
  )
  WHERE
    "tBDSL_Terminator" IS NULL;

-- "tBDSL_EndRelevance" :: timestamp with time zone(>)
CREATE INDEX CONCURRENTLY "~tBrokerDocStateLinks_0000-f4919bb3"
  ON "tBrokerDocStateLinks_0000"("tBDSL_EndRelevance")
  WHERE
    "tBDSL_State" = 10 AND
    "tBDSL_Terminator" IS NULL;

Parallel Seq Scan on "tBrokerDocStateLinks_0002" st_3  (cost=0.00..337.97 rows=805 width=4) (actual time=0.014..0.746 rows=165 loops=2)
  Filter: (("tBDSL_Terminator" IS NULL) AND ("tBDSL_State" = 10) AND ("tBDSL_EndRelevance" > now()))
  Rows Removed by Filter: 7′611

-- "tBDSL_State" :: integer(=) | "tBDSL_EndRelevance" :: timestamp with time zone(>)
CREATE INDEX CONCURRENTLY "~tBrokerDocStateLinks_0002-1f90fe3a"
  ON "tBrokerDocStateLinks_0002"(
    "tBDSL_State"
  , "tBDSL_EndRelevance"
  )
  WHERE
    "tBDSL_Terminator" IS NULL;

-- "tBDSL_EndRelevance" :: timestamp with time zone(>)
CREATE INDEX CONCURRENTLY "~tBrokerDocStateLinks_0002-f4919bb3"
  ON "tBrokerDocStateLinks_0002"("tBDSL_EndRelevance")
  WHERE
    "tBDSL_State" = 10 AND
    "tBDSL_Terminator" IS NULL;

Сводно

время	%	rows	RRbF	%	loops	тип узла	таблица	индекс	узлы
4′810.620	8.1	24′104	200	.8		Parallel Index Scan	tAuctionAttributeValues_0062	tAuctionAttributeValues_0062_tAAV_Attribute_tAAV_Float_idx	66
4′289.705	7.2	26′280				Parallel Index Scan	tAuctionAttributeValues_0003	tAuctionAttributeValues_0003_tAAV_Attribute_tAAV_Float_idx	69
4′177.270	7.0	20′429	107	.5		Parallel Index Scan	tAuctionAttributeValues_0060	tAuctionAttributeValues_0060_tAAV_Attribute_tAAV_Float_idx	67
3′934.613	6.6	28′661				Parallel Index Scan	tAuctionAttributeValues_0009	tAuctionAttributeValues_0009_tAAV_Attribute_tAAV_Float_idx	68
3′605.396	6.1	24′184			2	Parallel Index Scan	tAuctionAttributeValues_0008	tAuctionAttributeValues_0008_tAAV_Attribute_tAAV_Float_idx	70
3′440.149	5.8	17′729	166	.9		Parallel Index Scan	tAuctionAttributeValues_0058	tAuctionAttributeValues_0058_tAAV_Attribute_tAAV_Float_idx	76
3′094.945	5.2	19′205	95	.5	5	Parallel Index Scan	tAuctionAttributeValues_0057	tAuctionAttributeValues_0057_tAAV_Attribute_tAAV_Float_idx	72
3′052.202	5.1	18′816			2	Parallel Index Scan	tAuctionAttributeValues_0007	tAuctionAttributeValues_0007_tAAV_Attribute_tAAV_Float_idx	74
2′957.409	5.0	17′841			3	Parallel Index Scan	tAuctionAttributeValues_0006	tAuctionAttributeValues_0006_tAAV_Attribute_tAAV_Float_idx	73
2′637.355	4.4	18′516				Parallel Index Scan	tAuctionAttributeValues_0004	tAuctionAttributeValues_0004_tAAV_Attribute_tAAV_Float_idx	71
2′420.458	4.1	15′446	1	.0		Parallel Index Scan	tAuctionAttributeValues_0005	tAuctionAttributeValues_0005_tAAV_Attribute_tAAV_Float_idx	75
1′948.379	3.3	673′235			10	Parallel Append			4 49	2
1′397.922	2.4	24′828	154	.6		Parallel Index Scan	tAuctionAttributeValues_0063	tAuctionAttributeValues_0063_tAAV_Attribute_tAAV_Float_idx	65
1′375.963	2.3	25′470				Parallel Index Scan	tAuctionAttributeValues_0016	tAuctionAttributeValues_0016_tAAV_Attribute_tAAV_Float_idx	63
1′268.689	2.1	26′652	197	.7		Parallel Index Scan	tAuctionAttributeValues_0061	tAuctionAttributeValues_0061_tAAV_Attribute_tAAV_Float_idx	50
1′218.220	2.1	672′245			5	Parallel Hash			48
1′209.842	2.0	25′875	9	.0		Parallel Index Scan	tAuctionAttributeValues_0050	tAuctionAttributeValues_0050_tAAV_Attribute_tAAV_Float_idx	51
1′195.565	2.0	25′217				Parallel Index Scan	tAuctionAttributeValues_0015	tAuctionAttributeValues_0015_tAAV_Attribute_tAAV_Float_idx	52
1′157.434	2.0	24′457	6	.0		Parallel Index Scan	tAuctionAttributeValues_0013	tAuctionAttributeValues_0013_tAAV_Attribute_tAAV_Float_idx	53
1′063.893	1.8	23′119				Parallel Index Scan	tAuctionAttributeValues_0014	tAuctionAttributeValues_0014_tAAV_Attribute_tAAV_Float_idx	59
1′029.494	1.7	24′296				Parallel Index Scan	tAuctionAttributeValues_0012	tAuctionAttributeValues_0012_tAAV_Attribute_tAAV_Float_idx	55
1′015.512	1.7	22′220	119	.5		Parallel Index Scan	tAuctionAttributeValues_0055	tAuctionAttributeValues_0055_tAAV_Attribute_tAAV_Float_idx	62
992.880	1.7	24′714	13	.1		Parallel Index Scan	tAuctionAttributeValues_0051	tAuctionAttributeValues_0051_tAAV_Attribute_tAAV_Float_idx	54
986.472	1.7	22′966				Parallel Index Scan	tAuctionAttributeValues_0011	tAuctionAttributeValues_0011_tAAV_Attribute_tAAV_Float_idx	58
932.872	1.6	23′497	156	.7		Parallel Index Scan	tAuctionAttributeValues_0054	tAuctionAttributeValues_0054_tAAV_Attribute_tAAV_Float_idx	60
882.339	1.5	18′030	91	.5		Parallel Index Scan	tAuctionAttributeValues_0059	tAuctionAttributeValues_0059_tAAV_Attribute_tAAV_Float_idx	64
874.548	1.5	22′771	152	.7		Parallel Index Scan	tAuctionAttributeValues_0053	tAuctionAttributeValues_0053_tAAV_Attribute_tAAV_Float_idx	56
799.104	1.3	22′399				Parallel Index Scan	tAuctionAttributeValues_0010	tAuctionAttributeValues_0010_tAAV_Attribute_tAAV_Float_idx	61
784.319	1.3	18′977				Parallel Index Scan	tAuctionAttributeValues_0000	tAuctionAttributeValues_0000_tAAV_Attribute_tAAV_Float_idx	57
623.547	1.1	16′034	79	.5		Parallel Index Scan	tAuctionAttributeValues_0052	tAuctionAttributeValues_0052_tAAV_Attribute_tAAV_Float_idx	77
81.764	0.1	78				Gather			0
31.515	0.1	253′370			5	Seq Scan	tBrokerDocs		47
29.865	0.1	253′370			5	Hash			46
13.600	0.0	660	129′155	99.5	5	Parallel Seq Scan	tBrokerDocStateLinks_0001		5
7.730	0.0	80			5	Nested Loop			1
3.027	0.0		2′364		3	Parallel Seq Scan	tBrokerDocStateLinks_0000		6
2.330	0.0	80			5	Parallel Hash Join			2
1.492	0.0	330	15′222	97.9	2	Parallel Seq Scan	tBrokerDocStateLinks_0002		7
1.165	0.0	990			5	Hash Join			3
.001	0.0					Parallel Seq Scan	tBrokerDocStateLinks_0011		16
.001	0.0					Parallel Seq Scan	tBrokerDocStateLinks_0014		19
.001	0.0					Parallel Seq Scan	tBrokerDocStateLinks_0025		30
.001	0.0					Parallel Seq Scan	tBrokerDocStateLinks_0033		38
.001	0.0					Parallel Seq Scan	tBrokerDocStateLinks_0040		45
						Parallel Seq Scan	tBrokerDocStateLinks_0003		8
						Parallel Seq Scan	tBrokerDocStateLinks_0004		9
						Parallel Seq Scan	tBrokerDocStateLinks_0005		10
						Parallel Seq Scan	tBrokerDocStateLinks_0006		11
						Parallel Seq Scan	tBrokerDocStateLinks_0007		12
						Parallel Seq Scan	tBrokerDocStateLinks_0008		13
						Parallel Seq Scan	tBrokerDocStateLinks_0009		14
						Parallel Seq Scan	tBrokerDocStateLinks_0010		15
						Parallel Seq Scan	tBrokerDocStateLinks_0012		17
						Parallel Seq Scan	tBrokerDocStateLinks_0013		18
						Parallel Seq Scan	tBrokerDocStateLinks_0015		20
						Parallel Seq Scan	tBrokerDocStateLinks_0016		21
						Parallel Seq Scan	tBrokerDocStateLinks_0017		22
						Parallel Seq Scan	tBrokerDocStateLinks_0018		23
						Parallel Seq Scan	tBrokerDocStateLinks_0019		24
						Parallel Seq Scan	tBrokerDocStateLinks_0020		25
						Parallel Seq Scan	tBrokerDocStateLinks_0021		26
						Parallel Seq Scan	tBrokerDocStateLinks_0022		27
						Parallel Seq Scan	tBrokerDocStateLinks_0023		28
						Parallel Seq Scan	tBrokerDocStateLinks_0024		29
						Parallel Seq Scan	tBrokerDocStateLinks_0026		31
						Parallel Seq Scan	tBrokerDocStateLinks_0027		32
						Parallel Seq Scan	tBrokerDocStateLinks_0028		33
						Parallel Seq Scan	tBrokerDocStateLinks_0029		34
						Parallel Seq Scan	tBrokerDocStateLinks_0030		35
						Parallel Seq Scan	tBrokerDocStateLinks_0031		36
						Parallel Seq Scan	tBrokerDocStateLinks_0032		37
						Parallel Seq Scan	tBrokerDocStateLinks_0034		39
						Parallel Seq Scan	tBrokerDocStateLinks_0035		40
						Parallel Seq Scan	tBrokerDocStateLinks_0036		41
						Parallel Seq Scan	tBrokerDocStateLinks_0037		42
						Parallel Seq Scan	tBrokerDocStateLinks_0038		43
						Parallel Seq Scan	tBrokerDocStateLinks_0039		44