explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BDoJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 1,031.359 ↑ 30.0 1 1

Limit (cost=449,298.28..449,298.36 rows=30 width=64) (actual time=1,031.356..1,031.359 rows=1 loops=1)

2. 0.013 1,031.354 ↑ 2,051.0 1 1

Sort (cost=449,298.28..449,303.41 rows=2,051 width=64) (actual time=1,031.352..1,031.354 rows=1 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: 25kB
3. 0.000 1,031.341 ↑ 2,051.0 1 1

HashAggregate (cost=449,186.43..449,237.70 rows=2,051 width=64) (actual time=1,031.323..1,031.341 rows=1 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))
4. 11.294 1,035.907 ↑ 20,485.5 10 1

Gather (cost=1,585.97..448,162.15 rows=204,855 width=64) (actual time=1,029.508..1,035.907 rows=10 loops=1)

  • Workers Planned: 6
  • Workers Launched: 4
5. 0.364 1,024.613 ↑ 17,071.0 2 5 / 5

Nested Loop (cost=585.97..426,676.65 rows=34,142 width=64) (actual time=1,024.568..1,024.613 rows=2 loops=5)

6. 41.323 1,024.173 ↑ 17,401.0 2 5 / 5

Hash Left Join (cost=585.41..376,137.80 rows=34,802 width=16) (actual time=1,024.157..1,024.173 rows=2 loops=5)

  • Hash Cond: (t_e20so1_document_boolean_history.c_fieldsid = t_e20so1_fielddetails.c_fieldschemaid)
  • 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: 45348
7. 71.856 973.365 ↑ 1.3 45,350 5 / 5

Hash Left Join (cost=376.09..374,353.60 rows=60,625 width=41) (actual time=18.998..973.365 rows=45,350 loops=5)

  • Hash Cond: (t_e20so1_document_boolean_history.c_fieldsid = t_sys_fieldpermission.c_fieldschemaid)
8. 66.443 882.722 ↓ 1.2 45,350 5 / 5

Parallel Append (cost=0.00..372,900.32 rows=37,676 width=32) (actual time=0.054..882.722 rows=45,350 loops=5)

9. 816.279 816.279 ↓ 1.2 45,350 5 / 5

Parallel Seq Scan on t_e20so1_document_boolean_history_issues t_e20so1_document_boolean_history (cost=0.00..372,711.93 rows=37,676 width=32) (actual time=0.052..816.279 rows=45,350 loops=5)

  • Filter: ((c_createddate IS NOT NULL) AND (c_tablegroupid = 'c0b2f85c-bc93-466b-a54d-b1330440db98'::uuid) AND (c_actiontype = 9))
  • Rows Removed by Filter: 3897405
10. 9.130 18.787 ↓ 1.0 9,568 5 / 5

Hash (cost=262.15..262.15 rows=9,115 width=25) (actual time=18.786..18.787 rows=9,568 loops=5)

  • Buckets: 16384 Batches: 1 Memory Usage: 661kB
11. 9.657 9.657 ↓ 1.0 9,568 5 / 5

Seq Scan on t_sys_fieldpermission (cost=0.00..262.15 rows=9,115 width=25) (actual time=0.019..9.657 rows=9,568 loops=5)

12. 4.703 9.485 ↓ 1.0 5,283 5 / 5

Hash (cost=144.70..144.70 rows=5,170 width=25) (actual time=9.484..9.485 rows=5,283 loops=5)

  • Buckets: 8192 Batches: 1 Memory Usage: 391kB
13. 4.782 4.782 ↓ 1.0 5,283 5 / 5

Seq Scan on t_e20so1_fielddetails (cost=0.00..144.70 rows=5,170 width=25) (actual time=0.020..4.782 rows=5,283 loops=5)

14. 0.010 0.076 ↑ 1.0 1 10 / 5

Append (cost=0.56..1.43 rows=1 width=8) (actual time=0.034..0.038 rows=1 loops=10)

15. 0.066 0.066 ↑ 1.0 1 10 / 5

Index Only Scan using t_e20so1_document_datastore_2_pkey on t_e20so1_document_datastore_2 t_e20so1_document (cost=0.56..1.42 rows=1 width=8) (actual time=0.032..0.033 rows=1 loops=10)

  • Index Cond: ((c_documentid = t_e20so1_document_boolean_history.c_docid) AND (c_datastoresid = 2))
  • Heap Fetches: 0