explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P6Xy

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 346.860 ↓ 4.6 64 1

Nested Loop (cost=28.73..70,019.02 rows=14 width=253) (actual time=344.348..346.860 rows=64 loops=1)

2. 0.048 346.437 ↓ 4.6 64 1

Nested Loop Left Join (cost=28.30..70,002.65 rows=14 width=226) (actual time=344.330..346.437 rows=64 loops=1)

3. 0.046 346.389 ↓ 4.6 64 1

Nested Loop Left Join (cost=28.02..69,998.33 rows=14 width=244) (actual time=344.309..346.389 rows=64 loops=1)

4. 0.058 346.279 ↓ 4.6 64 1

Nested Loop Left Join (cost=27.88..69,995.94 rows=14 width=183) (actual time=344.300..346.279 rows=64 loops=1)

5. 0.046 346.221 ↓ 4.6 64 1

Nested Loop (cost=27.46..69,989.38 rows=14 width=194) (actual time=344.286..346.221 rows=64 loops=1)

6. 0.045 346.047 ↓ 4.6 64 1

Nested Loop (cost=27.04..69,982.52 rows=14 width=159) (actual time=344.271..346.047 rows=64 loops=1)

7. 170.742 345.874 ↓ 4.6 64 1

Hash Right Join (cost=26.62..69,974.83 rows=14 width=159) (actual time=344.252..345.874 rows=64 loops=1)

  • Hash Cond: ((rsi.serialized_product_id_)::text = (rmsi.serialized_product_id_)::text)
8. 174.966 174.966 ↑ 1.0 1,197,716 1

Seq Scan on receipt_serialized_item rsi (cost=0.00..65,445.32 rows=1,200,732 width=74) (actual time=0.004..174.966 rows=1,197,716 loops=1)

9. 0.039 0.166 ↓ 4.9 64 1

Hash (cost=26.46..26.46 rows=13 width=122) (actual time=0.166..0.166 rows=64 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
10. 0.032 0.127 ↓ 4.9 64 1

Nested Loop (cost=1.39..26.46 rows=13 width=122) (actual time=0.066..0.127 rows=64 loops=1)

11. 0.005 0.044 ↑ 2.0 1 1

Nested Loop (cost=0.96..15.36 rows=2 width=82) (actual time=0.043..0.044 rows=1 loops=1)

12. 0.024 0.024 ↑ 2.0 1 1

Index Only Scan using receipt_case_info_idx02 on receipt_case_info rci (cost=0.54..6.46 rows=2 width=45) (actual time=0.023..0.024 rows=1 loops=1)

  • Index Cond: (supplier_slip_no_ = 'NL202263'::text)
  • Heap Fetches: 1
13. 0.015 0.015 ↑ 1.0 1 1

Index Scan using pk_receiptmanifest on receipt_manifest rm (cost=0.41..4.44 rows=1 width=37) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: ((receipt_manifest_id_)::text = (rci.receipt_manifest_id_)::text)
  • Filter: ((manifest_status_)::text = 'C127ISSUED'::text)
14. 0.051 0.051 ↓ 5.8 64 1

Index Scan using receipt_manifest_serialized_item_idx02 on receipt_manifest_serialized_item rmsi (cost=0.43..5.44 rows=11 width=151) (actual time=0.018..0.051 rows=64 loops=1)

  • Index Cond: ((receipt_manifest_id_)::text = (rm.receipt_manifest_id_)::text)
  • Filter: ((site_id_)::text = 'VA2301'::text)
15. 0.128 0.128 ↑ 1.0 1 64

Index Scan using pk_receiptmanifestitem on receipt_manifest_item rmi (cost=0.42..0.54 rows=1 width=74) (actual time=0.002..0.002 rows=1 loops=64)

  • Index Cond: ((receipt_manifest_item_id_)::text = (rmsi.receipt_manifest_item_id_)::text)
16. 0.128 0.128 ↑ 1.0 1 64

Index Scan using pk_product on product pro (cost=0.42..0.48 rows=1 width=109) (actual time=0.002..0.002 rows=1 loops=64)

  • Index Cond: ((product_id_)::text = (rmi.receipt_product_id_)::text)
17. 0.000 0.000 ↓ 0.0 0 64

Index Scan using receipt_slip_pkey on receipt_slip rs (cost=0.42..0.46 rows=1 width=63) (actual time=0.000..0.000 rows=0 loops=64)

  • Index Cond: ((receipt_slip_id_)::text = (rsi.receipt_slip_id_)::text)
18. 0.064 0.064 ↑ 1.0 1 64

Index Scan using pk_color_info on color_info ci (cost=0.14..0.16 rows=1 width=196) (actual time=0.001..0.001 rows=1 loops=64)

  • Index Cond: ((color_id_)::text = (pro.color_id_)::text)
19. 0.000 0.000 ↓ 0.0 0 64

Index Scan using pk_person on person (cost=0.28..0.30 rows=1 width=45) (actual time=0.000..0.000 rows=0 loops=64)

  • Index Cond: ((party_id_)::text = (rs.received_pic_id_)::text)
20. 0.384 0.384 ↑ 1.0 1 64

Index Scan using seria_pro_ide_idx03 on serialized_product_identifier spi (cost=0.43..1.16 rows=1 width=100) (actual time=0.006..0.006 rows=1 loops=64)

  • Index Cond: ((serialized_product_id_)::text = (rmsi.serialized_product_id_)::text)
Planning time : 4.402 ms
Execution time : 347.138 ms