explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WMey

Settings
# exclusive inclusive rows x rows loops node
1. 102.253 183.912 ↑ 1.0 65,649 1

Hash Join (cost=815.42..3,900.62 rows=67,062 width=32) (actual time=38.161..183.912 rows=65,649 loops=1)

  • Output: rte.id, rt.id
  • Hash Cond: (rte.parent_id = rt.id)
  • Buffers: shared hit=1480
2. 43.530 43.530 ↑ 1.0 66,330 1

Seq Scan on public.t_resolution_task_executer rte (cost=0.00..1,827.71 rows=67,071 width=32) (actual time=0.007..43.530 rows=66,330 loops=1)

  • Output: rte.id, rte.parent_id, rte.bo_type, rte.rec_date, rte.del_rec, rte.index_in_task, rte.is_inner, rte.executer_id, rte.enterprise_id, rte.work_status, rte.complete_date, rte.svod
  • Buffers: shared hit=1157
3. 19.022 38.129 ↑ 1.0 21,883 1

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

  • Output: rt.id
  • Buckets: 4096 Batches: 1 Memory Usage: 1026kB
  • Buffers: shared hit=323
4. 19.107 19.107 ↑ 1.0 21,883 1

Seq Scan on public.t_resolution_task rt (cost=0.00..541.87 rows=21,884 width=16) (actual time=0.007..19.107 rows=21,883 loops=1)

  • Output: rt.id
  • Filter: (NOT rt.del_rec)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=323
Planning time : 0.474 ms
Execution time : 223.440 ms