explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MRWZ

Settings
# exclusive inclusive rows x rows loops node
1. 1.351 403.344 ↑ 1.0 1,000 1

Limit (cost=2,666.67..14,587.24 rows=1,000 width=154) (actual time=122.123..403.344 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=7596 read=188
2. 235.684 401.993 ↑ 6.7 1,000 1

Nested Loop (cost=2,666.67..83,118.58 rows=6,749 width=154) (actual time=122.120..401.993 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 (...)
  • Buffers: shared hit=7596 read=188
3. 3.857 160.309 ↑ 6.8 1,000 1

Nested Loop (cost=2,666.38..80,131.38 rows=6,784 width=170) (actual time=121.776..160.309 rows=1,000 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
  • Buffers: shared hit=4595 read=177
4. 3.181 149.452 ↑ 6.8 1,000 1

Hash Join (cost=2,666.10..77,791.01 rows=6,785 width=114) (actual time=121.751..149.452 rows=1,000 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=1608 read=164
5. 24.559 24.559 ↑ 64.4 1,000 1

Seq Scan on public.t_docflow_businessobjects borte (cost=0.00..74,252.35 rows=64,377 width=48) (actual time=0.006..24.559 rows=1,000 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
  • Filter: (borte.business_object_type = 102)
  • Rows Removed by Filter: 7261
  • Buffers: shared hit=451 read=164
6. 64.652 121.712 ↑ 1.0 66,330 1

Hash (cost=1,827.71..1,827.71 rows=67,071 width=82) (actual time=121.712..121.712 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. 57.060 57.060 ↑ 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.006..57.060 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. 7.000 7.000 ↑ 1.0 1 1,000

Index Scan using t_resolution_task_pkey on public.t_resolution_task rt (cost=0.29..0.33 rows=1 width=56) (actual time=0.007..0.007 rows=1 loops=1,000)

  • 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_date, (...)
  • Index Cond: (rt.id = rte.parent_id)
  • Filter: (NOT rt.del_rec)
  • Buffers: shared hit=2987 read=13
9. 6.000 6.000 ↑ 1.0 1 1,000

Index Scan using t_resolution_pkey on public.t_resolution r (cost=0.29..0.42 rows=1 width=16) (actual time=0.005..0.006 rows=1 loops=1,000)

  • Output: r.id, r.parent_id, r.bo_type, r.rec_date, r.del_rec, r.parent_executer_id, r.parent_resolution_id, r.controlling, r.created_by, r.signer_workplace_id, r.signer_enterprise_id, r.signer_employee_id, r.sender_id, r.resolution_date, r.is_ (...)
  • Index Cond: (r.id = rt.parent_id)
  • Filter: (NOT r.del_rec)
  • Buffers: shared hit=3001 read=11