explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qE4Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.113 3.502 ↓ 2.0 4 1

Unique (cost=226.83..226.98 rows=2 width=407) (actual time=3.301..3.502 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=189
2. 0.591 3.389 ↓ 15.2 457 1

Sort (cost=226.83..226.91 rows=30 width=407) (actual time=3.300..3.389 rows=457 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: 260kB
  • Buffers: shared hit=189
3. 1.493 2.798 ↓ 15.2 457 1

Hash Right Join (cost=97.88..226.10 rows=30 width=407) (actual time=0.468..2.798 rows=457 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
  • Hash Cond: (j.trip_id = c.id)
  • Buffers: shared hit=189
4. 0.861 0.861 ↑ 1.0 3,200 1

Seq Scan on public.mt_log_location j (cost=0.00..115.61 rows=3,261 width=29) (actual time=0.003..0.861 rows=3,200 loops=1)

  • Output: j.id, j.lat, j.lang, j.trip_id, j.create_date, j.create_by, j.update_date, j.update_by, j.keterangan, j.driver_id
  • Buffers: shared hit=83
5. 0.009 0.444 ↓ 2.0 4 1

Hash (cost=97.86..97.86 rows=2 width=354) (actual time=0.444..0.444 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
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=106
6. 0.003 0.435 ↓ 2.0 4 1

Nested Loop Left Join (cost=49.92..97.86 rows=2 width=354) (actual time=0.238..0.435 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
7. 0.004 0.420 ↓ 2.0 4 1

Nested Loop Left Join (cost=49.77..93.68 rows=2 width=323) (actual time=0.229..0.420 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
8. 0.005 0.404 ↓ 2.0 4 1

Nested Loop Left Join (cost=49.50..77.06 rows=2 width=275) (actual time=0.222..0.404 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
9. 0.003 0.387 ↓ 2.0 4 1

Nested Loop Left Join (cost=49.22..60.45 rows=2 width=227) (actual time=0.213..0.387 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
10. 0.004 0.372 ↓ 2.0 4 1

Nested Loop Left Join (cost=49.09..60.02 rows=2 width=219) (actual time=0.206..0.372 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
11. 0.013 0.356 ↓ 2.0 4 1

Nested Loop Left Join (cost=48.81..57.41 rows=2 width=217) (actual time=0.197..0.356 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
12. 0.005 0.319 ↓ 2.0 4 1

Nested Loop Left Join (cost=48.81..55.90 rows=2 width=119) (actual time=0.177..0.319 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
13. 0.082 0.298 ↓ 2.0 4 1

Hash Right Join (cost=48.54..54.87 rows=2 width=85) (actual time=0.166..0.298 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
14. 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.005..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
15. 0.007 0.149 ↓ 2.0 4 1

Hash (cost=48.52..48.52 rows=2 width=77) (actual time=0.149..0.149 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
16. 0.142 0.142 ↓ 2.0 4 1

Seq Scan on public.mt_shipper_order a (cost=0.00..48.52 rows=2 width=77) (actual time=0.008..0.142 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
17. 0.016 0.016 ↑ 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.004..0.004 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
18. 0.016 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
19. 0.008 0.008 ↑ 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.005..0.008 rows=11 loops=1)

  • Output: d.status_ind, d.id
  • Buffers: shared hit=1
20. 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
21. 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.002..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
22. 0.012 0.012 ↑ 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.003..0.003 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
23. 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
24. 0.012 0.012 ↑ 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.003..0.003 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
Planning time : 1.641 ms
Execution time : 3.703 ms