explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WPUy

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 20.195 ↑ 1.0 1 1

Aggregate (cost=708.70..708.71 rows=1 width=8) (actual time=20.195..20.195 rows=1 loops=1)

2. 0.029 20.192 ↓ 37.0 37 1

GroupAggregate (cost=708.67..708.69 rows=1 width=23) (actual time=20.161..20.192 rows=37 loops=1)

  • Group Key: ad.nama
3. 0.189 20.163 ↓ 124.0 124 1

Sort (cost=708.67..708.67 rows=1 width=15) (actual time=20.156..20.163 rows=124 loops=1)

  • Sort Key: ad.nama
  • Sort Method: quicksort Memory: 32kB
4. 0.096 19.974 ↓ 124.0 124 1

Nested Loop (cost=62.86..708.66 rows=1 width=15) (actual time=2.143..19.974 rows=124 loops=1)

5. 0.146 19.630 ↓ 124.0 124 1

Nested Loop (cost=62.57..708.07 rows=1 width=19) (actual time=2.132..19.630 rows=124 loops=1)

6. 0.189 19.360 ↓ 124.0 124 1

Nested Loop (cost=62.43..707.70 rows=1 width=23) (actual time=2.121..19.360 rows=124 loops=1)

7. 13.242 19.038 ↓ 133.0 133 1

Nested Loop (cost=62.29..707.33 rows=1 width=8) (actual time=2.111..19.038 rows=133 loops=1)

  • Join Filter: (upper(p.kesimpulan) ~~* (('%'::text || upper((ak.nama)::text)) || '%'::text))
  • Rows Removed by Join Filter: 549
8. 3.780 5.730 ↓ 11.0 11 1

Hash Join (cost=62.29..704.32 rows=1 width=12) (actual time=1.843..5.730 rows=11 loops=1)

  • Hash Cond: (((p.id_pasien)::text = (d.id_pasien)::text) AND (p.id_kunjungan = d.id_kunjungan))
9. 1.617 1.617 ↑ 1.0 16,151 1

Seq Scan on pasien_kesimpulan p (cost=0.00..480.51 rows=16,151 width=16) (actual time=0.018..1.617 rows=16,151 loops=1)

10. 0.014 0.333 ↓ 2.4 40 1

Hash (cost=62.03..62.03 rows=17 width=14) (actual time=0.333..0.333 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
11. 0.008 0.319 ↓ 2.4 40 1

Subquery Scan on d (cost=61.69..62.03 rows=17 width=14) (actual time=0.297..0.319 rows=40 loops=1)

12. 0.013 0.311 ↓ 2.4 40 1

Unique (cost=61.69..61.86 rows=17 width=18) (actual time=0.295..0.311 rows=40 loops=1)

13. 0.126 0.298 ↓ 2.4 40 1

Sort (cost=61.69..61.74 rows=17 width=18) (actual time=0.294..0.298 rows=40 loops=1)

  • Sort Key: a_1.id_pasien, a_1.id_kunjungan, ((a_1.waktu_masuk)::date)
  • Sort Method: quicksort Memory: 28kB
14. 0.172 0.172 ↓ 2.4 40 1

Index Scan using idx_id_kategori_harga on antrian a_1 (cost=0.29..61.35 rows=17 width=18) (actual time=0.035..0.172 rows=40 loops=1)

  • Index Cond: ((id_kategori_harga)::text = '191'::text)
15. 0.066 0.066 ↑ 1.0 62 11

Seq Scan on anl_dtl_kes_persamaan_abnormal ak (cost=0.00..1.62 rows=62 width=21) (actual time=0.003..0.006 rows=62 loops=11)

16. 0.133 0.133 ↑ 1.0 1 133

Index Scan using anl_dtl_kes_abnormal_pkey on anl_dtl_kes_abnormal ad (cost=0.14..0.35 rows=1 width=23) (actual time=0.001..0.001 rows=1 loops=133)

  • Index Cond: (id = ak.id_dtl_kes_abnormal)
  • Filter: ((sts_post)::text = 'Y'::text)
17. 0.124 0.124 ↑ 1.0 1 124

Index Only Scan using anl_dtl_jns_pemeriksaan_pkey on anl_dtl_jns_pemeriksaan a (cost=0.14..0.36 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=124)

  • Index Cond: (id = ad.id_anl_dtl_jns_pemeriksaan)
  • Heap Fetches: 124
18. 0.248 0.248 ↑ 1.0 1 124

Index Only Scan using pasien_pkey on master_pasien m (cost=0.29..0.58 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=124)

  • Index Cond: (id = p.id_pasien)
  • Heap Fetches: 124