explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 14xa

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 12,993.466 ↑ 1.0 24 1

Limit (cost=2.57..2,276.18 rows=24 width=2,641) (actual time=12,992.976..12,993.466 rows=24 loops=1)

2. 0.033 12,993.461 ↑ 1,278.2 24 1

Nested Loop (cost=2.57..2,906,154.36 rows=30,677 width=2,641) (actual time=12,992.975..12,993.461 rows=24 loops=1)

3. 0.051 12,993.404 ↑ 1,278.2 24 1

Nested Loop (cost=2.42..2,864,612.53 rows=30,677 width=2,477) (actual time=12,992.962..12,993.404 rows=24 loops=1)

  • Join Filter: (subrequest3_.fk_service_code = servicecod4_.id_service_code)
  • Rows Removed by Join Filter: 284
4. 0.032 12,993.329 ↑ 1,278.2 24 1

Nested Loop (cost=2.42..2,848,021.21 rows=30,677 width=2,398) (actual time=12,992.940..12,993.329 rows=24 loops=1)

5. 0.031 12,993.225 ↑ 1,278.2 24 1

Nested Loop (cost=1.99..2,779,534.65 rows=30,677 width=2,094) (actual time=12,992.924..12,993.225 rows=24 loops=1)

6. 0.013 12,993.122 ↑ 1,278.2 24 1

Nested Loop (cost=1.56..2,721,589.56 rows=30,677 width=1,978) (actual time=12,992.907..12,993.122 rows=24 loops=1)

7. 2.235 12,993.013 ↑ 1,278.2 24 1

Nested Loop Left Join (cost=1.12..2,657,171.56 rows=30,677 width=1,841) (actual time=12,992.882..12,993.013 rows=24 loops=1)

  • Filter: ((package0_.fk_current_task IS NULL) OR (subrequest5_.task_type <> 0) OR (subrequest5_.status <> ALL ('{0,1}'::integer[])))
  • Rows Removed by Filter: 9650
8. 12,168.488 12,168.488 ↑ 3.2 9,674 1

Index Scan using packages_received_at_desc_id_desc_idx on packages package0_ (cost=0.56..2,578,934.46 rows=30,678 width=1,525) (actual time=1.062..12,168.488 rows=9,674 loops=1)

  • Filter: (status = 1)
  • Rows Removed by Filter: 38558
9. 822.290 822.290 ↑ 1.0 1 9,674

Index Scan using subrequest_tasks_pkey on subrequest_tasks subrequest5_ (cost=0.56..2.54 rows=1 width=316) (actual time=0.085..0.085 rows=1 loops=9,674)

  • Index Cond: (package0_.fk_current_task = id)
10. 0.096 0.096 ↑ 1.0 1 24

Index Scan using requests_pkey on requests request1_ (cost=0.43..2.10 rows=1 width=137) (actual time=0.004..0.004 rows=1 loops=24)

  • Index Cond: (id_request = package0_.fk_request)
11. 0.072 0.072 ↑ 1.0 1 24

Index Scan using orders_pkey on orders order2_ (cost=0.43..1.89 rows=1 width=116) (actual time=0.003..0.003 rows=1 loops=24)

  • Index Cond: (id = request1_.fk_order)
12. 0.072 0.072 ↑ 1.0 1 24

Index Scan using sub_requests_pkey on sub_requests subrequest3_ (cost=0.43..2.23 rows=1 width=304) (actual time=0.003..0.003 rows=1 loops=24)

  • Index Cond: (id_sub_request = package0_.fk_current_sub_request)
13. 0.017 0.024 ↑ 2.8 13 24

Materialize (cost=0.00..1.56 rows=37 width=79) (actual time=0.000..0.001 rows=13 loops=24)

14. 0.007 0.007 ↑ 1.7 22 1

Seq Scan on service_codes servicecod4_ (cost=0.00..1.37 rows=37 width=79) (actual time=0.005..0.007 rows=22 loops=1)

15. 0.024 0.024 ↑ 1.0 1 24

Index Scan using business_partner_pkey on business_partners businesspa6_ (cost=0.15..1.36 rows=1 width=148) (actual time=0.001..0.001 rows=1 loops=24)

  • Index Cond: (id_business_partner = package0_.fk_current_business_partner)
Planning time : 15.844 ms
Execution time : 12,993.921 ms