explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DVQS : Requirements filtering by author and search

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=2.18..2.19 rows=1 width=590) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=2.18..2.19 rows=1 width=590) (actual rows= loops=)

  • Sort Key: created_at DESC, id DESC
3. 0.000 0.000 ↓ 0.0

Index Scan using index_requirements_on_project_id_and_iid on requirements (cost=0.14..2.17 rows=1 width=590) (actual rows= loops=)

  • Index Cond: (project_id = 27)
  • Filter: (((title)::text ~~* '%make%'::text) AND ((title)::text ~~* '%more%'::text) AND ((title)::text ~~* '%betterer%'::text) AND (author_id = 1))