explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r8SA

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 58.313 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.69..8.79 rows=1 width=23) (actual time=58.309..58.313 rows=1 loops=1)

  • Buffers: shared hit=4 read=7
2. 0.083 0.083 ↑ 1.0 1 1

Index Scan using pk_common_entities_organization on common_entities_organization (cost=0.27..4.31 rows=1 width=60) (actual time=0.080..0.083 rows=1 loops=1)

  • Index Cond: (sid = 437)
  • Buffers: shared hit=4 read=2
3. 58.222 58.222 ↑ 1.0 1 1

Index Only Scan using ix_settings_organization_setting_04 on settings_organization_setting (cost=0.42..4.46 rows=1 width=37) (actual time=58.222..58.222 rows=1 loops=1)

  • Index Cond: ((organization_identity = (common_entities_organization.identity)::text) AND (key = 'CompanyStartOfDay'::text))
  • Heap Fetches: 1
  • Buffers: shared read=5
Planning time : 4.869 ms
Execution time : 58.453 ms