explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hCEB

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 49.939 ↑ 1.0 1 1

Limit (cost=1.09..5.79 rows=1 width=355) (actual time=49.939..49.939 rows=1 loops=1)

  • Output: organization.acl, organization.id, organization.create_date, organization.delete_date, organization.modify_date, organization.soft_deleted, organization.name, organization.organization_type_id, organization.contact_email, organization.contact_phone, organization.country_code, organization.address, organization.address_2, organization.city, organization.province, organization.postal_code, organization.country, organization.homepage, organization.role_id, organization.lock_date, organization.track_usage, organization.self_node_id
2. 49.922 49.938 ↑ 1.0 1 1

Nested Loop (cost=1.09..5.79 rows=1 width=355) (actual time=49.938..49.938 rows=1 loops=1)

  • Output: organization.acl, organization.id, organization.create_date, organization.delete_date, organization.modify_date, organization.soft_deleted, organization.name, organization.organization_type_id, organization.contact_email, organization.contact_phone, organization.country_code, organization.address, organization.address_2, organization.city, organization.province, organization.postal_code, organization.country, organization.homepage, organization.role_id, organization.lock_date, organization.track_usage, organization.self_node_id
3. 0.011 0.011 ↑ 1.0 1 1

Index Scan using rate_pkey on alpine.rate rate_1 (cost=0.56..2.78 rows=1 width=461) (actual time=0.011..0.011 rows=1 loops=1)

  • Output: rate_1.id, rate_1.create_date, rate_1.modify_date, rate_1.delete_date, rate_1.soft_deleted, rate_1.numerator, rate_1.numerator_unit_id, rate_1.denominator, rate_1.denominator_unit_id, rate_1.acl
  • Index Cond: (rate_1.id = '7803945d-f9d6-4566-af11-56f5c23afbee'::uuid)
4. 0.005 0.005 ↑ 1.0 1 1

Index Scan using organization_pkey on alpine.organization (cost=0.53..3.00 rows=1 width=355) (actual time=0.005..0.005 rows=1 loops=1)

  • Output: organization.id, organization.create_date, organization.modify_date, organization.soft_deleted, organization.name, organization.organization_type_id, organization.contact_email, organization.contact_phone, organization.address, organization.address_2, organization.city, organization.province, organization.postal_code, organization.country, organization.homepage, organization.delete_date, organization.acl, organization.role_id, organization.lock_date, organization.self_node_id, organization.track_usage, organization.country_code
  • Index Cond: (organization.id = organization_in_acl(rate_1.acl))