explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Acv

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

Aggregate (cost=417,298.75..417,298.76 rows=1 width=4) (actual time=68,615.568..68,615.570 rows=1 loops=1)

2. 0.004 68,615.542 ↓ 0.0 0 1

Nested Loop (cost=244,890.91..417,295.21 rows=1,417 width=4) (actual time=68,615.542..68,615.542 rows=0 loops=1)

3. 0.047 68,615.538 ↓ 0.0 0 1

Hash Join (cost=244,890.91..407,034.99 rows=1,417 width=12) (actual time=68,615.538..68,615.538 rows=0 loops=1)

  • Hash Cond: (accountlis2_.fklistingid = auction0_.fklistingid)
4. 0.004 68,238.565 ↓ 0.0 0 1

Nested Loop (cost=241,982.67..404,047.06 rows=2,184 width=4) (actual time=68,238.565..68,238.565 rows=0 loops=1)

5. 0.054 68,238.561 ↓ 0.0 0 1

Hash Join (cost=241,982.67..343,823.57 rows=13,597 width=4) (actual time=68,238.561..68,238.561 rows=0 loops=1)

  • Hash Cond: (account3_.fkcontactid = contact4_.contactid)
6. 0.013 0.013 ↑ 2,719,516.0 1 1

Seq Scan on account account3_ (cost=0.00..77,909.16 rows=2,719,516 width=8) (actual time=0.013..0.013 rows=1 loops=1)

7. 0.004 68,238.494 ↓ 0.0 0 1

Hash (cost=241,725.42..241,725.42 rows=20,580 width=4) (actual time=68,238.494..68,238.494 rows=0 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 0kB
8. 68,238.490 68,238.490 ↓ 0.0 0 1

Seq Scan on contact contact4_ (cost=0.00..241,725.42 rows=20,580 width=4) (actual time=68,238.490..68,238.490 rows=0 loops=1)

  • Filter: (lower(((firstname || ' '::text) || lastname)) = 'nicole philbeck'::text)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_accountlisting_fkaccountid on accountlisting accountlis2_ (cost=0.00..4.10 rows=26 width=8) (actual time=.. rows= loops=0)

  • Index Cond: (fkaccountid = account3_.accountid)
  • Filter: (stop IS NULL)
10. 190.395 376.926 ↑ 1.0 91,833 1

Hash (cost=1,760.33..1,760.33 rows=91,833 width=8) (actual time=376.926..376.926 rows=91,833 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 2512kB
11. 186.531 186.531 ↑ 1.0 91,833 1

Seq Scan on auction auction0_ (cost=0.00..1,760.33 rows=91,833 width=8) (actual time=0.020..186.531 rows=91,833 loops=1)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_listing_listingid on listing listing1_ (cost=0.00..7.23 rows=1 width=4) (actual time=.. rows= loops=0)

  • Index Cond: (listingid = auction0_.fklistingid)