explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Smno

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 588.418 ↓ 0.0 0 1

Nested Loop (cost=1.57..2,004.91 rows=209 width=644) (actual time=588.418..588.418 rows=0 loops=1)

2. 0.000 588.417 ↓ 0.0 0 1

Nested Loop (cost=1.29..1,939.41 rows=209 width=636) (actual time=588.417..588.417 rows=0 loops=1)

3. 0.000 588.417 ↓ 0.0 0 1

Nested Loop (cost=0.86..1,842.05 rows=209 width=628) (actual time=588.417..588.417 rows=0 loops=1)

4. 588.417 588.417 ↓ 0.0 0 1

Index Scan using fcafrfv_index_only_active_on_version_id on fr_cache_all_filter_revisions_for_version cfr_cache (cost=0.43..78.95 rows=209 width=8) (actual time=588.417..588.417 rows=0 loops=1)

  • Index Cond: (cached_version_id = (NULLIF(current_setting('dagp.user.currentversion'::text), ''::text))::bigint)
5. 0.000 0.000 ↓ 0.0 0

Index Scan using filter_revision_pkey on filter_revisions fr (cost=0.43..8.43 rows=1 width=628) (never executed)

  • Index Cond: (filter_revision_id = cfr_cache.filter_revision_id)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using filters_pkey on filters f (cost=0.42..0.46 rows=1 width=16) (never executed)

  • Index Cond: (filter_id = fr.filter_id)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using versions_pkey on versions v (cost=0.29..0.30 rows=1 width=16) (never executed)

  • Index Cond: (version_id = fr.filter_version_id)
Planning time : 17.037 ms
Execution time : 588.552 ms