explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9eU0

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

CTE Scan on project_notes (cost=49,960.17..51,013.99 rows=1 width=2,382) (actual time=229.588..229.588 rows=0 loops=1)

  • Filter: ((note ~~* '%mattermost%'::text) AND (note ~~* '%connection%'::text) AND (note ~~* '%sting%'::text))
  • Rows Removed by Filter: 12,538
2.          

CTE project_notes

3. 184.692 184.692 ↑ 3.1 12,538 1

Index Scan using index_notes_on_project_id_and_noteable_type on notes (cost=0.57..49,960.17 rows=38,321 width=2,444) (actual time=0.195..184.692 rows=12,538 loops=1)

  • Index Cond: ((project_id = 278,964) AND ((noteable_type)::text = 'Commit'::text))
Planning time : 6.589 ms
Execution time : 232.659 ms