explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GfAT

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 133.952 ↑ 1.0 100 1

Limit (cost=1.00..14,128.62 rows=100 width=763) (actual time=3.551..133.952 rows=100 loops=1)

2. 0.877 133.933 ↑ 502.3 100 1

Nested Loop Semi Join (cost=1.00..7,096,730.53 rows=50,233 width=763) (actual time=3.549..133.933 rows=100 loops=1)

  • Join Filter: (repository_languages.programming_language_id = programming_languages.id)
  • Rows Removed by Join Filter: 1471
3. 28.684 133.056 ↑ 8,825.1 1,571 1

Nested Loop (cost=1.00..6,888,749.79 rows=13,864,286 width=767) (actual time=1.406..133.056 rows=1,571 loops=1)

  • -> Index Only Scan using index_repository_languages_on_project_and_languages_id on repository_languages (cost=0.43..0.50 rows=3 width=8) (actual time=0.002..0.002 rows=0 loop
4. 104.372 104.372 ↑ 793.3 14,208 1

Index Scan using index_projects_on_created_at_and_id on projects (cost=0.56..958,880.48 rows=11,271,389 width=763) (actual time=0.100..104.372 rows=14,208 loops=1)

  • Index Cond: (project_id = projects.id)
  • Heap Fetches: 483
5. 0.000 0.000 ↑ 1.0 1 1,571

Materialize (cost=0.00..16.45 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1,571)

6. 0.240 0.240 ↑ 1.0 1 1

Seq Scan on programming_languages (cost=0.00..16.45 rows=1 width=4) (actual time=0.035..0.240 rows=1 loops=1)

  • Filter: ((name)::text ~~* 'ruby'::text)
  • Rows Removed by Filter: 355
Planning time : 8.770 ms
Execution time : 134.128 ms