explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TEgZ

Settings
# exclusive inclusive rows x rows loops node
1. 101.453 183.199 ↑ 1.0 65,649 1

Hash Join (cost=815.42..3,900.62 rows=67,062 width=16) (actual time=38.380..183.199 rows=65,649 loops=1)

  • Output: rte.id
  • Hash Cond: (rte.parent_id = rt.id)
  • Buffers: shared hit=1480
2. 43.419 43.419 ↑ 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.009..43.419 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.141 38.327 ↑ 1.0 21,883 1

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

  • Output: rt.id
  • Buckets: 4096 Batches: 1 Memory Usage: 1026kB
  • Buffers: shared hit=323
4. 19.186 19.186 ↑ 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.008..19.186 rows=21,883 loops=1)

  • Output: rt.id
  • Filter: (NOT rt.del_rec)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=323