explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9eFa

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.812 ↑ 1.2 236 1

Limit (cost=761.80..762.50 rows=277 width=12) (actual time=0.779..0.812 rows=236 loops=1)

2. 0.061 0.797 ↑ 1.2 236 1

Sort (cost=761.80..762.50 rows=277 width=12) (actual time=0.777..0.797 rows=236 loops=1)

  • Sort Key: projects.last_repository_updated_at
  • Sort Method: quicksort Memory: 36kB
3. 0.663 0.736 ↑ 1.2 236 1

Nested Loop (cost=0.70..750.57 rows=277 width=12) (actual time=0.021..0.736 rows=236 loops=1)

  • -> Index Only Scan using idx_projects_on_repository_storage_last_repository_updated_at on projects (cost=0.56..2.62 rows=1 width=12) (actual time=0.002..0.003 rows=1 loops=2
4. 0.073 0.073 ↑ 1.2 236 1

Index Only Scan using dbalexandre_tmp1 on project_repository_states (cost=0.14..22.52 rows=277 width=4) (actual time=0.014..0.073 rows=236 loops=1)

  • Filter: ((last_repository_verification_at IS NULL) OR (last_repository_verification_at <= '2018-11-26 20:23:41.997419+00'::timestamp with time zone))
  • Heap Fetches: 0
  • Index Cond: (id = project_repository_states.project_id)
  • Heap Fetches: 10