explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yuO2

Settings
# exclusive inclusive rows x rows loops node
1. 0.049 3.000 ↑ 5.0 9 1

Hash Join (cost=10,003.45..20,017.65 rows=45 width=198) (actual time=2.934..3.000 rows=9 loops=1)

  • Hash Cond: (ora_department.department_id = emp.department_id)
2. 2.920 2.920 ↑ 37.0 27 1

Foreign Scan on ora_department (cost=10,000.00..20,000.00 rows=1,000 width=128) (actual time=2.849..2.920 rows=27 loops=1)

  • Oracle query: SELECT /*20040caa331a70f3a3c62098756bf4b7*/ r2."DEPARTMENT_ID", r2."DEPARTMENT_NAME", r2."MANAGER_ID", r2."LOCATION_ID" FROM "DEPARTMENTS" r2
3. 0.007 0.031 ↑ 1.0 9 1

Hash (cost=3.34..3.34 rows=9 width=70) (actual time=0.031..0.031 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.024 0.024 ↑ 1.0 9 1

Seq Scan on emp (cost=0.00..3.34 rows=9 width=70) (actual time=0.014..0.024 rows=9 loops=1)

  • Filter: (last_name ~~ 'S%'::text)
  • Rows Removed by Filter: 98
Planning time : 0.782 ms
Execution time : 3.039 ms