explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iePJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.276 692.376 ↓ 72.1 649 1

Sort (cost=393,093.88..393,093.90 rows=9 width=156) (actual time=692.336..692.376 rows=649 loops=1)

  • Sort Key: ((NULLIF(regexp_replace((d.object_cn)::text, '\D'::text, ''::text, 'g'::text), ''::text))::bigint)
  • Sort Method: quicksort Memory: 192kB
2. 1.956 692.100 ↓ 72.1 649 1

GroupAggregate (cost=393,093.24..393,093.74 rows=9 width=156) (actual time=690.130..692.100 rows=649 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. 2.495 690.144 ↓ 82.8 745 1

Sort (cost=393,093.24..393,093.27 rows=9 width=160) (actual time=690.102..690.144 rows=745 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: 191kB
4. 9.636 687.649 ↓ 82.8 745 1

Gather (cost=1,002.54..393,093.10 rows=9 width=160) (actual time=50.917..687.649 rows=745 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 1.119 678.013 ↓ 62.0 248 3

Nested Loop Left Join (cost=2.54..392,092.20 rows=4 width=160) (actual time=40.593..678.013 rows=248 loops=3)

6. 1.201 676.890 ↓ 57.8 231 3

Nested Loop Left Join (cost=1.98..391,909.53 rows=4 width=153) (actual time=40.573..676.890 rows=231 loops=3)

7. 1.365 675.684 ↓ 54.0 216 3

Nested Loop Left Join (cost=1.43..391,871.58 rows=4 width=115) (actual time=40.559..675.684 rows=216 loops=3)

8. 1.132 674.313 ↓ 54.0 216 3

Nested Loop Left Join (cost=0.99..391,852.68 rows=4 width=109) (actual time=40.541..674.313 rows=216 loops=3)

9. 2.003 673.176 ↓ 54.0 216 3

Nested Loop (cost=0.56..391,833.95 rows=4 width=99) (actual time=40.519..673.176 rows=216 loops=3)

10. 671.165 671.165 ↓ 54.0 216 3

Parallel Seq Scan on object_address a (cost=0.00..391,799.64 rows=4 width=51) (actual time=40.463..671.165 rows=216 loops=3)

  • Filter: (((object_street)::text = 'Ленинский'::text) AND ((object_house)::text = '98'::text))
  • Rows Removed by Filter: 4050347
11. 0.008 0.008 ↑ 1.0 1 649

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

  • Index Cond: ((object_id)::text = (a.object_id)::text)
12. 0.005 0.005 ↓ 0.0 0 649

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

  • Index Cond: ((d.object_id)::text = (object_id)::text)
13. 0.006 0.006 ↑ 1.0 1 649

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

  • Index Cond: ((d.object_id)::text = (object_id)::text)
14. 0.005 0.005 ↓ 0.0 0 649

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

  • Index Cond: ((d.object_id)::text = (object_id)::text)
15. 0.004 0.004 ↓ 0.0 0 694

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

  • Index Cond: ((d.object_id)::text = (object_id)::text)