explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9DF0

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=103.15..103.25 rows=5 width=29) (actual rows= loops=)

  • Group Key: "PC0".formtype, "PC0".pystatuswork
2. 0.000 0.000 ↓ 0.0

Sort (cost=103.15..103.16 rows=5 width=30) (actual rows= loops=)

  • Sort Key: "PC0".formtype, "PC0".pystatuswork
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=30.68..103.09 rows=5 width=30) (actual rows= loops=)

  • Hash Cond: (("PARTY".pxinsindexedkey)::text = ("PC0".pzinskey)::text)
4. 0.000 0.000 ↓ 0.0

Index Scan using pc_index_workparty_idx1 on pc_index_workparty "PARTY" (cost=0.28..72.49 rows=77 width=35) (actual rows= loops=)

  • Index Cond: ((pypartyidentifier)::text = 'pradeepan'::text)
  • Filter: ((pxobjclass)::text = 'Index-WorkPartyUri'::text)
5. 0.000 0.000 ↓ 0.0

Hash (cost=27.20..27.20 rows=256 width=57) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on pc_pri_life_pls_work "PC0" (cost=0.00..27.20 rows=256 width=57) (actual rows= loops=)

  • Filter: ((pxobjclass)::text = 'PRI-Life-PLS-Work-PolicyServicing'::text)