explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KHTG

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 4.418 ↓ 2.0 4 1

Unique (cost=449.45..449.46 rows=2 width=407) (actual time=4.414..4.418 rows=4 loops=1)

  • Output: a.id_order, c.id_trip, a.id, c.id, d.status_ind, a.status, e.nama, f.plat_nomor, a.jadwal_penjemputan, a.jadwal_sampai, g.nama_perusahaan, h.nama_perusahaan, a.shipper_id, i.jenis_kendaraan, j.lang, j.lat, g.lang, g.lat, h.lang, h.lat, (to_char(a.jadwal_penjemputan, 'DD-MM-YYYY HH24:MI:SS'::text)), a.create_by
  • Buffers: shared hit=200
2. 0.021 4.414 ↓ 2.0 4 1

Sort (cost=449.45..449.45 rows=2 width=407) (actual time=4.413..4.414 rows=4 loops=1)

  • Output: a.id_order, c.id_trip, a.id, c.id, d.status_ind, a.status, e.nama, f.plat_nomor, a.jadwal_penjemputan, a.jadwal_sampai, g.nama_perusahaan, h.nama_perusahaan, a.shipper_id, i.jenis_kendaraan, j.lang, j.lat, g.lang, g.lat, h.lang, h.lat, (to_char(a.jadwal_penjemputan, 'DD-MM-YYYY HH24:MI:SS'::text)), a.create_by
  • Sort Key: a.id_order, c.id DESC
  • Sort Method: quicksort Memory: 27kB
  • Buffers: shared hit=200
3. 0.028 4.393 ↓ 2.0 4 1

Hash Left Join (cost=401.49..449.44 rows=2 width=407) (actual time=4.171..4.393 rows=4 loops=1)

  • Output: a.id_order, c.id_trip, a.id, c.id, d.status_ind, a.status, e.nama, f.plat_nomor, a.jadwal_penjemputan, a.jadwal_sampai, g.nama_perusahaan, h.nama_perusahaan, a.shipper_id, i.jenis_kendaraan, j.lang, j.lat, g.lang, g.lat, h.lang, h.lat, to_char(a.jadwal_penjemputan, 'DD-MM-YYYY HH24:MI:SS'::text), a.create_by
  • Inner Unique: true
  • Hash Cond: (c.id = j.id)
  • Buffers: shared hit=200
4. 0.007 0.460 ↓ 2.0 4 1

Nested Loop Left Join (cost=49.92..97.86 rows=2 width=354) (actual time=0.246..0.460 rows=4 loops=1)

  • Output: a.id_order, a.id, a.status, a.jadwal_penjemputan, a.jadwal_sampai, a.shipper_id, a.create_by, c.id_trip, c.id, d.status_ind, e.nama, f.plat_nomor, g.nama_perusahaan, g.lang, g.lat, h.nama_perusahaan, h.lang, h.lat, i.jenis_kendaraan
  • Inner Unique: true
  • Buffers: shared hit=106
5. 0.005 0.445 ↓ 2.0 4 1

Nested Loop Left Join (cost=49.77..93.68 rows=2 width=323) (actual time=0.239..0.445 rows=4 loops=1)

  • Output: a.id_order, a.id, a.status, a.jadwal_penjemputan, a.jadwal_sampai, a.shipper_id, a.create_by, c.id_trip, c.id, d.status_ind, e.nama, f.plat_nomor, f.jenis_kendaraan, g.nama_perusahaan, g.lang, g.lat, h.nama_perusahaan, h.lang, h.lat
  • Inner Unique: true
  • Buffers: shared hit=98
6. 0.007 0.428 ↓ 2.0 4 1

Nested Loop Left Join (cost=49.50..77.06 rows=2 width=275) (actual time=0.232..0.428 rows=4 loops=1)

  • Output: a.id_order, a.id, a.status, a.jadwal_penjemputan, a.jadwal_sampai, a.shipper_id, a.create_by, a.tujuan_id, c.id_trip, c.id, d.status_ind, e.nama, f.plat_nomor, f.jenis_kendaraan, g.nama_perusahaan, g.lang, g.lat
  • Inner Unique: true
  • Buffers: shared hit=86
