explain.depesz.com

A tool for finding a real cause for slow queries.

Result: N8EG

options
# exclusive inclusive rows x rows loops node
1. 0.004 0.172 ↑ 1.0 1 1
→

Subquery Scan on average (cost=127.96..127.99 rows=1 width=32) (actual time=0.171..0.172 rows=1 loops=1)

2. 0.010 0.168 ↑ 1.0 1 1
→

Aggregate (cost=127.96..127.97 rows=1 width=32) (actual time=0.168..0.168 rows=1 loops=1)

3. 0.001 0.158 ↓ 0.0 0 1
→

HashAggregate (cost=127.94..127.95 rows=1 width=16) (actual time=0.158..0.158 rows=0 loops=1)

4. 0.000 0.157 ↓ 0.0 0 1
→

Unique (cost=127.91..127.92 rows=1 width=28) (actual time=0.157..0.157 rows=0 loops=1)

5. 0.053 0.157 ↓ 0.0 0 1
→

Sort (cost=127.91..127.91 rows=1 width=28) (actual time=0.157..0.157 rows=0 loops=1)

  • Sort Key: (date_trunc('day'::text, abmafile.dateinserted)), abmafile.abmafileid, webclip.runtimeseconds, abmafile.filesize
  • Sort Method: quicksort Memory: 25kB
6. 0.002 0.104 ↓ 0.0 0 1
→

HashAggregate (cost=127.88..127.90 rows=1 width=28) (actual time=0.104..0.104 rows=0 loops=1)

7. 0.000 0.102 ↓ 0.0 0 1
→

Nested Loop (cost=4.84..127.87 rows=1 width=28) (actual time=0.102..0.102 rows=0 loops=1)

  • Join Filter: (contentmetadata.contentmetadataid = webclip.contentmetadataid)
8. 0.002 0.102 ↓ 0.0 0 1
→

Nested Loop (cost=4.84..124.63 rows=1 width=28) (actual time=0.102..0.102 rows=0 loops=1)

9. 0.000 0.100 ↓ 0.0 0 1
→

Nested Loop (cost=4.84..116.35 rows=1 width=24) (actual time=0.100..0.100 rows=0 loops=1)

10. 0.000 0.100 ↓ 0.0 0 1
→

Nested Loop (cost=4.84..88.96 rows=70 width=4) (actual time=0.100..0.100 rows=0 loops=1)

11. 0.100 0.100 ↓ 0.0 0 1
→

Seq Scan on service (cost=0.00..4.58 rows=1 width=4) (actual time=0.100..0.100 rows=0 loops=1)

  • Filter: (productid = 12)
12. 0.000 0.000 ↓ 0.0 0
→

Bitmap Heap Scan on sku (cost=4.84..83.43 rows=76 width=8) (actual time=.. rows= loops=0)

  • Recheck Cond: (sku.serviceid = service.serviceid)
13. 0.000 0.000 ↓ 0.0 0
→

Bitmap Index Scan on sku_serviceid_idx (cost=0.00..4.82 rows=76 width=0) (actual time=.. rows= loops=0)

  • Index Cond: (sku.serviceid = service.serviceid)
14. 0.000 0.000 ↓ 0.0 0
→

Index Scan using pk_content on abmafile (cost=0.00..0.38 rows=1 width=24) (actual time=.. rows= loops=0)

  • Index Cond: (abmafile.abmafileid = sku.abmafileid)
  • Filter: ((abmafile.dateinserted >= now()) AND (abmafile.dateinserted <= now()))
15. 0.000 0.000 ↓ 0.0 0
→

Index Scan using pk_contentmetadata on contentmetadata (cost=0.00..8.27 rows=1 width=4) (actual time=.. rows= loops=0)

  • Index Cond: (contentmetadata.contentmetadataid = abmafile.contentmetadataid)
16. 0.000 0.000 ↓ 0.0 0
→

Seq Scan on webclip (cost=0.00..2.55 rows=55 width=12) (actual time=.. rows= loops=0)