explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hets

Settings
# exclusive inclusive rows x rows loops node
1. 4,027.063 8,017.263 ↓ 0.0 0 1

Insert on t_overall_ratings (cost=34,930.52..34,935.70 rows=1 width=614) (actual time=8,017.262..8,017.263 rows=0 loops=1)

2. 490.312 3,990.200 ↓ 165,765.0 165,765 1

Nested Loop (cost=34,930.52..34,935.70 rows=1 width=614) (actual time=270.134..3,990.200 rows=165,765 loops=1)

3. 202.375 3,170.006 ↓ 164,941.0 164,941 1

Nested Loop (cost=34,930.10..34,935.17 rows=1 width=614) (actual time=269.860..3,170.006 rows=164,941 loops=1)

4. 2,472.928 2,472.928 ↓ 164,901.0 164,901 1

CTE Scan on scoring (cost=34,929.68..34,929.71 rows=1 width=624) (actual time=269.834..2,472.928 rows=164,901 loops=1)

5.          

CTE scoring

6. 731.828 2,201.151 ↓ 164,901.0 164,901 1

Nested Loop (cost=23,077.55..34,929.68 rows=1 width=79) (actual time=269.825..2,201.151 rows=164,901 loops=1)

7. 258.544 644.818 ↓ 164,901.0 164,901 1

Hash Join (cost=23,077.12..34,929.13 rows=1 width=51) (actual time=269.476..644.818 rows=164,901 loops=1)

  • Hash Cond: (((a_1.rating_return_objectid)::text = (f_1.rating_return_objectid)::text) AND (a_1.t_rating_request_id = f_1.t_rating_request_id))
8. 118.078 118.078 ↑ 1.0 164,894 1

Seq Scan on t_at_ratings a_1 (cost=0.00..6,492.94 rows=164,894 width=31) (actual time=0.016..118.078 rows=164,894 loops=1)

9. 102.919 268.196 ↑ 1.0 164,845 1

Hash (cost=20,604.45..20,604.45 rows=164,845 width=39) (actual time=268.195..268.196 rows=164,845 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 13877kB
10. 165.277 165.277 ↑ 1.0 164,845 1

Seq Scan on t_financial_ratings f_1 (cost=0.00..20,604.45 rows=164,845 width=39) (actual time=28.809..165.277 rows=164,845 loops=1)

11. 824.505 824.505 ↑ 1.0 1 164,901

Index Only Scan using t_rating_request_pkey on t_rating_request r (cost=0.42..0.52 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=164,901)

  • Index Cond: (t_rating_request_id = f_1.t_rating_request_id)
  • Heap Fetches: 329732
12. 494.703 494.703 ↑ 1.0 1 164,901

Index Scan using ix7t_financial_ratings on t_financial_ratings f (cost=0.42..5.44 rows=1 width=18) (actual time=0.002..0.003 rows=1 loops=164,901)

  • Index Cond: (t_rating_request_id = scoring.t_rating_request_id)
13. 329.882 329.882 ↑ 1.0 1 164,941

Index Scan using ix3t_at_ratings on t_at_ratings a (cost=0.42..0.52 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=164,941)

  • Index Cond: (t_rating_request_id = f.t_rating_request_id)
Planning time : 3.556 ms
Execution time : 8,023.116 ms