explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tamb

Settings
# exclusive inclusive rows x rows loops node
1. 66.560 11,998.443 ↓ 7.4 50,000 1

Limit (cost=5,917.90..76,184.77 rows=6,749 width=130) (actual time=206.246..11,998.443 rows=50,000 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('//ExecuterNam (...)
  • Buffers: shared hit=24978
2. 11,371.577 11,931.883 ↓ 7.4 50,000 1

Hash Join (cost=5,917.90..76,184.77 rows=6,749 width=130) (actual time=206.243..11,931.883 rows=50,000 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('//ExecuterNa (...)
  • Hash Cond: (rt.parent_id = r.id)
  • Buffers: shared hit=24978
3. 97.035 522.634 ↓ 7.4 50,060 1

Hash Join (cost=4,963.90..75,002.69 rows=6,784 width=146) (actual time=168.189..522.634 rows=50,060 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=24508
4. 159.320 391.680 ↓ 7.5 50,615 1

Hash Join (cost=4,145.44..74,057.02 rows=6,785 width=114) (actual time=134.202..391.680 rows=50,615 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=24185
5. 104.205 113.746 ↑ 1.3 50,615 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.527..113.746 rows=50,615 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=22779
  • Buffers: shared hit=23028
6. 9.541 9.541 ↓ 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.541..9.541 rows=66,330 loops=1)

  • Index Cond: (borte.business_object_type = 102)
  • Buffers: shared hit=249
7. 62.807 118.614 ↑ 1.0 66,330 1

Hash (cost=1,827.71..1,827.71 rows=67,071 width=82) (actual time=118.614..118.614 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
8. 55.807 55.807 ↑ 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.010..55.807 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
9. 17.067 33.919 ↑ 1.0 21,883 1

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

  • Output: rt.id, rt.parent_id
  • Buckets: 4096 Batches: 1 Memory Usage: 1368kB
  • Buffers: shared hit=323
10. 16.852 16.852 ↑ 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.852 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
11. 18.050 37.672 ↑ 1.0 21,473 1

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

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

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