explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wcpJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.271 6.090 ↓ 1.9 626 1

WindowAgg (cost=769.27..775.18 rows=338 width=265) (actual time=5.765..6.090 rows=626 loops=1)

2. 1.000 5.819 ↓ 1.9 626 1

Sort (cost=769.27..770.11 rows=338 width=257) (actual time=5.753..5.819 rows=626 loops=1)

  • Sort Key: l.internal_reference_id
  • Sort Method: quicksort Memory: 313kB
3. 0.513 4.819 ↓ 1.9 626 1

Hash Join (cost=708.34..755.07 rows=338 width=257) (actual time=4.025..4.819 rows=626 loops=1)

  • Hash Cond: (tl.id = l.id)
4. 0.312 0.312 ↓ 1.7 2,194 1

Seq Scan on temp_load tl (cost=0.00..38.40 rows=1,320 width=8) (actual time=0.017..0.312 rows=2,194 loops=1)

  • Filter: should_return
5. 0.443 3.994 ↑ 1.0 626 1

Hash (cost=700.52..700.52 rows=626 width=265) (actual time=3.994..3.994 rows=626 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 221kB
6. 0.533 3.551 ↑ 1.0 626 1

Hash Join (cost=597.61..700.52 rows=626 width=265) (actual time=2.579..3.551 rows=626 loops=1)

  • Hash Cond: (l.id = lf.load_id)
7. 0.459 0.459 ↑ 1.0 2,443 1

Seq Scan on load l (cost=0.00..84.43 rows=2,443 width=123) (actual time=0.005..0.459 rows=2,443 loops=1)

8. 0.424 2.559 ↑ 1.0 626 1

Hash (cost=589.79..589.79 rows=626 width=142) (actual time=2.559..2.559 rows=626 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 146kB
9. 2.135 2.135 ↑ 1.0 626 1

Seq Scan on load_fact lf (cost=0.00..589.79 rows=626 width=142) (actual time=0.257..2.135 rows=626 loops=1)

  • Filter: (carrier_user_id = '1693876186242876624'::bigint)
  • Rows Removed by Filter: 3837
Planning time : 27.348 ms
Execution time : 6.353 ms