explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O9MM

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 23,639.230 ↓ 20.0 20 1

Limit (cost=1,022.22..1,022.22 rows=1 width=776) (actual time=23,639.209..23,639.230 rows=20 loops=1)

2. 3.883 23,639.219 ↓ 20.0 20 1

Sort (cost=1,022.22..1,022.22 rows=1 width=776) (actual time=23,639.208..23,639.219 rows=20 loops=1)

  • Sort Key: issues.updated_at DESC, issues.id DESC
  • Sort Method: top-N heapsort Memory: 38kB
3. 3.406 23,635.336 ↓ 1,251.0 1,251 1

Nested Loop Semi Join (cost=957.83..1,022.21 rows=1 width=776) (actual time=205.636..23,635.336 rows=1,251 loops=1)

4. 23,464.081 23,624.424 ↓ 1,251.0 1,251 1

Bitmap Heap Scan on issues (cost=957.40..1,018.74 rows=1 width=776) (actual time=205.559..23,624.424 rows=1,251 loops=1)

  • Recheck Cond: ((((title)::text ~~* '%ldap%'::text) AND ((title)::text ~~* '%fail%'::text)) OR ((description ~~* '%ldap%'::text) AND (description ~~* '%fail%'::text)))
  • Rows Removed by Index Recheck: 42968
  • Filter: ((confidential IS NOT TRUE) AND (project_id = 13083))
  • Rows Removed by Filter: 4020
  • Heap Blocks: exact=39029
5. 0.003 160.343 ↓ 0.0 0 1

BitmapOr (cost=957.40..957.40 rows=40 width=0) (actual time=160.342..160.343 rows=0 loops=1)

6. 42.820 42.820 ↓ 15.1 271 1

Bitmap Index Scan on index_issues_on_title_trigram (cost=0.00..645.18 rows=18 width=0) (actual time=42.820..42.820 rows=271 loops=1)

  • Index Cond: (((title)::text ~~* '%ldap%'::text) AND ((title)::text ~~* '%fail%'::text))
7. 117.520 117.520 ↓ 2,187.9 48,133 1

Bitmap Index Scan on index_issues_on_description_trigram (cost=0.00..312.22 rows=22 width=0) (actual time=117.519..117.520 rows=48,133 loops=1)

  • Index Cond: ((description ~~* '%ldap%'::text) AND (description ~~* '%fail%'::text))
8. 7.506 7.506 ↑ 1.0 1 1,251

Index Only Scan using projects_pkey on projects (cost=0.43..3.45 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=1,251)

  • Index Cond: (id = 13083)
  • Heap Fetches: 0
Planning time : 33.476 ms
Execution time : 23,639.650 ms