explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yp14

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 101.076 ↑ 1.0 100 1

Limit (cost=1.00..14,128.63 rows=100 width=763) (actual time=0.684..101.076 rows=100 loops=1)

2. 1.795 101.050 ↑ 502.3 100 1

Nested Loop Semi Join (cost=1.00..7,096,733.53 rows=50,233 width=763) (actual time=0.683..101.050 rows=100 loops=1)

  • Join Filter: (repository_languages.programming_language_id = programming_languages.id)
  • Rows Removed by Join Filter: 4329
3. 55.147 99.255 ↑ 3,130.3 4,429 1

Nested Loop (cost=1.00..6,888,752.79 rows=13,864,286 width=767) (actual time=0.641..99.255 rows=4,429 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.008..0.017 rows=1 loop
4. 44.108 44.108 ↑ 3,605.7 3,126 1

Index Scan Backward using index_projects_on_created_at_and_id on projects (cost=0.56..958,881.98 rows=11,271,389 width=763) (actual time=0.064..44.108 rows=3,126 loops=1)

  • Index Cond: (project_id = projects.id)
  • Heap Fetches: 4992
5. 0.000 0.000 ↑ 1.0 1 4,429

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

6. 0.220 0.220 ↑ 1.0 1 1

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

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