By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 10
INSERT 0 10
| previous_id | previous_status | previous_timestamp | id | status | timestamp | next_id | next_status | next_timestamp |
|---|---|---|---|---|---|---|---|---|
| null | null | null | 1 | Active | 2023-01-13 18:00:01.528 | 1 | Failed | 2023-01-13 18:00:01.53 |
| 1 | Active | 2023-01-13 18:00:01.528 | 1 | Failed | 2023-01-13 18:00:01.53 | 1 | Failed | 2023-01-13 18:00:01.532 |
| 1 | Failed | 2023-01-13 18:00:01.53 | 1 | Failed | 2023-01-13 18:00:01.532 | 1 | Active | 2023-01-13 18:00:01.533 |
| 1 | Failed | 2023-01-13 18:00:01.532 | 1 | Active | 2023-01-13 18:00:01.533 | 1 | Failed | 2023-01-13 18:00:01.535 |
| 1 | Active | 2023-01-13 18:00:01.533 | 1 | Failed | 2023-01-13 18:00:01.535 | 1 | Active | 2023-01-13 18:00:01.537 |
| 1 | Failed | 2023-01-13 18:00:01.535 | 1 | Active | 2023-01-13 18:00:01.537 | 1 | Failed | 2023-01-13 18:00:01.538 |
| 1 | Active | 2023-01-13 18:00:01.537 | 1 | Failed | 2023-01-13 18:00:01.538 | 1 | Failed | 2023-01-13 18:00:01.539 |
| 1 | Failed | 2023-01-13 18:00:01.538 | 1 | Failed | 2023-01-13 18:00:01.539 | 1 | Failed | 2023-01-13 18:00:01.54 |
| 1 | Failed | 2023-01-13 18:00:01.539 | 1 | Failed | 2023-01-13 18:00:01.54 | 1 | Failed | 2023-01-13 18:00:01.541 |
| 1 | Failed | 2023-01-13 18:00:01.54 | 1 | Failed | 2023-01-13 18:00:01.541 | 1 | Failed | 2023-01-13 18:00:01.542 |
| 1 | Failed | 2023-01-13 18:00:01.541 | 1 | Failed | 2023-01-13 18:00:01.542 | 1 | Failed | 2023-01-13 18:00:01.543 |
| 1 | Failed | 2023-01-13 18:00:01.542 | 1 | Failed | 2023-01-13 18:00:01.543 | 1 | Failed | 2023-01-13 18:00:01.544 |
| 1 | Failed | 2023-01-13 18:00:01.543 | 1 | Failed | 2023-01-13 18:00:01.544 | 1 | Failed | 2023-01-13 18:00:01.545 |
| 1 | Failed | 2023-01-13 18:00:01.544 | 1 | Failed | 2023-01-13 18:00:01.545 | 1 | Failed | 2023-01-13 18:00:01.546 |
| 1 | Failed | 2023-01-13 18:00:01.545 | 1 | Failed | 2023-01-13 18:00:01.546 | 1 | Failed | 2023-01-13 18:00:01.547 |
| 1 | Failed | 2023-01-13 18:00:01.546 | 1 | Failed | 2023-01-13 18:00:01.547 | null | null | null |
| null | null | null | 2 | Active | 2023-01-13 18:00:01.529 | null | null | null |
| null | null | null | 3 | Active | 2023-01-13 18:00:01.531 | 3 | Active | 2023-01-13 18:00:01.534 |
| 3 | Active | 2023-01-13 18:00:01.531 | 3 | Active | 2023-01-13 18:00:01.534 | null | null | null |
| null | null | null | 4 | Failed | 2023-01-13 18:00:01.536 | null | null | null |
SELECT 20