explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KNPT

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 38.320 ↓ 0.0 0 1

Limit (cost=18,711.61..18,711.61 rows=1 width=16) (actual time=38.320..38.320 rows=0 loops=1)

2.          

Initplan (forLimit)

3. 4.135 39.133 ↑ 1.0 1 1

Gather (cost=1,000.00..18,605.05 rows=1 width=8) (actual time=0.378..39.133 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 34.998 34.998 ↓ 0.0 0 3

Parallel Seq Scan on tag_id_container_no_map (cost=0.00..17,604.95 rows=1 width=8) (actual time=22.524..34.998 rows=0 loops=3)

  • Filter: (((tag_id)::text = 'TAGID0000005'::text) AND ((tag_status)::text = 'ACTIVE'::text))
  • Rows Removed by Filter: 333170
5. 0.036 38.316 ↓ 0.0 0 1

Sort (cost=106.56..106.73 rows=69 width=16) (actual time=38.316..38.316 rows=0 loops=1)

  • Sort Key: rfid_txn_details.txn_date DESC
  • Sort Method: quicksort Memory: 25kB
6. 38.280 38.280 ↓ 0.0 0 1

Seq Scan on rfid_txn_details (cost=0.00..106.22 rows=69 width=16) (actual time=38.280..38.280 rows=0 loops=1)

  • Filter: ((created_date >= $0) AND ((tag_id)::text = 'TAGID0000005'::text) AND (location_master_sl_no = 223))
  • Rows Removed by Filter: 3136