explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZW5r

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 0.295 ↓ 4.0 4 1

Sort (cost=8.22..8.23 rows=1 width=300) (actual time=0.295..0.295 rows=4 loops=1)

  • Sort Key: "insLineIszCalcRequest".date_create DESC
  • Sort Method: quicksort Memory: 26kB
2. 0.009 0.279 ↓ 4.0 4 1

GroupAggregate (cost=8.18..8.21 rows=1 width=300) (actual time=0.271..0.279 rows=4 loops=1)

  • Group Key: "insLineIszCalcRequest".id, "insLineIszCalcBasket".id, "refCurrency".id, "refInsDateUnit".id, "refIszCalcStatus".id
3. 0.032 0.270 ↓ 11.0 11 1

Sort (cost=8.18..8.18 rows=1 width=275) (actual time=0.258..0.270 rows=11 loops=1)

  • Sort Key: "insLineIszCalcRequest".id, "insLineIszCalcBasket".id, "refCurrency".id, "refInsDateUnit".id, "refIszCalcStatus".id
  • Sort Method: quicksort Memory: 27kB
4. 0.019 0.238 ↓ 11.0 11 1

Nested Loop Left Join (cost=2.49..8.17 rows=1 width=275) (actual time=0.106..0.238 rows=11 loops=1)

  • Join Filter: ("refCurrency".id = "insLineIszCalcRequest".ref_currency_id)
  • Rows Removed by Join Filter: 83
5. 0.007 0.197 ↓ 11.0 11 1

Nested Loop Left Join (cost=2.49..6.94 rows=1 width=211) (actual time=0.097..0.197 rows=11 loops=1)

6. 0.017 0.157 ↓ 11.0 11 1

Nested Loop Left Join (cost=2.34..6.05 rows=1 width=208) (actual time=0.078..0.157 rows=11 loops=1)

  • Join Filter: ("refInsDateUnit".id = "insLineIszCalcBasket".freq_payment_term_unit)
  • Rows Removed by Join Filter: 32
7. 0.031 0.129 ↓ 11.0 11 1

Nested Loop (cost=2.34..4.89 rows=1 width=144) (actual time=0.072..0.129 rows=11 loops=1)

  • Join Filter: (("insLineIszCalcRequest".ref_isz_calc_status_id = "refIszCalcStatus".id) AND ((("insLineIszCalcRequest".date_beg <= now()) AND ("insLineIszCalcRequest".date_end >= now()) AND ("refIszCalcStatus".id = 1)) OR ("refIszCalcStatus".id = 2)))
  • Rows Removed by Join Filter: 16
8. 0.026 0.079 ↓ 19.0 19 1

Hash Right Join (cost=2.34..3.81 rows=1 width=120) (actual time=0.063..0.079 rows=19 loops=1)

  • Hash Cond: ("insLineIszCalcBasketAsset".ins_line_isz_calc_basket_id = "insLineIszCalcBasket".id)
9. 0.009 0.009 ↓ 1.6 52 1

Seq Scan on ins_line_isz_calc_basket_assets "insLineIszCalcBasketAsset" (cost=0.00..1.33 rows=33 width=8) (actual time=0.004..0.009 rows=52 loops=1)

10. 0.004 0.044 ↓ 6.0 6 1

Hash (cost=2.33..2.33 rows=1 width=116) (actual time=0.043..0.044 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.015 0.040 ↓ 6.0 6 1

Hash Right Join (cost=1.11..2.33 rows=1 width=116) (actual time=0.033..0.040 rows=6 loops=1)

  • Hash Cond: ("insLineIszCalcBasket".id = "insLineIszCalcRequest".ins_line_isz_calc_basket_id)
12. 0.005 0.005 ↓ 1.4 21 1

Seq Scan on ins_line_isz_calc_baskets "insLineIszCalcBasket" (cost=0.00..1.15 rows=15 width=80) (actual time=0.003..0.005 rows=21 loops=1)

13. 0.005 0.020 ↓ 6.0 6 1

Hash (cost=1.10..1.10 rows=1 width=40) (actual time=0.020..0.020 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.015 0.015 ↓ 6.0 6 1

Seq Scan on ins_line_isz_calc_requests "insLineIszCalcRequest" (cost=0.00..1.10 rows=1 width=40) (actual time=0.012..0.015 rows=6 loops=1)

  • Filter: (user_id = 1)
  • Rows Removed by Filter: 2
15. 0.019 0.019 ↑ 2.0 1 19

Seq Scan on ref_isz_calc_statuses "refIszCalcStatus" (cost=0.00..1.03 rows=2 width=36) (actual time=0.001..0.001 rows=1 loops=19)

  • Filter: ((id = 1) OR (id = 2))
  • Rows Removed by Filter: 0
16. 0.011 0.011 ↑ 1.8 4 11

Seq Scan on ref_ins_date_units "refInsDateUnit" (cost=0.00..1.07 rows=7 width=68) (actual time=0.001..0.001 rows=4 loops=11)

17. 0.033 0.033 ↑ 1.0 1 11

Index Scan using "PK_b0885a635a55b874da1472fef48" on ref_isz_assets "refIszAsset" (cost=0.14..0.89 rows=1 width=11) (actual time=0.003..0.003 rows=1 loops=11)

  • Index Cond: (id = "insLineIszCalcBasketAsset".ref_isz_asset_id)
18. 0.022 0.022 ↑ 1.1 9 11

Seq Scan on ref_currencies "refCurrency" (cost=0.00..1.10 rows=10 width=68) (actual time=0.001..0.002 rows=9 loops=11)

Planning time : 1.340 ms
Execution time : 0.434 ms