explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JpuAD

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=52,372,214,135,980,762,368,583,925,760.00..52,816,660,984,764,223,813,207,457,792.00 rows=65,300 width=151) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=52,372,214,135,980,762,368,583,925,760.00..52,435,706,542,949,828,289,244,430,336.00 rows=25,396,962,787,626,174,750,155,341,824 width=151) (actual rows= loops=)

  • Sort Key: cleb.cle_id, trans.name, trans.description, trans1.attribute1, trans1.attribute2, trans1.attribute3
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,056,482,208.26..285,715,837,098,804,265,311,272,960.00 rows=25,396,962,787,626,174,750,155,341,824 width=151) (actual rows= loops=)

  • Hash Cond: (cleb.id = citem.cle_id)
4. 0.000 0.000 ↓ 0.0

Merge Join (cost=140.93..1,337,011,990,820,165,888.00 rows=89,134,131,547,115,208,704 width=167) (actual rows= loops=)

  • Merge Cond: (cleb.id = entit_line.cle_id)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.00..108,911,798.80 rows=157,233,760 width=16) (actual rows= loops=)

  • Join Filter: (cleb.cle_id = msi.coverage_schedule_id)
6. 0.000 0.000 ↓ 0.0

Index Scan using okc_k_lines_b_u1 on okc_k_lines_b cleb (cost=0.58..102,088,984.78 rows=454,853,705 width=16) (actual rows= loops=)

  • Filter: (lse_id = ANY ('{3,16,21}'::double precision[]))
7. 0.000 0.000 ↓ 0.0

Materialize (cost=0.42..8.45 rows=1 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Scan using mtl_system_items_b_u1 on mtl_system_items_b msi (cost=0.42..8.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((inventory_item_id = '146126'::double precision) AND (organization_id = '81'::double precision))
9. 0.000 0.000 ↓ 0.0

Materialize (cost=139.93..31,912,077,362.37 rows=815,589,752,336 width=151) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=139.93..29,873,102,981.53 rows=815,589,752,336 width=151) (actual rows= loops=)

  • Join Filter: (entit_item.cle_id = entit_line.id)
11. 0.000 0.000 ↓ 0.0

Index Scan using okc_k_lines_b_n5 on okc_k_lines_b entit_line (cost=0.58..99,773,343.50 rows=4,137,279 width=16) (actual rows= loops=)

  • Filter: (lse_id = ANY ('{5,23}'::double precision[]))
12. 0.000 0.000 ↓ 0.0

Materialize (cost=139.35..13,969,265.45 rows=197,132 width=151) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash Join (cost=139.35..13,964,043.79 rows=197,132 width=151) (actual rows= loops=)

  • Hash Cond: (((entit_item.object1_id1)::integer)::double precision = tbt.txn_billing_type_id)
14. 0.000 0.000 ↓ 0.0

Index Scan using okc_k_items_n11 on okc_k_items entit_item (cost=0.58..13,943,484.03 rows=2,460,358 width=14) (actual rows= loops=)

  • Index Cond: ((jtot_object1_code)::text = 'OKX_BILLTYPE'::text)
  • Filter: ((object1_id2)::text = '#'::text)
15. 0.000 0.000 ↓ 0.0

Hash (cost=137.48..137.48 rows=104 width=151) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Hash Join (cost=100.56..137.48 rows=104 width=151) (actual rows= loops=)

  • Hash Cond: (tbt.transaction_type_id = trans.transaction_type_id)
17. 0.000 0.000 ↓ 0.0

Seq Scan on cs_txn_billing_types tbt (cost=0.00..31.00 rows=1,300 width=16) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash (cost=99.26..99.26 rows=104 width=156) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Hash Join (cost=61.65..99.26 rows=104 width=156) (actual rows= loops=)

  • Hash Cond: ((trans1.transaction_type_id)::double precision = trans.transaction_type_id)
20. 0.000 0.000 ↓ 0.0

Seq Scan on cs_transaction_types_b trans1 (cost=0.00..37.33 rows=104 width=64) (actual rows= loops=)

  • Filter: ((attribute1)::text = ANY ('{BOTH,NEW}'::text[]))
21. 0.000 0.000 ↓ 0.0

Hash (cost=45.33..45.33 rows=1,306 width=92) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Seq Scan on cs_transaction_types_tl trans (cost=0.00..45.33 rows=1,306 width=92) (actual rows= loops=)

  • Filter: ((language)::text = 'US'::text)
23. 0.000 0.000 ↓ 0.0

Hash (cost=51,807,438.88..51,807,438.88 rows=284,929,716 width=8) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Seq Scan on okc_k_items citem (cost=0.00..51,807,438.88 rows=284,929,716 width=8) (actual rows= loops=)

  • Filter: (((object1_id2)::text = '#'::text) AND ((jtot_object1_code)::text = 'OKX_BUSIPROC'::text))