explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MYWJ

Settings
# exclusive inclusive rows x rows loops node
1. 810.164 810.164 ↑ 1.1 2,654,615 1

Index Only Scan using services_pkey on services (cost=0.43..69,769.81 rows=2,801,022 width=4) (actual time=1.700..810.164 rows=2,654,615 loops=1)

  • Heap Fetches: 53691
  • Buffers: shared hit=95099 read=19128
  • I/O Timings: read=318.181
Planning time : 0.716 ms
Execution time : 955.877 ms