By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
| sessionid | hit | type | path | event | grp | prior_path | prior_event |
|---|---|---|---|---|---|---|---|
| 1001 | 1 | event | www.stackoverflow.com | hover | 1 | null | null |
| 1001 | 2 | page | www.stackoverflow.com | null | 1 | null | hover |
| 1001 | 3 | event | www.stackoverflow.com | load | 2 | null | null |
| 1001 | 4 | event | www.stackoverflow.com | blur | 3 | null | load |
| 1001 | 5 | event | www.stackoverflow.com | click | 4 | null | blur |
| 1001 | 6 | page | www.stackoverflow.com/post/10 | null | 4 | www.stackoverflow.com | click |
| 1001 | 7 | event | www.stackoverflow.com/post/10#details | offer | 5 | null | null |
| 1001 | 8 | page | www.stackoverflow.com/post/confirm | null | 5 | www.stackoverflow.com/post/10 | offer |
| 1001 | 9 | page | www.stackoverflow.com/questions/10 | null | 5 | www.stackoverflow.com/post/confirm | offer |
| 1001 | 10 | event | www.stackoverflow.com/questions/10 | exit | 6 | null | null |