explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Omh5

Settings
# exclusive inclusive rows x rows loops node
1. 6.885 37.601 ↓ 1.0 33,307 1

Hash Join (cost=1,979.12..4,746.11 rows=33,165 width=8) (actual time=14.430..37.601 rows=33,307 loops=1)

  • Hash Cond: (ssp.sales_split_id = ss.sales_split_id)
2. 6.752 19.673 ↓ 1.0 33,307 1

Hash Join (cost=424.94..2,735.91 rows=33,165 width=8) (actual time=3.137..19.673 rows=33,307 loops=1)

  • Hash Cond: (ssp.sales_person_id = sp.sales_person_id)
3. 9.907 9.907 ↓ 1.0 33,307 1

Seq Scan on sales_split_sales_person ssp (cost=0.00..1,854.95 rows=33,165 width=8) (actual time=0.096..9.907 rows=33,307 loops=1)

  • Filter: (is_primary = 1)
  • Rows Removed by Filter: 40,689
4. 0.414 3.014 ↑ 1.0 2,859 1

Hash (cost=389.21..389.21 rows=2,859 width=8) (actual time=3.014..3.014 rows=2,859 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 144kB
5. 0.805 2.600 ↑ 1.0 2,859 1

Hash Join (cost=281.31..389.21 rows=2,859 width=8) (actual time=1.648..2.600 rows=2,859 loops=1)

  • Hash Cond: (sp.user_id = du.user_id)
6. 0.188 0.188 ↑ 1.0 2,859 1

Seq Scan on sales_person sp (cost=0.00..68.59 rows=2,859 width=8) (actual time=0.002..0.188 rows=2,859 loops=1)

7. 0.863 1.607 ↑ 1.0 7,019 1

Hash (cost=193.57..193.57 rows=7,019 width=4) (actual time=1.606..1.607 rows=7,019 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 311kB
8. 0.744 0.744 ↑ 1.0 7,019 1

Index Only Scan using idx_stage_harbor_user_user_id on "user" du (cost=0.28..193.57 rows=7,019 width=4) (actual time=0.013..0.744 rows=7,019 loops=1)

  • Heap Fetches: 0
9. 5.959 11.043 ↑ 1.0 41,919 1

Hash (cost=1,030.19..1,030.19 rows=41,919 width=4) (actual time=11.043..11.043 rows=41,919 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 1,986kB
10. 5.084 5.084 ↑ 1.0 41,919 1

Seq Scan on sales_split ss (cost=0.00..1,030.19 rows=41,919 width=4) (actual time=0.092..5.084 rows=41,919 loops=1)

Planning time : 0.347 ms
Execution time : 38.943 ms