explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U3yF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 208.174 ↓ 1.2 40 1

Limit (cost=72,659.07..72,662.81 rows=32 width=78) (actual time=208.137..208.174 rows=40 loops=1)

2. 0.000 221.539 ↓ 1.2 40 1

Gather Merge (cost=72,659.07..72,662.81 rows=32 width=78) (actual time=208.135..221.539 rows=40 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.207 615.663 ↑ 1.2 13 3

Sort (cost=71,659.05..71,659.09 rows=16 width=78) (actual time=205.218..205.221 rows=13 loops=3)

  • Sort Key: ts.tn_createtime DESC
  • Sort Method: quicksort Memory: 27kB
4. 0.363 615.456 ↑ 1.2 13 3

Hash Left Join (cost=8.32..71,658.73 rows=16 width=78) (actual time=19.046..205.152 rows=13 loops=3)

  • Hash Cond: (ts.tn_createop = m.orgstructid)
5. 614.988 614.988 ↑ 1.2 13 3

Parallel Seq Scan on tn_sfa_t_location ts (cost=0.00..71,650.15 rows=16 width=41) (actual time=18.921..204.996 rows=13 loops=3)

  • 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 (tn_createop = '1125224228375891968'::bigint) AND (platstatus = 1))
  • Rows Removed by Filter: 519987
6. 0.018 0.105 ↑ 1.0 1 3

Hash (cost=8.31..8.31 rows=1 width=25) (actual time=0.034..0.035 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.087 0.087 ↑ 1.0 1 3

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

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