explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9UOC

Settings
# exclusive inclusive rows x rows loops node
1. 86.107 616.018 ↓ 53,025.0 53,025 1

Nested Loop (cost=17.26..38,091.51 rows=1 width=70) (actual time=1.535..616.018 rows=53,025 loops=1)

  • Join Filter: (a.cycle_id = c.id)
  • Rows Removed by Join Filter: 477225
2. 28.424 476.886 ↓ 53,025.0 53,025 1

Nested Loop (cost=17.26..38,090.29 rows=1 width=62) (actual time=1.522..476.886 rows=53,025 loops=1)

3. 0.000 395.437 ↓ 53,025.0 53,025 1

Nested Loop (cost=16.99..38,081.99 rows=1 width=45) (actual time=1.472..395.437 rows=53,025 loops=1)

4. 183.634 184.721 ↓ 323.3 53,025 1

Hash Join (cost=16.56..37,318.11 rows=164 width=38) (actual time=1.378..184.721 rows=53,025 loops=1)

  • Hash Cond: (d.application_status_id = s.id)
  • -> Index Scan using index_designations_on_association_id on designations d (cost=0.56..37094.87 rows=54826 width=32) (actual time=0.205..167.082 rows=5302
  • Index Cond: (association_id = 340)
5. 0.011 1.087 ↑ 1.0 10 1

Hash (cost=15.87..15.87 rows=10 width=18) (actual time=1.087..1.087 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 1.076 1.076 ↑ 1.0 10 1

Index Scan using index_statuses_on_association_id on statuses s (cost=0.28..15.87 rows=10 width=18) (actual time=1.069..1.076 rows=10 loops=1)

  • Index Cond: (association_id = 340)
7. 212.100 212.100 ↑ 1.0 1 53,025

Index Scan using applicants_pkey on applicants ap (cost=0.43..4.65 rows=1 width=19) (actual time=0.003..0.004 rows=1 loops=53,025)

  • Index Cond: (id = d.applicant_id)
  • Filter: (association_id = 340)
8. 53.025 53.025 ↑ 1.0 1 53,025

Index Scan using associations_pkey on associations a (cost=0.27..8.29 rows=1 width=21) (actual time=0.001..0.001 rows=1 loops=53,025)

  • Index Cond: (id = 340)
  • Filter: cas3
9. 53.025 53.025 ↑ 1.0 10 53,025

Seq Scan on cycles c (cost=0.00..1.10 rows=10 width=16) (actual time=0.000..0.001 rows=10 loops=53,025)

Planning time : 2.610 ms
Execution time : 619.126 ms