explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sSj6 : 123

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 27.159 ↓ 3.8 23 1

Merge Right Join (cost=1,052.90..1,092.62 rows=6 width=24) (actual time=27.148..27.159 rows=23 loops=1)

  • Merge Cond: (m.mo_contract_id = m_1.id)
2. 4.530 27.094 ↑ 17.2 158 1

Sort (cost=1,044.58..1,051.39 rows=2,723 width=16) (actual time=27.077..27.094 rows=158 loops=1)

  • Sort Key: m.mo_contract_id, m.id
  • Sort Method: quicksort Memory: 444kB
3. 2.681 22.564 ↓ 2.0 5,357 1

Hash Join (cost=567.83..889.22 rows=2,723 width=16) (actual time=12.228..22.564 rows=5,357 loops=1)

  • Hash Cond: (mgu.mogu_gps_unit_id = gu.id)
4. 2.912 13.035 ↓ 1.5 5,357 1

Hash Join (cost=299.50..579.90 rows=3,671 width=24) (actual time=5.299..13.035 rows=5,357 loops=1)

  • Hash Cond: (mgu.mogu_mobject_id = m.id)
5. 4.903 4.903 ↓ 1.0 5,357 1

Seq Scan on uzgps_mobject_gps_units mgu (cost=0.00..223.73 rows=5,323 width=16) (actual time=0.011..4.903 rows=5,357 loops=1)

  • Filter: ((mogu_status)::text = 'A'::text)
  • Rows Removed by Filter: 2861
6. 1.437 5.220 ↓ 1.0 5,370 1

Hash (cost=232.76..232.76 rows=5,339 width=16) (actual time=5.220..5.220 rows=5,370 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 316kB
7. 3.783 3.783 ↓ 1.0 5,370 1

Seq Scan on uzgps_mobject m (cost=0.00..232.76 rows=5,339 width=16) (actual time=0.011..3.783 rows=5,370 loops=1)

  • Filter: ((mo_status)::text = 'A'::text)
  • Rows Removed by Filter: 2371
8. 1.663 6.848 ↓ 1.0 5,462 1

Hash (cost=200.48..200.48 rows=5,428 width=8) (actual time=6.848..6.848 rows=5,462 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 278kB
9. 5.185 5.185 ↓ 1.0 5,462 1

Seq Scan on uzgps_gps_unit gu (cost=0.00..200.48 rows=5,428 width=8) (actual time=0.017..5.185 rows=5,462 loops=1)

  • Filter: ((gu_status)::text = 'A'::text)
  • Rows Removed by Filter: 1856
10. 0.003 0.038 ↑ 1.0 1 1

Materialize (cost=8.32..8.32 rows=1 width=8) (actual time=0.037..0.038 rows=1 loops=1)

11. 0.014 0.035 ↑ 1.0 1 1

Sort (cost=8.32..8.32 rows=1 width=8) (actual time=0.035..0.035 rows=1 loops=1)

  • Sort Key: m_1.id
  • Sort Method: quicksort Memory: 25kB
12. 0.021 0.021 ↑ 1.0 1 1

Index Scan using uzgps_contract_pkey on uzgps_contract m_1 (cost=0.28..8.30 rows=1 width=8) (actual time=0.020..0.021 rows=1 loops=1)

  • Index Cond: (id = 12)
  • Filter: ((c_status)::text = 'A'::text)