explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LKMl

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 846.337 ↓ 0.0 0 1

Limit (cost=119,915.46..119,915.47 rows=2 width=33) (actual time=846.336..846.337 rows=0 loops=1)

2. 0.008 846.334 ↓ 0.0 0 1

Sort (cost=119,915.46..119,915.47 rows=2 width=33) (actual time=846.334..846.334 rows=0 loops=1)

  • Sort Key: t_sys_users.c_username NULLS FIRST
  • Sort Method: quicksort Memory: 25kB
3. 0.002 846.326 ↓ 0.0 0 1

Group (cost=1,000.70..119,915.45 rows=2 width=33) (actual time=846.325..846.326 rows=0 loops=1)

  • Group Key: t_sys_users.c_userid
4. 0.002 846.324 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,000.70..119,915.45 rows=2 width=33) (actual time=846.323..846.324 rows=0 loops=1)

  • Join Filter: (t_sys_fieldpermission.c_fieldschemaid = t_e20so1_document_text_history.c_fieldsid)
  • Filter: (((t_sys_fieldpermission.c_roleid = 2) AND t_sys_fieldpermission.c_isdisplay) OR (t_e20so1_fielddetails.c_isprivate AND (t_e20so1_fielddetails.c_createdby = 71939)))
5. 0.002 846.322 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,000.70..119,493.78 rows=1 width=58) (actual time=846.321..846.322 rows=0 loops=1)

  • Join Filter: (t_e20so1_fielddetails.c_fieldschemaid = t_e20so1_document_text_history.c_fieldsid)
6. 0.075 846.320 ↓ 0.0 0 1

Nested Loop (cost=1,000.70..119,284.46 rows=1 width=49) (actual time=846.320..846.320 rows=0 loops=1)

  • Join Filter: (t_e20so1_document_text_history.c_createdby = t_sys_users.c_userid)
7. 0.053 0.053 ↓ 1.1 48 1

Index Scan using pk_sys_users on t_sys_users (cost=0.14..4.21 rows=44 width=33) (actual time=0.007..0.053 rows=48 loops=1)

  • Index Cond: (c_userid IS NOT NULL)
8. 0.038 846.192 ↓ 0.0 0 48

Materialize (cost=1,000.56..119,279.59 rows=1 width=24) (actual time=17.629..17.629 rows=0 loops=48)

9. 0.000 846.154 ↓ 0.0 0 1

Nested Loop (cost=1,000.56..119,279.59 rows=1 width=24) (actual time=846.153..846.154 rows=0 loops=1)

10. 0.454 846.236 ↓ 0.0 0 1

Gather (cost=1,000.00..119,277.89 rows=1 width=32) (actual time=846.151..846.236 rows=0 loops=1)

  • Workers Planned: 5
  • Workers Launched: 0
11. 845.782 845.782 ↓ 0.0 0 1

Parallel Seq Scan on t_e20so1_document_text_history (cost=0.00..118,277.79 rows=1 width=32) (actual time=845.782..845.782 rows=0 loops=1)

  • Filter: ((c_actiontype = 13) AND (c_tablegroupid = '222aad7c-b92d-4eeb-9b6b-8b4403378b7f'::uuid))
  • Rows Removed by Filter: 5278679
12. 0.000 0.000 ↓ 0.0 0

Append (cost=0.56..1.69 rows=1 width=8) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Only Scan using t_e20so1_document_datastore_2_pkey on t_e20so1_document_datastore_2 t_e20so1_document (cost=0.56..1.68 rows=1 width=8) (never executed)

  • Index Cond: ((c_documentid = t_e20so1_document_text_history.c_docid) AND (c_datastoresid = 2))
  • Heap Fetches: 0
14. 0.000 0.000 ↓ 0.0 0

Seq Scan on t_e20so1_fielddetails (cost=0.00..144.70 rows=5,170 width=25) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Seq Scan on t_sys_fieldpermission (cost=0.00..262.15 rows=9,115 width=25) (never executed)