explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H21T

Settings
# exclusive inclusive rows x rows loops node
1. 0.054 36.595 ↑ 1.0 10 1

Limit (cost=12,487.97..12,487.99 rows=10 width=793) (actual time=36.543..36.595 rows=10 loops=1)

  • Buffers: shared hit=59380 dirtied=20
2. 2.363 36.541 ↑ 969.8 12 1

Sort (cost=12,487.96..12,517.05 rows=11,637 width=793) (actual time=36.540..36.541 rows=12 loops=1)

  • Sort Method: top-N heapsort Memory: 37kB
  • Buffers: shared hit=59380 dirtied=20
3. 5.547 34.178 ↑ 1.9 6,168 1

WindowAgg (cost=1,000.84..12,221.19 rows=11,637 width=793) (actual time=32.361..34.178 rows=6,168 loops=1)

  • Buffers: shared hit=59380 dirtied=20
4. 5.562 28.631 ↑ 1.9 6,168 1

Gather (cost=1,000.84..12,046.63 rows=11,637 width=785) (actual time=1.978..28.631 rows=6,168 loops=1)

  • Buffers: shared hit=59380 dirtied=20
5. 8.901 23.069 ↑ 2.4 2,056 3

Nested Loop (cost=0.84..9,882.93 rows=4,849 width=785) (actual time=0.882..23.069 rows=2,056 loops=3)

  • Buffers: shared hit=59380 dirtied=20
6. 14.164 14.164 ↑ 2.4 2,056 3

Index Scan using ix_orch_tsk_all_qid_st_sid_tid on etm_task_alloc_info ta (cost=0.42..3,856.40 rows=4,849 width=142) (actual time=0.845..14.164 rows=2,056 loops=3)

  • Index Cond: ((ta.queue_id = 4) AND ((ta.work_status)::text = 'ASSIGNED'::text))
  • Filter: ((ta.scope_id)::text = ANY ('{41296,41298,41300,41302,41000}'::text[]))
  • Buffers: shared hit=34681 dirtied=20
7. 0.004 0.004 ↑ 1.0 1 6,168

Index Scan using etm_task_basic_info_pkey on etm_task_basic_info tbi (cost=0.42..1.24 rows=1 width=647) (actual time=0.004..0.004 rows=1 loops=6,168)

  • Index Cond: (tbi.task_id = ta.task_id)
  • 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=24699