explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nHou

Settings
# exclusive inclusive rows x rows loops node
1. 4.573 180.840 ↑ 1.0 133 1

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

  • Workers Planned: 4
  • Workers Launched: 3
2. 0.057 176.267 ↑ 1.0 33 4 / 4

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

3. 175.952 175.952 ↑ 17.4 43 4 / 4

Parallel Seq Scan on component_detail cd (cost=0.00..91,135.44 rows=750 width=151) (actual time=160.743..175.952 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.378 ms
Execution time : 180.915 ms