explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Wca

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 6.047 9.879 ↓ 1.0 4704 1

Merge Left Join (cost=16.65..834.08 rows=4664 width=779) (actual time=0.168..9.879 rows=4704 loops=1)

  • Merge Cond: (kp.id = purchase_order.project_id)
2. 0.136 0.177 ↑ 1.0 218 1

Sort (cost=16.65..17.19 rows=218 width=224) (actual time=0.147..0.177 rows=218 loops=1)

  • Sort Key: kp.id
  • Sort Method: quicksort Memory: 83kB
3. 0.041 0.041 ↑ 1.0 218 1

Seq Scan on kdvn_project kp (cost=0.00..8.18 rows=218 width=224) (actual time=0.006..0.041 rows=218 loops=1)

4. 1.386 3.655 ↑ 1.0 4664 1

Materialize (cost=0.00..758.04 rows=4664 width=555) (actual time=0.014..3.655 rows=4664 loops=1)

5. 2.269 2.269 ↑ 1.0 4664 1

Index Scan using project_id on purchase_order (cost=0.00..699.74 rows=4664 width=555) (actual time=0.012..2.269 rows=4664 loops=1)