explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t5uyO

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.269 ↓ 4.0 4 1

Sort (cost=8.21..8.21 rows=1 width=300) (actual time=0.269..0.269 rows=4 loops=1)

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

GroupAggregate (cost=8.17..8.20 rows=1 width=300) (actual time=0.237..0.256 rows=4 loops=1)

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

Sort (cost=8.17..8.17 rows=1 width=275) (actual time=0.225..0.226 rows=11 loops=1)

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

Nested Loop Left Join (cost=2.47..8.16 rows=1 width=275) (actual time=0.116..0.211 rows=11 loops=1)

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

Nested Loop Left Join (cost=2.47..6.93 rows=1 width=211) (actual time=0.110..0.177 rows=11 loops=1)

6. 0.015 0.148 ↓ 11.0 11 1

Nested Loop Left Join (cost=2.33..6.04 rows=1 width=208) (actual time=0.098..0.148 rows=11 loops=1)

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

Nested Loop (cost=2.33..4.88 rows=1 width=144) (actual time=0.092..0.122 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: 4
8. 0.021 0.091 ↓ 13.0 13 1

Hash Right Join (cost=2.33..3.79 rows=1 width=120) (actual time=0.081..0.091 rows=13 loops=1)

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

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

10. 0.005 0.061 ↓ 5.0 5 1

Hash (cost=2.32..2.32 rows=1 width=116) (actual time=0.061..0.061 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.018 0.056 ↓ 5.0 5 1

Hash Right Join (cost=1.10..2.32 rows=1 width=116) (actual time=0.048..0.056 rows=5 loops=1)

  • Hash Cond: ("insLineIszCalcBasket".id = "insLineIszCalcRequest".ins_line_isz_calc_basket_id)
12. 0.010 0.010 ↓ 1.3 20 1

Seq Scan on ins_line_isz_calc_baskets "insLineIszCalcBasket" (cost=0.00..1.15 rows=15 width=80) (actual time=0.007..0.010 rows=20 loops=1)

13. 0.008 0.028 ↓ 5.0 5 1

Hash (cost=1.09..1.09 rows=1 width=40) (actual time=0.027..0.028 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.020 0.020 ↓ 5.0 5 1

Seq Scan on ins_line_isz_calc_requests "insLineIszCalcRequest" (cost=0.00..1.09 rows=1 width=40) (actual time=0.017..0.020 rows=5 loops=1)

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

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=13)

  • 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.022 0.022 ↑ 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.002..0.002 rows=1 loops=11)

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

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

Planning time : 1.138 ms
Execution time : 0.398 ms