explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DTCK

Settings
# exclusive inclusive rows x rows loops node
1. 0.556 43.380 ↓ 5.0 364 1

Nested Loop (cost=0.86..20,948.58 rows=73 width=511) (actual time=0.071..43.380 rows=364 loops=1)

2. 30.896 30.896 ↓ 6.0 1,988 1

Index Scan using component_status_type on component c (cost=0.43..15,782.00 rows=329 width=352) (actual time=0.043..30.896 rows=1,988 loops=1)

  • Index Cond: ((component_type = 'job'::component_entity_type) AND (status = 'allocated'::component_status))
  • Filter: (active AND (file_type = ANY ('{default,tex}'::allocation_file_type[])) AND (allocation_type = 'job_board'::allocation_type))
  • Rows Removed by Filter: 2,094
3. 11.928 11.928 ↓ 0.0 0 1,988

Index Scan using component_detail_component_id_idx on component_detail cd (cost=0.43..15.69 rows=1 width=151) (actual time=0.005..0.006 rows=0 loops=1,988)

  • Index Cond: (component_id = c.id)
  • Filter: ((wb_user_id IS NULL) AND active)
  • Rows Removed by Filter: 1
Planning time : 0.384 ms
Execution time : 43.512 ms