explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O6dh

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 11.447 ↓ 4.0 4 1

GroupAggregate (cost=17.64..17.66 rows=1 width=24) (actual time=11.430..11.447 rows=4 loops=1)

  • Group Key: sourcing_strategies.id, applications.source_id
  • Buffers: shared hit=1,112 read=152
2. 0.025 11.425 ↓ 56.0 56 1

Sort (cost=17.64..17.64 rows=1 width=24) (actual time=11.422..11.425 rows=56 loops=1)

  • Sort Key: sourcing_strategies.id, applications.source_id
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=1,112 read=152
3. 0.044 11.400 ↓ 56.0 56 1

Nested Loop (cost=2.12..17.63 rows=1 width=24) (actual time=0.060..11.400 rows=56 loops=1)

  • Buffers: shared hit=1,112 read=152
4. 0.000 11.356 ↓ 56.0 56 1

Nested Loop Semi Join (cost=1.99..17.48 rows=1 width=24) (actual time=0.057..11.356 rows=56 loops=1)

  • Buffers: shared hit=1,055 read=152
5. 0.025 11.023 ↓ 57.0 57 1

Nested Loop (cost=1.28..10.79 rows=1 width=32) (actual time=0.038..11.023 rows=57 loops=1)

  • Buffers: shared hit=663 read=145
6. 0.102 10.029 ↓ 57.0 57 1

Nested Loop Left Join (cost=0.99..8.48 rows=1 width=16) (actual time=0.031..10.029 rows=57 loops=1)

  • Filter: ((prospective_hiring_plans.hiring_plan_id = '4460836002'::bigint) OR (prospective_hiring_plans.hiring_plan_id IS NULL))
  • Rows Removed by Filter: 81
  • Buffers: shared hit=496 read=141
7. 0.405 0.405 ↓ 69.0 138 1

Index Scan using pob_applications_idx on applications (cost=0.56..3.57 rows=2 width=16) (actual time=0.020..0.405 rows=138 loops=1)

  • Index Cond: ((organization_id = '4002074002'::bigint) AND (stage_status_id = '4000005002'::bigint) AND (prospect = true) AND (created_at >= '2020-01-27 00:00:00'::timestamp without time zone) AND (created_at <= '2020-02-02 23:59:59.999999'::timestamp without time zone))
  • Filter: prospect
  • Buffers: shared hit=87 read=55
8. 9.522 9.522 ↑ 1.0 1 138

Index Scan using index_prospective_hiring_plans_on_application_id on prospective_hiring_plans (cost=0.43..2.45 rows=1 width=16) (actual time=0.069..0.069 rows=1 loops=138)

  • Index Cond: (application_id = applications.id)
  • Buffers: shared hit=409 read=86
9. 0.969 0.969 ↑ 1.0 1 57

Index Scan using sources_pkey on sources (cost=0.29..2.31 rows=1 width=16) (actual time=0.017..0.017 rows=1 loops=57)

  • Index Cond: (id = applications.source_id)
  • Buffers: shared hit=167 read=4
10. 0.058 0.342 ↑ 1.0 1 57

Nested Loop (cost=0.71..6.67 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=57)

  • Join Filter: (sources_1.sourcing_strategy_id = sourcing_strategies_1.id)
  • Rows Removed by Join Filter: 3
  • Buffers: shared hit=392 read=7
11. 0.057 0.228 ↑ 1.0 1 57

Nested Loop Left Join (cost=0.71..5.49 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=57)

  • Filter: ((source_overrides.hide IS NULL) OR (source_overrides.hide IS FALSE))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=336 read=7
12. 0.057 0.057 ↑ 1.0 1 57

Index Scan using sources_pkey on sources sources_1 (cost=0.29..3.04 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=57)

  • Index Cond: ((id = sources.id) AND (id = ANY ('{4000011002,4000017002,4000031002,4000056002,4000096002,4000098002,4000100002,4000110002,4000151002,4000173002}'::bigint[])))
  • Filter: (display AND ((organization_id IS NULL) OR (organization_id = '4002074002'::bigint)))
  • Buffers: shared hit=171
13. 0.114 0.114 ↓ 0.0 0 57

Index Scan using index_source_overrides_on_source_id_and_organization_id on source_overrides (cost=0.42..2.44 rows=1 width=9) (actual time=0.002..0.002 rows=0 loops=57)

  • Index Cond: ((sources_1.id = source_id) AND (organization_id = '4002074002'::bigint))
  • Buffers: shared hit=165 read=7
14. 0.056 0.056 ↑ 2.0 4 56

Seq Scan on sourcing_strategies sourcing_strategies_1 (cost=0.00..1.08 rows=8 width=8) (actual time=0.000..0.001 rows=4 loops=56)

  • Filter: (display AND reportable)
  • Buffers: shared hit=56
15. 0.000 0.000 ↑ 1.0 1 56

Index Only Scan using sourcing_strategies_pkey on sourcing_strategies (cost=0.13..0.15 rows=1 width=8) (actual time=0.000..0.000 rows=1 loops=56)

  • Index Cond: (id = sources.sourcing_strategy_id)
  • Heap Fetches: 0
  • Buffers: shared hit=57
Planning time : 6.267 ms
Execution time : 11.514 ms