explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bwR : cam_2

Settings
# exclusive inclusive rows x rows loops node
1. 108.682 3,716.276 ↑ 1.0 1 1

Aggregate (cost=11,242.88..11,242.89 rows=1 width=8) (actual time=3,716.272..3,716.276 rows=1 loops=1)

2. 108.741 3,607.594 ↓ 2.8 22,671 1

Hash Right Join (cost=9,199.78..11,222.50 rows=8,154 width=8) (actual time=3,480.801..3,607.594 rows=22,671 loops=1)

  • Hash Cond: (addresses7_.personid = person5_.personid)
3. 18.184 18.184 ↑ 95.3 313 1

Seq Scan on address addresses7_ (cost=0.00..1,885.43 rows=29,817 width=8) (actual time=0.030..18.184 rows=313 loops=1)

  • Filter: ((addresstype)::text = ($1)::text)
  • Rows Removed by Filter: 60199
4. 113.683 3,480.669 ↓ 2.8 22,671 1

Hash (cost=9,097.86..9,097.86 rows=8,154 width=16) (actual time=3,480.669..3,480.669 rows=22,671 loops=1)

  • Buckets: 32768 (originally 8192) Batches: 1 (originally 1) Memory Usage: 1319kB
5. 3,257.042 3,366.986 ↓ 2.8 22,671 1

Hash Join (cost=8,120.20..9,097.86 rows=8,154 width=16) (actual time=3,040.367..3,366.986 rows=22,671 loops=1)

  • Hash Cond: (consumeror9_.orderedproductid = orderedpro0_.orderedproductid)
6. 0.000 109.944 ↓ 1.0 22,671 1

Seq Scan on prod_consumerorder consumeror9_ (cost=0.00..813.81 rows=22,081 width=8) (actual time=0.023..109.944 rows=22,671 loops=1)

7. 76.310 3,040.305 ↓ 2.7 15,169 1

