# Certaines requêtes qui ne se terminent pas

**URL:** <https://meta.discourse.org/t/some-queries-that-dont-finish/113560>\
**Category:** Product Support\
**Created:** [Avril 5, 2019, 3:19 UTC](https://meta.discourse.org/t/some-queries-that-dont-finish/113560 "2019-04-05T15:19:00Z")\
**Posts on this page:** 1\
**Showing post:** 12

<div class="post-metadata">

**Author:** ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)\
**Post date:** [Avril 5, 2019, 6:41 UTC](https://meta.discourse.org/t/some-queries-that-dont-finish/113560/12 "2019-04-05T18:41:15Z")

</div>

The OP has the “stuck” queries with the PIDs of each one.

You can use `SELECT pg_cancel_backend( __pid__ );` to ask the query to stop nicely, and `SELECT pg_terminate_backend( __pid__ );` to ask it to stop NOW. (where ` __pid__ ` is a number)

For vacuum:

```plaintext
VACUUM VERBOSE ANALYZE posts;
VACUUM VERBOSE ANALYZE topics;
VACUUM VERBOSE ANALYZE post_search_data;

```

---

_[View the full topic](https://meta.discourse.org/t/some-queries-that-dont-finish/113560)._