explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WKqN

Settings
# exclusive inclusive rows x rows loops node
1. 19,194.561 23,285.501 ↓ 1.0 254,380 1

Sort (cost=149,838.35..150,474.24 rows=254,356 width=463) (actual time=16,519.064..23,285.501 rows=254,380 loops=1)

  • Sort Key: "productDescription
  • Sort Method: external merge Disk: 121,888kB
  • Buffers: shared hit=14,451 read=2,028, temp read=23,237 written=23,237
  • I/O Timings: read=108.573
2. 4,090.940 4,090.940 ↓ 1.0 254,380 1

Seq Scan on export_data (cost=0.00..20,930.65 rows=254,356 width=463) (actual time=0.016..4,090.940 rows=254,380 loops=1)

  • Filter: ((("productDescription")::text ~~* '%'::text) AND ("shippingBillDate" >= '2019-08-01 00:00:00'::timestamp without time zone) AND ("shippingBillDate" <= '2019-08-31 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=14,451 read=2,028
  • I/O Timings: read=108.573
Planning time : 0.376 ms
Execution time : 24,196.046 ms