explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s9rs

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.020 603.522 ↑ 1.0 100 1

Limit (cost=1,056.97..88,885.95 rows=100 width=414) (actual time=25.202..603.522 rows=100 loops=1)

2. 224.169 603.502 ↑ 6,235.6 100 1

Nested Loop (cost=1,056.97..547,664,806.18 rows=623,557 width=414) (actual time=25.201..603.502 rows=100 loops=1)

3. 226.143 308.533 ↑ 6,235.6 100 1

Nested Loop (cost=1,056.97..277,560,925.38 rows=623,557 width=334) (actual time=17.997..308.533 rows=100 loops=1)

4. 0.255 11.090 ↑ 6,235.6 100 1

Hash Join (cost=1,056.97..7,464,839.05 rows=623,557 width=328) (actual time=10.728..11.09 rows=100 loops=1)

5. 0.149 0.373 ↑ 6,235.6 100 1

Hash Join (cost=7.82..93,229.24 rows=623,557 width=322) (actual time=0.193..0.373 rows=100 loops=1)

6. 0.156 0.156 ↑ 6,235.6 100 1

Seq Scan on items_raw items_raw (cost=0..46,289.57 rows=623,557 width=308) (actual time=0.116..0.156 rows=100 loops=1)

7. 0.018 0.068 ↑ 2.5 51 1

Hash (cost=5.91..5.91 rows=127 width=18) (actual time=0.068..0.068 rows=51 loops=1)

8. 0.033 0.050 ↑ 1.0 127 1

Hash Join (cost=1.18..5.91 rows=127 width=18) (actual time=0.015..0.05 rows=127 loops=1)

9. 0.010 0.010 ↑ 1.0 127 1

Seq Scan on facility_warehouse_link fwl (cost=0..3.27 rows=127 width=16) (actual time=0.002..0.01 rows=127 loops=1)

10. 0.004 0.007 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=10) (actual time=0.007..0.007 rows=8 loops=1)

11. 0.003 0.003 ↑ 1.0 8 1

Seq Scan on wms_systems ws (cost=0..1.08 rows=8 width=10) (actual time=0.001..0.003 rows=8 loops=1)

12. 6.234 10.462 ↑ 1.0 15,751 1

Hash (cost=773.51..773.51 rows=15,751 width=21) (actual time=10.462..10.462 rows=15,751 loops=1)

13. 4.228 4.228 ↑ 1.0 15,751 1

Seq Scan on sfdc_xref_customer cx (cost=0..773.51 rows=15,751 width=21) (actual time=0.098..4.228 rows=15,751 loops=1)

14. 68.229 71.300 ↑ 1.0 15,751 100

Materialize (cost=0..852.26 rows=15,751 width=21) (actual time=0.001..0.713 rows=15,751 loops=100)

15. 3.071 3.071 ↑ 1.0 15,751 1

Seq Scan on sfdc_xref_customer cxb (cost=0..773.51 rows=15,751 width=21) (actual time=0.041..3.071 rows=15,751 loops=1)

16. 67.743 70.800 ↑ 1.0 15,751 100

Materialize (cost=0..852.26 rows=15,751 width=21) (actual time=0..0.708 rows=15,751 loops=100)

17. 3.057 3.057 ↑ 1.0 15,751 1

Seq Scan on sfdc_xref_customer cxo (cost=0..773.51 rows=15,751 width=21) (actual time=0.043..3.057 rows=15,751 loops=1)