explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hcKZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.166 0.387 ↑ 6.7 12 1

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

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

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

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

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

4. 0.019 0.063 ↑ 6.7 12 1

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

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

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

Planning time : 0.608 ms