explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5l07

Settings
# exclusive inclusive rows x rows loops node
1. 67.234 3,439.061 ↓ 7.4 50,000 1

Limit (cost=5,914.87..76,097.79 rows=6,783 width=130) (actual time=203.891..3,439.061 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
  • Buffers: shared hit=24978
2. 2,815.876 3,371.827 ↓ 7.4 50,000 1

Hash Join (cost=5,914.87..76,097.79 rows=6,783 width=130) (actual time=203.888..3,371.827 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
  • Hash Cond: (rt.parent_id = r.id)
  • Buffers: shared hit=24978
3. 99.396 521.584 ↓ 7.4 50,060 1

Hash Join (cost=4,960.86..74,999.65 rows=6,784 width=146) (actual time=169.341..521.584 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. 158.374 387.650 ↓ 7.5 50,615 1

Hash Join (cost=4,145.44..74,057.02 rows=6,785 width=114) (actual time=134.738..387.650 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. 100.634 110.424 ↑ 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.822..110.424 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.790 9.790 ↓ 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.790..9.790 rows=66,330 loops=1)

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

Hash (cost=1,827.71..1,827.71 rows=67,071 width=82) (actual time=118.852..118.852 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. 56.203 56.203 ↑ 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.011..56.203 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.217 34.538 ↑ 1.0 21,883 1

Hash (cost=541.87..541.87 rows=21,884 width=32) (actual time=34.538..34.538 rows=21,883 loops=1)

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

Seq Scan on public.t_resolution_task rt (cost=0.00..541.87 rows=21,884 width=32) (actual time=0.007..17.321 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. 16.756 34.367 ↑ 1.0 21,473 1

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

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

  • Output: r.id
  • Filter: (NOT r.del_rec)
  • Rows Removed by Filter: 9
  • Buffers: shared hit=470
Planning time : 1.220 ms
Execution time : 3,475.191 ms