explain.depesz.com

A tool for finding a real cause for slow queries.

Result: eGy

options
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0
→

Sort (cost=434222.18..434222.20 rows=8 width=468) (actual time=.. rows= loops=)

  • Sort Key: punch_items.updated_at
2. 0.000 0.000 ↓ 0.0
→

Index Scan using idx_punch_item_project_id_hidden on punch_items (cost=0.00..434222.06 rows=8 width=468) (actual time=.. rows= loops=)

  • Index Cond: (project_id = 55)
  • Filter: ((hidden IS NOT TRUE) AND ((status)::text = 'Open'::text) AND ((SubPlan 1) > 0) AND ((SubPlan 2) > 0))
3.          

SubPlan (forIndex Scan)
4. 0.000 0.000 ↓ 0.0
→

Aggregate (cost=599.09..599.10 rows=1 width=0) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0
→

Seq Scan on punch_item_assignments (cost=0.00..599.09 rows=1 width=0) (actual time=.. rows= loops=)

  • Filter: ((NOT approved) AND (punch_item_id = $0))
6. 0.000 0.000 ↓ 0.0
→

Aggregate (cost=682.71..682.72 rows=1 width=0) (actual time=.. rows= loops=)

7. 0.000 0.000 ↓ 0.0
→

Seq Scan on punch_item_assignments (cost=0.00..682.70 rows=1 width=0) (actual time=.. rows= loops=)

  • Filter: ((NOT approved) AND (login_information_id = 1) AND (punch_item_id = $0))