explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NqYr

Settings
# exclusive inclusive rows x rows loops node
1. 100.428 743.957 ↑ 1.0 1 1

Aggregate (cost=76,797.25..76,797.26 rows=1 width=4) (actual time=743.957..743.957 rows=1 loops=1)

  • Buffers: shared hit=365 read=66019
2. 643.529 643.529 ↑ 1.0 833,060 1

Seq Scan on appointments a0_ (cost=0.00..74,714.60 rows=833,060 width=4) (actual time=0.074..643.529 rows=833,060 loops=1)

  • Filter: (NOT deleted)
  • Buffers: shared hit=365 read=66019
Planning time : 0.166 ms
Execution time : 744.000 ms