explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fJTv

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.309 ↑ 1.0 1 1

Sort (cost=17.07..17.08 rows=1 width=52) (actual time=0.309..0.309 rows=1 loops=1)

  • Sort Key: ((((((task_m.taskownerbeard)::text || '%'::text) || (task.processtype)::text) || '%'::text) || (subform.objectid)::tex
  • Sort Method: quicksort Memory: 25kB
2. 0.027 0.298 ↑ 1.0 1 1

Nested Loop (cost=9.83..17.06 rows=1 width=52) (actual time=0.262..0.298 rows=1 loops=1)

  • -> Index Scan using u_5854_0 on idc_task task (cost=0.14..1.98 rows=1 width=22) (actual time=0.016..0.017 rows=1 loops=1
3. 0.028 0.271 ↑ 1.0 1 1

Hash Join (cost=9.69..15.00 rows=1 width=125) (actual time=0.236..0.271 rows=1 loops=1)

  • Hash Cond: (task_m.owner = subform.id)
  • Index Cond: (id = task_m.owner)
  • Filter: ((processtype)::text = 'signature'::text)
4. 0.084 0.084 ↑ 1.0 57 1

Seq Scan on idc_task_m task_m (cost=0.00..5.15 rows=57 width=59) (actual time=0.024..0.084 rows=57 loops=1)

  • Filter: ((taskownerbeard)::text = '44257A620030E342:476170278FED97DCC3257D7B0042EFDFX'::text)
  • Rows Removed by Filter: 35
5. 0.159 0.159 ↑ 1.0 1 1

Hash (cost=9.68..9.68 rows=1 width=66) (actual time=0.159..0.159 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • -> Seq Scan on idc_appliedobjlnksubform subform (cost=0.00..9.68 rows=1 width=66) (actual time=0.096..0.153
  • Filter: ((met <> 1) AND ((objectid)::text = '43257F18003FA18B:3C840E5BD0E8BD384325839B003FFDC4'::text))
  • Rows Removed by Filter: 113