explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tHxk

Settings
# exclusive inclusive rows x rows loops node
1. 0.359 76,456.093 ↑ 1.0 5,000 1

Limit (cost=0.99..234,986.44 rows=5,000 width=175) (actual time=68,608.194..76,456.093 rows=5,000 loops=1)

2. 1.141 76,455.734 ↑ 165.3 5,000 1

Unique (cost=0.99..38,846,337.99 rows=826,569 width=175) (actual time=68,608.193..76,455.734 rows=5,000 loops=1)

3. 63.553 76,454.593 ↑ 165.3 5,000 1

Merge Left Join (cost=0.99..38,844,271.56 rows=826,569 width=175) (actual time=68,608.190..76,454.593 rows=5,000 loops=1)

  • Merge Cond: (c0.id = c1.customer_id)
4. 60,419.342 60,419.342 ↑ 165.3 5,000 1

Index Scan using customers_pkey on customers c0 (cost=0.56..37,752,038.17 rows=826,569 width=105) (actual time=53,425.357..60,419.342 rows=5,000 loops=1)

  • Index Cond: (id > 0)
  • Filter: (provider_id = 136966)
  • Rows Removed by Filter: 17257048
5. 15,971.698 15,971.698 ↑ 3.9 799,614 1

Index Scan using index_customer_online_profiles_on_customer_id on customer_online_profiles c1 (cost=0.43..1,081,782.24 rows=3,096,137 width=74) (actual time=0.042..15,971.698 rows=799,614 loops=1)