explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sUoc

Settings
# exclusive inclusive rows x rows loops node
1. 3.200 3.493 ↑ 8.0 1 1

Sort (cost=43.74..43.76 rows=8 width=550) (actual time=3.492..3.493 rows=1 loops=1)

  • Sort Key: documento.docu_folio
  • Sort Method: quicksort Memory: 25kB
2. 0.129 0.293 ↑ 8.0 1 1

Append (cost=0.00..43.62 rows=8 width=550) (actual time=0.275..0.293 rows=1 loops=1)

  • -> Index Scan using idx_documento_78259420_2015_envi_id on documento_78259420_2015 (cost=0.15..8.17 rows=1 width=424) (actual time=0.037..0.037 rows=0 loops=
  • -> Index Scan using idx_documento_78259420_2016_envi_id on documento_78259420_2016 (cost=0.15..8.17 rows=1 width=547) (actual time=0.014..0.014 rows=0 loops=
  • -> Index Scan using idx_documento_78259420_2017_envi_id on documento_78259420_2017 (cost=0.15..8.17 rows=1 width=516) (actual time=0.031..0.031 rows=0 loops=
  • -> Index Scan using idx_documento_78259420_2018_envi_id on documento_78259420_2018 (cost=0.15..8.17 rows=1 width=489) (actual time=0.035..0.036 rows=1 loops=
3. 0.030 0.030 ↓ 0.0 0 1

Seq Scan on documento (cost=0.00..1.07 rows=1 width=636) (actual time=0.030..0.030 rows=0 loops=1)

  • Filter: ((empr_id_emisor = 78259420) AND (envi_id = 45130653))
  • Rows Removed by Filter: 5
4. 0.051 0.051 ↓ 0.0 0 1

Seq Scan on documento_78259420_2013 (cost=0.00..1.01 rows=1 width=742) (actual time=0.051..0.051 rows=0 loops=1)

  • Filter: ((empr_id_emisor = 78259420) AND (envi_id = 45130653))
  • Rows Removed by Filter: 1
5. 0.066 0.066 ↓ 0.0 0 1

Seq Scan on documento_78259420_2014 (cost=0.00..7.84 rows=1 width=445) (actual time=0.066..0.066 rows=0 loops=1)

  • Filter: ((empr_id_emisor = 78259420) AND (envi_id = 45130653))
  • Rows Removed by Filter: 123
  • Index Cond: (envi_id = 45130653)
  • Filter: (empr_id_emisor = 78259420)
  • Index Cond: (envi_id = 45130653)
  • Filter: (empr_id_emisor = 78259420)
  • Index Cond: (envi_id = 45130653)
  • Filter: (empr_id_emisor = 78259420)
  • Index Cond: (envi_id = 45130653)
  • Filter: (empr_id_emisor = 78259420)
6. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on documento_78259420_2019 (cost=0.00..1.01 rows=1 width=604) (actual time=0.017..0.017 rows=0 loops=1)

  • Filter: ((empr_id_emisor = 78259420) AND (envi_id = 45130653))
  • Rows Removed by Filter: 1