FrankChen021 / bithon

An observability platform mainly for Java
Apache License 2.0
14 stars 4 forks source link

Apply secondary indexes to improve query performance #713

Closed FrankChen021 closed 4 months ago

FrankChen021 commented 5 months ago

no: read rows: 3709008, read bytes: 131548830 f1: read rows: 303104, read bytes: 11470698 f1 + f2: read rows: 303104, read bytes: 11470698 f1 + f2 + f3: read rows: 16384, read bytes: 1330559

f1:

        Skip
          Name: idx_f1
          Description: bloom_filter GRANULARITY 1
          Parts: 6/6
          Granules: 37/455

f1+f2

        Skip
          Name: idx_f1
          Description: bloom_filter GRANULARITY 1
          Parts: 6/6
          Granules: 37/455
        Skip
          Name: idx_f2
          Description: bloom_filter GRANULARITY 1
          Parts: 6/6
          Granules: 37/37

f1+f2+f3:

        Skip
          Name: idx_f1
          Description: bloom_filter GRANULARITY 1
          Parts: 6/6
          Granules: 37/455
        Skip
          Name: idx_f2
          Description: bloom_filter GRANULARITY 1
          Parts: 6/6
          Granules: 37/37
        Skip
          Name: idx_f3
          Description: bloom_filter GRANULARITY 1
          Parts: 2/6
          Granules: 2/37