explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hVyp

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 10.905 ↑ 1.0 1 1

Result (cost=2,951.72..2,951.73 rows=1 width=48) (actual time=10.905..10.905 rows=1 loops=1)

2.          

Initplan (forResult)

3. 0.324 4.315 ↑ 1.0 1 1

Aggregate (cost=587.33..587.34 rows=1 width=8) (actual time=4.315..4.315 rows=1 loops=1)

4. 3.991 3.991 ↑ 1.1 3,786 1

Seq Scan on cs_issues (cost=0.00..577.24 rows=4,036 width=0) (actual time=0.018..3.991 rows=3,786 loops=1)

  • Filter: (parent_issue_id IS NULL)
  • Rows Removed by Filter: 1393
5. 0.270 2.526 ↑ 1.0 1 1

Aggregate (cost=584.62..584.63 rows=1 width=8) (actual time=2.526..2.526 rows=1 loops=1)

6. 2.256 2.256 ↓ 1.3 3,785 1

Seq Scan on cs_issues cs_issues_1 (cost=0.00..577.24 rows=2,953 width=0) (actual time=0.009..2.256 rows=3,785 loops=1)

  • Filter: ((parent_issue_id IS NULL) AND (assignee_id IS NOT NULL))
  • Rows Removed by Filter: 1394
7. 0.002 1.375 ↑ 1.0 1 1

Aggregate (cost=579.95..579.96 rows=1 width=8) (actual time=1.375..1.375 rows=1 loops=1)

8. 1.373 1.373 ↑ 1,083.0 1 1

Seq Scan on cs_issues cs_issues_2 (cost=0.00..577.24 rows=1,083 width=0) (actual time=1.121..1.373 rows=1 loops=1)

  • Filter: ((parent_issue_id IS NULL) AND (assignee_id IS NULL))
  • Rows Removed by Filter: 5178
9. 0.011 1.122 ↑ 1.0 1 1

Aggregate (cost=593.97..593.98 rows=1 width=8) (actual time=1.122..1.122 rows=1 loops=1)

10. 1.111 1.111 ↑ 10.4 112 1

Seq Scan on cs_issues cs_issues_3 (cost=0.00..591.05 rows=1,168 width=0) (actual time=0.300..1.111 rows=112 loops=1)

  • Filter: ((parent_issue_id IS NULL) AND ((status)::text = 'open'::text))
  • Rows Removed by Filter: 5067
11. 0.272 1.526 ↑ 1.0 1 1

Aggregate (cost=598.22..598.23 rows=1 width=8) (actual time=1.526..1.526 rows=1 loops=1)

12. 1.254 1.254 ↓ 1.3 3,674 1

Seq Scan on cs_issues cs_issues_4 (cost=0.00..591.05 rows=2,868 width=0) (actual time=0.015..1.254 rows=3,674 loops=1)

  • Filter: ((parent_issue_id IS NULL) AND ((status)::text = 'resolved'::text))
  • Rows Removed by Filter: 1505
13. 0.001 0.027 ↑ 1.0 1 1

Aggregate (cost=7.57..7.58 rows=1 width=8) (actual time=0.027..0.027 rows=1 loops=1)

14. 0.026 0.026 ↓ 0.0 0 1

Index Scan using index_cs_issues_on_status on cs_issues cs_issues_5 (cost=0.28..7.57 rows=1 width=0) (actual time=0.026..0.026 rows=0 loops=1)

  • Index Cond: ((status)::text = 'snoozed'::text)
  • Filter: (parent_issue_id IS NULL)