explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lEUX

Settings
# exclusive inclusive rows x rows loops node
1. 6.711 37.041 ↓ 1.0 33,307 1

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

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

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

  • Hash Cond: (ssp.sales_person_id = sp.sales_person_id)
3. 9.875 9.875 ↓ 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.094..9.875 rows=33,307 loops=1)

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

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

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

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

  • Hash Cond: (sp.user_id = du.user_id)
6. 0.194 0.194 ↑ 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.194 rows=2,859 loops=1)

7. 0.879 1.622 ↑ 1.0 7,019 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 311kB
8. 0.743 0.743 ↑ 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.014..0.743 rows=7,019 loops=1)

  • Heap Fetches: 0
9. 5.693 10.744 ↑ 1.0 41,919 1

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

  • Buckets: 65,536 Batches: 1 Memory Usage: 1,986kB
10. 5.051 5.051 ↑ 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.090..5.051 rows=41,919 loops=1)

Planning time : 0.362 ms
Execution time : 38.370 ms