explain.depesz.com

PostgreSQL's explain analyze made readable

Result: da0A

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 853.268 ↓ 0.0 0 1

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

2. 0.017 853.264 ↓ 0.0 0 1

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

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

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

  • Group Key: t_sys_users.c_userid
4. 0.011 853.235 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,000.70..119,915.45 rows=2 width=33) (actual time=853.234..853.235 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.008 853.224 ↓ 0.0 0 1

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

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

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

  • Join Filter: (t_e20so1_document_text_history.c_createdby = t_sys_users.c_userid)
7. 0.099 0.099 ↓ 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.015..0.099 rows=48 loops=1)

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

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

9. 0.000 852.991 ↓ 0.0 0 1

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

10. 0.834 853.159 ↓ 0.0 0 1

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

  • Workers Planned: 5
  • Workers Launched: 0
11. 852.325 852.325 ↓ 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=852.324..852.325 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)