explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PAe6 : Optimization for: plan #yEAp

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 0.034 ↑ 1.0 1 1

Limit (cost=0.87..1.90 rows=1 width=127) (actual time=0.034..0.034 rows=1 loops=1)

2. 0.009 0.032 ↑ 7,467,158.0 1 1

Nested Loop Left Join (cost=0.87..7,737,062.67 rows=7,467,158 width=127) (actual time=0.032..0.032 rows=1 loops=1)

3. 0.001 0.015 ↑ 7,467,158.0 1 1

Nested Loop (cost=0.43..3,958,701.74 rows=7,467,158 width=117) (actual time=0.015..0.015 rows=1 loops=1)

4. 0.004 0.004 ↑ 7,610,275.0 1 1

Seq Scan on de_files de (cost=0.00..286,333.24 rows=7,610,275 width=53) (actual time=0.004..0.004 rows=1 loops=1)

  • Filter: (((stored IS FALSE) OR (stored IS NULL)) AND (NOT active))
5. 0.010 0.010 ↑ 1.0 1 1

Index Scan using defilesonpt_index on pt_files f (cost=0.43..0.47 rows=1 width=72) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (de_filesid = de.de_filesid)
  • Filter: ((NOT moved) AND (error_text IS NULL))
6. 0.008 0.008 ↑ 1.0 1 1

Index Scan using property_pkey on property p (cost=0.43..0.48 rows=1 width=26) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (f.propertyid = propertyid)
Planning time : 0.679 ms
Execution time : 0.093 ms