explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fkx2 : Optimization for: plan #UGoG

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.817 1,605.222 ↓ 1.9 49 1

Nested Loop (cost=0.43..181,461.67 rows=26 width=971) (actual time=98.612..1,605.222 rows=49 loops=1)

2. 1,602.212 1,602.212 ↓ 1.1 129 1

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

  • Filter: ((storage_version < 1) OR (storage_version IS NULL))
  • Rows Removed by Filter: 3071655
3. 2.193 2.193 ↓ 0.0 0 129

Index Scan using index_uploads_on_model_id_and_model_type on uploads (cost=0.43..10.82 rows=5 width=204) (actual time=0.017..0.017 rows=0 loops=129)

  • Index Cond: ((model_id = projects.id) AND ((model_type)::text = 'Project'::text))
  • Filter: (store = 1)
  • Rows Removed by Filter: 0
Planning time : 1.112 ms
Execution time : 1,605.320 ms