explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qYBj

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.019 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.99..16.16 rows=1 width=40) (actual time=0.011..0.019 rows=1 loops=1)

  • Join Filter: (task.id = task_with_task_hidden_property.task_id)
2.          

CTE task_with_task_hidden_property

3. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on task_property_value_assignment (cost=4.29..9.99 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (fk_property_id = 1)
  • Filter: is_valid_now(valid_from, valid_to)
4. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on ixfk_task_property_value_assignment_property (cost=0.00..4.29 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (fk_property_id = 1)
5. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on task (cost=0.00..6.14 rows=1 width=8) (actual time=0.003..0.011 rows=1 loops=1)

  • Filter: (id = 1)
  • Rows Removed by Filter: 105
6. 0.004 0.004 ↓ 0.0 0 1

CTE Scan on task_with_task_hidden_property (cost=0.00..0.02 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (task_id = 1)