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 68615.570 ↑ 1.0 1 1

Aggregate (cost=417298.75..417298.76 rows=1 width=4) (actual time=68615.568..68615.570 rows=1 loops=1)

2. 0.004 68615.542 ↓ 0.0 0 1

Nested Loop (cost=244890.91..417295.21 rows=1417 width=4) (actual time=68615.542..68615.542 rows=0 loops=1)

3. 0.047 68615.538 ↓ 0.0 0 1

Hash Join (cost=244890.91..407034.99 rows=1417 width=12) (actual time=68615.538..68615.538 rows=0 loops=1)

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

Nested Loop (cost=241982.67..404047.06 rows=2184 width=4) (actual time=68238.565..68238.565 rows=0 loops=1)

5. 0.054 68238.561 ↓ 0.0 0 1

Hash Join (cost=241982.67..343823.57 rows=13597 width=4) (actual time=68238.561..68238.561 rows=0 loops=1)

  • Hash Cond: (account3_.fkcontactid = contact4_.contactid)
6. 0.013 0.013 ↑ 2719516.0 1 1

Seq Scan on account account3_ (cost=0.00..77909.16 rows=2719516 width=8) (actual time=0.013..0.013 rows=1 loops=1)

7. 0.004 68238.494 ↓ 0.0 0 1

Hash (cost=241725.42..241725.42 rows=20580 width=4) (actual time=68238.494..68238.494 rows=0 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 0kB
8. 68238.490 68238.490 ↓ 0.0 0 1

Seq Scan on contact contact4_ (cost=0.00..241725.42 rows=20580 width=4) (actual time=68238.490..68238.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 91833 1

Hash (cost=1760.33..1760.33 rows=91833 width=8) (actual time=376.926..376.926 rows=91833 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 2512kB
11. 186.531 186.531 ↑ 1.0 91833 1

Seq Scan on auction auction0_ (cost=0.00..1760.33 rows=91833 width=8) (actual time=0.020..186.531 rows=91833 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)