explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5w4R

Settings
# exclusive inclusive rows x rows loops node
1. 0.117 0.524 ↑ 6.7 12 1

Sort (cost=31.99..32.19 rows=80 width=1,112) (actual time=0.523..0.524 rows=12 loops=1)

  • Sort Key: (to_char(td."dteReportedOn", 'dd/MM/yyyy HH24:MI:SS'::text))
  • Sort Method: quicksort Memory: 27kB
2. 0.375 0.407 ↑ 6.7 12 1

Hash Right Join (cost=12.00..29.46 rows=80 width=1,112) (actual time=0.319..0.407 rows=12 loops=1)

  • Hash Cond: (((sl."strWayBillNo")::text = (td."strWayBillNo")::text) AND ((sl."strDeviceNo")::text = (td."strDeviceNo")::text))
3. 0.008 0.008 ↑ 150.0 2 1

Seq Scan on "TempWayBills" sl (cost=0.00..13.00 rows=300 width=244) (actual time=0.006..0.008 rows=2 loops=1)

4. 0.012 0.024 ↑ 6.7 12 1

Hash (cost=10.80..10.80 rows=80 width=918) (actual time=0.024..0.024 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
5. 0.012 0.012 ↑ 6.7 12 1

Seq Scan on "Temp_FaultData" td (cost=0.00..10.80 rows=80 width=918) (actual time=0.010..0.012 rows=12 loops=1)

Planning time : 0.347 ms