explain.depesz.com

A tool for finding a real cause for slow queries.

Result: b4sy

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 4,914.124 5,237.457 ↓ 0.0 0 1

Insert (cost=3,589.03..3,598.97 rows=26 width=45) (actual time=5,237.457..5,237.457 rows=0 loops=1)

2. 10.010 323.333 ↓ 115.7 3,009 1

Subquery Scan on "*SELECT*" (cost=3,589.03..3,598.97 rows=26 width=45) (actual time=299.229..323.333 rows=3,009 loops=1)

3. 8.826 313.323 ↓ 115.7 3,009 1

Unique (cost=3,589.03..3,598.65 rows=26 width=12) (actual time=299.218..313.323 rows=3,009 loops=1)

4. 18.190 304.497 ↓ 1.6 3,009 1

Sort (cost=3,589.03..3,593.84 rows=1,924 width=12) (actual time=299.214..304.497 rows=3,009 loops=1)

  • Sort Key: queryexecutioncategories.category
  • Sort Method: quicksort Memory: 332kB
5. 286.307 286.307 ↓ 1.6 3,009 1

Index Scan using idx_qexcatqxid on queryexecutioncategories (cost=0.00..3,484.07 rows=1,924 width=12) (actual time=0.031..286.307 rows=3,009 loops=1)

  • Index Cond: (queryexecutionid = 34708)