explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K8z : Optimization for: Optimization for: ; plan #szA; plan #w1Qn

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.222 6,034.256 ↑ 57.2 48 1

Sort (cost=463,589.38..463,596.25 rows=2,747 width=237) (actual time=6,034.242..6,034.256 rows=48 loops=1)

  • Sort Key: "PC0".toplevelcasehandle, "PC0".pyid
  • Sort Method: quicksort Memory: 47kB
2. 2,650.664 6,034.034 ↑ 57.2 48 1

Merge Left Join (cost=1,486.25..463,432.48 rows=2,747 width=237) (actual time=970.179..6,034.034 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: 1070408
3. 1,167.188 1,167.188 ↓ 1.0 566,830 1

Index Scan using pc_sg_admissions_work_handle on pc_sg_admissions_work "PC0" (cost=0.43..290,244.05 rows=547,835 width=192) (actual time=0.088..1,167.188 rows=566,830 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: 913507
4. 2,216.182 2,216.182 ↓ 1.6 1,961,795 1

Index Scan using insindexedkey_d06a8 on pr_index_sg_data_contactpartie "Student" (cost=0.43..146,467.15 rows=1,229,840 width=82) (actual time=0.015..2,216.182 rows=1,961,795 loops=1)

  • Filter: (((partyrole)::text = ANY ('{Student,Agent}'::text[])) AND ((pxobjclass)::text = 'Index-SG-Data-ContactParties'::text))
  • Rows Removed by Filter: 1054605
Planning time : 3.114 ms
Execution time : 6,034.450 ms