explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zOs

Settings
# exclusive inclusive rows x rows loops node
1. 2,085.962 2,087.335 ↓ 377.1 41,859 1

Seq Scan on entitlement (cost=383.81..4,861.40 rows=111 width=347) (actual time=1.471..2,087.335 rows=41,859 loops=1)

  • Filter: (deactivated AND (NOT (hashed SubPlan 1)) AND ((config ->> 'clusters_deleted'::text) = 'false'::text))
  • Rows Removed by Filter: 2,663
2.          

SubPlan (for Seq Scan)

3. 1.373 1.373 ↑ 1.0 162 1

Index Only Scan using entitlement_organization_id on entitlement entitlement_1 (cost=0.27..383.40 rows=163 width=4) (actual time=0.931..1.373 rows=162 loops=1)

  • Heap Fetches: 80
Planning time : 15.117 ms
Execution time : 2,290.498 ms