explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R3EV

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 5,438.882 ↑ 1.0 20 1

Limit (cost=1,606,380.96..1,606,381.01 rows=20 width=12) (actual time=5,438.877..5,438.882 rows=20 loops=1)

2. 1.340 5,438.877 ↑ 30.1 20 1

Sort (cost=1,606,380.96..1,606,382.46 rows=602 width=12) (actual time=5,438.876..5,438.877 rows=20 loops=1)

  • Sort Key: publishdate DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 5,437.537 5,437.537 ↓ 2.0 1,195 1

Index Only Scan using ix_v_orders_all on v_orders dnoc (cost=0.69..1,606,364.94 rows=602 width=12) (actual time=64.637..5,437.537 rows=1,195 loops=1)

  • Index Cond: (customerid = '{67017}'::integer[])
  • Heap Fetches: 1,195
Planning time : 0.132 ms
Execution time : 5,438.909 ms