explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ktPT

Settings
# exclusive inclusive rows x rows loops node
1. 0.496 11.317 ↑ 1.0 1 1

Aggregate (cost=9,232.68..9,232.69 rows=1 width=8) (actual time=11.316..11.317 rows=1 loops=1)

2. 10.821 10.821 ↑ 1.5 6,285 1

Index Only Scan using proclass_prokind_idx on proclass (cost=0.43..9,208.40 rows=9,715 width=0) (actual time=2.946..10.821 rows=6,285 loops=1)

  • Index Cond: (prokind = 'w'::"char")
  • Heap Fetches: 6285
Planning time : 0.201 ms
Execution time : 11.391 ms