explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r2Bu

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=335.40..335.41 rows=1 width=0) (actual rows= loops=)

2.          

Initplan (for Limit)

3. 0.000 0.000 ↓ 0.0

Limit (cost=0.56..167.70 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using pk_dadotransp on tb_dado_transp (cost=0.56..41,648,477.67 rows=249,188 width=8) (actual rows= loops=)

  • Index Cond: (co_seq_dado_transp IS NOT NULL)
  • Filter: (co_unico_ficha IS NULL)
5. 0.000 0.000 ↓ 0.0

Limit (cost=0.56..167.70 rows=1 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan Backward using pk_dadotransp on tb_dado_transp tb_dado_transp_1 (cost=0.56..41,648,477.67 rows=249,188 width=8) (actual rows= loops=)

  • Index Cond: (co_seq_dado_transp IS NOT NULL)
7. 0.000 0.000 ↓ 0.0

Filter: (co_unico_ficha IS NULL)" -> Result (cost=0.00..0.01 rows=1 width=0) (actual rows= loops=)