explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gNXg

Settings
# exclusive inclusive rows x rows loops node
1. 5.570 485.210 ↓ 1.3 10,787 1

GroupAggregate (cost=72,966.81..73,289.08 rows=8,594 width=60) (actual time=478.885..485.210 rows=10,787 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. 16.503 479.640 ↓ 1.3 11,099 1

Sort (cost=72,966.81..72,988.29 rows=8,594 width=40) (actual time=478.867..479.640 rows=11,099 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: 1,252kB
3. 3.135 463.137 ↓ 1.3 11,099 1

Hash Join (cost=55,223.66..72,405.23 rows=8,594 width=40) (actual time=394.799..463.137 rows=11,099 loops=1)

  • Hash Cond: (sampling_rollups.list_id = lists.id)
4. 65.362 65.362 ↑ 1.7 11,099 1

Index Scan using index_sampling_rollups_on_list_date on sampling_rollups (cost=0.43..17,108.10 rows=18,350 width=44) (actual time=0.096..65.362 rows=11,099 loops=1)

  • Index Cond: (list_date >= '2019-03-27'::date)
  • Filter: (vendor_id = 175)
  • Rows Removed by Filter: 399,240
5. 22.554 394.640 ↓ 1.4 75,100 1

Hash (cost=54,542.04..54,542.04 rows=54,495 width=4) (actual time=394.640..394.640 rows=75,100 loops=1)

  • Buckets: 131,072 (originally 65536) Batches: 1 (originally 1) Memory Usage: 3,665kB
6. 372.086 372.086 ↓ 1.4 75,100 1

Seq Scan on lists (cost=0.00..54,542.04 rows=54,495 width=4) (actual time=0.017..372.086 rows=75,100 loops=1)

  • Filter: ((vendor_id = 175) AND ((type)::text = 'SampleList'::text))
  • Rows Removed by Filter: 1,889,437
Planning time : 0.791 ms
Execution time : 485.940 ms