explain.depesz.com

PostgreSQL's explain analyze made readable

Result: upEN

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 77,140.441 ↑ 1.0 20 1

Limit (cost=2.83..553.75 rows=20 width=2,273) (actual time=76,915.257..77,140.441 rows=20 loops=1)

2. 0.059 77,140.431 ↑ 18,978.8 20 1

Nested Loop (cost=2.83..10,455,698.65 rows=379,575 width=2,273) (actual time=76,915.255..77,140.431 rows=20 loops=1)

3. 0.070 77,140.272 ↑ 18,978.8 20 1

Nested Loop (cost=2.56..9,703,862.04 rows=379,575 width=2,109) (actual time=76,915.232..77,140.272 rows=20 loops=1)

  • Join Filter: (subrequest3_.fk_service_code = servicecod4_.id_service_code)
  • Rows Removed by Join Filter: 148
4. 0.050 77,140.162 ↑ 18,978.8 20 1

Nested Loop (cost=2.56..9,498,590.52 rows=379,575 width=2,030) (actual time=76,915.207..77,140.162 rows=20 loops=1)

5. 0.050 77,139.972 ↑ 18,978.8 20 1

Nested Loop (cost=2.00..8,607,277.77 rows=379,575 width=1,778) (actual time=76,915.190..77,139.972 rows=20 loops=1)

6. 0.048 77,139.302 ↑ 18,978.8 20 1

Nested Loop (cost=1.56..7,772,880.97 rows=379,575 width=1,663) (actual time=76,915.175..77,139.302 rows=20 loops=1)

7. 0.093 77,139.134 ↑ 18,978.8 20 1

Nested Loop Left Join (cost=1.13..6,935,018.67 rows=379,575 width=1,526) (actual time=76,915.147..77,139.134 rows=20 loops=1)

  • Filter: ((package0_.fk_current_task IS NULL) OR (subrequest5_.task_type <> 0) OR (subrequest5_.status <> ALL ('{0,1}'::integer[])))
8. 77,136.441 77,136.441 ↑ 18,980.1 20 1

Index Scan using packages_received_at_desc_id_desc_idx on packages package0_ (cost=0.56..5,999,724.47 rows=379,602 width=1,163) (actual time=76,915.119..77,136.441 rows=20 loops=1)

  • Filter: (status = 9)
  • Rows Removed by Filter: 213321
9. 2.600 2.600 ↑ 1.0 1 20

Index Scan using subrequest_tasks_pkey on subrequest_tasks subrequest5_ (cost=0.57..2.45 rows=1 width=363) (actual time=0.130..0.130 rows=1 loops=20)

  • Index Cond: (package0_.fk_current_task = id)
10. 0.120 0.120 ↑ 1.0 1 20

Index Scan using requests_pkey on requests request1_ (cost=0.43..2.21 rows=1 width=137) (actual time=0.006..0.006 rows=1 loops=20)

  • Index Cond: (id_request = package0_.fk_request)
11. 0.620 0.620 ↑ 1.0 1 20

Index Scan using orders_pkey on orders order2_ (cost=0.43..2.20 rows=1 width=115) (actual time=0.031..0.031 rows=1 loops=20)

  • Index Cond: (id = request1_.fk_order)
12. 0.140 0.140 ↑ 1.0 1 20

Index Scan using sub_requests_pkey on sub_requests subrequest3_ (cost=0.56..2.35 rows=1 width=252) (actual time=0.007..0.007 rows=1 loops=20)

  • Index Cond: (id_sub_request = package0_.fk_current_sub_request)
13. 0.031 0.040 ↑ 4.6 8 20

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

14. 0.009 0.009 ↑ 1.7 22 1

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

15. 0.100 0.100 ↑ 1.0 1 20

Index Scan using business_partner_pkey on business_partners businesspa6_ (cost=0.28..1.98 rows=1 width=148) (actual time=0.005..0.005 rows=1 loops=20)

  • Index Cond: (id_business_partner = package0_.fk_current_business_partner)