explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bJCH

Settings
# exclusive inclusive rows x rows loops node
1. 0.102 0.192 ↑ 6.7 12 1

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

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

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

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

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

4. 0.009 0.017 ↑ 6.7 12 1

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

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

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

Planning time : 0.301 ms