explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vpq6

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 0.032 ↓ 0.0 0 1

Sort (cost=11.00..11.00 rows=1 width=58) (actual time=0.032..0.032 rows=0 loops=1)

  • Sort Key: jpacommand0_.next_try
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=4
2. 0.001 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.41..10.99 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=1)

  • Buffers: shared hit=1
3. 0.002 0.002 ↓ 0.0 0 1

Index Scan using i_command_status_failed on command jpacommand1_ (cost=0.12..3.66 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Buffers: shared hit=1
4. 0.000 0.000 ↓ 0.0 0

Index Scan using command_retry_pkey on command_retry jpacommand0_ (cost=0.29..7.33 rows=1 width=58) (never executed)

  • Index Cond: (command_id = jpacommand1_.command_id)
  • Filter: ((next_try IS NOT NULL) AND (next_try < '15-SEP-20 10:31:33.9871'::timestamp without time zone))
Planning time : 0.699 ms
Execution time : 0.080 ms