explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JJM

Settings
# exclusive inclusive rows x rows loops node
1. 4.272 199.629 ↑ 1.0 133 1

Gather (cost=1,000.43..98,229.46 rows=136 width=503) (actual time=182.511..199.629 rows=133 loops=1)

  • Workers Planned: 4
  • Workers Launched: 3
2. 0.061 195.357 ↑ 1.0 33 4 / 4

Nested Loop (cost=0.43..97,215.86 rows=34 width=503) (actual time=179.644..195.357 rows=33 loops=4)

3. 195.038 195.038 ↑ 17.4 43 4 / 4

Parallel Seq Scan on component_detail cd (cost=0.00..91,135.44 rows=750 width=151) (actual time=179.593..195.038 rows=43 loops=4)

  • Filter: ((wb_user_id IS NULL) AND active AND (expected_end_date > '2019-09-30 12:01:44'::timestamp without time zone))
  • Rows Removed by Filter: 944,056
4. 0.258 0.258 ↑ 1.0 1 172 / 4

Index Scan using component_pkey on component c (cost=0.43..8.11 rows=1 width=352) (actual time=0.006..0.006 rows=1 loops=172)

  • Index Cond: (id = cd.component_id)
  • Filter: (active AND (title IS NOT NULL) AND (file_type = ANY ('{default,tex}'::allocation_file_type[])) AND (status <> 'abandoned'::component_status) AND (component_type = 'job'::component_entity_type) AND (allocation_type = 'job_board'::allocation_type))
  • Rows Removed by Filter: 0
Planning time : 0.419 ms
Execution time : 199.705 ms