explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M4iQ : Optimization for: plan #CLUt

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Seq Scan on subscribers (cost=254,440.71..1,681,729.37 rows=2,636,209 width=972) (actual rows= loops=)

  • Filter: (((hashed SubPlan 1) AND (NOT (hashed SubPlan 2))) OR (hashed SubPlan 3) OR ((msisdn)::text = '56965817010'::text))
2.          

SubPlan (for Seq Scan)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.88..68,633.79 rows=9,804 width=13) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Only Scan using file_contents_pkey on file_contents fc (cost=0.44..2,661.99 rows=9,804 width=4) (actual rows= loops=)

  • Index Cond: (file_id = ANY (('{827,749}'::text[])::integer[]))
5. 0.000 0.000 ↓ 0.0

Index Scan using content_pkey on content c (cost=0.43..6.73 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (id = fc.content_id)
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.88..37,994.62 rows=4,902 width=13) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Only Scan using file_contents_pkey on file_contents fc_1 (cost=0.44..1,364.72 rows=4,902 width=4) (actual rows= loops=)

  • Index Cond: (file_id = ANY (('{750}'::text[])::integer[]))
8. 0.000 0.000 ↓ 0.0

Index Scan using content_pkey on content c_1 (cost=0.43..7.47 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (id = fc_1.content_id)
9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.88..147,702.00 rows=29,413 width=13) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Only Scan using file_contents_pkey on file_contents fc_2 (cost=0.44..7,354.15 rows=29,413 width=4) (actual rows= loops=)

  • Index Cond: (file_id = ANY (('{926,994,1292,1398,1551,1555}'::text[])::integer[]))
11. 0.000 0.000 ↓ 0.0

Index Scan using content_pkey on content c_2 (cost=0.43..4.77 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (id = fc_2.content_id)