explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nsJv

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

HashSetOp Intersect (cost=1,009.73..166,894.02 rows=11 width=578) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Append (cost=1,009.73..166,893.81 rows=41 width=578) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Subquery Scan on victor_victor (cost=1,009.73..83,422.74 rows=11 width=73) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Gather (cost=1,009.73..83,422.63 rows=11 width=69) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.73..82,421.53 rows=5 width=69) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.30..82,406.16 rows=5 width=29) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.88..82,390.28 rows=5 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.31..79,412.60 rows=38 width=8) (actual rows= loops=)

  • Hash Cond: (quebec.six_november = yankee_foxtrot.six_november)
9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on yankee_november quebec (cost=0.00..78,068.00 rows=508,900 width=16) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using india on four yankee_foxtrot (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((foxtrot_yankee)::text = 'whiskey_six'::text)
12. 0.000 0.000 ↓ 0.0

Index Scan using victor_golf_zulu on alpha_uniform oscar (cost=0.56..78.29 rows=7 width=16) (actual rows= loops=)

  • Index Cond: (tango_kilo = quebec.tango_kilo)
  • Filter: ((sierra_quebec < 'foxtrot_lima'::numeric) AND ((juliet_foxtrot)::text = 'six_foxtrot'::text) AND ((charlie)::text = 'whiskey_foxtrot'::text) AND ((juliet_alpha)::text = 'tango_xray'::text))
13. 0.000 0.000 ↓ 0.0

Index Scan using whiskey_quebec on sierra_four echo_quebec (cost=0.43..3.18 rows=1 width=21) (actual rows= loops=)

  • Index Cond: (alpha_tango = oscar.alpha_tango)
14. 0.000 0.000 ↓ 0.0

Index Scan using victor_golf_hotel on yankee_echo mike_seven (cost=0.43..3.07 rows=1 width=64) (actual rows= loops=)

  • Index Cond: (alpha_tango = echo_quebec.alpha_tango)
15. 0.000 0.000 ↓ 0.0

Subquery Scan on echo_uniform (cost=1,009.73..83,470.87 rows=30 width=73) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Gather (cost=1,009.73..83,470.57 rows=30 width=69) (actual rows= loops=)

  • Workers Planned: 2
17. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.73..82,467.57 rows=12 width=69) (actual rows= loops=)

  • -> Index Scan using pk_cmpdstr_molregno on compound_structures cs_1 (cost=0.43..3.07 rows=1 width=64)" Index Cond: (molregno = md_1.molregno)
18. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.30..82,430.68 rows=12 width=29) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.88..82,394.84 rows=12 width=8) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.31..79,412.60 rows=38 width=8) (actual rows= loops=)

  • Hash Cond: (mike_november1.six_november = yankee_quebec1.six_november)
21. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on yankee_november juliet_xray (cost=0.00..78,068.00 rows=508,900 width=16) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=8) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Index Scan using india on four papa (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((foxtrot_yankee)::text = 'mike_oscar'::text)
24. 0.000 0.000 ↓ 0.0

Index Scan using victor_golf_zulu on alpha_uniform five (cost=0.56..78.29 rows=19 width=16) (actual rows= loops=)

  • Index Cond: (tango_kilo = mike_november1.tango_kilo)
  • Filter: ((sierra_quebec > 'tango_victor'::numeric) AND ((juliet_foxtrot)::text = 'six_foxtrot'::text) AND ((charlie)::text = 'whiskey_foxtrot'::text) AND ((juliet_alpha)::text = 'tango_xray'::text))
25. 0.000 0.000 ↓ 0.0

Index Scan using whiskey_quebec on sierra_four echo_sierra (cost=0.43..2.99 rows=1 width=21) (actual rows= loops=)

  • Index Cond: (alpha_tango = six_five1.alpha_tango)