explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fyc5

Settings
# exclusive inclusive rows x rows loops node
1. 69.334 78.265 ↑ 1.1 44,933 1

Seq Scan on people (cost=1,401.46..3,579.81 rows=49,734 width=45) (actual time=32.030..78.265 rows=44,933 loops=1)

  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 55,067
2.          

SubPlan (for Seq Scan)

3. 8.931 8.931 ↑ 1.0 80,000 1

Seq Scan on phonebook (cost=0.00..1,196.57 rows=81,957 width=4) (actual time=0.055..8.931 rows=80,000 loops=1)

Planning time : 0.092 ms
Execution time : 80.084 ms