explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fINE

Settings
# exclusive inclusive rows x rows loops node
1. 0.070 122.050 ↓ 114.0 114 1

GroupAggregate (cost=370.28..370.32 rows=1 width=60) (actual time=121.983..122.050 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.148 121.980 ↓ 132.0 132 1

Sort (cost=370.28..370.28 rows=1 width=40) (actual time=121.970..121.980 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. 0.701 121.832 ↓ 132.0 132 1

Nested Loop (cost=0.86..370.27 rows=1 width=40) (actual time=121.614..121.832 rows=132 loops=1)

4. 1.587 1.587 ↓ 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.015..1.587 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. 119.544 119.544 ↓ 0.0 0 408

Index Scan using index_sampling_rollups_on_list_id on sampling_rollups (cost=0.43..9.62 rows=1 width=44) (actual time=0.293..0.293 rows=0 loops=408)

  • Index Cond: (list_id = lists.id)
  • Filter: ((list_date >= '2019-03-27'::date) AND (vendor_id = 174))
  • Rows Removed by Filter: 5
Planning time : 11.305 ms
Execution time : 122.111 ms