explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DrQp

Settings
# exclusive inclusive rows x rows loops node
1. 2.231 882.284 ↓ 40.3 1,936 1

Nested Loop Left Join (cost=0.85..5,444.09 rows=48 width=6,135) (actual time=36.280..882.284 rows=1,936 loops=1)

2. 2.187 880.053 ↓ 40.3 1,936 1

Nested Loop Left Join (cost=0.57..5,152.97 rows=48 width=3,622) (actual time=36.255..880.053 rows=1,936 loops=1)

  • Join Filter: (tasks3_.language_specialization_id = languagesp4_.language_specialization_id)
  • Rows Removed by Join Filter: 32,912
3. 1.078 875.930 ↓ 40.3 1,936 1

Nested Loop Left Join (cost=0.57..5,123.26 rows=48 width=3,051) (actual time=36.202..875.930 rows=1,936 loops=1)

  • Join Filter: (quote0_.quote_id = tasks3_.quote_id)
4. 0.289 0.660 ↓ 44.0 44 1

Nested Loop Left Join (cost=0.57..18.39 rows=1 width=2,008) (actual time=0.147..0.660 rows=44 loops=1)

  • Join Filter: (quote0_.rejection_reason_id = rejectionr2_.rejection_reason_id)
  • Rows Removed by Join Filter: 88
5. 0.079 0.283 ↓ 44.0 44 1

Nested Loop Left Join (cost=0.57..17.30 rows=1 width=1,916) (actual time=0.121..0.283 rows=44 loops=1)

  • Join Filter: (quote0_.quote_id = languageco1_.quote_id)
6. 0.066 0.066 ↑ 1.0 1 1

Index Scan using quote_pkey on quote quote0_ (cost=0.28..8.30 rows=1 width=1,872) (actual time=0.065..0.066 rows=1 loops=1)

  • Index Cond: (quote_id = 7,238)
7. 0.138 0.138 ↓ 11.0 44 1

Index Scan using quote_language_combination_quote_id_idx on quote_language_combination languageco1_ (cost=0.29..8.95 rows=4 width=44) (actual time=0.052..0.138 rows=44 loops=1)

  • Index Cond: (quote_id = 7,238)
8. 0.088 0.088 ↑ 1.3 3 44

Seq Scan on rejection_reason rejectionr2_ (cost=0.00..1.04 rows=4 width=92) (actual time=0.002..0.002 rows=3 loops=44)

9. 874.192 874.192 ↑ 1.1 44 44

Seq Scan on task tasks3_ (cost=0.00..5,104.27 rows=48 width=1,043) (actual time=19.425..19.868 rows=44 loops=44)

  • Filter: (quote_id = 7,238)
  • Rows Removed by Filter: 35,972
10. 1.913 1.936 ↑ 1.8 18 1,936

Materialize (cost=0.00..6.50 rows=33 width=571) (actual time=0.000..0.001 rows=18 loops=1,936)

11. 0.023 0.023 ↑ 1.8 18 1

Seq Scan on language_specialization languagesp4_ (cost=0.00..6.33 rows=33 width=571) (actual time=0.021..0.023 rows=18 loops=1)

12. 0.000 0.000 ↓ 0.0 0 1,936

Index Scan using project_pkey on project project5_ (cost=0.28..6.05 rows=1 width=1,897) (actual time=0.000..0.000 rows=0 loops=1,936)

  • Index Cond: (tasks3_.project_id = project_id)
Planning time : 12.778 ms
Execution time : 882.748 ms