explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pTcH

Settings
# 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.287 662.727 ↑ 1.4 45 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.240 662.434 ↑ 1.4 45 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.417 662.189 ↑ 1.5 43 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.213 661.763 ↑ 1.5 43 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.367 661.546 ↑ 1.5 43 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.598 661.172 ↑ 1.5 43 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
→

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: 4050520
12. 0.012 0.012 ↑ 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=0.012..0.012 rows=1 loops=130)

  • Index Cond: ((object_id)::text = (object_address.object_id)::text)
13. 0.007 0.007 ↑ 1.0 1 130
→

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.004 0.004 ↓ 0.0 0 130
→

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.009 0.009 ↑ 1.0 1 130
→

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.005 0.005 ↓ 0.0 0 130
→

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.006 0.006 ↓ 0.0 0 134
→

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)