explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wc3i

Settings
# exclusive inclusive rows x rows loops node
1. 3.169 262.123 ↓ 0.0 0 1

Update on temp_posting tp (cost=24,833.55..49,039.89 rows=32,152,362 width=39) (actual time=262.123..262.123 rows=0 loops=1)

2. 7.161 258.954 ↑ 23,198.0 1,386 1

Merge Join (cost=24,833.55..49,039.89 rows=32,152,362 width=39) (actual time=183.235..258.954 rows=1,386 loops=1)

  • Merge Cond: (p.id = pf.posting_id)
3. 30.625 241.904 ↑ 1.0 100,386 1

Merge Left Join (cost=24,832.56..26,844.79 rows=100,690 width=20) (actual time=182.994..241.904 rows=100,386 loops=1)

  • Merge Cond: (p.id = ld.posting_id)
4. 61.552 77.237 ↑ 1.0 100,367 1

Sort (cost=11,868.42..12,119.36 rows=100,375 width=14) (actual time=63.667..77.237 rows=100,367 loops=1)

  • Sort Key: p.id
  • Sort Method: external sort Disk: 2552kB
5. 15.685 15.685 ↑ 1.0 100,375 1

Seq Scan on posting p (cost=0.00..3,529.75 rows=100,375 width=14) (actual time=0.010..15.685 rows=100,375 loops=1)

6. 98.535 134.042 ↓ 1.0 97,745 1

Sort (cost=12,964.14..13,208.26 rows=97,648 width=14) (actual time=119.322..134.042 rows=97,745 loops=1)

  • Sort Key: ld.posting_id
  • Sort Method: external sort Disk: 2864kB
7. 35.507 35.507 ↓ 1.0 97,753 1

Seq Scan on load_detail ld (cost=0.00..4,871.41 rows=97,648 width=14) (actual time=0.031..35.507 rows=97,753 loops=1)

  • Filter: (status = 6301)
  • Rows Removed by Filter: 3960
8. 0.413 9.889 ↑ 46.1 1,386 1

Materialize (cost=0.98..21,142.07 rows=63,864 width=34) (actual time=0.071..9.889 rows=1,386 loops=1)

9. 1.544 9.476 ↑ 46.1 1,386 1

Nested Loop Left Join (cost=0.98..20,982.41 rows=63,864 width=34) (actual time=0.066..9.476 rows=1,386 loops=1)

10. 0.000 5.162 ↑ 1.9 1,385 1

Nested Loop (cost=0.70..11,622.90 rows=2,597 width=79) (actual time=0.048..5.162 rows=1,385 loops=1)

11. 1.160 1.160 ↑ 1.9 1,385 1

Index Scan using idx_temp_posting_id on temp_posting tp (cost=0.28..155.24 rows=2,597 width=14) (actual time=0.034..1.160 rows=1,385 loops=1)

12. 4.155 4.155 ↑ 1.0 1 1,385

Index Scan using idx_posting_fact_posting_id on posting_fact pf (cost=0.42..4.41 rows=1 width=65) (actual time=0.002..0.003 rows=1 loops=1,385)

  • Index Cond: (posting_id = tp.id)
13. 2.770 2.770 ↓ 0.0 0 1,385

Index Scan using idx_posting_link_id_posted_to_user_id on posting_link my_pl (cost=0.29..3.35 rows=25 width=14) (actual time=0.002..0.002 rows=0 loops=1,385)

  • Index Cond: ((id = ANY (pf.posting_link_ids)) AND (posted_to_user_id = '1693876192869877128'::bigint))