search

cwida / duckpgq-extension

DuckDB extension that adds support for SQL/PGQ
https://duckpgq.notion.site/b8ac652667964f958bfada1c3e53f1bb?v=3b47a8d44bdf4e0c8b503bf23f1b76f2
MIT License
77 stars 7 forks source link

IS2 Recent messages of a person #76

Open Dtenwolde opened 9 months ago

Dtenwolde commented 9 months ago

Very similar to IS6 #74, this query is slow to terminate and requires a lot of memory. 

FROM GRAPH_TABLE (snb_projected
    MATCH p = ANY SHORTEST (person:Person WHERE person.id = 28587302328111)<-[mhc:Message_hasCreator]-(message:Message)-[ro:message_replyOf]-> *(post:Post)-[phc:post_hasCreator]->(originalPoster:Person)
    COLUMNS (message.id as mid, coalesce(message.content, message.imageFile), message.creationDate, post.id, originalPoster.id, originalPoster.firstName, originalPoster.lastName)
    ) tmp
    ORDER BY tmp.creationDate desc, tmp.mid desc

image

Dtenwolde commented 9 months ago

See ic2-analyze.txt

I believe the time tracking for the last BLOCKWISE_NL_JOIN is not correct, as 0.00 is not believable in this case

github-actions[bot] commented 2 months ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.