explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CmfY

Settings
# exclusive inclusive rows x rows loops node
1. 1,448.658 12,145.009 ↑ 39.6 8,857 1

GroupAggregate (cost=1,583,271.85..1,764,713.72 rows=350,987 width=12) (actual time=7,880.697..12,145.009 rows=8,857 loops=1)

  • Group Key: tt.id
2. 737.196 10,696.351 ↑ 1.0 7,363,734 1

Merge Join (cost=1,583,271.85..1,724,230.73 rows=7,394,624 width=12) (actual time=7,870.080..10,696.351 rows=7,363,734 loops=1)

  • Merge Cond: (tt.id = tklm.tahsilat_turu_id)
3. 53.066 53.066 ↓ 1.0 351,118 1

Index Only Scan using pk_tahsilat_turu_id on tahsilat_turu tt (cost=0.42..10,677.23 rows=350,987 width=4) (actual time=0.010..53.066 rows=351,118 loops=1)

  • Heap Fetches: 9918
4. 564.267 9,906.089 ↑ 1.0 7,363,734 1

Materialize (cost=1,583,271.39..1,620,244.51 rows=7,394,624 width=12) (actual time=7,870.050..9,906.089 rows=7,363,734 loops=1)

5. 3,078.948 9,341.822 ↑ 1.0 7,363,734 1

Sort (cost=1,583,271.39..1,601,757.95 rows=7,394,624 width=12) (actual time=7,870.045..9,341.822 rows=7,363,734 loops=1)

  • Sort Key: tklm.tahsilat_turu_id
  • Sort Method: external merge Disk: 158272kB
6. 1,458.232 6,262.874 ↑ 1.0 7,363,734 1

Merge Join (cost=0.91..649,349.57 rows=7,394,624 width=12) (actual time=0.033..6,262.874 rows=7,363,734 loops=1)

  • Merge Cond: (tk.id = tklm.tahsilat_kaydi_id)
7. 1,963.151 1,963.151 ↓ 1.0 6,168,593 1

Index Only Scan using pk_tahsilat_kaydi on tahsilat_kaydi tk (cost=0.43..262,370.93 rows=6,160,937 width=8) (actual time=0.023..1,963.151 rows=6,168,593 loops=1)

  • Heap Fetches: 1594406
8. 2,841.491 2,841.491 ↑ 1.0 7,363,734 1

Index Scan using in_tahsilat_kalemi_tahsilat_kaydi on tahsilat_kalemi tklm (cost=0.43..286,113.31 rows=7,394,624 width=12) (actual time=0.008..2,841.491 rows=7,363,734 loops=1)