explain.depesz.com

A tool for finding a real cause for slow queries.

Result: hX2

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.014 104.154 ↑ 1.0 1 1

Aggregate (cost=41777.22..41777.23 rows=1 width=118) (actual time=104.154..104.154 rows=1 loops=1)

2. 0.406 104.140 ↑ 1804.8 80 1

Unique (cost=39250.46..39972.39 rows=144386 width=37) (actual time=103.505..104.140 rows=80 loops=1)

3. 10.594 103.734 ↑ 44.0 3285 1

Sort (cost=39250.46..39611.42 rows=144386 width=37) (actual time=103.504..103.734 rows=3285 loops=1)

  • Sort Key: downloaded_content.esn
  • Sort Method: quicksort Memory: 353kB
4. 0.355 93.140 ↑ 44.0 3285 1

Append (cost=19169.69..22925.39 rows=144386 width=37) (actual time=91.326..93.140 rows=3285 loops=1)

5. 24.749 91.855 ↑ 341.8 414 1

Merge Join (cost=19169.69..21395.34 rows=141510 width=37) (actual time=91.325..91.855 rows=414 loops=1)

  • Merge Cond: (downloaded_content.abmafileid = sku.abmafileid)
6. 54.597 54.597 ↓ 1.0 200236 1

Index Scan using "Index1" on downloaded_content (cost=0.00..18188.95 rows=200231 width=41) (actual time=0.039..54.597 rows=200236 loops=1)

  • Index Cond: ((fulfilledtime >= '2012-01-01 00:00:00-06'::timestamp with time zone) AND (fulfilledtime <= '2012-06-01 00:00:00-05'::timestamp with time zone))
7. 4.121 12.509 ↑ 4.3 1236 1

Sort (cost=583.21..596.48 rows=5310 width=4) (actual time=12.398..12.509 rows=1236 loops=1)

  • Sort Key: sku.abmafileid
  • Sort Method: quicksort Memory: 409kB
8. 4.026 8.388 ↑ 1.2 4616 1

Hash Join (cost=5.53..254.67 rows=5310 width=4) (actual time=0.150..8.388 rows=4616 loops=1)

  • Hash Cond: (sku.serviceid = service.serviceid)
9. 4.232 4.232 ↑ 1.0 8803 1

Seq Scan on sku (cost=0.00..163.03 rows=8803 width=8) (actual time=0.009..4.232 rows=8803 loops=1)

10. 0.025 0.130 ↑ 1.0 76 1

Hash (cost=4.58..4.58 rows=76 width=4) (actual time=0.130..0.130 rows=76 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
11. 0.105 0.105 ↑ 1.0 76 1

Seq Scan on service (cost=0.00..4.58 rows=76 width=4) (actual time=0.021..0.105 rows=76 loops=1)

  • Filter: (productid = 2232)
12. 0.196 0.196 ↑ 1.0 558 1

Seq Scan on appusagereport (cost=0.00..19.30 rows=562 width=37) (actual time=0.018..0.196 rows=558 loops=1)

  • Filter: ((recordedtime >= '2012-01-01 00:00:00-06'::timestamp with time zone) AND (recordedtime <= '2012-06-01 00:00:00-05'::timestamp with time zone) AND (productid = 2232))
13. 0.013 0.013 ↑ 1.0 5 1

Seq Scan on contentviewsreport (cost=0.00..1.28 rows=5 width=37) (actual time=0.010..0.013 rows=5 loops=1)

  • Filter: ((recordedtime >= '2012-01-01 00:00:00-06'::timestamp with time zone) AND (recordedtime <= '2012-06-01 00:00:00-05'::timestamp with time zone) AND (appproductid = 2232))
14. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on rssnewsviewsreport (cost=0.00..1.21 rows=1 width=37) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: ((recordedtime >= '2012-01-01 00:00:00-06'::timestamp with time zone) AND (recordedtime <= '2012-06-01 00:00:00-05'::timestamp with time zone) AND (productid = 2232))
15. 0.713 0.713 ↑ 1.0 2308 1

Seq Scan on rssrequestreport (cost=0.00..64.39 rows=2308 width=37) (actual time=0.010..0.713 rows=2308 loops=1)

  • Filter: ((recordedtime >= '2012-01-01 00:00:00-06'::timestamp with time zone) AND (recordedtime <= '2012-06-01 00:00:00-05'::timestamp with time zone) AND (productid = 2232))