filecoin-project / filecoin-project/lily

View to track deal activation, slashing, expiry

Open
#496 0 comments 0 reactions 0 assignees View on GitHub
kind/feature kind/schema P3
Dominant language
Go
Stars
52
Forks
47
PR merge metrics
No merged PRs in 30d

Description

Essentially need a view that does:

```
SELECT
min(s.height) FILTER (WHERE slash_epoch < 0) as act_height,
min(s.height) FILTER (WHERE slash_epoch > 0) as slash_height,
s.deal_id, end_epoch
FROM market_deal_states s
JOIN market_deal_proposals p ON s.deal_id = p.deal_id
GROUP BY s.deal_id, end_epoch
```

Where for each deal it is possible to see when it was activated, when it was slashed, and when it expires. This JOIN takes way to long.

Alternatively we could add end_epoch to market_deal_states (in scope of #495 perhaps).

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.