explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mkI1

Settings
# exclusive inclusive rows x rows loops node
1. 0.049 4,349.930 ↑ 1.2 130 1

Sort (cost=397,442.11..397,442.49 rows=152 width=156) (actual time=4,349.924..4,349.930 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. 1.266 4,349.881 ↑ 1.2 130 1

GroupAggregate (cost=397,428.24..397,436.60 rows=152 width=156) (actual time=4,348.635..4,349.881 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 4,348.615 ↑ 1.1 134 1

Sort (cost=397,428.24..397,428.62 rows=152 width=160) (actual time=4,348.607..4,348.615 rows=134 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: 48kB
4. 3.365 4,349.410 ↑ 1.1 134 1

Gather (cost=1,002.54..397,422.73 rows=152 width=160) (actual time=427.961..4,349.410 rows=134 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 420.454 4,346.045 ↑ 1.4 45 3

Nested Loop Left Join (cost=2.54..396,407.53 rows=63 width=160) (actual time=421.375..4,346.045 rows=45 loops=3)

6. 738.891 3,915.966 ↑ 1.4 45 3

Nested Loop Left Join (cost=1.98..393,530.41 rows=63 width=153) (actual time=410.821..3,915.966 rows=45 loops=3)

7. 501.751 3,159.625 ↑ 1.5 43 3

Nested Loop Left Join (cost=1.43..392,932.75 rows=63 width=115) (actual time=387.420..3,159.625 rows=43 loops=3)

8. 376.317 2,646.025 ↑ 1.5 43 3

Nested Loop Left Join (cost=0.99..392,635.05 rows=63 width=109) (actual time=201.207..2,646.025 rows=43 loops=3)

9. 1,377.124 2,260.824 ↑ 1.5 43 3

Nested Loop (cost=0.56..392,340.02 rows=63 width=99) (actual time=174.740..2,260.824 rows=43 loops=3)

10. 851.175 851.175 ↑ 1.5 43 3

Parallel Seq Scan on object_address a (cost=0.00..391,799.64 rows=63 width=51) (actual time=15.191..851.175 rows=43 loops=3)

  • Filter: (((object_street)::text = 'Ленинский'::text) AND ((object_house)::text = '97'::text))
  • Rows Removed by Filter: 4050520
11. 32.525 32.525 ↑ 1.0 1 130

Index Scan using object_data_pkey on object_data d (cost=0.56..8.58 rows=1 width=63) (actual time=32.525..32.525 rows=1 loops=130)

  • Index Cond: ((object_id)::text = (a.object_id)::text)
12. 8.884 8.884 ↓ 0.0 0 130

Index Scan using premises_data_pkey on premises_data p (cost=0.43..4.68 rows=1 width=25) (actual time=8.884..8.884 rows=0 loops=130)

  • Index Cond: ((d.object_id)::text = (object_id)::text)
13. 11.849 11.849 ↑ 1.0 1 130

Index Scan using parcel_data_pkey on parcel_data par (cost=0.43..4.73 rows=1 width=21) (actual time=11.849..11.849 rows=1 loops=130)

  • Index Cond: ((d.object_id)::text = (object_id)::text)
14. 17.450 17.450 ↓ 0.0 0 130

Index Scan using right_data_pkey on right_data r (cost=0.56..9.46 rows=3 width=53) (actual time=17.442..17.450 rows=0 loops=130)

  • Index Cond: ((d.object_id)::text = (object_id)::text)
15. 9.625 9.625 ↓ 0.0 0 134

Index Scan using encumbrance_data_pkey on encumbrance_data e (cost=0.56..45.47 rows=20 width=22) (actual time=9.625..9.625 rows=0 loops=134)

  • Index Cond: ((d.object_id)::text = (object_id)::text)
Planning time : 1.000 ms
Execution time : 4,351.357 ms