explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m6gF

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 885.842 ↓ 0.0 0 1

Limit (cost=119,912.57..119,912.59 rows=2 width=33) (actual time=885.842..885.842 rows=0 loops=1)

2. 0.003 885.840 ↓ 0.0 0 1

Unique (cost=119,912.57..119,912.59 rows=2 width=33) (actual time=885.839..885.840 rows=0 loops=1)

3. 0.008 885.837 ↓ 0.0 0 1

Sort (cost=119,912.57..119,912.58 rows=2 width=33) (actual time=885.837..885.837 rows=0 loops=1)

  • Sort Key: t_sys_users.c_username NULLS FIRST, t_sys_users.c_userid
  • Sort Method: quicksort Memory: 25kB
4. 0.002 885.829 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,000.56..119,912.56 rows=2 width=33) (actual time=885.829..885.829 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.001 885.827 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,000.56..119,490.90 rows=1 width=58) (actual time=885.827..885.827 rows=0 loops=1)

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

Nested Loop (cost=1,000.56..119,281.58 rows=1 width=49) (actual time=885.825..885.826 rows=0 loops=1)

  • Join Filter: (t_e20so1_document_text_history.c_createdby = t_sys_users.c_userid)
7. 0.000 885.823 ↓ 0.0 0 1

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

8. 0.466 885.936 ↓ 0.0 0 1

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

  • Workers Planned: 5
  • Workers Launched: 0
9. 885.470 885.470 ↓ 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=885.470..885.470 rows=0 loops=1)

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

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

11. 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
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on t_sys_users (cost=0.00..1.44 rows=44 width=33) (never executed)

  • Filter: (c_userid IS NOT NULL)
13. 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)

14. 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)