explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Wns

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

Limit (cost=33.12..66.33 rows=1 width=44) (actual time=2.195..2.195 rows=1 loops=1)

2. 0.012 2.193 ↑ 1.0 1 1

Nested Loop (cost=33.12..66.33 rows=1 width=44) (actual time=2.193..2.193 rows=1 loops=1)

3. 0.043 2.155 ↑ 1.0 1 1

Nested Loop (cost=33.12..59.39 rows=1 width=23) (actual time=2.155..2.155 rows=1 loops=1)

  • Join Filter: ((r.request_effective_date >= ep.strt_dt) AND (r.request_effective_date <= ep.end_dt))
4. 0.036 1.525 ↑ 1.0 1 1

Hash Right Join (cost=33.12..56.88 rows=1 width=36) (actual time=1.525..1.525 rows=1 loops=1)

  • Hash Cond: (rl.request_id = r.request_id)
5. 0.020 0.020 ↑ 71.4 14 1

Seq Scan on request_lock rl (cost=0.00..20.00 rows=1000 width=8) (actual time=0.017..0.020 rows=14 loops=1)

6. 0.005 1.469 ↑ 1.0 1 1

Hash (cost=33.11..33.11 rows=1 width=36) (actual time=1.469..1.469 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
7. 0.008 1.464 ↑ 1.0 1 1

Nested Loop (cost=0.00..33.11 rows=1 width=36) (actual time=0.558..1.464 rows=1 loops=1)

8. 1.433 1.433 ↑ 1.0 1 1

Seq Scan on request_client c (cost=0.00..24.82 rows=1 width=8) (actual time=0.530..1.433 rows=1 loops=1)

  • Filter: (((client_id)::text = '5QCYJ57F00C'::text) AND ((address_id)::text = 'R3ZSP57D00C'::text))
9. 0.023 0.023 ↑ 1.0 1 1

Index Scan using request_pkey on request r (cost=0.00..8.27 rows=1 width=36) (actual time=0.021..0.023 rows=1 loops=1)

  • Index Cond: (request_id = c.request_id)
10. 0.587 0.587 ↑ 1.0 1 1

Index Scan using fr705gix on edb_prod ep (cost=0.00..2.49 rows=1 width=23) (actual time=0.587..0.587 rows=1 loops=1)

  • Index Cond: (prod_id = (r.product_specification_id)::bpchar)
11. 0.026 0.026 ↑ 1.0 1 1

Index Scan using fr703aix on edb_spec es (cost=0.00..6.93 rows=1 width=45) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: (spec_id = (r.request_specification_id)::bpchar)