Could a query be still active after pgAdmin4 crashed?

Question

As i am asking in the title, I am wondering if a query can be still active after pgAdmin4 crashed ?

Indeed I was running a very long-time query..

CREATE TABLE intersection as ( 
SELECT buff.rownum as buffrownum,
       ST_Intersection(union.st_union, buff.st_buffer) AS geom 
FROM union, buff 
WHERE ST_Intersects (union.st_union, buff.st_buffer));

..when pgAdmin crashed... (due to my mistake I believe, as I runned a query in parallel to create a big table setting many rows...)

I have seen this post but as I am a very new user of PostgreSQL/postGIS, I didn't really understood the answer...

I opened again pgAdmin4 and did the query..

SELECT * FROM pg_stat_activity;

..and it returns me :

As you can see the query in question (CREATE...) on the second line has still an "active" state. Does it mean that the query is still active even after pgAdmin4 closed ? I mean will the table "intersection" be created ?