7. 0.004 0.401 ↓ 2.0 4 1

Nested Loop Left Join (cost=49.22..60.45 rows=2 width=227) (actual time=0.215..0.401 rows=4 loops=1)

  • Output: a.id_order, a.id, a.status, a.jadwal_penjemputan, a.jadwal_sampai, a.shipper_id, a.create_by, a.asal_id, a.tujuan_id, c.id_trip, c.id, d.status_ind, e.nama, f.plat_nomor, f.jenis_kendaraan
  • Inner Unique: true
  • Buffers: shared hit=74
8. 0.005 0.385 ↓ 2.0 4 1

Nested Loop Left Join (cost=49.09..60.02 rows=2 width=219) (actual time=0.208..0.385 rows=4 loops=1)

  • Output: a.id_order, a.id, a.status, a.jadwal_penjemputan, a.jadwal_sampai, a.shipper_id, a.create_by, a.asal_id, a.tujuan_id, c.id_trip, c.id, c.kendaraan_id, d.status_ind, e.nama
  • Inner Unique: true
  • Buffers: shared hit=66
9. 0.017 0.368 ↓ 2.0 4 1

Nested Loop Left Join (cost=48.81..57.41 rows=2 width=217) (actual time=0.200..0.368 rows=4 loops=1)

  • Output: a.id_order, a.id, a.status, a.jadwal_penjemputan, a.jadwal_sampai, a.shipper_id, a.create_by, a.asal_id, a.tujuan_id, c.id_trip, c.id, c.driver_id, c.kendaraan_id, d.status_ind
  • Inner Unique: true
  • Join Filter: (d.id = a.status)
  • Rows Removed by Join Filter: 40
  • Buffers: shared hit=54
10. 0.011 0.327 ↓ 2.0 4 1

Nested Loop Left Join (cost=48.81..55.90 rows=2 width=119) (actual time=0.181..0.327 rows=4 loops=1)

  • Output: a.id_order, a.id, a.status, a.jadwal_penjemputan, a.jadwal_sampai, a.shipper_id, a.create_by, a.asal_id, a.tujuan_id, c.id_trip, c.id, c.driver_id, c.kendaraan_id
  • Inner Unique: true
  • Buffers: shared hit=53
11. 0.084 0.296 ↓ 2.0 4 1

Hash Right Join (cost=48.54..54.87 rows=2 width=85) (actual time=0.162..0.296 rows=4 loops=1)

  • Output: a.id_order, a.id, a.status, a.jadwal_penjemputan, a.jadwal_sampai, a.shipper_id, a.create_by, a.asal_id, a.tujuan_id, b.trip_id
  • Inner Unique: true
  • Hash Cond: (b.order_id = a.id)
  • Buffers: shared hit=41
12. 0.067 0.067 ↓ 1.0 268 1

Seq Scan on public.mt_trip_order_transaction b (cost=0.00..5.64 rows=264 width=16) (actual time=0.004..0.067 rows=268 loops=1)

  • Output: b.id, b.order_id, b.trip_id, b.create_date, b.create_by, b.update_date, b.update_by
  • Buffers: shared hit=3
13. 0.007 0.145 ↓ 2.0 4 1

Hash (cost=48.52..48.52 rows=2 width=77) (actual time=0.145..0.145 rows=4 loops=1)

  • Output: a.id_order, a.id, a.status, a.jadwal_penjemputan, a.jadwal_sampai, a.shipper_id, a.create_by, a.asal_id, a.tujuan_id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=38
14. 0.138 0.138 ↓ 2.0 4 1

