explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kcEe

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

Hash Join (cost=5,917.90..76,184.77 rows=6,749 width=154) (actual time=214.437..15,770.542 rows=65,584 loops=1)

  • Output: rte.id, rte.parent_id, rt.id, NULL::unknown, NULL::unknown, NULL::unknown, NULL::unknown, rte.work_status, rte.complete_date, NULL::unknown, COALESCE(rt.prolongation_date, rt.outer_limit, rt.inner_limit), 0, NULL::unknown, NULL::unknown, NULL::un (...)
  • Hash Cond: (rt.parent_id = r.id)
  • Buffers: shared hit=29255
2. 131.257 636.952 ↓ 9.7 65,649 1

Hash Join (cost=4,963.90..75,002.69 rows=6,784 width=170) (actual time=175.149..636.952 rows=65,649 loops=1)

  • Output: rt.id, rt.prolongation_date, rt.outer_limit, rt.inner_limit, 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. 206.304 468.318 ↓ 9.8 66,330 1

Hash Join (cost=4,145.44..74,057.02 rows=6,785 width=114) (actual time=137.702..468.318 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. 131.833 143.230 ↓ 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=18.853..143.230 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. 11.397 11.397 ↓ 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=11.397..11.397 rows=66,330 loops=1)

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

Hash (cost=1,827.71..1,827.71 rows=67,071 width=82) (actual time=118.784..118.784 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.694 55.694 ↑ 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.008..55.694 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. 19.010 37.377 ↑ 1.0 21,883 1

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

  • Output: rt.id, rt.prolongation_date, rt.outer_limit, rt.inner_limit, rt.parent_id
  • Buckets: 4096 Batches: 1 Memory Usage: 1450kB
  • Buffers: shared hit=323
9. 18.367 18.367 ↑ 1.0 21,883 1

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

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

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

  • Output: r.id
  • Buckets: 4096 Batches: 1 Memory Usage: 1007kB
  • Buffers: shared hit=470
11. 20.144 20.144 ↑ 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..20.144 rows=21,473 loops=1)

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