explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OBoMT

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

Delete on pr4_rule_vw (cost=0.00..178.35 rows=20 width=6) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on pr4_rule_vw (cost=0.00..178.35 rows=20 width=6) (actual rows= loops=)

  • Filter: (SubPlan 1)
3.          

SubPlan (forSeq Scan)

4. 0.000 0.000 ↓ 0.0

Index Scan using pr_engclass_code on pr_engineclasses (cost=0.00..8.39 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (((pzcodeset)::text = 'pega-enginecode'::text) AND (pzcodesetversion IS NOT NULL) AND ((pzcodesetversion)::text < '08'::text))