Seq Scan on public.mt_shipper_order a (cost=0.00..48.52 rows=2 width=77) (actual time=0.007..0.138 rows=4 loops=1)

  • Output: a.id_order, a.id, a.status, a.jadwal_penjemputan, a.jadwal_sampai, a.shipper_id, a.create_by, a.asal_id, a.tujuan_id
  • Filter: ((a.status >= 7) AND (a.status <= 11))
  • Rows Removed by Filter: 713
  • Buffers: shared hit=38
15. 0.020 0.020 ↑ 1.0 1 4

Index Scan using mt_master_trip_pkey on public.mt_master_trip c (cost=0.27..0.51 rows=1 width=42) (actual time=0.005..0.005 rows=1 loops=4)

  • Output: c.id, c.id_trip, c.transporter_id, c.driver_id, c.kendaraan_id, c.jenis_kendaraan_id, c.asal_id, c.tujuan_id, c.tanggal_pengiriman, c.jam_pengiriman, c.tanggal_sampai, c.jam_sampai, c.status, c.create_date, c.create_by, c.update_date, c.update_by, c.keterangan, c.reason_cancel_id, c.foto_checklist, c.mfee, c.trip_log, c.is_konsol
  • Index Cond: (b.trip_id = c.id)
  • Buffers: shared hit=12
16. 0.018 0.024 ↑ 1.1 11 4

Materialize (cost=0.00..1.18 rows=12 width=106) (actual time=0.002..0.006 rows=11 loops=4)

  • Output: d.status_ind, d.id
  • Buffers: shared hit=1
17. 0.006 0.006 ↑ 1.1 11 1

Seq Scan on public.mt_shipper_order_status d (cost=0.00..1.12 rows=12 width=106) (actual time=0.003..0.006 rows=11 loops=1)

  • Output: d.status_ind, d.id
  • Buffers: shared hit=1
18. 0.012 0.012 ↑ 1.0 1 4

Index Scan using mt_master_user_pkey on public.mt_master_user e (cost=0.28..1.30 rows=1 width=18) (actual time=0.003..0.003 rows=1 loops=4)

  • Output: e.id, e.nama, e.hp, e.email, e.password, e.role, e.hak_akses, e.active, e.shipper_id, e.transporter_id, e.create_date, e.create_by, e.update_date, e.update_by, e.imei_hp, e.gapplicationname, e.gdeviceid, e.gbatterylevel, e.gbrand, e.gdevice, e.gdevicename, e.gfreediskstorage, e.gmaxmemory, e.gmodel, e.gphonenumber, e.gpowerstate, e.gtotaldiskcapacity, e.gtotalmemory, e.gisbatterycharging, e.gdevicetype, e.guniqueid
  • Index Cond: (e.id = c.driver_id)
  • Buffers: shared hit=12
19. 0.012 0.012 ↑ 1.0 1 4

Index Scan using mt_master_kendaraan_pkey on public.mt_master_kendaraan f (cost=0.14..0.21 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=4)

  • Output: f.plat_nomor, f.id, f.jenis_kendaraan
  • Index Cond: (f.id = c.kendaraan_id)
  • Buffers: shared hit=8
20. 0.020 0.020 ↑ 1.0 1 4

Index Scan using mt_shipper_contact_pkey on public.mt_shipper_contact g (cost=0.27..8.29 rows=1 width=64) (actual time=0.005..0.005 rows=1 loops=4)

  • Output: g.id, g.external_id, g.nama, g.nama_perusahaan, g.email, g.alamat1, g.alamat2, g.phone, g.kota, g.kode_pos, g.is_transit, g.is_konsol, g.shipper_id, g.jenis_kendaraan_id, g.lat, g.lang, g.create_date, g.create_by, g.update_date, g.update_by
  • Index Cond: (g.id = a.asal_id)
  • Buffers: shared hit=12
21. 0.012 0.012 ↑ 1.0 1 4

