explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ex4J

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 5,776.745 ↑ 1.0 24 1

Limit (cost=2.56..867.75 rows=24 width=2,736) (actual time=5,767.580..5,776.745 rows=24 loops=1)

2. 0.018 5,776.740 ↑ 2,136.6 24 1

Nested Loop (cost=2.56..1,848,597.99 rows=51,279 width=2,736) (actual time=5,767.579..5,776.740 rows=24 loops=1)

3. 0.044 5,776.674 ↑ 2,136.6 24 1

Nested Loop (cost=2.41..1,780,490.72 rows=51,279 width=2,568) (actual time=5,767.563..5,776.674 rows=24 loops=1)

  • Join Filter: (subrequest3_.fk_service_code = servicecod4_.id_service_code)
  • Rows Removed by Join Filter: 378
4. 0.032 5,776.582 ↑ 2,136.6 24 1

Nested Loop (cost=2.41..1,752,758.16 rows=51,279 width=2,489) (actual time=5,767.548..5,776.582 rows=24 loops=1)

5. 0.035 5,776.022 ↑ 2,136.6 24 1

Nested Loop (cost=1.98..1,645,242.43 rows=51,279 width=2,205) (actual time=5,767.533..5,776.022 rows=24 loops=1)

6. 0.038 5,775.915 ↑ 2,136.6 24 1

Nested Loop (cost=1.55..1,543,826.93 rows=51,279 width=2,090) (actual time=5,767.518..5,775.915 rows=24 loops=1)

7. 11.258 5,770.573 ↑ 2,136.6 24 1

Nested Loop Left Join (cost=1.12..1,440,014.77 rows=51,279 width=1,953) (actual time=5,767.493..5,770.573 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: 23670
8. 2,963.423 2,963.423 ↑ 2.2 23,694 1

Index Scan using packages_received_at_desc_id_desc_idx on packages package0_ (cost=0.56..1,313,294.19 rows=51,288 width=1,635) (actual time=1.281..2,963.423 rows=23,694 loops=1)

  • Filter: (status = 1)
  • Rows Removed by Filter: 5272
9. 2,795.892 2,795.892 ↑ 1.0 1 23,694

Index Scan using subrequest_tasks_pkey on subrequest_tasks subrequest5_ (cost=0.56..2.46 rows=1 width=318) (actual time=0.118..0.118 rows=1 loops=23,694)

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

Index Scan using requests_pkey on requests request1_ (cost=0.43..2.02 rows=1 width=137) (actual time=0.221..0.221 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.98 rows=1 width=115) (actual time=0.003..0.003 rows=1 loops=24)

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

Index Scan using sub_requests_pkey on sub_requests subrequest3_ (cost=0.43..2.10 rows=1 width=284) (actual time=0.022..0.022 rows=1 loops=24)

  • Index Cond: (id_sub_request = package0_.fk_current_sub_request)
13. 0.040 0.048 ↑ 2.2 17 24

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

14. 0.008 0.008 ↑ 1.9 20 1

Seq Scan on service_codes servicecod4_ (cost=0.00..1.37 rows=37 width=79) (actual time=0.006..0.008 rows=20 loops=1)

15. 0.048 0.048 ↑ 1.0 1 24

Index Scan using business_partner_pkey on business_partners businesspa6_ (cost=0.15..1.33 rows=1 width=152) (actual time=0.002..0.002 rows=1 loops=24)

  • Index Cond: (id_business_partner = package0_.fk_current_business_partner)