explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gw69

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.054 ↓ 0.0 0 1

Subquery Scan on g (cost=15.78..15.82 rows=1 width=386) (actual time=0.054..0.054 rows=0 loops=1)

  • Filter: ((g.row_num > 0) AND (g.row_num <= 1))
  • 'SUCCESS'::text WHEN (((state)::text = 'DN_DONE'::text) AND (error_code IS NOT NULL)) THEN 'ERROR'::text ELSE
  • 'PROGRESS'::text END = 'DONE'::text (...)
2. 0.005 0.051 ↓ 0.0 0 1

WindowAgg (cost=15.78..15.81 rows=1 width=386) (actual time=0.051..0.051 rows=0 loops=1)

3. 0.022 0.046 ↓ 0.0 0 1

Sort (cost=15.78..15.78 rows=1 width=314) (actual time=0.046..0.046 rows=0 loops=1)

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

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

5. 0.020 0.020 ↓ 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..7.47 rows=1 width=122) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: (insert_time >= '2020-10-13 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.29 rows=1 width=200) (never executed)

  • Index Cond: (id = dn.t_xs_ftx_item_id)
Planning time : 1.550 ms
Execution time : 2.068 ms