explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YM7B

Settings
# exclusive inclusive rows x rows loops node
1. 6.044 78,437.170 ↑ 1.0 10,000 1

Limit (cost=2.10..188,202.44 rows=10,000 width=183) (actual time=0.754..78,437.170 rows=10,000 loops=1)

2. 46.739 78,431.126 ↑ 223.1 10,000 1

Nested Loop Left Join (cost=2.10..41,979,950.58 rows=2,230,599 width=183) (actual time=0.751..78,431.126 rows=10,000 loops=1)

3. 48.352 78,374.387 ↑ 223.1 10,000 1

Nested Loop Left Join (cost=1.69..40,998,307.68 rows=2,230,599 width=259) (actual time=0.742..78,374.387 rows=10,000 loops=1)

4. 33.238 34,766.035 ↑ 223.1 10,000 1

Nested Loop Left Join (cost=1.12..39,674,933.22 rows=2,230,599 width=314) (actual time=0.623..34,766.035 rows=10,000 loops=1)

5. 58.291 34,302.797 ↑ 223.1 10,000 1

Nested Loop (cost=0.56..38,306,673.23 rows=2,230,599 width=324) (actual time=0.615..34,302.797 rows=10,000 loops=1)

6. 27.141 27.141 ↑ 3,528.6 16,765 1

Seq Scan on fnsrf22pump_temp_link t (cost=0.00..2,019,359.12 rows=59,157,212 width=330) (actual time=0.046..27.141 rows=16,765 loops=1)

7. 34,217.365 34,217.365 ↑ 1.0 1 16,765

Index Scan using uk_d_egr_fnsrfogrn on d_egr_fnsrf egr (cost=0.56..0.60 rows=1 width=31) (actual time=2.041..2.041 rows=1 loops=16,765)

  • Index Cond: ((ogrn)::text = (t.ogrn)::text)
  • Filter: ((id IS NOT NULL) AND (t.loaddate = loaddate))
  • Rows Removed by Filter: 0
8. 430.000 430.000 ↓ 0.0 0 10,000

Index Scan using uk_d_egr_fnsrfogrn on d_egr_fnsrf egr2 (cost=0.56..0.60 rows=1 width=31) (actual time=0.043..0.043 rows=0 loops=10,000)

  • Index Cond: ((ogrn)::text = (t.ogrndepend)::text)
  • Filter: (loaddate = t.loaddate)
  • Rows Removed by Filter: 0
9. 43,560.000 43,560.000 ↑ 1.0 1 10,000

Index Scan using uk_d_person_fnsrfinnname on d_person_fnsrf p (cost=0.56..0.59 rows=1 width=70) (actual time=4.356..4.356 rows=1 loops=10,000)

  • Index Cond: (((inn)::text = (t.inn)::text) AND ((name)::text = (t.name)::text))
10. 10.000 10.000 ↓ 0.0 0 10,000

Index Scan using uk_d_external_fnsrfnamefulloks on d_external_fnsrf e (cost=0.42..0.44 rows=1 width=108) (actual time=0.001..0.001 rows=0 loops=10,000)

  • Index Cond: (((namefull)::text = (t.namefull)::text) AND ((oksm)::text = (t.oksm)::text) AND ((regnum)::text = (t.regnum)::text))
Planning time : 7.976 ms
Execution time : 78,441.987 ms