explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bo0H

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

Result (cost=572,456.81..572,456.82 rows=1 width=8) (actual rows= loops=)

2.          

Initplan (forResult)

3. 0.000 0.000 ↓ 0.0

Aggregate (cost=4.61..4.62 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using idx_screening_package_screen_type_associations_screening_packag on screening_package_screen_type_associations (cost=0.42..4.61 rows=3 width=4) (actual rows= loops=)

  • Index Cond: (screening_package_id = 64294)
  • Filter: (screen_type_id <> ALL ('{12,13,20,210,22}'::integer[]))
5. 0.000 0.000 ↓ 0.0

Finalize Aggregate (cost=572,452.18..572,452.19 rows=1 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Gather (cost=572,451.96..572,452.17 rows=2 width=8) (actual rows= loops=)

  • Workers Planned: 2
7. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=571,451.96..571,451.97 rows=1 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on screening_transactions (cost=0.00..563,323.42 rows=3,251,418 width=4) (actual rows= loops=)