explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eTH

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

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

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

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

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

Sort (cost=8.18..8.18 rows=1 width=275) (actual time=0.276..0.277 rows=11 loops=1)

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

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

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

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

6. 0.010 0.183 ↓ 11.0 11 1

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

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

Nested Loop (cost=2.34..4.89 rows=1 width=144) (actual time=0.108..0.151 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.021 0.085 ↓ 19.0 19 1

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

  • Hash Cond: ("insLineIszCalcBasketAsset".ins_line_isz_calc_basket_id = "insLineIszCalcBasket".id)
9. 0.007 0.007 ↓ 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.007 rows=52 loops=1)

10. 0.006 0.057 ↓ 6.0 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.018 0.051 ↓ 6.0 6 1

Hash Right Join (cost=1.11..2.33 rows=1 width=116) (actual time=0.044..0.051 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.004..0.005 rows=21 loops=1)

13. 0.008 0.028 ↓ 6.0 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.020 0.020 ↓ 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.017..0.020 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.022 0.022 ↑ 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.002 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.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.002..0.002 rows=9 loops=11)

Planning time : 1.426 ms
Execution time : 0.476 ms