explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RRB5

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 358.822 ↑ 1.0 10 1

Limit (cost=19.97..115.63 rows=10 width=793) (actual time=358.817..358.822 rows=10 loops=1)

  • Buffers: shared hit=870800
2. 3.845 358.818 ↑ 953.0 12 1

WindowAgg (cost=0.84..109,393.12 rows=11,436 width=793) (actual time=358.814..358.818 rows=12 loops=1)

  • Buffers: shared hit=870800
3. 54.053 354.973 ↑ 1.9 6,168 1

Nested Loop (cost=0.84..109,221.58 rows=11,436 width=785) (actual time=2.492..354.973 rows=6,168 loops=1)

  • Buffers: shared hit=870800
4. 124.922 124.922 ↑ 1.0 175,998 1

Index Scan using test_etm_task_basic_info on etm_task_basic_info tbi (cost=0.42..22,644.78 rows=176,017 width=647) (actual time=0.032..124.922 rows=175,998 loops=1)

  • Filter: ((((tbi.last_mod_by)::text <> 'AdminUser-'::text) OR (tbi.last_mod_by IS NULL)) AND ((tbi.correlation_ty)::text = ANY ('{ RoleUI_Type,SystemPolicy_Type,User_Type}'::text[])))
  • Buffers: shared hit=165851
5. 175.998 175.998 ↓ 0.0 0 175,998

Index Scan using ix_orch_task_alloc_tid on etm_task_alloc_info ta (cost=0.42..0.48 rows=1 width=142) (actual time=0.001..0.001 rows=0 loops=175,998)

  • Index Cond: (ta.task_id = tbi.task_id)
  • Filter: ((ta.queue_id = 4) AND ((ta.work_status)::text = 'ASSIGNED'::text) AND ((ta.scope_id)::text = ANY ('{41296,41298,41300,41302,41 000}'::text[])))
  • Buffers: shared hit=704949