PostgreSQL'de başarım

• Nested Loop Left Join (cost=0.00..3.76 rows=1 width=654) (actual time=0.054..0.054 rows=0 loops=1)

• Join Filter: ("outer".user_id = "inner".id)

• -> Nested Loop Left Join (cost=0.00..2.56 rows=1 width=592) (actual time=0.052..0.052 rows=0 loops=1)

• Join Filter: ("inner".id = "outer".firm_id)

• -> Seq Scan on cases (cost=0.00..1.40 rows=1 width=528) (actual time=0.050..0.050 rows=0 loops=1)

• Filter: ((case_closed = false) AND (active = true) AND (id = 2))

• -> Seq Scan on firm_info (cost=0.00..1.07 rows=7 width=72) (never executed)

• -> Seq Scan on userdetails (cost=0.00..1.09 rows=9 width=70) (never executed)

• Total runtime: 0.198 ms

Notes: