query-plan-1176
Change label- Query Plan as raw text
-
- Summary
-
Time Node Node (ms) Percent 1.825 100.00% ¶ Hash Join (cost=44.57..84.62 rows=10 width=34) (actual time=1.234..1.825 rows=2 loops=1) Hash Cond: (f.id = r.id)0.914 50.08% ¶ -> Seq Scan on financials f (cost=0.0..35.6 rows=1160 width=12) (actual time=0.024..0.914 rows=1160 loops=1)0.050 2.74% ¶ -> Hash (cost=44.43..44.43 rows=11 width=30) (actual time=0.050..0.050 rows=3 loops=1)0.038 2.08% ¶ -> Index Scan using studentfacultyratio_idx on rankings r (cost=0.0..44.43 rows=11 width=30) (actual time=0.025..0.038 rows=3 loops=1) Index Cond: (studentfacultyratio < 3::double precision) - Run-time
- 0.013992 seconds (13.992 ms)

ANALYZEto update the server's statistics.EXPLAINand interpreting its output, see the Postgres documentation, in particular theEXPLAINandANALYZEreferences pages, and Using Explain.