explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OP49

Settings
# exclusive inclusive rows x rows loops node
1. 178,315.482 178,972.560 ↓ 0.0 0 1

Update on work_units w (cost=0.56..115,145.04 rows=1 width=210) (actual time=178,972.560..178,972.560 rows=0 loops=1)

2. 42.515 657.078 ↓ 19,482.0 19,482 1

Nested Loop (cost=0.56..115,145.04 rows=1 width=210) (actual time=0.065..657.078 rows=19,482 loops=1)

3. 69.067 69.067 ↑ 1.3 19,482 1

Seq Scan on bt_test s (cost=0.00..1,753.83 rows=25,483 width=434) (actual time=0.027..69.067 rows=19,482 loops=1)

4. 545.496 545.496 ↑ 1.0 1 19,482

Index Scan using work_units_natural_key_index on work_units w (cost=0.56..4.44 rows=1 width=132) (actual time=0.026..0.028 rows=1 loops=19,482)

  • Index Cond: ((tenant_id = s.tenant_id) AND ((business_interval)::text = (s.business_interval)::text) AND (work_unit_definition_id = s.work_unit_definition_id) AND ((work_unit_id)::text = (s.work_unit_id)::text))
  • Filter: ((s.work_unit_definition_version_id = work_unit_definition_version_id) AND (s.dimensions = dimensions) AND (s.state = state) AND (knowledge_range_utc @> lower(s.knowledge_range_utc)))
Planning time : 0.479 ms
Execution time : 178,972.776 ms