#	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)

"Limit  (cost=33.12..66.33 rows=1 width=44) (actual time=2.195..2.195 rows=1 loops=1)"
"  ->  Nested Loop  (cost=33.12..66.33 rows=1 width=44) (actual time=2.193..2.193 rows=1 loops=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))"
"              ->  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)"
"                    ->  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)"
"                    ->  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"
"                          ->  Nested Loop  (cost=0.00..33.11 rows=1 width=36) (actual time=0.558..1.464 rows=1 loops=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))"
"                                ->  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)"
"              ->  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)"
"        ->  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)"
"Total runtime: 2.505 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	1	0.005 ms	0.2 %
Hash Right Join	1	0.036 ms	1.6 %
Index Scan	3	0.636 ms	29.0 %
Limit	1	0.002 ms	0.1 %
Nested Loop	3	0.063 ms	2.9 %
Seq Scan	2	1.453 ms	66.2 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
edb_prod	1	0.587 ms	26.7 %
Index Scan	1	0.587 ms	100.0 %
edb_spec	1	0.026 ms	1.2 %
Index Scan	1	0.026 ms	100.0 %
request	1	0.023 ms	1.0 %
Index Scan	1	0.023 ms	100.0 %
request_client	1	1.433 ms	65.3 %
Seq Scan	1	1.433 ms	100.0 %
request_lock	1	0.020 ms	0.9 %
Seq Scan	1	0.020 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Wns

Colorize:

Columns visibility:

Per node type stats

Per table stats