explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8MtH

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.155 ↓ 2.0 2 1

Limit (cost=28.30..28.30 rows=1 width=4,829) (actual time=0.155..0.155 rows=2 loops=1)

2. 0.007 0.154 ↓ 2.0 2 1

Sort (cost=28.30..28.30 rows=1 width=4,829) (actual time=0.154..0.154 rows=2 loops=1)

  • Sort Key: service_request.created_date DESC NULLS LAST
  • Sort Method: quicksort Memory: 25kB
3. 0.005 0.147 ↓ 2.0 2 1

Nested Loop Left Join (cost=2.91..28.29 rows=1 width=4,829) (actual time=0.128..0.147 rows=2 loops=1)

  • Join Filter: (service_request.type_id = typetransl4_.type_id)
  • Filter: ((typetransl4_.locale_id = 1) OR (typetransl4_.id IS NULL))
  • Rows Removed by Filter: 4
4. 0.012 0.134 ↓ 2.0 2 1

Nested Loop Left Join (cost=2.91..16.52 rows=1 width=4,829) (actual time=0.119..0.134 rows=2 loops=1)

  • Join Filter: (service_request.status_id = statustran3_.status_id)
  • Rows Removed by Join Filter: 48
  • Filter: ((statustran3_.locale_id = 1) OR (statustran3_.id IS NULL))
  • Rows Removed by Filter: 4
5. 0.014 0.110 ↓ 2.0 2 1

Hash Right Join (cost=2.91..14.85 rows=1 width=4,829) (actual time=0.103..0.110 rows=2 loops=1)

  • Hash Cond: (countrytra1_.country_id = service_request.country_id)
  • Filter: ((countrytra1_.locale_id = 1) OR (countrytra1_.id IS NULL))
  • Rows Removed by Filter: 4
6. 0.006 0.006 ↑ 15.6 9 1

Seq Scan on country_translation countrytra1_ (cost=0.00..11.40 rows=140 width=24) (actual time=0.005..0.006 rows=9 loops=1)

7. 0.002 0.090 ↓ 2.0 2 1

Hash (cost=2.90..2.90 rows=1 width=4,829) (actual time=0.089..0.090 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 0.034 0.088 ↓ 2.0 2 1

Hash Right Join (cost=1.04..2.90 rows=1 width=4,829) (actual time=0.068..0.088 rows=2 loops=1)

  • Hash Cond: (regiontran2_.region_id = service_request.region_id)
  • Filter: ((regiontran2_.locale_id = 1) OR (regiontran2_.id IS NULL))
  • Rows Removed by Filter: 4
9. 0.013 0.013 ↑ 1.0 60 1

Seq Scan on region_translation regiontran2_ (cost=0.00..1.60 rows=60 width=24) (actual time=0.007..0.013 rows=60 loops=1)

10. 0.007 0.041 ↓ 2.0 2 1

Hash (cost=1.02..1.02 rows=1 width=4,829) (actual time=0.040..0.041 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
11. 0.034 0.034 ↓ 2.0 2 1

Seq Scan on service_request (cost=0.00..1.02 rows=1 width=4,829) (actual time=0.031..0.034 rows=2 loops=1)

  • Filter: (type_id = 1)
12. 0.012 0.012 ↑ 1.0 27 2

Seq Scan on status_translation statustran3_ (cost=0.00..1.27 rows=27 width=24) (actual time=0.004..0.006 rows=27 loops=2)

13. 0.008 0.008 ↓ 3.0 3 2

Seq Scan on type_translation typetransl4_ (cost=0.00..11.75 rows=1 width=24) (actual time=0.003..0.004 rows=3 loops=2)

  • Filter: (type_id = 1)
  • Rows Removed by Filter: 6
Planning time : 0.497 ms
Execution time : 0.211 ms