explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UinU

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 239.579 ↓ 0.0 0 1

Limit (cost=206,744.11..206,744.12 rows=1 width=84) (actual time=239.579..239.579 rows=0 loops=1)

2. 0.004 239.577 ↓ 0.0 0 1

Sort (cost=206,744.11..206,745.15 rows=416 width=84) (actual time=239.577..239.577 rows=0 loops=1)

  • Sort Key: sp_tracks.popularity DESC
  • Sort Method: quicksort Memory: 25kB
3. 3.283 239.573 ↓ 0.0 0 1

Gather (cost=1,000.88..206,742.03 rows=416 width=84) (actual time=239.573..239.573 rows=0 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
4. 0.001 236.290 ↓ 0.0 0 6 / 6

Nested Loop (cost=0.88..205,700.43 rows=83 width=84) (actual time=236.290..236.290 rows=0 loops=6)

5. 0.002 236.289 ↓ 0.0 0 6 / 6

Nested Loop (cost=0.44..196,883.97 rows=16,646 width=4) (actual time=236.289..236.289 rows=0 loops=6)

6. 236.287 236.287 ↓ 0.0 0 6 / 6

Parallel Seq Scan on sp_accounts (cost=0.00..145,583.32 rows=3,374 width=4) (actual time=236.287..236.287 rows=0 loops=6)

  • Filter: (lower((name)::text) = 'Mr. Credo'::text)
  • Rows Removed by Filter: 346006
7. 0.000 0.000 ↓ 0.0 0 / 6

Index Scan using index_sp_account_tracks_on_sp_account_id on sp_account_tracks (cost=0.44..14.62 rows=58 width=8) (never executed)

  • Index Cond: (sp_account_id = sp_accounts.id)
  • Filter: ("primary" AND (NOT inactive))
8. 0.000 0.000 ↓ 0.0 0 / 6

Index Scan using sp_tracks_pkey on sp_tracks (cost=0.44..0.52 rows=1 width=84) (never executed)

  • Index Cond: (id = sp_account_tracks.sp_track_id)
  • Filter: (lower((name)::text) = 'Медляк'::text)
Planning time : 0.528 ms
Execution time : 242.723 ms