explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mHso

Settings
# exclusive inclusive rows x rows loops node
1. 5,252.277 69,579.869 ↑ 2,195.8 932 1

Group (cost=0.56..1,940,672.34 rows=2,046,502 width=16) (actual time=1.508..69,579.869 rows=932 loops=1)

  • Group Key: int_office, int_client, int_sub, int_winteam_number
  • Buffers: shared hit=1143580 read=281186 dirtied=715
2. 64,327.592 64,327.592 ↓ 1.0 20,466,480 1

Index Only Scan using tab_activity_summary_int_office_int_client_int_sub_int_wint_idx on tab_activity_summary (cost=0.56..1,736,022.16 rows=20,465,018 width=16) (actual time=1.505..64,327.592 rows=20,466,480 loops=1)

  • Heap Fetches: 2093840
  • Buffers: shared hit=1143580 read=281186 dirtied=715
Planning time : 0.111 ms
Execution time : 69,580.248 ms