explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i3HL

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 1,628.667 ↓ 0.0 1 1

(cost=484402.46..484402.47 rows=1 width=8) (cost=0..0 rows=0 width=0) (actual time=1,628.666..1,628.667 rows=1 loops=1)

2.          

Initplan (for (cost=484402.46..484402.47 rows=1 width=8))

3. 0.003 0.065 ↑ 1.0 1 1

Aggregate (cost=4.65..4.66 rows=1 width=8) (actual time=0.065..0.065 rows=1 loops=1)

4. 0.062 0.062 ↓ 1.2 5 1

Index Scan using idx_screening_package_screen_type_associations_screening_packag on screening_package_screen_type_associations (cost=0.42..4.64 rows=4 width=4) (actual time=0.061..0.062 rows=5 loops=1)

  • Index Cond: (screening_package_id = 53,435)
  • Filter: (screen_type_id <> ALL ('{12,13}'::integer[]))
5. 0.000 1,628.598 ↑ 1.0 1 1

Finalize Aggregate (cost=484,397.79..484,397.80 rows=1 width=8) (actual time=1,628.598..1,628.598 rows=1 loops=1)

6. 134.756 1,760.622 ↓ 1.5 3 1

Gather (cost=484,397.57..484,397.78 rows=2 width=8) (actual time=1,628.549..1,760.622 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 0.003 1,625.866 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=483,397.57..483,397.58 rows=1 width=8) (actual time=1,625.866..1,625.866 rows=1 loops=3)

8. 1,625.863 1,625.863 ↑ 1,616,062.5 2 3 / 3

Parallel Seq Scan on screening_transactions (cost=0.00..475,317.26 rows=3,232,125 width=4) (actual time=1,088.866..1,625.863 rows=2 loops=3)

  • Filter: CASE WHEN (additional_details @> '{"is_skipped_transaction": true}'::jsonb) THEN ((screening_applicant_id = 5,488,310) AND (screen_type_id <> ALL ('{12,13}'::integer[]))) ELSE ((screening_applicant_id = 5,488,310) AND (screening_status_type_id <> ALL ('{3,5}'::integer[])) AND (screen_type_id <> ALL ('{12,13}'::integer[]))) END
  • Rows Removed by Filter: 5,175,422
Planning time : 1.258 ms
Execution time : 1,760.790 ms