explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DPRf : Optimization for: plan #Ypsb

Settings

Optimization path:

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

Sort (cost=265.640..265.890 rows=100 width=890) (actual rows= loops=)

  • Sort Key: romeo_three.november
2. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=58.860..262.320 rows=100 width=890) (actual rows= loops=)

  • Hash Cond: (kilo.six = ""zulu_juliet"".oscar)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=15.380..217.470 rows=100 width=894) (actual rows= loops=)

  • Hash Cond: (kilo.six = romeo_three.quebec_seven)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12.930..214.700 rows=100 width=883) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=12.660..27.210 rows=100 width=12) (actual rows= loops=)

  • Hash Cond: (quebec_sierra.quebec_seven = (((two(lima_november.zulu_delta)))::integer))
6. 0.000 0.000 ↓ 0.0

Seq Scan on zulu_delta quebec_sierra (cost=0.000..11.890 rows=589 width=12) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=11.410..11.410 rows=100 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Result (cost=0.140..10.410 rows=100 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.140..8.660 rows=100 width=32) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using yankee on lima_november (cost=0.140..8.150 rows=1 width=194) (actual rows= loops=)

  • Index Cond: (quebec_seven = 2)
11. 0.000 0.000 ↓ 0.0

Index Scan using golf on romeo_oscar kilo (cost=0.280..1.870 rows=1 width=883) (actual rows= loops=)

  • Index Cond: (quebec_seven = quebec_sierra.mike)
12. 0.000 0.000 ↓ 0.0

Hash (cost=2.200..2.200 rows=20 width=11) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on tango romeo_three (cost=0.000..2.200 rows=20 width=11) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash (cost=42.220..42.220 rows=100 width=8) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Subquery Scan on zulu_juliet (cost=0.000..42.220 rows=100 width=8) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.000..41.220 rows=100 width=12) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.000..40.710 rows=1 width=68) (actual rows= loops=)

  • Group Key: lima_delta.quebec_seven
18. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.000..40.620 rows=10 width=20) (actual rows= loops=)

  • Join Filter: (juliet.quebec_seven = ANY (lima_delta.charlie))
19. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_lima lima_delta (cost=0.000..2.270 rows=1 width=43) (actual rows= loops=)

  • Filter: (quebec_seven = 25)
20. 0.000 0.000 ↓ 0.0

Seq Scan on sierra juliet (cost=0.000..29.800 rows=380 width=20) (actual rows= loops=)