#	exclusive	inclusive	rows x	rows	loops	node
1.	0.366	16,781.661	↓ 7.0	362	1	→ Sort (cost=4,022.76..4,022.89 rows=52 width=156) (actual time=16,781.619..16,781.661 rows=362 loops=1) Sort Key: ((NULLIF(regexp_replace((d.object_cn)::text, '\D'::text, ''::text, 'g'::text), ''::text))::bigint) Sort Method: quicksort Memory: 120kB
2.	3.504	16,781.295	↓ 7.0	362	1	→ GroupAggregate (cost=4,018.42..4,021.28 rows=52 width=156) (actual time=16,777.779..16,781.295 rows=362 loops=1) Group Key: d.object_id, a.object_street, a.object_house, a.object_building, a.object_structure, a.object_apartment, p.premises_floor, p.area_value, par.area_value
3.	3.462	16,777.791	↓ 8.7	452	1	→ Sort (cost=4,018.42..4,018.55 rows=52 width=160) (actual time=16,777.728..16,777.791 rows=452 loops=1) Sort Key: d.object_id, a.object_building, a.object_structure, a.object_apartment, p.premises_floor, p.area_value, par.area_value Sort Method: quicksort Memory: 121kB
4.	2.824	16,774.329	↓ 8.7	452	1	→ Nested Loop Left Join (cost=3.10..4,016.94 rows=52 width=160) (actual time=85.583..16,774.329 rows=452 loops=1)
5.	2.391	15,258.505	↓ 8.2	425	1	→ Nested Loop Left Join (cost=2.54..1,642.17 rows=52 width=153) (actual time=67.987..15,258.505 rows=425 loops=1)
6.	2.031	9,966.932	↓ 7.0	362	1	→ Nested Loop Left Join (cost=1.99..1,148.87 rows=52 width=115) (actual time=42.858..9,966.932 rows=362 loops=1)
7.	2.971	8,953.111	↓ 7.0	362	1	→ Nested Loop Left Join (cost=1.55..903.15 rows=52 width=109) (actual time=42.800..8,953.111 rows=362 loops=1)
8.	2.303	4,885.604	↓ 7.0	362	1	→ Nested Loop (cost=1.12..659.63 rows=52 width=99) (actual time=19.575..4,885.604 rows=362 loops=1)
9.	4.265	4.265	↓ 7.0	362	1	→ Index Scan using object_adress_index on object_address a (cost=0.56..213.60 rows=52 width=51) (actual time=0.177..4.265 rows=362 loops=1) Index Cond: (((object_street)::text = 'Ленинский'::text) AND ((object_house)::text = '102'::text))
10.	4,879.036	4,879.036	↑ 1.0	1	362	→ Index Scan using object_data_pkey on object_data d (cost=0.56..8.58 rows=1 width=63) (actual time=13.478..13.478 rows=1 loops=362) Index Cond: ((object_id)::text = (a.object_id)::text)
11.	4,064.536	4,064.536	↓ 0.0	0	362	→ Index Scan using premises_data_pkey on premises_data p (cost=0.43..4.68 rows=1 width=25) (actual time=11.228..11.228 rows=0 loops=362) Index Cond: ((d.object_id)::text = (object_id)::text)
12.	1,011.790	1,011.790	↑ 1.0	1	362	→ Index Scan using parcel_data_pkey on parcel_data par (cost=0.43..4.73 rows=1 width=21) (actual time=2.795..2.795 rows=1 loops=362) Index Cond: ((d.object_id)::text = (object_id)::text)
13.	5,289.182	5,289.182	↑ 3.0	1	362	→ Index Scan using right_data_pkey on right_data r (cost=0.56..9.46 rows=3 width=53) (actual time=14.200..14.611 rows=1 loops=362) Index Cond: ((d.object_id)::text = (object_id)::text)
14.	1,513.000	1,513.000	↓ 0.0	0	425	→ Index Scan using encumbrance_data_pkey on encumbrance_data e (cost=0.56..45.47 rows=20 width=22) (actual time=3.559..3.560 rows=0 loops=425) Index Cond: ((d.object_id)::text = (object_id)::text)

                                                                                        QUERY PLAN                                                                                         
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Sort  (cost=4022.76..4022.89 rows=52 width=156) (actual time=16781.619..16781.661 rows=362 loops=1)
   Sort Key: ((NULLIF(regexp_replace((d.object_cn)::text, '\D'::text, ''::text, 'g'::text), ''::text))::bigint)
   Sort Method: quicksort  Memory: 120kB
   ->  GroupAggregate  (cost=4018.42..4021.28 rows=52 width=156) (actual time=16777.779..16781.295 rows=362 loops=1)
         Group Key: d.object_id, a.object_street, a.object_house, a.object_building, a.object_structure, a.object_apartment, p.premises_floor, p.area_value, par.area_value
         ->  Sort  (cost=4018.42..4018.55 rows=52 width=160) (actual time=16777.728..16777.791 rows=452 loops=1)
               Sort Key: d.object_id, a.object_building, a.object_structure, a.object_apartment, p.premises_floor, p.area_value, par.area_value
               Sort Method: quicksort  Memory: 121kB
               ->  Nested Loop Left Join  (cost=3.10..4016.94 rows=52 width=160) (actual time=85.583..16774.329 rows=452 loops=1)
                     ->  Nested Loop Left Join  (cost=2.54..1642.17 rows=52 width=153) (actual time=67.987..15258.505 rows=425 loops=1)
                           ->  Nested Loop Left Join  (cost=1.99..1148.87 rows=52 width=115) (actual time=42.858..9966.932 rows=362 loops=1)
                                 ->  Nested Loop Left Join  (cost=1.55..903.15 rows=52 width=109) (actual time=42.800..8953.111 rows=362 loops=1)
                                       ->  Nested Loop  (cost=1.12..659.63 rows=52 width=99) (actual time=19.575..4885.604 rows=362 loops=1)
                                             ->  Index Scan using object_adress_index on object_address a  (cost=0.56..213.60 rows=52 width=51) (actual time=0.177..4.265 rows=362 loops=1)
                                                   Index Cond: (((object_street)::text = 'Ленинский'::text) AND ((object_house)::text = '102'::text))
                                             ->  Index Scan using object_data_pkey on object_data d  (cost=0.56..8.58 rows=1 width=63) (actual time=13.478..13.478 rows=1 loops=362)
                                                   Index Cond: ((object_id)::text = (a.object_id)::text)
                                       ->  Index Scan using premises_data_pkey on premises_data p  (cost=0.43..4.68 rows=1 width=25) (actual time=11.228..11.228 rows=0 loops=362)
                                             Index Cond: ((d.object_id)::text = (object_id)::text)
                                 ->  Index Scan using parcel_data_pkey on parcel_data par  (cost=0.43..4.73 rows=1 width=21) (actual time=2.795..2.795 rows=1 loops=362)
                                       Index Cond: ((d.object_id)::text = (object_id)::text)
                           ->  Index Scan using right_data_pkey on right_data r  (cost=0.56..9.46 rows=3 width=53) (actual time=14.200..14.611 rows=1 loops=362)
                                 Index Cond: ((d.object_id)::text = (object_id)::text)
                     ->  Index Scan using encumbrance_data_pkey on encumbrance_data e  (cost=0.56..45.47 rows=20 width=22) (actual time=3.559..3.560 rows=0 loops=425)
                           Index Cond: ((d.object_id)::text = (object_id)::text)

Per node type stats

node type	count	sum of times	% of query
GroupAggregate	1	3.504 ms	0.0 %
Index Scan	6	16,761.809 ms	99.9 %
Nested Loop	1	2.303 ms	0.0 %
Nested Loop Left Join	4	10.217 ms	0.1 %
Sort	2	3.828 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
encumbrance_data	1	1,513.000 ms	9.0 %
Index Scan	1	1,513.000 ms	100.0 %
object_address	1	4.265 ms	0.0 %
Index Scan	1	4.265 ms	100.0 %
object_data	1	4,879.036 ms	29.1 %
Index Scan	1	4,879.036 ms	100.0 %
parcel_data	1	1,011.790 ms	6.0 %
Index Scan	1	1,011.790 ms	100.0 %
premises_data	1	4,064.536 ms	24.2 %
Index Scan	1	4,064.536 ms	100.0 %
right_data	1	5,289.182 ms	31.5 %
Index Scan	1	5,289.182 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FXTX

Color mode:

Visible columns:

Per node type stats

Per table stats