explain.depesz.com

PostgreSQL's explain analyze made readable

Result: szA :

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.291 7,299.509 ↑ 56.9 48 1

Sort (cost=462,076.11..462,082.93 rows=2,731 width=236) (actual time=7,299.486..7,299.509 rows=48 loops=1)

  • Sort Key: "PC0".toplevelcasehandle, "PC0".pyid
  • Sort Method: quicksort Memory: 47kB
2. 3,307.502 7,299.218 ↑ 56.9 48 1

Merge Left Join (cost=1,480.66..461,920.23 rows=2,731 width=236) (actual time=957.814..7,299.218 rows=48 loops=1)

  • Merge Cond: (("PC0".toplevelcasehandle)::text = ("Student".pxinsindexedkey)::text)
  • Join Filter: (("PC0".pxobjclass)::text = ANY ('{SG-Admissions-Work,SG-Admissions-Work-AcademicAssessment,SG-Admissions-Work-Admission,SG-Admissions-Work-Assessment,SG-Admissions-Work-Assessment-AU,SG-Admissions-Work-Assessment-AU-CSU,SG-Admissions- (...)
  • Filter: ((upper(("Student".firstname)::text) ~~ 'PEGA%'::text) OR (upper(("PC0".firstname)::text) ~~ 'PEGA%'::text))
  • Rows Removed by Filter: 1070060
3. 1,306.043 1,306.043 ↓ 1.0 566,681 1

Index Scan using pc_sg_admissions_work_handle on pc_sg_admissions_work "PC0" (cost=0.43..289,416.97 rows=544,567 width=191) (actual time=0.065..1,306.043 rows=566,681 loops=1)

  • Filter: ((pxcreatedatetime >= '2017-04-07 14:00:00'::timestamp without time zone) AND (pxcreatedatetime <= '2019-04-09 13:59:59.999'::timestamp without time zone) AND ((pxobjclass)::text = ANY ('{SG-Admissions-Work,SG-Admissions-Work-Academic (...)
  • Rows Removed by Filter: 911973
4. 2,685.673 2,685.673 ↓ 1.6 1,960,056 1

Index Scan using insindexedkey_d06a8 on pr_index_sg_data_contactpartie "Student" (cost=0.43..145,910.33 rows=1,225,064 width=82) (actual time=0.012..2,685.673 rows=1,960,056 loops=1)

  • Filter: (((partyrole)::text = ANY ('{Student,Agent}'::text[])) AND ((pxobjclass)::text = 'Index-SG-Data-ContactParties'::text))
  • Rows Removed by Filter: 1053954