explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cPBw

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 1.191 ↓ 1.1 40 1

Limit (cost=1,457.00..1,457.09 rows=38 width=78) (actual time=1.179..1.191 rows=40 loops=1)

2. 0.032 1.182 ↓ 1.1 40 1

Sort (cost=1,457.00..1,457.09 rows=38 width=78) (actual time=1.178..1.182 rows=40 loops=1)

  • Sort Key: ts.tn_createtime DESC
  • Sort Method: quicksort Memory: 30kB
3. 0.037 1.150 ↓ 1.1 40 1

Nested Loop Left Join (cost=11.58..1,456.00 rows=38 width=78) (actual time=0.221..1.150 rows=40 loops=1)

  • Join Filter: (ts.tn_createop = m.orgstructid)
4. 1.044 1.113 ↓ 1.1 40 1

Bitmap Heap Scan on tn_sfa_t_location ts (cost=11.29..1,447.03 rows=38 width=41) (actual time=0.206..1.113 rows=40 loops=1)

  • Recheck Cond: (tn_createop = '1125224228375891968'::bigint)
  • Filter: ((tn_createtime <= '2019-05-10 23:59:59'::timestamp without time zone) AND (tn_createtime >= '2019-05-03 00:00:00'::timestamp without time zone) AND (platstatus = 1))
  • Rows Removed by Filter: 350
  • Heap Blocks: exact=390
5. 0.069 0.069 ↓ 1.0 390 1

Bitmap Index Scan on tn_sfa_t_location_tn_createop (cost=0.00..11.29 rows=381 width=0) (actual time=0.069..0.069 rows=390 loops=1)

  • Index Cond: (tn_createop = '1125224228375891968'::bigint)
6. 0.000 0.000 ↑ 1.0 1 40

Materialize (cost=0.29..8.31 rows=1 width=25) (actual time=0.000..0.000 rows=1 loops=40)

7. 0.011 0.011 ↑ 1.0 1 1

Index Scan using pl_orgstruct_orgstructid on pl_orgstruct m (cost=0.29..8.31 rows=1 width=25) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (orgstructid = '1125224228375891968'::bigint)
  • Filter: (platstatus = 1)
Planning time : 0.254 ms
Execution time : 1.241 ms