explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pe9x

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 0.065 ↑ 1.0 43 1

Sort (cost=7.22..7.33 rows=43 width=2,113) (actual time=0.061..0.065 rows=43 loops=1)

  • Sort Key: (CASE WHEN (id = 1) THEN 0 WHEN (id = 44) THEN 1 WHEN (id = 6) THEN 2 WHEN (id = 33) THEN 3 WHEN (id = 31) THEN 4 WHEN (id = 23) THEN 5 WHEN (id = 32) THEN 6 WHEN (id = 30) THEN 7 WHEN (id = 41) THEN 8 WHEN (id = 39) THEN 9 WHEN (id = 35) THEN 10 WHEN (id = 37) THEN 11 WHEN (id = 36) THEN 12 WHEN (id = 40) THEN 13 WHEN (id = 38) THEN 14 WHEN (id = 3) THEN 15 WHEN (id = 43) THEN 16 WHEN (id = 5) THEN 17 WHEN (id = 28) THEN 18 WHEN (id = 25) THEN 19 WHEN (id = 22) THEN 20 WHEN (id = 34) THEN 21 WHEN (id = 29) THEN 22 WHEN (id = 24) THEN 23 WHEN (id = 27) THEN 24 WHEN (id = 26) THEN 25 WHEN (id = 2) THEN 26 WHEN (id = 8) THEN 27 WHEN (id = 14) THEN 28 WHEN (id = 18) THEN 29 WHEN (id = 10) THEN 30 WHEN (id = 17) THEN 31 WHEN (id = 9) THEN 32 WHEN (id = 16) THEN 33 WHEN (id = 7) THEN 34 WHEN (id = 21) THEN 35 WHEN (id = 15) THEN 36 WHEN (id = 13) THEN 37 WHEN (id = 11) THEN 38 WHEN (id = 12) THEN 39 WHEN (id = 4) THEN 40 WHEN (id = 20) THEN 41 WHEN (id = 19) THEN 42 ELSE NULL::integer END)
  • Sort Method: quicksort Memory: 30kB
  • Planning time: 0.166 ms
  • Execution time: 0.155 ms
2. 0.028 0.028 ↑ 1.0 43 1

Seq Scan on catalogue_category (cost=0.00..6.05 rows=43 width=2,113) (actual time=0.010..0.028 rows=43 loops=1)