Hash (cost=8,051.19..8,051.19 rows=5,521 width=16) (actual time=3,040.305..3,040.305 rows=15,169 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 840kB
  • Hash Cond: (carparksim4_.operatorpersonid = operatorco6_.operatorcompanyid)
8. 145.088 2,963.995 ↓ 2.7 15,169 1

Hash Join (cost=5,263.25..8,051.19 rows=5,521 width=16) (actual time=1,662.345..2,963.995 rows=15,169 loops=1)

9. 190.709 2,818.907 ↓ 2.7 15,169 1

Hash Join (cost=5,262.21..7,974.23 rows=5,521 width=24) (actual time=1,662.262..2,818.907 rows=15,169 loops=1)

  • Hash Cond: (orderedpro0_.facilityid = carparksim4_.carparkid)
10. 496.196 2,628.141 ↓ 2.7 15,169 1

Hash Join (cost=5,115.62..7,751.73 rows=5,521 width=16) (actual time=1,616.879..2,628.141 rows=15,169 loops=1)

  • Hash Cond: (person3_.personid = customer2_.personid)
11. 473.364 473.364 ↓ 1.0 97,663 1

Seq Scan on person person3_ (cost=0.00..2,223.11 rows=95,411 width=8) (actual time=0.021..473.364 rows=97,663 loops=1)

  • Filter: (deletedate IS NULL)
  • Rows Removed by Filter: 2
12. 76.319 1,613.224 ↓ 2.7 15,169 1

Hash (cost=5,046.61..5,046.61 rows=5,521 width=24) (actual time=1,613.224..1,613.224 rows=15,169 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 958kB
13. 143.902 1,536.905 ↓ 2.7 15,169 1

Hash Join (cost=3,697.82..5,046.61 rows=5,521 width=24) (actual time=1,316.274..1,536.905 rows=15,169 loops=1)

  • Hash Cond: (orderedpro0_.paymentcontractid = paymentcon1_.paymentcontractid)
14. 76.801 76.801 ↓ 1.0 15,169 1

Seq Scan on prod_orderedproduct orderedpro0_ (cost=0.00..1,237.51 rows=14,951 width=24) (actual time=0.023..76.801 rows=15,169 loops=1)

15. 80.152 1,316.202 ↓ 2.7 15,169 1

Hash (cost=3,628.50..3,628.50 rows=5,546 width=24) (actual time=1,316.202..1,316.202 rows=15,169 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 958kB
16. 152.362 1,236.050 ↓ 2.7 15,169 1

Hash Join (cost=2,775.60..3,628.50 rows=5,546 width=24) (actual time=1,007.462..1,236.050 rows=15,169 loops=1)

  • Hash Cond: (paymentdat11_.paymentdataid = paymentord10_.paymentdataid)
17. 76.320 76.320 ↓ 1.0 15,173 1

Seq Scan on cam_paymentdata paymentdat11_ (cost=0.00..741.70 rows=14,870 width=8) (actual time=0.021..76.320 rows=15,173 loops=1)

18. 92.816 1,007.368 ↓ 2.7 15,169 1

Hash (cost=2,706.27..2,706.27 rows=5,546 width=32) (actual time=1,007.368..1,007.368 rows=15,169 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 1077kB
19. 266.433 914.552 ↓ 2.7 15,169 1

Hash Join (cost=2,024.27..2,706.27 rows=5,546 width=32) (actual time=648.181..914.552 rows=15,169 loops=1)

  • Hash Cond: (paymentord10_.paymentcontractid = paymentcon1_.paymentcontractid)
  • -> Seq Scan on cam_paymentorder paymentord10_ (cost=0.00..570.76 rows=14876 width=16) (actual time=0.020..87.947
  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 840kB
20. 103.536 648.119 ↓ 2.7 15,169 1

Hash (cost=1,954.28..1,954.28 rows=5,599 width=16) (actual time=648.119..648.119 rows=15,169 loops=1)

  • Hash Cond: (paymentcon1_.customerid = customer2_.customerid)
  • -> Seq Scan on cam_paymentcontract paymentcon1_ (cost=0.00..1109.72 rows=11198 width=16) (actual
  • Filter: ((deletedate IS NULL) AND ((((status)::text = ($5)::text) AND (valstartdate <= $6) AND ((valenddate >= $7) OR (valenddate IS NULL))) OR ((valenddate >= $8) AND ((status)::text = ($9)::text)) OR ((((status)::text = ($10)::text) OR ((status)::text = ($11)::text)) AND (valenddate < $12)) OR (((status)::text = ($13)::text) AND (valstartdate > $14)) OR ((status)::text = ($15)::text) OR ((status)::text = ($16)::text)))
21. 311.131 544.583 ↓ 2.7 15,169 1

Hash Join (cost=747.24..1,954.28 rows=5,599 width=16) (actual time=233.520..544.583 rows=15,169 loops=1)

22. 114.392 233.452 ↓ 2.0 15,167 1

Hash (cost=654.49..654.49 rows=7,420 width=16) (actual time=233.452..233.452 rows=15,167 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 839kB
23. 119.060 119.060 ↓ 2.0 15,167 1

Seq Scan on cam_customer customer2_ (cost=0.00..654.49 rows=7,420 width=16) (actual time=0.021..119.060 rows=15,167 loops=1)

  • Filter: ((deletedate IS NULL) AND ((status)::text <> ($4)::text))
24. 1.905 45.357 ↑ 1.0 306 1

Hash (cost=142.76..142.76 rows=306 width=24) (actual time=45.357..45.357 rows=306 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
25. 20.109 43.452 ↑ 1.0 306 1

Merge Join (cost=70.93..142.76 rows=306 width=24) (actual time=4.645..43.452 rows=306 loops=1)

  • Merge Cond: (person5_.personid = carparksim4_.carparkpersonid)
26. 17.180 17.180 ↑ 36.6 2,604 1

Index Only Scan using person_pkey on person person5_ (cost=0.29..3,756.39 rows=95,411 width=8) (actual time=0.022..17.180 rows=2,604 loops=1)

  • Heap Fetches: 2604
27. 3.992 6.163 ↑ 1.0 306 1

Sort (cost=30.69..31.46 rows=306 width=32) (actual time=4.294..6.163 rows=306 loops=1)

  • Sort Key: carparksim4_.carparkpersonid
  • Sort Method: quicksort Memory: 48kB
28. 2.171 2.171 ↑ 1.0 306 1

Seq Scan on cpi_carpark carparksim4_ (cost=0.00..18.06 rows=306 width=32) (actual time=0.021..2.171 rows=306 loops=1)

  • Filter: (deletedate IS NULL)
29. 0.025 0.057 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=8) (actual time=0.057..0.057 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
30. 0.032 0.032 ↑ 1.0 2 1

Seq Scan on bdm_operatorcompany operatorco6_ (cost=0.00..1.02 rows=2 width=8) (actual time=0.018..0.032 rows=2 loops=1)