explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UGoG

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 3.016 1,670.986 ↓ 1.7 56 1

Nested Loop (cost=0.43..181,461.10 rows=33 width=971) (actual time=87.409..1,670.986 rows=56 loops=1)

  • -> Index Scan using index_uploads_on_model_id_and_model_type on uploads (cost=0.43..10.81 rows=6 width=204) (actual time=
2. 1,667.970 1,667.970 ↓ 1.1 129 1

Seq Scan on projects (cost=0.00..180,233.11 rows=113 width=767) (actual time=3.004..1,667.970 rows=129 loops=1)

  • Filter: ((storage_version < 1) OR (storage_version IS NULL))
  • Rows Removed by Filter: 3071659
  • Index Cond: ((model_id = projects.id) AND ((model_type)::text = 'Project'::text))
Planning time : 0.979 ms
Execution time : 1,671.127 ms