explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KUYL : dd

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 11,459.450 ↑ 1.0 1 1

Aggregate (cost=2,602,257.6..2,602,257.61 rows=1 width=8) (actual time=11,459.449..11,459.45 rows=1 loops=1)

  • Buffers: shared hit=381,683 read=131,389 dirtied=4,535
2. 557.941 11,738.462 ↓ 1.5 3 1

Gather (cost=2,602,257.38..2,602,257.59 rows=2 width=8) (actual time=11,459.158..11,738.462 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=381,683 read=131,389 dirtied=4,535
3. 3,026.861 11,180.521 ↑ 1.0 1 3 / 3

Aggregate (cost=2,601,257.38..2,601,257.39 rows=1 width=8) (actual time=11,180.521..11,180.521 rows=1 loops=3)

  • Buffers: shared hit=381,683 read=131,389 dirtied=4,535
4. 8,153.660 8,153.660 ↑ 1.2 40,557,518 3 / 3

Index Only Scan using "PK_ResultContracts" on ResultContracts rc (cost=0.57..2,475,778.11 rows=50,191,707 width=0) (actual time=0.087..8,153.66 rows=40,557,518 loops=3)

  • Heap Fetches: 794,245
  • Buffers: shared hit=381,683 read=131,389 dirtied=4,535
Planning time : 0.117 ms
Execution time : 11,738.566 ms