Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

feat: Explain cid & field attributes for dagScanNode #598

Merged
merged 2 commits into from
Jul 7, 2022

Conversation

shahzadlone
Copy link
Member

Relevant issue(s)

Resolves #597

Description

Adds two more attributes to be included in the explain graph for dagScanNode.

Tasks

  • I made sure the code is well commented, particularly in hard-to-understand areas.
  • I made sure the repository-held documentation is changed accordingly.
  • I made sure the pull request title adheres to the conventional commit style (the subset used in the project can be found in tools/configs/chglog/config.yml).
  • I made sure to discuss its limitations such as threats to validity, vulnerability to mistake and misuse, robustness to invalidation of assumptions, resource requirements, ...

How has this been tested?

CI and make test (updated integration tests.)

Specify the platform(s) on which this was tested:

  • Manjaro Linux (WSL2)

@shahzadlone shahzadlone added feature New feature or request area/query Related to the query component labels Jul 7, 2022
@shahzadlone shahzadlone added this to the DefraDB v0.3 milestone Jul 7, 2022
@shahzadlone shahzadlone requested a review from a team July 7, 2022 12:28
@shahzadlone shahzadlone self-assigned this Jul 7, 2022
@shahzadlone shahzadlone added the action/no-benchmark Skips the action that runs the benchmark. label Jul 7, 2022
@source-devs
Copy link

Benchmark Results

Summary

  • 113 Benchmarks successfully compared.
  • 62 Benchmarks were ✅ Better.
  • 51 Benchmarks were ❌ Worse .
  • 0 Benchmarks were ✨ Unchanged.
✅ See Better Results...
time/opdelta
_Collection_UserSimple_Create_Sync_0_1000-41.16s ± 0%1.05s ± 0%−9.82%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_100-453.0ms ± 0%45.2ms ± 0%−14.65%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_1000-4458ms ± 0%452ms ± 0%−1.29%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_10000-44.62s ± 0%4.59s ± 0%−0.80%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_10_10-4382µs ± 0%359µs ± 0%−5.83%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_1000-441.4ms ± 0%40.8ms ± 0%−1.44%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_10-4375µs ± 0%368µs ± 0%−1.91%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_10_10-4320µs ± 0%272µs ± 0%−14.87%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_100_100-41.84ms ± 0%1.81ms ± 0%−1.68%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_10-4268µs ± 0%266µs ± 0%−0.56%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_100-41.97ms ± 0%1.88ms ± 0%−4.78%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_100-41.24ms ± 0%1.24ms ± 0%−0.25%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_1000-49.50ms ± 0%9.08ms ± 0%−4.42%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_10-4463µs ± 0%458µs ± 0%−1.05%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_10-4476µs ± 0%460µs ± 0%−3.34%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_100-4539µs ± 0%520µs ± 0%−3.60%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_1000-4462µs ± 0%460µs ± 0%−0.52%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_10-4805µs ± 0%737µs ± 0%−8.52%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_100-4755µs ± 0%691µs ± 0%−8.44%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_10-4445µs ± 0%437µs ± 0%−1.85%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_1000-410.2ms ± 0%9.9ms ± 0%−2.56%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_10-4336µs ± 0%332µs ± 0%−1.02%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0128-417.1µs ± 0%16.6µs ± 0%−3.13%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0256-416.5µs ± 0%16.1µs ± 0%−2.56%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:1024-423.8µs ± 0%20.8µs ± 0%−12.61%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0064-4151µs ± 0%135µs ± 0%−10.21%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0128-4154µs ± 0%146µs ± 0%−5.25%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:1024-4211µs ± 0%209µs ± 0%−0.76%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0128-419.1µs ± 0%16.9µs ± 0%−11.25%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0128-4159µs ± 0%156µs ± 0%−2.02%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0256-4162µs ± 0%159µs ± 0%−1.53%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0064-450.5µs ± 0%47.6µs ± 0%−5.72%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0256-453.5µs ± 0%53.2µs ± 0%−0.54%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0512-459.2µs ± 0%53.6µs ± 0%−9.35%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:1024-468.1µs ± 0%66.3µs ± 0%−2.69%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0064-4405µs ± 0%383µs ± 0%−5.54%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0128-4467µs ± 0%389µs ± 0%−16.87%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0512-4448µs ± 0%447µs ± 0%−0.03%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:1024-4532µs ± 0%517µs ± 0%−2.82%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0128-453.9µs ± 0%51.3µs ± 0%−4.95%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0256-4404µs ± 0%401µs ± 0%−0.71%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0512-4472µs ± 0%457µs ± 0%−3.20%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:1024-41.86ms ± 0%1.76ms ± 0%−5.21%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0128-4143µs ± 0%120µs ± 0%−15.83%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0256-4143µs ± 0%122µs ± 0%−14.73%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0512-4137µs ± 0%128µs ± 0%−6.43%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0256-41.35ms ± 0%1.24ms ± 0%−8.14%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0512-41.38ms ± 0%1.29ms ± 0%−6.64%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:1024-41.63ms ± 0%1.45ms ± 0%−11.22%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0064-411.0µs ± 0%9.8µs ± 0%−10.60%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0128-411.4µs ± 0%9.8µs ± 0%−14.11%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0256-413.0µs ± 0%11.6µs ± 0%−10.92%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0512-412.8µs ± 0%12.7µs ± 0%−0.36%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:1024-417.4µs ± 0%16.9µs ± 0%−2.75%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0256-4121µs ± 0%117µs ± 0%−3.00%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0064-4147µs ± 0%147µs ± 0%−0.35%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0256-4136µs ± 0%134µs ± 0%−1.46%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0512-4140µs ± 0%138µs ± 0%−1.45%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:1024-4145µs ± 0%143µs ± 0%−1.74%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0128-41.44ms ± 0%1.40ms ± 0%−2.40%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0256-41.40ms ± 0%1.27ms ± 0%−8.90%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0512-41.37ms ± 0%1.29ms ± 0%−6.04%(p=1.000 n=1+1)
 
