explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yY1L

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 996.305 ↑ 1.0 1 1

Limit (cost=83,735.49..83,735.50 rows=1 width=4) (actual time=996.304..996.305 rows=1 loops=1)

  • Buffers: shared hit=205 read=66179
2. 111.696 996.303 ↑ 1.0 1 1

Aggregate (cost=83,735.49..83,735.50 rows=1 width=4) (actual time=996.302..996.303 rows=1 loops=1)

  • Buffers: shared hit=205 read=66179
3. 884.607 884.607 ↓ 3.0 833,060 1

Seq Scan on appointments a0_ (cost=0.00..83,044.76 rows=276,291 width=4) (actual time=0.155..884.607 rows=833,060 loops=1)

  • Filter: (((deleted)::integer < 1) AND ((deleted)::integer <> 1))
  • Buffers: shared hit=205 read=66179
Planning time : 0.234 ms
Execution time : 996.365 ms