explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f1Mt

Settings
# exclusive inclusive rows x rows loops node
1. 1,212.117 55,990.785 ↑ 1.0 1 1

Aggregate (cost=379,320.92..379,320.93 rows=1 width=8) (actual time=55,990.784..55,990.785 rows=1 loops=1)

2. 54,778.668 54,778.668 ↓ 1.0 16,002,523 1

Index Only Scan using transactions_pkey on transactions (cost=0.43..339,628.08 rows=15,877,135 width=0) (actual time=3.506..54,778.668 rows=16,002,523 loops=1)

  • Heap Fetches: 2682155
Planning time : 0.687 ms
Execution time : 55,992.136 ms