explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vCaS : werwer

Settings
# exclusive inclusive rows x rows loops node
1. 0.329 0.892 ↑ 640.0 1 1

Sort (cost=75.44..77.04 rows=640 width=1,158) (actual time=0.892..0.892 rows=1 loops=1)

  • Sort Key: products_product.preferred DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.026 0.563 ↑ 640.0 1 1

Hash Join (cost=26.30..45.61 rows=640 width=1,158) (actual time=0.563..0.563 rows=1 loops=1)

  • Hash Cond: (museums_museumcontractline.product_id = museums_museumproduct.product_ptr_id)
3. 0.017 0.521 ↑ 448.0 1 1

Hash Join (cost=13.15..31.26 rows=448 width=638) (actual time=0.520..0.521 rows=1 loops=1)

  • Hash Cond: (museums_museumcontractline.product_id = products_product.id)
4. 0.006 0.006 ↑ 640.0 1 1

Seq Scan on museums_museumcontractline (cost=0.00..16.40 rows=640 width=99) (actual time=0.006..0.006 rows=1 loops=1)

5. 0.005 0.498 ↑ 140.0 1 1

Hash (cost=11.40..11.40 rows=140 width=539) (actual time=0.498..0.498 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.493 0.493 ↑ 140.0 1 1

Seq Scan on products_product (cost=0.00..11.40 rows=140 width=539) (actual time=0.492..0.493 rows=1 loops=1)

7. 0.005 0.016 ↑ 140.0 1 1

Hash (cost=11.40..11.40 rows=140 width=520) (actual time=0.016..0.016 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.011 0.011 ↑ 140.0 1 1

Seq Scan on museums_museumproduct (cost=0.00..11.40 rows=140 width=520) (actual time=0.010..0.011 rows=1 loops=1)

Planning time : 14.657 ms
Execution time : 1.247 ms