explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uejU

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.043 1,638.109 ↑ 1.0 76 1

Limit (cost=0.42..244.87 rows=76 width=102) (actual time=4.842..1,638.109 rows=76 loops=1)

2. 7.386 1,638.066 ↑ 81,640,401.4 76 1

Nested Loop Left Join (cost=0.42..19,956,397,481.79 rows=6,204,670,503 width=102) (actual time=4.842..1,638.066 rows=76 loops=1)

  • Join Filter: (p.personnelid = bp.personnelid)
  • Rows Removed by Join Filter: 64162
3. 0.141 1,626.728 ↑ 3,405,940.8 76 1

Nested Loop (cost=0.42..1,249,315,743.50 rows=258,851,502 width=102) (actual time=4.197..1,626.728 rows=76 loops=1)

4. 780.623 1,625.827 ↑ 3,405,940.8 76 1

Nested Loop (cost=0.00..776,585,298.73 rows=258,851,502 width=96) (actual time=4.186..1,625.827 rows=76 loops=1)

  • Join Filter: (bp.bookingid = stg_js.convertedid)
  • Rows Removed by Join Filter: 7778881
5. 15.360 15.360 ↑ 11,140.4 76 1

Seq Scan on msp_bookingprocedure bp (cost=0.00..19,837.67 rows=846,667 width=52) (actual time=0.605..15.360 rows=76 loops=1)

6. 744.697 829.844 ↓ 1.7 102,355 76

Materialize (cost=0.00..11,108.19 rows=61,146 width=56) (actual time=0.003..10.919 rows=102,355 loops=76)

7. 85.147 85.147 ↓ 1.7 103,611 1

Seq Scan on stg_combined_jail_stays stg_js (cost=0.00..10,802.46 rows=61,146 width=56) (actual time=0.003..85.147 rows=103,611 loops=1)

8. 0.760 0.760 ↑ 1.0 1 76

Index Scan using people_pkey on people lkp_ppl (cost=0.42..1.82 rows=1 width=22) (actual time=0.009..0.010 rows=1 loops=76)

  • Index Cond: (peopleid = stg_js.peopleid)
9. 3.173 3.952 ↑ 5.7 845 76

Materialize (cost=0.00..183.91 rows=4,794 width=8) (actual time=0.002..0.052 rows=845 loops=76)

10. 0.779 0.779 ↑ 5.6 856 1

Seq Scan on msp_personnel p (cost=0.00..159.94 rows=4,794 width=8) (actual time=0.099..0.779 rows=856 loops=1)

Planning time : 11.918 ms
Execution time : 1,639.462 ms