explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lEno

Settings
# exclusive inclusive rows x rows loops node
1. 175,082.076 183,449.152 ↓ 0.0 0 1

Update on work_units w (cost=0.56..115,228.75 rows=1 width=210) (actual time=183,449.152..183,449.152 rows=0 loops=1)

2. 40.979 8,367.076 ↓ 19,482.0 19,482 1

Nested Loop (cost=0.56..115,228.75 rows=1 width=210) (actual time=3.147..8,367.076 rows=19,482 loops=1)

3. 65.729 65.729 ↑ 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.030..65.729 rows=19,482 loops=1)

4. 8,260.368 8,260.368 ↑ 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.304..0.424 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 : 2.110 ms
Execution time : 183,449.343 ms