explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Zaj

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 123.326 ↓ 1.5 3 1

Sort (cost=10,239.60..10,239.60 rows=2 width=75) (actual time=123.326..123.326 rows=3 loops=1)

  • Sort Key: city."usageCount" DESC
  • Sort Method: quicksort Memory: 25kB
2. 8.645 123.359 ↓ 1.5 3 1

Gather (cost=1,017.49..10,239.59 rows=2 width=75) (actual time=71.261..123.359 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.002 114.636 ↑ 1.0 1 3 / 3

Nested Loop Left Join (cost=17.49..9,202.43 rows=1 width=43) (actual time=83.667..114.636 rows=1 loops=3)

4. 0.005 114.626 ↑ 1.0 1 3 / 3

Nested Loop (cost=17.21..9,202.13 rows=1 width=40) (actual time=83.658..114.626 rows=1 loops=3)

5. 0.217 114.605 ↑ 2.0 1 3 / 3

Hash Join (cost=16.79..9,188.48 rows=2 width=32) (actual time=83.640..114.605 rows=1 loops=3)

  • Hash Cond: ("languageData"."languageId" = language.id)
6. 114.370 114.370 ↑ 300.0 1 3 / 3

Parallel Seq Scan on "languageData" (cost=0.00..9,170.89 rows=300 width=36) (actual time=83.407..114.370 rows=1 loops=3)

  • Filter: ((("tableName")::text = 'cities'::text) AND (lower((value)::text) ~~* 'balb%'::text))
  • Rows Removed by Filter: 107128
7. 0.003 0.018 ↑ 3.0 1 2 / 3

Hash (cost=16.75..16.75 rows=3 width=4) (actual time=0.027..0.027 rows=1 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.015 0.015 ↑ 3.0 1 2 / 3

Seq Scan on languages language (cost=0.00..16.75 rows=3 width=4) (actual time=0.022..0.023 rows=1 loops=2)

  • Filter: ((code)::text = 'en-US'::text)
  • Rows Removed by Filter: 1
9. 0.016 0.016 ↑ 1.0 1 3 / 3

Index Scan using "PK_4762ffb6e5d198cfec5606bc11e" on cities city (cost=0.42..6.83 rows=1 width=12) (actual time=0.016..0.016 rows=1 loops=3)

  • Index Cond: (id = "languageData"."fkId")
10. 0.008 0.008 ↑ 1.0 1 3 / 3

Index Scan using "PK_09ab30ca0975c02656483265f4f" on states state (cost=0.28..0.30 rows=1 width=7) (actual time=0.008..0.008 rows=1 loops=3)

  • Index Cond: (id = city."stateId")
11.          

SubPlan (for Gather)

12. 0.006 0.078 ↑ 1.0 1 3

Limit (cost=0.70..18.48 rows=1 width=28) (actual time=0.025..0.026 rows=1 loops=3)

13. 0.009 0.072 ↑ 1.0 1 3

Nested Loop (cost=0.70..18.48 rows=1 width=28) (actual time=0.024..0.024 rows=1 loops=3)

14. 0.039 0.039 ↑ 1.0 1 3

Index Only Scan using "PK_09ab30ca0975c02656483265f4f" on states "stateSub" (cost=0.28..8.30 rows=1 width=4) (actual time=0.013..0.013 rows=1 loops=3)

  • Index Cond: (id = city."stateId")
  • Heap Fetches: 3
15. 0.024 0.024 ↑ 1.0 1 3

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" sld (cost=0.42..10.17 rows=1 width=32) (actual time=0.008..0.008 rows=1 loops=3)

  • Index Cond: ("fkId" = city."stateId")
  • Filter: (("tableName")::text = 'states'::text)
Planning time : 1.098 ms
Execution time : 123.440 ms