explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SaUH

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.518 ↑ 1.0 25 1

Limit (cost=0.57..43.64 rows=25 width=1,080) (actual time=0.070..0.518 rows=25 loops=1)

2. 0.035 0.511 ↑ 25,493.8 25 1

Nested Loop Left Join (cost=0.57..1,098,076.31 rows=637,345 width=1,080) (actual time=0.070..0.511 rows=25 loops=1)

3. 0.007 0.451 ↑ 25,493.8 25 1

Nested Loop (cost=0.29..900,136.26 rows=637,345 width=765) (actual time=0.059..0.451 rows=25 loops=1)

4. 0.066 0.066 ↑ 38,560.9 63 1

Seq Scan on user_result_view userconten0_ (cost=0.00..103,010.76 rows=2,429,338 width=190) (actual time=0.041..0.066 rows=63 loops=1)

  • Filter: ((type = ANY ('{81,84}'::integer[])) OR (type <> ALL ('{81,84,27}'::integer[])) OR (type = 27))
5. 0.378 0.378 ↓ 0.0 0 63

Index Scan using sec_user_pk on sec_user_t user1_ (cost=0.29..0.32 rows=1 width=575) (actual time=0.006..0.006 rows=0 loops=63)

  • Index Cond: (user_id = userconten0_.user_id)
  • Filter: ((row_status = 1) AND (long_absence = '0'::numeric))
  • Rows Removed by Filter: 1
6. 0.025 0.025 ↑ 1.0 1 25

Index Scan using pk_cnt_content_t on cnt_content_t lightconte2_ (cost=0.28..0.30 rows=1 width=315) (actual time=0.001..0.001 rows=1 loops=25)

  • Index Cond: (userconten0_.content_id = content_id)