explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cd8Gr

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 28.924 558.730 ↑ 1.0 1 1

Aggregate (cost=215,994.07..215,994.08 rows=1 width=8) (actual time=558.729..558.730 rows=1 loops=1)

2. 529.806 529.806 ↓ 34.1 780,000 1

Index Only Scan using idxhands on hands (cost=0.57..215,936.90 rows=22,868 width=0) (actual time=57.815..529.806 rows=780,000 loops=1)

  • Index Cond: ((training_id = 100,007) AND (hero = 'Player1'::text) AND (rank = 'Paired'::text))
  • Heap Fetches: 780,000
Planning time : 0.191 ms
Execution time : 558.778 ms