explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t311

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

XN Hash Left Join DS_BCAST_INNER (cost=153,531.75..1,473,794.27 rows=1 width=346) (actual rows= loops=)

  • Hash Cond: (("outer".c_rbu)::text = ("inner".c_rbu)::text)
2. 0.000 0.000 ↓ 0.0

XN Hash Left Join DS_DIST_ALL_NONE (cost=153,531.71..153,794.19 rows=1 width=317) (actual rows= loops=)

  • Hash Cond: (("outer".department_source_identifier)::text = ("inner".c_mdept)::text)
3. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=153,530.47..153,792.93 rows=1 width=311) (actual rows= loops=)

  • Hash Cond: ((COALESCE("outer".class_generated_identifier, 0::bigint) = COALESCE("inner".class_generated_identifier, 0::bigint)) AND (COALESCE("outer".family_generated_identifier, 0::bigint) = COALESCE("inner".family_generated_identifier, 0::bigint)) AND (COALESCE("outer".minor_department_generated_id, 0::bigint) = COALESCE("inner".minor_department_generated_id, 0::bigint)) AND ("outer".department_generated_id = "inner".department_generated_id) AND ("outer".division_generated_identifier = "inner".division_generated_identifier) AND ("outer".rbu_generated_identifier = "inner".rbu_generated_identifier) AND (COALESCE("outer".sub_class_generated_id, 0::bigint) = COALESCE("inner".sub_class_generated_id, 0::bigint)) AND (COALESCE("outer".sub_sub_class_generated_id, 0::bigint) = COALESCE("inner".sub_sub_class_generated_id, 0::bigint)))
4. 0.000 0.000 ↓ 0.0

XN Hash Left Join DS_DIST_ALL_NONE (cost=153,371.68..153,415.09 rows=8 width=64) (actual rows= loops=)

  • Hash Cond: ("outer".preferred_supplier_gnrt_id = "inner".supplier_generated_identifier)
5. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=152,612.01..152,626.84 rows=1 width=72) (actual rows= loops=)

  • Hash Cond: ("outer".product_generated_identifier = "inner".product_generated_identifier)
6. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=76,264.45..76,279.10 rows=13 width=16) (actual rows= loops=)

  • Hash Cond: (("outer".c_mdept)::text = ("inner".department_source_identifier)::text)
7. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=1.24..3.64 rows=99 width=7) (actual rows= loops=)

  • Hash Cond: (("outer".c_rbu)::text = ("inner".c_rbu)::text)
8. 0.000 0.000 ↓ 0.0

XN Seq Scan on vjr403 (cost=0.00..0.03 rows=3 width=6) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

XN Hash (cost=0.99..0.99 rows=99 width=13) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

XN Seq Scan on vjr420 (cost=0.00..0.99 rows=99 width=13) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

XN Hash (cost=76,263.18..76,263.18 rows=12 width=23) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

XN Seq Scan on keycode (cost=0.00..76,263.18 rows=12 width=23) (actual rows= loops=)

  • Filter: (product_generated_identifier = ANY ('{4003932900004,4013427700004,4114702300004,4175999800004,4195948000004,4204982100004,4225911400004,4226621100004,4234840500004,4256556700004,4257691400004,4270378500004}'::bigint[]))
13. 0.000 0.000 ↓ 0.0

XN Hash (cost=76,347.53..76,347.53 rows=13 width=72) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

XN Seq Scan on keycode_family_tree_current (cost=0.00..76,347.53 rows=13 width=72) (actual rows= loops=)

  • Filter: (product_generated_identifier = ANY ('{4003932900004,4013427700004,4114702300004,4175999800004,4195948000004,4204982100004,4225911400004,4226621100004,4234840500004,4256556700004,4257691400004,4270378500004}'::bigint[]))
15. 0.000 0.000 ↓ 0.0

XN Hash (cost=651.15..651.15 rows=43,408 width=8) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

XN Seq Scan on supplier (cost=0.00..651.15 rows=43,408 width=8) (actual rows= loops=)

  • Filter: ((expiry_date >= '2019-05-09'::date) AND (effective_date <= '2019-05-09'::date))
17. 0.000 0.000 ↓ 0.0

XN Hash (cost=52.93..52.93 rows=5,293 width=311) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

XN Seq Scan on family_tree_work family_tree (cost=0.00..52.93 rows=5,293 width=311) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

XN Hash (cost=0.99..0.99 rows=99 width=13) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

XN Seq Scan on vjr420 (cost=0.00..0.99 rows=99 width=13) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

XN Hash (cost=0.03..0.03 rows=3 width=35) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

XN Seq Scan on vjr403 (cost=0.00..0.03 rows=3 width=35) (actual rows= loops=)