explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a5dr

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.030 ↓ 0.0 0 1

Subquery Scan on g (cost=16.61..16.65 rows=1 width=386) (actual time=0.030..0.030 rows=0 loops=1)

  • Filter: ((g.row_num > 0) AND (g.row_num <= 0))
2. 0.004 0.029 ↓ 0.0 0 1

WindowAgg (cost=16.61..16.64 rows=1 width=386) (actual time=0.029..0.029 rows=0 loops=1)

3. 0.011 0.025 ↓ 0.0 0 1

Sort (cost=16.61..16.61 rows=1 width=314) (actual time=0.025..0.025 rows=0 loops=1)

  • Sort Key: dn.id DESC
  • Sort Method: quicksort Memory: 25kB
4. 0.002 0.014 ↓ 0.0 0 1

Nested Loop (cost=0.55..16.60 rows=1 width=314) (actual time=0.014..0.014 rows=0 loops=1)

5. 0.012 0.012 ↓ 0.0 0 1

Index Scan using idx_fuffa on t_xs_ftx_dn_item dn (cost=0.27..8.29 rows=1 width=122) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((insert_time >= '2020-10-13 11:37:41.443244'::timestamp without time zone) AND (insert_time <= '2020-10-23 11:37:41.443244'::timestamp without time zone))
6. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_t_xs_ftx_item on t_xs_ftx_item it (cost=0.27..8.30 rows=1 width=200) (never executed)

  • Index Cond: (id = dn.t_xs_ftx_item_id)
  • Filter: (upper((dom_local_ba)::text) ~~ '%BA%'::text)
Planning time : 3.507 ms
Execution time : 0.235 ms