explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 6Xf

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.206 0.276 ↑ 1.0 576 1

Hash Join (cost=4.00..16.08 rows=576 width=615) (actual time=0.057..0.276 rows=576 loops=1)

  • Hash Cond: (s3_.service_offer_id = s2_.id)
2. 0.026 0.026 ↑ 1.0 288 1

Seq Scan on service_offer_capability s3_ (cost=0.00..4.88 rows=288 width=13) (actual time=0.007..0.026 rows=288 loops=1)

3. 0.013 0.044 ↑ 1.0 18 1

Hash (cost=3.78..3.78 rows=18 width=602) (actual time=0.044..0.044 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
4. 0.009 0.031 ↑ 1.0 18 1

Hash Join (cost=2.34..3.78 rows=18 width=602) (actual time=0.021..0.031 rows=18 loops=1)

  • Hash Cond: (s0_.id = s1_.service_id)
5. 0.009 0.015 ↑ 1.0 9 1

Hash Join (cost=1.11..2.33 rows=9 width=58) (actual time=0.011..0.015 rows=9 loops=1)

  • Hash Cond: (s2_.service_id = s0_.id)
6. 0.001 0.001 ↑ 1.0 9 1

Seq Scan on service_offer s2_ (cost=0.00..1.09 rows=9 width=29) (actual time=0.000..0.001 rows=9 loops=1)

7. 0.002 0.005 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=29) (actual time=0.005..0.005 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
8. 0.003 0.003 ↑ 1.0 5 1

Seq Scan on service s0_ (cost=0.00..1.05 rows=5 width=29) (actual time=0.001..0.003 rows=5 loops=1)

9. 0.005 0.007 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=544) (actual time=0.007..0.007 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
10. 0.002 0.002 ↑ 1.0 10 1

Seq Scan on service_tr s1_ (cost=0.00..1.10 rows=10 width=544) (actual time=0.001..0.002 rows=10 loops=1)