explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IoYk

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

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

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

Gather (cost=1,017.490..10,239.590 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.490..9,202.430 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.210..9,202.130 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.790..9,188.480 rows=2 width=32) (actual time=83.640..114.605 rows=1 loops=3)

  • Hash Cond: ("golf_zulu_mike"."golf_echo" = four_echo.quebec)
6. 114.370 114.370 ↑ 300.0 1 3 / 3

Parallel Seq Scan on golf_zulu_mike (cost=0.000..9,170.890 rows=300 width=36) (actual time=83.407..114.370 rows=1 loops=3)

  • Filter: ((("delta_yankee")::text = 'yankee'::text) AND (golf_romeo((six_mike)::text) ~~* 'india'::text))
  • Rows Removed by Filter: 107128
7. 0.003 0.018 ↑ 3.0 1 2 / 3

Hash (cost=16.750..16.750 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 alpha four_echo (cost=0.000..16.750 rows=3 width=4) (actual time=0.022..0.023 rows=1 loops=2)

  • Filter: ((four_three)::text = 'kilo'::text)
  • Rows Removed by Filter: 1
9. 0.016 0.016 ↑ 1.0 1 3 / 3

Index Scan using golf_zulu_five on papa_whiskey foxtrot (cost=0.420..6.830 rows=1 width=12) (actual time=0.016..0.016 rows=1 loops=3)

  • Index Cond: (quebec = "golf_zulu_mike"."papa_oscar")
10. 0.008 0.008 ↑ 1.0 1 3 / 3

Index Scan using golf_sierra on six_zulu victor_juliet (cost=0.280..0.300 rows=1 width=7) (actual time=0.008..0.008 rows=1 loops=3)

  • Index Cond: (quebec = foxtrot."bravo")
11.          

SubPlan (for Gather)

12. 0.006 0.078 ↑ 1.0 1 3

Limit (cost=0.700..18.480 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.700..18.480 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 golf_sierra on six_zulu xray (cost=0.280..8.300 rows=1 width=4) (actual time=0.013..0.013 rows=1 loops=3)

  • Index Cond: (quebec = foxtrot."bravo")
  • Heap Fetches: 3
15. 0.024 0.024 ↑ 1.0 1 3

Index Scan using sierra on golf_zulu_mike november (cost=0.420..10.170 rows=1 width=32) (actual time=0.008..0.008 rows=1 loops=3)

  • Index Cond: ("papa_oscar" = foxtrot."bravo")
  • Filter: (("delta_yankee")::text = 'delta_tango'::text)
Planning time : 1.098 ms
Execution time : 123.440 ms