❌ See Worse Results...
time/opdelta
_Collection_UserSimple_CreateMany_Sync_0_100-4256ms ± 0%264ms ± 0%+3.15%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_10-410.5ms ± 0%12.1ms ± 0%+15.63%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_100-4112ms ± 0%114ms ± 0%+2.50%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_100_100-43.75ms ± 0%4.13ms ± 0%+10.00%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_100-43.88ms ± 0%4.08ms ± 0%+5.16%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_1000-424.2ms ± 0%25.0ms ± 0%+3.55%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_100-41.38ms ± 0%1.40ms ± 0%+1.01%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_1000-410.0ms ± 0%11.2ms ± 0%+11.75%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_1000-4674µs ± 0%684µs ± 0%+1.35%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_100-41.30ms ± 0%1.34ms ± 0%+3.28%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_100-4334µs ± 0%349µs ± 0%+4.45%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_1000-4299µs ± 0%305µs ± 0%+2.04%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0512-417.2µs ± 0%18.4µs ± 0%+7.48%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0256-4147µs ± 0%158µs ± 0%+7.69%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0512-4173µs ± 0%177µs ± 0%+2.12%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0064-415.3µs ± 0%16.5µs ± 0%+7.77%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0256-416.5µs ± 0%17.4µs ± 0%+5.14%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0512-418.6µs ± 0%22.5µs ± 0%+20.75%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:1024-424.4µs ± 0%25.6µs ± 0%+4.65%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0064-4147µs ± 0%159µs ± 0%+8.01%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0512-4168µs ± 0%183µs ± 0%+8.69%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:1024-4203µs ± 0%227µs ± 0%+11.75%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0128-448.3µs ± 0%53.6µs ± 0%+10.99%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0256-4397µs ± 0%406µs ± 0%+2.31%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0064-447.8µs ± 0%50.7µs ± 0%+6.09%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0256-450.9µs ± 0%56.5µs ± 0%+10.94%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0512-456.7µs ± 0%64.1µs ± 0%+13.13%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:1024-467.2µs ± 0%70.8µs ± 0%+5.42%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0064-4365µs ± 0%380µs ± 0%+4.05%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0128-4384µs ± 0%401µs ± 0%+4.54%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:1024-4494µs ± 0%546µs ± 0%+10.53%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0064-4116µs ± 0%129µs ± 0%+11.56%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0128-4116µs ± 0%159µs ± 0%+36.95%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0256-4127µs ± 0%159µs ± 0%+25.03%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0512-4136µs ± 0%145µs ± 0%+6.73%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:1024-4148µs ± 0%175µs ± 0%+18.18%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0064-41.21ms ± 0%1.77ms ± 0%+45.90%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0128-41.29ms ± 0%1.49ms ± 0%+15.42%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0256-41.32ms ± 0%1.60ms ± 0%+21.15%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0512-41.36ms ± 0%1.72ms ± 0%+26.71%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0064-4126µs ± 0%135µs ± 0%+7.48%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:1024-4137µs ± 0%143µs ± 0%+5.10%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0064-41.16ms ± 0%1.25ms ± 0%+7.71%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0128-41.23ms ± 0%1.35ms ± 0%+9.23%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0064-4102µs ± 0%112µs ± 0%+10.59%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0128-4106µs ± 0%120µs ± 0%+13.42%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0512-4122µs ± 0%148µs ± 0%+21.34%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:1024-4177µs ± 0%196µs ± 0%+10.75%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0128-4130µs ± 0%134µs ± 0%+3.20%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0064-41.26ms ± 0%1.40ms ± 0%+11.34%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:1024-41.44ms ± 0%1.62ms ± 0%+12.60%(p=1.000 n=1+1)
 
