explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TKEe

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

Nested Loop (cost=943.300..6,316,010.180 rows=866 width=717) (never executed)

2. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=943.300..6,309,524.960 rows=866 width=453) (never executed)

3. 0.000 0.000 ↓ 0.0 0

Append (cost=0.000..5,330,715.910 rows=260,761,891 width=421) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Seq Scan on four november (cost=0.000..4,512,317.030 rows=220,494,203 width=421) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Seq Scan on six november (cost=0.000..653,053.600 rows=32,149,560 width=421) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Seq Scan on victor november (cost=0.000..158,881.640 rows=7,803,064 width=421) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Seq Scan on whiskey november (cost=0.000..6,463.640 rows=315,064 width=399) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Hash (cost=940.410..940.410 rows=231 width=32) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Scan using golf_five on zulu bravo (cost=0.000..940.410 rows=231 width=32) (never executed)

  • Index Cond: (uniform = 1)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using golf_four on five india (cost=0.000..7.480 rows=1 width=264) (never executed)

  • Index Cond: (charlie = bravo.charlie)