explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sc0p : Optimization for: plan #01Tp

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Update on ri_work_metadata m (cost=0.56..17,061.08 rows=1,990 width=1,753) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..17,061.08 rows=1,990 width=1,753) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on ri_righted_works_delta d (cost=0.00..29.90 rows=1,990 width=10) (actual rows= loops=)

  • Filter: has_rights_flag
4. 0.000 0.000 ↓ 0.0

Index Scan using pk_ri_work_metadata_subset on ri_work_metadata m (cost=0.56..8.56 rows=1 width=1,734) (actual rows= loops=)