Index Scan using mt_shipper_contact_pkey on public.mt_shipper_contact h (cost=0.27..8.29 rows=1 width=64) (actual time=0.003..0.003 rows=1 loops=4)

  • Output: h.id, h.external_id, h.nama, h.nama_perusahaan, h.email, h.alamat1, h.alamat2, h.phone, h.kota, h.kode_pos, h.is_transit, h.is_konsol, h.shipper_id, h.jenis_kendaraan_id, h.lat, h.lang, h.create_date, h.create_by, h.update_date, h.update_by
  • Index Cond: (h.id = a.tujuan_id)
  • Buffers: shared hit=12
22. 0.008 0.008 ↑ 1.0 1 4

Index Scan using mt_master_jenis_kendaraan_pkey on public.mt_master_jenis_kendaraan i (cost=0.15..2.09 rows=1 width=47) (actual time=0.002..0.002 rows=1 loops=4)

  • Output: i.id, i.jenis_kendaraan, i.category, i.maksimal_berat, i.maksimal_dimensi, i.create_date, i.create_by, i.update_date, i.update_by, i.loading_time, i.unloading_time, i.active
  • Index Cond: (i.id = f.jenis_kendaraan)
  • Buffers: shared hit=8
23. 0.073 3.905 ↓ 1.0 217 1

Hash (cost=348.89..348.89 rows=214 width=29) (actual time=3.905..3.905 rows=217 loops=1)

  • Output: j.lang, j.lat, j.id
  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
  • Buffers: shared hit=94
24. 0.096 3.832 ↓ 1.0 217 1

Subquery Scan on j (cost=330.45..348.89 rows=214 width=29) (actual time=3.185..3.832 rows=217 loops=1)

  • Output: j.lang, j.lat, j.id
  • Buffers: shared hit=94
25. 0.316 3.736 ↓ 1.0 217 1

Unique (cost=330.45..346.75 rows=214 width=37) (actual time=3.184..3.736 rows=217 loops=1)

  • Output: a_1.id, b_1.lat, b_1.lang, b_1.id
  • Buffers: shared hit=94
26. 1.259 3.420 ↑ 2.7 1,208 1

Sort (cost=330.45..338.60 rows=3,261 width=37) (actual time=3.181..3.420 rows=1,208 loops=1)

  • Output: a_1.id, b_1.lat, b_1.lang, b_1.id
  • Sort Key: a_1.id, b_1.id DESC
  • Sort Method: quicksort Memory: 137kB
  • Buffers: shared hit=94
27. 1.161 2.161 ↑ 2.7 1,208 1

Hash Right Join (cost=15.82..140.15 rows=3,261 width=37) (actual time=0.157..2.161 rows=1,208 loops=1)

  • Output: a_1.id, b_1.lat, b_1.lang, b_1.id
  • Inner Unique: true
  • Hash Cond: (b_1.trip_id = a_1.id)
  • Buffers: shared hit=94
28. 0.856 0.856 ↑ 1.0 3,200 1

Seq Scan on public.mt_log_location b_1 (cost=0.00..115.61 rows=3,261 width=37) (actual time=0.003..0.856 rows=3,200 loops=1)

  • Output: b_1.id, b_1.lat, b_1.lang, b_1.trip_id, b_1.create_date, b_1.create_by, b_1.update_date, b_1.update_by, b_1.keterangan, b_1.driver_id
  • Buffers: shared hit=83
29. 0.067 0.144 ↓ 1.0 217 1

Hash (cost=13.14..13.14 rows=214 width=8) (actual time=0.144..0.144 rows=217 loops=1)

  • Output: a_1.id
  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
  • Buffers: shared hit=11
30. 0.077 0.077 ↓ 1.0 217 1

Seq Scan on public.mt_master_trip a_1 (cost=0.00..13.14 rows=214 width=8) (actual time=0.005..0.077 rows=217 loops=1)

  • Output: a_1.id
  • Buffers: shared hit=11
Planning time : 1.678 ms
Execution time : 4.660 ms