✨ See Unchanged Results...
time/opdelta
 
🐋 See Full Results...
develop.txtcurrent.txt
time/opdelta
pkg:collection goos:linux goarch:amd64
_Collection_UserSimple_CreateMany_Sync_0_10-411.3ms ± 0%11.3ms ± 0%+0.32%(p=1.000 n=1+1)
_Collection_UserSimple_CreateMany_Sync_0_100-4256ms ± 0%264ms ± 0%+3.15%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_10-410.5ms ± 0%12.1ms ± 0%+15.63%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_100-4112ms ± 0%114ms ± 0%+2.50%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_1000-41.16s ± 0%1.05s ± 0%−9.82%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_100-453.0ms ± 0%45.2ms ± 0%−14.65%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_1000-4458ms ± 0%452ms ± 0%−1.29%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_10000-44.62s ± 0%4.59s ± 0%−0.80%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_10_10-4382µs ± 0%359µs ± 0%−5.83%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_100_100-43.75ms ± 0%4.13ms ± 0%+10.00%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_1000-441.4ms ± 0%40.8ms ± 0%−1.44%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_10-4375µs ± 0%368µs ± 0%−1.91%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_100-43.88ms ± 0%4.08ms ± 0%+5.16%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_10_10-4320µs ± 0%272µs ± 0%−14.87%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_100_100-41.84ms ± 0%1.81ms ± 0%−1.68%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_1000-424.2ms ± 0%25.0ms ± 0%+3.55%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_10-4268µs ± 0%266µs ± 0%−0.56%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_100-41.97ms ± 0%1.88ms ± 0%−4.78%(p=1.000 n=1+1)
pkg:query/simple goos:linux goarch:amd64
_Query_UserSimple_Query_Sync_10-4405µs ± 0%375µs ± 0%−7.51%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_100-41.24ms ± 0%1.24ms ± 0%−0.25%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_1000-49.50ms ± 0%9.08ms ± 0%−4.42%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_10-4463µs ± 0%458µs ± 0%−1.05%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_100-41.38ms ± 0%1.40ms ± 0%+1.01%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_1000-410.0ms ± 0%11.2ms ± 0%+11.75%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_10-4476µs ± 0%460µs ± 0%−3.34%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_100-4539µs ± 0%520µs ± 0%−3.60%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_1000-4462µs ± 0%460µs ± 0%−0.52%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_10-4805µs ± 0%737µs ± 0%−8.52%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_100-4755µs ± 0%691µs ± 0%−8.44%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_1000-4674µs ± 0%684µs ± 0%+1.35%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_10-4445µs ± 0%437µs ± 0%−1.85%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_100-41.30ms ± 0%1.34ms ± 0%+3.28%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_1000-410.2ms ± 0%9.9ms ± 0%−2.56%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_10-4336µs ± 0%332µs ± 0%−1.02%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_100-4334µs ± 0%349µs ± 0%+4.45%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_1000-4299µs ± 0%305µs ± 0%+2.04%(p=1.000 n=1+1)
pkg:storage goos:linux goarch:amd64
_Storage_Simple_Read_Sync_1_10/ValueSize:0064-414.7µs ± 0%14.5µs ± 0%−1.69%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0128-417.1µs ± 0%16.6µs ± 0%−3.13%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0256-416.5µs ± 0%16.1µs ± 0%−2.56%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0512-417.2µs ± 0%18.4µs ± 0%+7.48%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:1024-423.8µs ± 0%20.8µs ± 0%−12.61%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0064-4151µs ± 0%135µs ± 0%−10.21%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0128-4154µs ± 0%146µs ± 0%−5.25%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0256-4147µs ± 0%158µs ± 0%+7.69%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0512-4173µs ± 0%177µs ± 0%+2.12%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:1024-4211µs ± 0%209µs ± 0%−0.76%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0064-415.3µs ± 0%16.5µs ± 0%+7.77%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0128-419.1µs ± 0%16.9µs ± 0%−11.25%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0256-416.5µs ± 0%17.4µs ± 0%+5.14%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0512-418.6µs ± 0%22.5µs ± 0%+20.75%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:1024-424.4µs ± 0%25.6µs ± 0%+4.65%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0064-4147µs ± 0%159µs ± 0%+8.01%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0128-4159µs ± 0%156µs ± 0%−2.02%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0256-4162µs ± 0%159µs ± 0%−1.53%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0512-4168µs ± 0%183µs ± 0%+8.69%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:1024-4203µs ± 0%227µs ± 0%+11.75%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0064-450.5µs ± 0%47.6µs ± 0%−5.72%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0128-448.3µs ± 0%53.6µs ± 0%+10.99%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0256-453.5µs ± 0%53.2µs ± 0%−0.54%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0512-459.2µs ± 0%53.6µs ± 0%−9.35%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:1024-468.1µs ± 0%66.3µs ± 0%−2.69%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0064-4405µs ± 0%383µs ± 0%−5.54%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0128-4467µs ± 0%389µs ± 0%−16.87%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0256-4397µs ± 0%406µs ± 0%+2.31%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0512-4448µs ± 0%447µs ± 0%−0.03%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:1024-4532µs ± 0%517µs ± 0%−2.82%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0064-447.8µs ± 0%50.7µs ± 0%+6.09%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0128-453.9µs ± 0%51.3µs ± 0%−4.95%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0256-450.9µs ± 0%56.5µs ± 0%+10.94%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0512-456.7µs ± 0%64.1µs ± 0%+13.13%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:1024-467.2µs ± 0%70.8µs ± 0%+5.42%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0064-4365µs ± 0%380µs ± 0%+4.05%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0128-4384µs ± 0%401µs ± 0%+4.54%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0256-4404µs ± 0%401µs ± 0%−0.71%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0512-4472µs ± 0%457µs ± 0%−3.20%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:1024-4494µs ± 0%546µs ± 0%+10.53%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0064-4116µs ± 0%129µs ± 0%+11.56%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0128-4116µs ± 0%159µs ± 0%+36.95%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0256-4127µs ± 0%159µs ± 0%+25.03%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0512-4136µs ± 0%145µs ± 0%+6.73%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:1024-4148µs ± 0%175µs ± 0%+18.18%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0064-41.21ms ± 0%1.77ms ± 0%+45.90%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0128-41.29ms ± 0%1.49ms ± 0%+15.42%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0256-41.32ms ± 0%1.60ms ± 0%+21.15%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0512-41.36ms ± 0%1.72ms ± 0%+26.71%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:1024-41.86ms ± 0%1.76ms ± 0%−5.21%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0064-4126µs ± 0%135µs ± 0%+7.48%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0128-4143µs ± 0%120µs ± 0%−15.83%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0256-4143µs ± 0%122µs ± 0%−14.73%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0512-4137µs ± 0%128µs ± 0%−6.43%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:1024-4137µs ± 0%143µs ± 0%+5.10%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0064-41.16ms ± 0%1.25ms ± 0%+7.71%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0128-41.23ms ± 0%1.35ms ± 0%+9.23%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0256-41.35ms ± 0%1.24ms ± 0%−8.14%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0512-41.38ms ± 0%1.29ms ± 0%−6.64%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:1024-41.63ms ± 0%1.45ms ± 0%−11.22%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0064-411.0µs ± 0%9.8µs ± 0%−10.60%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0128-411.4µs ± 0%9.8µs ± 0%−14.11%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0256-413.0µs ± 0%11.6µs ± 0%−10.92%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0512-412.8µs ± 0%12.7µs ± 0%−0.36%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:1024-417.4µs ± 0%16.9µs ± 0%−2.75%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0064-4102µs ± 0%112µs ± 0%+10.59%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0128-4106µs ± 0%120µs ± 0%+13.42%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0256-4121µs ± 0%117µs ± 0%−3.00%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0512-4122µs ± 0%148µs ± 0%+21.34%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:1024-4177µs ± 0%196µs ± 0%+10.75%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0064-4147µs ± 0%147µs ± 0%−0.35%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0128-4130µs ± 0%134µs ± 0%+3.20%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0256-4136µs ± 0%134µs ± 0%−1.46%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0512-4140µs ± 0%138µs ± 0%−1.45%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:1024-4145µs ± 0%143µs ± 0%−1.74%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0064-41.26ms ± 0%1.40ms ± 0%+11.34%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0128-41.44ms ± 0%1.40ms ± 0%−2.40%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0256-41.40ms ± 0%1.27ms ± 0%−8.90%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0512-41.37ms ± 0%1.29ms ± 0%−6.04%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:1024-41.44ms ± 0%1.62ms ± 0%+12.60%(p=1.000 n=1+1)
 

