explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yEAp

Settings

Optimization(s) for this plan:

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

Limit (cost=0.87..1.90 rows=1 width=126) (actual time=26.505..26.505 rows=1 loops=1)

2. 0.020 26.503 ↑ 7,464,710.0 1 1

Nested Loop Left Join (cost=0.87..7,735,893.74 rows=7,464,710 width=126) (actual time=26.503..26.503 rows=1 loops=1)

3. 0.002 0.013 ↑ 7,464,710.0 1 1

Nested Loop (cost=0.43..3,958,701.74 rows=7,464,710 width=116) (actual time=0.013..0.013 rows=1 loops=1)

4. 0.003 0.003 ↑ 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.003..0.003 rows=1 loops=1)

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

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

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

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

  • Index Cond: (f.propertyid = propertyid)
Planning time : 17.228 ms
Execution time : 26.577 ms