explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jrcU

Settings
# exclusive inclusive rows x rows loops node
1. 0.086 27,358.380 ↓ 114.0 114 1

GroupAggregate (cost=17,500.05..17,500.09 rows=1 width=60) (actual time=27,358.311..27,358.380 rows=114 loops=1)

  • Group Key: sampling_rollups.sales_rep_id, sampling_rollups.sku, sampling_rollups.vendor_item_id, sampling_rollups.product_version_id, sampling_rollups.account_id
2. 0.212 27,358.294 ↓ 132.0 132 1

Sort (cost=17,500.05..17,500.05 rows=1 width=40) (actual time=27,358.282..27,358.294 rows=132 loops=1)

  • Sort Key: sampling_rollups.sales_rep_id, sampling_rollups.sku, sampling_rollups.vendor_item_id, sampling_rollups.product_version_id, sampling_rollups.account_id
  • Sort Method: quicksort Memory: 35kB
3. 47.655 27,358.082 ↓ 132.0 132 1

Nested Loop (cost=0.86..17,500.04 rows=1 width=40) (actual time=26,023.436..27,358.082 rows=132 loops=1)

  • Join Filter: (sampling_rollups.list_id = lists.id)
  • Rows Removed by Join Filter: 474,780
4. 2.171 2.171 ↓ 408.0 408 1

Index Scan using index_lists_on_user_id on lists (cost=0.43..360.63 rows=1 width=4) (actual time=0.016..2.171 rows=408 loops=1)

  • Index Cond: (user_id = 3,285)
  • Filter: ((vendor_id = 174) AND ((type)::text = 'SampleList'::text))
  • Rows Removed by Filter: 114
5. 27,308.256 27,308.256 ↑ 2.2 1,164 408

Index Scan using index_sampling_rollups_on_list_date on sampling_rollups (cost=0.43..17,108.10 rows=2,505 width=44) (actual time=0.013..66.932 rows=1,164 loops=408)

  • Index Cond: (list_date >= '2019-03-27'::date)
  • Filter: (vendor_id = 174)
  • Rows Removed by Filter: 409,175
Planning time : 0.758 ms
Execution time : 27,358.450 ms