explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0EKt

Settings
# exclusive inclusive rows x rows loops node
1. 15,021.585 15,678.513 ↓ 9.7 65,584 1

Hash Join (cost=5,917.90..76,184.77 rows=6,749 width=130) (actual time=204.382..15,678.513 rows=65,584 loops=1)

  • Output: rte.id, rte.parent_id, rt.id, rte.work_status, rte.complete_date, 0, ((xpath('//Reason/text()'::text, borte.data, '{}'::text[]))[1])::text, rte.is_inner, rte.index_in_task, rte.executer_id, rte.enterprise_id, rte.svod, ((xpath('//ExecuterName/tex (...)
  • Hash Cond: (rt.parent_id = r.id)
  • Buffers: shared hit=29255
2. 126.448 619.609 ↓ 9.7 65,649 1

Hash Join (cost=4,963.90..75,002.69 rows=6,784 width=146) (actual time=166.694..619.609 rows=65,649 loops=1)

  • Output: rt.id, rt.parent_id, rte.id, rte.parent_id, rte.work_status, rte.complete_date, rte.is_inner, rte.index_in_task, rte.executer_id, rte.enterprise_id, rte.svod, borte.data
  • Hash Cond: (rte.parent_id = rt.id)
  • Buffers: shared hit=28785
3. 205.594 459.425 ↓ 9.8 66,330 1

Hash Join (cost=4,145.44..74,057.02 rows=6,785 width=114) (actual time=132.887..459.425 rows=66,330 loops=1)

  • Output: rte.id, rte.parent_id, rte.work_status, rte.complete_date, rte.is_inner, rte.index_in_task, rte.executer_id, rte.enterprise_id, rte.svod, borte.data
  • Hash Cond: (borte.id = rte.id)
  • Buffers: shared hit=28462
4. 126.986 136.450 ↓ 1.0 66,330 1

Bitmap Heap Scan on public.t_docflow_businessobjects borte (cost=1,479.35..70,518.36 rows=64,377 width=48) (actual time=15.444..136.450 rows=66,330 loops=1)

  • Output: borte.id, borte.parent_id, borte.business_object_type, borte.typeof, borte.data, borte.user_id, borte.rec_date, borte.status, borte.del_rec
  • Recheck Cond: (borte.business_object_type = 102)
  • Heap Blocks: exact=27056
  • Buffers: shared hit=27305
5. 9.464 9.464 ↓ 1.0 66,330 1

Bitmap Index Scan on t_docflow_businessobjects_business_object_type_idx (cost=0.00..1,463.25 rows=64,377 width=0) (actual time=9.464..9.464 rows=66,330 loops=1)

  • Index Cond: (borte.business_object_type = 102)
  • Buffers: shared hit=249
6. 61.966 117.381 ↑ 1.0 66,330 1

Hash (cost=1,827.71..1,827.71 rows=67,071 width=82) (actual time=117.381..117.381 rows=66,330 loops=1)

  • Output: rte.id, rte.parent_id, rte.work_status, rte.complete_date, rte.is_inner, rte.index_in_task, rte.executer_id, rte.enterprise_id, rte.svod
  • Buckets: 8192 Batches: 1 Memory Usage: 7604kB
  • Buffers: shared hit=1157
7. 55.415 55.415 ↑ 1.0 66,330 1

Seq Scan on public.t_resolution_task_executer rte (cost=0.00..1,827.71 rows=67,071 width=82) (actual time=0.009..55.415 rows=66,330 loops=1)

  • Output: rte.id, rte.parent_id, rte.work_status, rte.complete_date, rte.is_inner, rte.index_in_task, rte.executer_id, rte.enterprise_id, rte.svod
  • Buffers: shared hit=1157
8. 17.044 33.736 ↑ 1.0 21,883 1

Hash (cost=543.22..543.22 rows=22,019 width=32) (actual time=33.736..33.736 rows=21,883 loops=1)

  • Output: rt.id, rt.parent_id
  • Buckets: 4096 Batches: 1 Memory Usage: 1368kB
  • Buffers: shared hit=323
9. 16.692 16.692 ↑ 1.0 21,883 1

Seq Scan on public.t_resolution_task rt (cost=0.00..543.22 rows=22,019 width=32) (actual time=0.009..16.692 rows=21,883 loops=1)

  • Output: rt.id, rt.parent_id
  • Filter: (NOT rt.del_rec)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=323
10. 18.084 37.319 ↑ 1.0 21,473 1

Hash (cost=685.14..685.14 rows=21,509 width=16) (actual time=37.319..37.319 rows=21,473 loops=1)

  • Output: r.id
  • Buckets: 4096 Batches: 1 Memory Usage: 1007kB
  • Buffers: shared hit=470
11. 19.235 19.235 ↑ 1.0 21,473 1

Seq Scan on public.t_resolution r (cost=0.00..685.14 rows=21,509 width=16) (actual time=0.009..19.235 rows=21,473 loops=1)

  • Output: r.id
  • Filter: (NOT r.del_rec)
  • Rows Removed by Filter: 9
  • Buffers: shared hit=470