#	exclusive	inclusive	rows x	rows	loops	node
1.	0.048	673.078	↑ 1.2	130	1	→ Sort (cost=398,548.09..398,548.47 rows=152 width=156) (actual time=673.074..673.078 rows=130 loops=1) Sort Key: ((NULLIF(regexp_replace((d.object_cn)::text, '\D'::text, ''::text, 'g'::text), ''::text))::bigint) Sort Method: quicksort Memory: 56kB
2.	0.410	673.030	↑ 1.2	130	1	→ GroupAggregate (cost=398,534.22..398,542.58 rows=152 width=156) (actual time=672.641..673.030 rows=130 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.	0.000	672.620	↑ 1.1	134	1	→ Sort (cost=398,534.22..398,534.60 rows=152 width=160) (actual time=672.613..672.620 rows=134 loops=1) Sort 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 Method: quicksort Memory: 48kB
4.	10.667	673.394	↑ 1.1	134	1	→ Gather (cost=1,003.10..398,528.71 rows=152 width=160) (actual time=21.260..673.394 rows=134 loops=1) Workers Planned: 2 Workers Launched: 2
5.	0.025	662.727	↑ 1.4	45	3 / 3	→ Nested Loop Left Join (cost=3.10..397,513.51 rows=63 width=160) (actual time=18.212..662.727 rows=45 loops=3)
6.	0.028	662.434	↑ 1.4	45	3 / 3	→ Nested Loop Left Join (cost=2.54..394,089.64 rows=63 width=153) (actual time=18.117..662.434 rows=45 loops=3)
7.	0.036	662.189	↑ 1.5	43	3 / 3	→ Nested Loop Left Join (cost=1.99..393,396.37 rows=63 width=115) (actual time=18.094..662.189 rows=43 loops=3)
8.	0.044	661.763	↑ 1.5	43	3 / 3	→ Nested Loop Left Join (cost=1.55..393,047.28 rows=63 width=109) (actual time=18.057..661.763 rows=43 loops=3)
9.	0.071	661.546	↑ 1.5	43	3 / 3	→ Nested Loop Left Join (cost=1.12..392,699.82 rows=63 width=99) (actual time=18.029..661.546 rows=43 loops=3)
10.	0.090	661.172	↑ 1.5	43	3 / 3	→ Nested Loop (cost=0.56..392,340.02 rows=63 width=63) (actual time=17.997..661.172 rows=43 loops=3)
11.	660.562	660.562	↑ 1.5	43	3 / 3	→ Parallel Seq Scan on object_address (cost=0.00..391,799.64 rows=63 width=15) (actual time=17.934..660.562 rows=43 loops=3) Filter: (((object_street)::text = 'Ленинский'::text) AND ((object_house)::text = '97'::text)) Rows Removed by Filter: 4,050,520
12.	0.520	0.520	↑ 1.0	1	130 / 3	→ Index Scan using object_data_pkey on object_data d (cost=0.56..8.58 rows=1 width=63) (actual time=0.012..0.012 rows=1 loops=130) Index Cond: ((object_id)::text = (object_address.object_id)::text)
13.	0.303	0.303	↑ 1.0	1	130 / 3	→ Index Scan using object_address_pkey on object_address a (cost=0.56..5.71 rows=1 width=51) (actual time=0.007..0.007 rows=1 loops=130) Index Cond: ((d.object_id)::text = (object_id)::text)
14.	0.173	0.173	↓ 0.0	0	130 / 3	→ Index Scan using premises_data_pkey on premises_data p (cost=0.43..5.52 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=130) Index Cond: ((d.object_id)::text = (object_id)::text)
15.	0.390	0.390	↑ 1.0	1	130 / 3	→ Index Scan using parcel_data_pkey on parcel_data par (cost=0.43..5.54 rows=1 width=21) (actual time=0.009..0.009 rows=1 loops=130) Index Cond: ((d.object_id)::text = (object_id)::text)
16.	0.217	0.217	↓ 0.0	0	130 / 3	→ Index Scan using right_data_pkey on right_data r (cost=0.56..10.97 rows=3 width=53) (actual time=0.005..0.005 rows=0 loops=130) Index Cond: ((d.object_id)::text = (object_id)::text)
17.	0.268	0.268	↓ 0.0	0	134 / 3	→ Index Scan using encumbrance_data_pkey on encumbrance_data e (cost=0.56..54.15 rows=20 width=22) (actual time=0.006..0.006 rows=0 loops=134) Index Cond: ((d.object_id)::text = (object_id)::text)

                                                                                          QUERY PLAN                                                                                           
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Sort  (cost=398548.09..398548.47 rows=152 width=156) (actual time=673.074..673.078 rows=130 loops=1)
   Sort Key: ((NULLIF(regexp_replace((d.object_cn)::text, '\D'::text, ''::text, 'g'::text), ''::text))::bigint)
   Sort Method: quicksort  Memory: 56kB
   ->  GroupAggregate  (cost=398534.22..398542.58 rows=152 width=156) (actual time=672.641..673.030 rows=130 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=398534.22..398534.60 rows=152 width=160) (actual time=672.613..672.620 rows=134 loops=1)
               Sort 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 Method: quicksort  Memory: 48kB
               ->  Gather  (cost=1003.10..398528.71 rows=152 width=160) (actual time=21.260..673.394 rows=134 loops=1)
                     Workers Planned: 2
                     Workers Launched: 2
                     ->  Nested Loop Left Join  (cost=3.10..397513.51 rows=63 width=160) (actual time=18.212..662.727 rows=45 loops=3)
                           ->  Nested Loop Left Join  (cost=2.54..394089.64 rows=63 width=153) (actual time=18.117..662.434 rows=45 loops=3)
                                 ->  Nested Loop Left Join  (cost=1.99..393396.37 rows=63 width=115) (actual time=18.094..662.189 rows=43 loops=3)
                                       ->  Nested Loop Left Join  (cost=1.55..393047.28 rows=63 width=109) (actual time=18.057..661.763 rows=43 loops=3)
                                             ->  Nested Loop Left Join  (cost=1.12..392699.82 rows=63 width=99) (actual time=18.029..661.546 rows=43 loops=3)
                                                   ->  Nested Loop  (cost=0.56..392340.02 rows=63 width=63) (actual time=17.997..661.172 rows=43 loops=3)
                                                         ->  Parallel Seq Scan on object_address  (cost=0.00..391799.64 rows=63 width=15) (actual time=17.934..660.562 rows=43 loops=3)
                                                               Filter: (((object_street)::text = 'Ленинский'::text) AND ((object_house)::text = '97'::text))
                                                               Rows Removed by Filter: 4050520
                                                         ->  Index Scan using object_data_pkey on object_data d  (cost=0.56..8.58 rows=1 width=63) (actual time=0.012..0.012 rows=1 loops=130)
                                                               Index Cond: ((object_id)::text = (object_address.object_id)::text)
                                                   ->  Index Scan using object_address_pkey on object_address a  (cost=0.56..5.71 rows=1 width=51) (actual time=0.007..0.007 rows=1 loops=130)
                                                         Index Cond: ((d.object_id)::text = (object_id)::text)
                                             ->  Index Scan using premises_data_pkey on premises_data p  (cost=0.43..5.52 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=130)
                                                   Index Cond: ((d.object_id)::text = (object_id)::text)
                                       ->  Index Scan using parcel_data_pkey on parcel_data par  (cost=0.43..5.54 rows=1 width=21) (actual time=0.009..0.009 rows=1 loops=130)
                                             Index Cond: ((d.object_id)::text = (object_id)::text)
                                 ->  Index Scan using right_data_pkey on right_data r  (cost=0.56..10.97 rows=3 width=53) (actual time=0.005..0.005 rows=0 loops=130)
                                       Index Cond: ((d.object_id)::text = (object_id)::text)
                           ->  Index Scan using encumbrance_data_pkey on encumbrance_data e  (cost=0.56..54.15 rows=20 width=22) (actual time=0.006..0.006 rows=0 loops=134)
                                 Index Cond: ((d.object_id)::text = (object_id)::text)

Per node type stats

node type	count	sum of times	% of query
Gather	1	10.667 ms	1.6 %
GroupAggregate	1	0.410 ms	0.1 %
Index Scan	6	1.871 ms	0.3 %
Nested Loop	1	0.090 ms	0.0 %
Nested Loop Left Join	5	0.204 ms	0.0 %
Parallel Seq Scan	1	660.562 ms	98.1 %
Sort	2	0.048 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	0.268 ms	0.0 %
Index Scan	1	0.268 ms	100.0 %
object_address	2	660.865 ms	98.2 %
Index Scan	1	0.303 ms	0.0 %
Parallel Seq Scan	1	660.562 ms	100.0 %
object_data	1	0.520 ms	0.1 %
Index Scan	1	0.520 ms	100.0 %
parcel_data	1	0.390 ms	0.1 %
Index Scan	1	0.390 ms	100.0 %
premises_data	1	0.173 ms	0.0 %
Index Scan	1	0.173 ms	100.0 %
right_data	1	0.217 ms	0.0 %
Index Scan	1	0.217 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pTcH

Color mode:

Visible columns:

Per node type stats

Per table stats