explain.depesz.com

PostgreSQL's explain analyze made readable

Result: grrU

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,065.791 ↓ 4.0 4 1

Limit (cost=681,638.03..681,638.06 rows=1 width=64) (actual time=1,065.783..1,065.791 rows=4 loops=1)

2. 0.010 1,065.789 ↓ 4.0 4 1

Group (cost=681,638.03..681,638.06 rows=1 width=64) (actual time=1,065.782..1,065.789 rows=4 loops=1)

  • Group Key: (to_char((date(t_e20so1_document_boolean_history.c_createddate))::timestamp with time zone, 'MM/DD/YYYY'::text)), (to_char((date(t_e20so1_document_boolean_history.c_createddate))::timestamp with time zone, 'MM/DD/YYYY'::text))
3. 0.032 1,065.779 ↓ 7.0 14 1

Sort (cost=681,638.03..681,638.04 rows=2 width=64) (actual time=1,065.778..1,065.779 rows=14 loops=1)

  • Sort Key: (to_char((date(t_e20so1_document_boolean_history.c_createddate))::timestamp with time zone, 'MM/DD/YYYY'::text)) NULLS FIRST
  • Sort Method: quicksort Memory: 26kB
4. 13.584 1,065.747 ↓ 7.0 14 1

Nested Loop Left Join (cost=1,000.28..681,638.02 rows=2 width=64) (actual time=523.693..1,065.747 rows=14 loops=1)

  • Join Filter: (t_sys_fieldpermission.c_fieldschemaid = t_e20so1_document_boolean_history.c_fieldsid)
  • Rows Removed by Join Filter: 201609
  • 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)))
  • Rows Removed by Filter: 25
5. 20.445 1,022.056 ↓ 23.0 23 1

Nested Loop Left Join (cost=1,000.28..681,186.12 rows=1 width=33) (actual time=521.633..1,022.056 rows=23 loops=1)

  • Join Filter: (t_e20so1_fielddetails.c_fieldschemaid = t_e20so1_document_boolean_history.c_fieldsid)
  • Rows Removed by Join Filter: 202102
6. 0.000 983.533 ↓ 23.0 23 1

Nested Loop (cost=1,000.28..680,749.48 rows=1 width=24) (actual time=521.370..983.533 rows=23 loops=1)

7. 0.000 1,001.042 ↓ 72.0 72 1

Gather (cost=1,000.00..680,748.07 rows=1 width=32) (actual time=521.341..1,001.042 rows=72 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
8. 1,048.721 1,048.721 ↓ 10.0 10 7 / 7

Parallel Seq Scan on t_e20so1_document_boolean_history_issues t_e20so1_document_boolean_history (cost=0.00..679,747.97 rows=1 width=32) (actual time=593.978..1,048.721 rows=10 loops=7)

  • Filter: ((c_createddate IS NOT NULL) AND (c_actiontype = 9))
  • Rows Removed by Filter: 5255610
9. 0.072 0.288 ↓ 0.0 0 72

Append (cost=0.28..1.41 rows=1 width=8) (actual time=0.003..0.004 rows=0 loops=72)

10. 0.216 0.216 ↓ 0.0 0 72

Index Only Scan using t_e20so1_document_datastore_11_pkey on t_e20so1_document_datastore_11 t_e20so1_document (cost=0.28..1.40 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=72)

  • Index Cond: ((c_documentid = t_e20so1_document_boolean_history.c_docid) AND (c_datastoresid = 11))
  • Heap Fetches: 0
11. 18.078 18.078 ↓ 1.0 8,788 23

Seq Scan on t_e20so1_fielddetails (cost=0.00..326.84 rows=8,784 width=25) (actual time=0.002..0.786 rows=8,788 loops=23)

12. 30.107 30.107 ↓ 1.0 8,767 23

Seq Scan on t_sys_fieldpermission (cost=0.00..298.59 rows=8,759 width=25) (actual time=0.002..1.309 rows=8,767 loops=23)