explain.depesz.com

PostgreSQL's explain analyze made readable

Result: whfR

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

Limit (cost=129,783.70..129,786.52 rows=25 width=126) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Group (cost=129,780.87..214,869.91 rows=753,975 width=126) (actual rows= loops=)

  • Group Key: kilo.zulu, papa.oscar_alpha, lima_delta.bravo, lima_delta.oscar_delta, quebec_sierra.november
3. 0.000 0.000 ↓ 0.0

Gather Merge (cost=129,780.87..207,016.01 rows=628,312 width=126) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Group (cost=128,780.85..133,493.19 rows=314,156 width=126) (actual rows= loops=)

  • Group Key: kilo.zulu, papa.oscar_alpha, lima_delta.bravo, lima_delta.oscar_delta, quebec_sierra.november
5. 0.000 0.000 ↓ 0.0

Sort (cost=128,780.85..129,566.24 rows=314,156 width=126) (actual rows= loops=)

  • Sort Key: kilo.zulu, papa.oscar_alpha, lima_delta.bravo, lima_delta.oscar_delta, quebec_sierra.november
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=35,722.91..79,691.65 rows=314,156 width=126) (actual rows= loops=)

  • Hash Cond: (quebec_sierra.oscar_alpha = papa.oscar_alpha)
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=35,654.25..78,795.85 rows=314,156 width=105) (actual rows= loops=)

  • Hash Cond: (lima_delta.bravo = quebec_sierra.bravo)
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=25,447.78..58,725.33 rows=336,009 width=57) (actual rows= loops=)

  • Hash Cond: (lima_delta.zulu = kilo.zulu)
9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on mike lima_delta (cost=0.00..23,321.53 rows=371,814 width=33) (actual rows= loops=)

  • Filter: (NOT seven)
10. 0.000 0.000 ↓ 0.0

Hash (cost=17,206.42..17,206.42 rows=405,709 width=40) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on lima_november kilo (cost=0.00..17,206.42 rows=405,709 width=40) (actual rows= loops=)

  • Filter: (NOT seven)
12. 0.000 0.000 ↓ 0.0

Hash (cost=6,394.26..6,394.26 rows=164,017 width=64) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on delta quebec_sierra (cost=0.00..6,394.26 rows=164,017 width=64) (actual rows= loops=)

  • Filter: (NOT seven)
14. 0.000 0.000 ↓ 0.0

Hash (cost=51.07..51.07 rows=1,407 width=37) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_oscar papa (cost=0.00..51.07 rows=1,407 width=37) (actual rows= loops=)