explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3pr7

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 77.095 ↑ 1.3 3 1

Sort (cost=2,692.10..2,692.11 rows=4 width=57) (actual time=77.094..77.095 rows=3 loops=1)

  • Sort Key: city."usageCount" DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.016 77.086 ↑ 1.3 3 1

Nested Loop Left Join (cost=17.49..2,692.06 rows=4 width=57) (actual time=15.423..77.086 rows=3 loops=1)

3. 0.009 77.025 ↑ 1.3 3 1

Nested Loop (cost=17.21..2,623.86 rows=4 width=22) (actual time=15.395..77.025 rows=3 loops=1)

4. 0.020 76.992 ↑ 1.3 3 1

Hash Join (cost=16.79..2,595.65 rows=4 width=14) (actual time=15.378..76.992 rows=3 loops=1)

  • Hash Cond: ("languageData"."languageId" = language.id)
5. 76.962 76.962 ↑ 220.0 3 1

Seq Scan on "languageData" (cost=0.00..2,577.12 rows=660 width=18) (actual time=15.352..76.962 rows=3 loops=1)

  • Filter: ((("tableName")::text = 'cities'::text) AND (lower((value)::text) ~~* 'balb%'::text))
  • Rows Removed by Filter: 89360
6. 0.003 0.010 ↑ 3.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.007 0.007 ↑ 3.0 1 1

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

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

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

  • Index Cond: (id = "languageData"."fkId")
9. 0.012 0.012 ↑ 1.0 1 3

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

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

SubPlan (for Nested Loop Left Join)

11. 0.006 0.033 ↑ 1.0 1 3

Limit (cost=0.70..16.75 rows=1 width=10) (actual time=0.010..0.011 rows=1 loops=3)

12. 0.006 0.027 ↑ 1.0 1 3

Nested Loop (cost=0.70..16.75 rows=1 width=10) (actual time=0.009..0.009 rows=1 loops=3)

13. 0.006 0.006 ↑ 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.002..0.002 rows=1 loops=3)

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

Index Scan using "IDX_LANGUAGEDATA_FKID" on "languageData" sld (cost=0.42..8.44 rows=1 width=14) (actual time=0.005..0.005 rows=1 loops=3)

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