explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Fdh

options
# exclusive inclusive rows x rows loops node
1. 0.003 0.089 ↑ 1.0 1 1
→

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

2. 0.006 0.086 ↑ 1.0 1 1
→

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

3. 0.000 0.080 ↓ 0.0 0 1
→

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

4. 0.000 0.080 ↓ 0.0 0 1
→

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

5. 0.009 0.080 ↓ 0.0 0 1
→

Sort (cost=127.91..127.91 rows=1 width=28) (actual time=0.080..0.080 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.001 0.071 ↓ 0.0 0 1
→

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

7. 0.001 0.070 ↓ 0.0 0 1
→

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

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

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

9. 0.001 0.069 ↓ 0.0 0 1
→

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

10. 0.000 0.068 ↓ 0.0 0 1
→

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

11. 0.068 0.068 ↓ 0.0 0 1
→

Seq Scan on service (cost=0.00..4.58 rows=1 width=4) (actual time=0.068..0.068 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)