explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w1Qn : Optimization for: ; plan #szA

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.194 6,242.363 ↑ 56.9 48 1

Sort (cost=462,099.43..462,106.25 rows=2,731 width=236) (actual time=6,242.346..6,242.363 rows=48 loops=1)

  • Sort Key: "PC0".toplevelcasehandle, "PC0".pyid
  • Sort Method: quicksort Memory: 47kB
2. 2,741.283 6,242.169 ↑ 56.9 48 1

Merge Left Join (cost=1,480.79..461,943.55 rows=2,731 width=236) (actual time=947.931..6,242.169 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: 1070210
3. 1,166.600 1,166.600 ↓ 1.0 566,762 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.062..1,166.600 rows=566,762 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: 911994
4. 2,334.286 2,334.286 ↓ 1.6 1,960,245 1

Index Scan using insindexedkey_d06a8 on pr_index_sg_data_contactpartie "Student" (cost=0.43..145,933.19 rows=1,225,248 width=82) (actual time=0.010..2,334.286 rows=1,960,245 loops=1)

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