explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hvuw

Settings
# exclusive inclusive rows x rows loops node
1. 0.713 120.734 ↑ 1.0 5,000 1

Unique (cost=49,806.87..49,831.87 rows=5,000 width=175) (actual time=119.737..120.734 rows=5,000 loops=1)

2. 2.606 120.021 ↑ 1.0 5,000 1

Sort (cost=49,806.87..49,819.37 rows=5,000 width=175) (actual time=119.736..120.021 rows=5,000 loops=1)

  • Sort Key: c0.id
  • Sort Method: quicksort Memory: 826kB
3. 0.000 117.415 ↑ 1.0 5,000 1

Nested Loop Left Join (cost=0.43..49,499.68 rows=5,000 width=175) (actual time=0.949..117.415 rows=5,000 loops=1)

4. 0.373 108.058 ↑ 1.0 5,000 1

Limit (cost=0.00..9,876.18 rows=5,000 width=123) (actual time=0.031..108.058 rows=5,000 loops=1)

5. 107.685 107.685 ↑ 165.3 5,000 1

Seq Scan on customers c0 (cost=0.00..1,632,668.44 rows=826,569 width=123) (actual time=0.030..107.685 rows=5,000 loops=1)

  • Filter: ((id > 0) AND (provider_id = 136966))
  • Rows Removed by Filter: 649550
6. 10.000 10.000 ↓ 0.0 0 5,000

Index Scan using index_customer_online_profiles_on_customer_id on customer_online_profiles c1 (cost=0.43..7.91 rows=1 width=74) (actual time=0.002..0.002 rows=0 loops=5,000)

  • Index Cond: (customer_id = c0.id)