explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nDAo

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.248 ↓ 1.1 40 1

Limit (cost=0.71..166.26 rows=38 width=78) (actual time=0.091..0.248 rows=40 loops=1)

2. 0.018 0.238 ↓ 1.1 40 1

Nested Loop Left Join (cost=0.71..166.26 rows=38 width=78) (actual time=0.090..0.238 rows=40 loops=1)

  • Join Filter: (ts.tn_createop = m.orgstructid)
3. 0.180 0.180 ↓ 1.1 40 1

Index Scan Backward using tn_sfa_t_location_tn_createtime on tn_sfa_t_location ts (cost=0.43..157.28 rows=38 width=41) (actual time=0.069..0.180 rows=40 loops=1)

  • Index Cond: ((tn_createop = '1125224228375891968'::bigint) AND (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))
4. 0.023 0.040 ↑ 1.0 1 40

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

5. 0.017 0.017 ↑ 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.016..0.017 rows=1 loops=1)

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