Copy link
Contributor

@AndrewSisley AndrewSisley left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM :)

explainerMap["cid"] = nil
}

// Build the explaination of the spans attribute.
spansExplainer := []map[string]interface{}{}
// Note: n.headset is `nil` for single commit selection query, so must check for it.
if n.headset != nil && n.headset.spans.HasValue {
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

thought: For the future (not) now, it might be worth refactoring explain-spans at some point, as it would be good to help encourage consistency here across all nodes

Copy link
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Agreed. Perhaps we can initiate a ticket to put any specific kind of refactor you might have in mind?

Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Whatever you prefer, I probably wound't bother with a ticket and just do it as the first commit in the next explain PR

@shahzadlone shahzadlone merged commit 7e90fbb into develop Jul 7, 2022
@shahzadlone shahzadlone deleted the lone/feat/explain-more-dagscan-attributes branch July 7, 2022 14:20
shahzadlone added a commit to shahzadlone/defradb that referenced this pull request Feb 23, 2024
…work#598)

## Relevant issue(s)
Resolves sourcenetwork#597  

## Description
Adds two more attributes to be included in the explain graph for `dagScanNode`.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
action/no-benchmark Skips the action that runs the benchmark. area/query Related to the query component feature New feature or request
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Add cid and field attributes to dagScanNode
3 participants