explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VmQA

Settings
# exclusive inclusive rows x rows loops node
1. 1.358 710.448 ↑ 1.0 1,000 1

Limit (cost=6,765.26..27,413.48 rows=1,000 width=154) (actual time=462.321..710.448 rows=1,000 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:: (...)
  • Buffers: shared hit=67393
2.          

CTE resolution_ids

3. 39.015 94.531 ↑ 1.0 21,870 1

Hash Join (cost=954.00..1,908.92 rows=21,903 width=16) (actual time=37.982..94.531 rows=21,870 loops=1)

  • Output: r.id
  • Hash Cond: (rt_1.parent_id = r.id)
  • Buffers: shared hit=793
4. 17.574 17.574 ↑ 1.0 21,883 1

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

  • Output: rt_1.id, rt_1.parent_id, rt_1.bo_type, rt_1.rec_date, rt_1.del_rec, rt_1.outer_limit, rt_1.inner_limit, rt_1.outer_ex_limit, rt_1.prolongation_date, rt_1.svod_limit, rt_1.control_type, rt_1.periodicity, rt_1.period_end_date, rt_1.wo (...)
  • Filter: (NOT rt_1.del_rec)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=323
5. 18.352 37.942 ↑ 1.0 21,473 1

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

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

  • Output: r.id
  • Filter: (NOT r.del_rec)
  • Rows Removed by Filter: 9
  • Buffers: shared hit=470
7. 241.335 709.090 ↑ 3.4 1,000 1

Hash Join (cost=4,856.34..74,895.12 rows=3,392 width=154) (actual time=462.318..709.090 rows=1,000 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, NU (...)
  • Hash Cond: (rte.parent_id = rt.id)
  • Buffers: shared hit=67393
8. 3.528 138.696 ↑ 5.9 1,141 1

Hash Join (cost=4,145.44..74,057.02 rows=6,785 width=114) (actual time=132.861..138.696 rows=1,141 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=1999
9. 8.372 17.984 ↑ 56.4 1,141 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.608..17.984 rows=1,141 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=593
  • Buffers: shared hit=842
10. 9.612 9.612 ↓ 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.612..9.612 rows=66,330 loops=1)

  • Index Cond: (borte.business_object_type = 102)
  • Buffers: shared hit=249
11. 61.647 117.184 ↑ 1.0 66,330 1

Hash (cost=1,827.71..1,827.71 rows=67,071 width=82) (actual time=117.184..117.184 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
12. 55.537 55.537 ↑ 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.020..55.537 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
13. 19.795 329.059 ↓ 2.0 21,873 1

Hash (cost=573.26..573.26 rows=11,011 width=40) (actual time=329.059..329.059 rows=21,873 loops=1)

  • Output: rt.id, rt.prolongation_date, rt.outer_limit, rt.inner_limit
  • Buckets: 2048 Batches: 1 Memory Usage: 1107kB
  • Buffers: shared hit=65394
14. 56.769 309.264 ↓ 2.0 21,873 1

Nested Loop (cost=493.11..573.26 rows=11,011 width=40) (actual time=148.381..309.264 rows=21,873 loops=1)

  • Output: rt.id, rt.prolongation_date, rt.outer_limit, rt.inner_limit
  • Buffers: shared hit=65394
15. 40.323 166.611 ↓ 107.4 21,471 1

HashAggregate (cost=492.82..494.82 rows=200 width=16) (actual time=148.359..166.611 rows=21,471 loops=1)

  • Output: resolution_ids.id
  • Group Key: resolution_ids.id
  • Buffers: shared hit=793
16. 126.288 126.288 ↑ 1.0 21,870 1

CTE Scan on resolution_ids (cost=0.00..438.06 rows=21,903 width=16) (actual time=37.987..126.288 rows=21,870 loops=1)

  • Output: resolution_ids.id
  • Buffers: shared hit=793
17. 85.884 85.884 ↑ 1.0 1 21,471

Index Scan using t_resolution_task_parent_id_idx on public.t_resolution_task rt (cost=0.29..0.38 rows=1 width=56) (actual time=0.003..0.004 rows=1 loops=21,471)

  • Output: rt.id, rt.parent_id, rt.bo_type, rt.rec_date, rt.del_rec, rt.outer_limit, rt.inner_limit, rt.outer_ex_limit, rt.prolongation_date, rt.svod_limit, rt.control_type, rt.periodicity, rt.period_end_date, rt.work_status, rt.exec (...)
  • Index Cond: (rt.parent_id = resolution_ids.id)
  • Buffers: shared hit=64601
Planning time : 1.836 ms
Execution time : 714.418 ms