explain.depesz.com

PostgreSQL's explain analyze made readable

Result: frGR

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.031 ↓ 0.0 0 1

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

  • Filter: ((g.row_num > 0) AND (g.row_num <= 0))
2. 0.003 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.026 ↓ 0.0 0 1

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

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

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

5. 0.013 0.013 ↓ 0.0 0 1

Index Scan using idx_t_xs_ftx_dn_item_insert_time_state on t_xs_ftx_dn_item dn (cost=0.27..8.29 rows=1 width=122) (actual time=0.013..0.013 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 : 2.264 ms
Execution time : 0.215 ms