explain.depesz.com

PostgreSQL's explain analyze made readable

Result: piDa

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.474 ↑ 1.0 1 1

Nested Loop Left Join (cost=8.89..26.69 rows=1 width=286) (actual time=0.469..0.474 rows=1 loops=1)

  • Output: this_.perid, this_.perapeadop1, this_.perapeadop2, this_.perautogenerado, this_.cciudalpha1, this_.conperid, this_.cetniaid, this_.fchbaja, this_.fchdesde, this_.fchhasta, this_.cgenid, this_.cpaisid, this_.perpriapellido, this_.perprinombre, thi (...)
  • Join Filter: (this_.csexoid = codsexo7_.csexoid)
  • Rows Removed by Join Filter: 4
  • Buffers: shared hit=6 read=11
2. 0.002 0.469 ↑ 1.0 1 1

Nested Loop Left Join (cost=8.89..25.57 rows=1 width=263) (actual time=0.465..0.469 rows=1 loops=1)

  • Output: this_.perid, this_.perapeadop1, this_.perapeadop2, this_.perautogenerado, this_.cciudalpha1, this_.conperid, this_.cetniaid, this_.fchbaja, this_.fchdesde, this_.fchhasta, this_.cgenid, this_.cpaisid, this_.perpriapellido, this_.perprinombr (...)
  • Join Filter: (this_.cgenid = codgenero5_.cgenid)
  • Rows Removed by Join Filter: 4
  • Buffers: shared hit=5 read=11
3. 0.002 0.466 ↑ 1.0 1 1

Nested Loop Left Join (cost=8.89..24.48 rows=1 width=243) (actual time=0.462..0.466 rows=1 loops=1)

  • Output: this_.perid, this_.perapeadop1, this_.perapeadop2, this_.perautogenerado, this_.cciudalpha1, this_.conperid, this_.cetniaid, this_.fchbaja, this_.fchdesde, this_.fchhasta, this_.cgenid, this_.cpaisid, this_.perpriapellido, this_.perpr (...)
  • Join Filter: (this_.cetniaid = codetnia4_.cetniaid)
  • Rows Removed by Join Filter: 6
  • Buffers: shared hit=4 read=11
4. 0.002 0.461 ↑ 1.0 1 1

Nested Loop (cost=8.89..23.35 rows=1 width=224) (actual time=0.457..0.461 rows=1 loops=1)

  • Output: this_.perid, this_.perapeadop1, this_.perapeadop2, this_.perautogenerado, this_.cciudalpha1, this_.conperid, this_.cetniaid, this_.fchbaja, this_.fchdesde, this_.fchhasta, this_.cgenid, this_.cpaisid, this_.perpriapellido, this_ (...)
  • Buffers: shared hit=3 read=11
5. 0.003 0.369 ↑ 1.0 1 1

Nested Loop Left Join (cost=8.46..14.89 rows=1 width=174) (actual time=0.366..0.369 rows=1 loops=1)

  • Output: this_.perid, this_.perapeadop1, this_.perapeadop2, this_.perautogenerado, this_.cciudalpha1, this_.conperid, this_.cetniaid, this_.fchbaja, this_.fchdesde, this_.fchhasta, this_.cgenid, this_.cpaisid, this_.perpriapellido, (...)
  • Join Filter: (this_.cciudalpha1 = codciudada2_.cciudalpha1)
  • Rows Removed by Join Filter: 4
  • Buffers: shared hit=3 read=7
6. 0.071 0.350 ↑ 1.0 1 1

Hash Right Join (cost=8.46..13.80 rows=1 width=122) (actual time=0.347..0.350 rows=1 loops=1)

  • Output: this_.perid, this_.perapeadop1, this_.perapeadop2, this_.perautogenerado, this_.cciudalpha1, this_.conperid, this_.cetniaid, this_.fchbaja, this_.fchdesde, this_.fchhasta, this_.cgenid, this_.cpaisid, this_.perpriape (...)
  • Hash Cond: (codpais6_.cpaisid = this_.cpaisid)
  • Buffers: shared hit=3 read=6
7. 0.184 0.184 ↑ 1.0 242 1

Seq Scan on "PersonasDireccionesSchema".codpais codpais6_ (cost=0.00..4.42 rows=242 width=29) (actual time=0.146..0.184 rows=242 loops=1)

  • Output: codpais6_.cpaisid, codpais6_.cpaisalpha2, codpais6_.cpaisalpha3, codpais6_.cpaisnombre, codpais6_.fchbaja
  • Buffers: shared read=2
8. 0.007 0.095 ↑ 1.0 1 1

Hash (cost=8.45..8.45 rows=1 width=93) (actual time=0.095..0.095 rows=1 loops=1)

  • Output: this_.perid, this_.perapeadop1, this_.perapeadop2, this_.perautogenerado, this_.cciudalpha1, this_.conperid, this_.cetniaid, this_.fchbaja, this_.fchdesde, this_.fchhasta, this_.cgenid, this_.cpaisid, this_.per (...)
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared read=4
9. 0.088 0.088 ↑ 1.0 1 1

Index Scan using idx_persona on "PersonasDireccionesSchema".persona this_ (cost=0.43..8.45 rows=1 width=93) (actual time=0.088..0.088 rows=1 loops=1)

  • Output: this_.perid, this_.perapeadop1, this_.perapeadop2, this_.perautogenerado, this_.cciudalpha1, this_.conperid, this_.cetniaid, this_.fchbaja, this_.fchdesde, this_.fchhasta, this_.cgenid, this_.cpaisid, thi (...)
  • Index Cond: (this_.conperid = 1,789,097)
  • Filter: ((this_.fchbaja IS NULL) AND (this_.fchdesde <= '2020-07-05'::date) AND ((this_.fchhasta > '2020-07-05'::date) OR (this_.fchhasta IS NULL)))
  • Buffers: shared read=4
10. 0.016 0.016 ↑ 1.0 4 1

Seq Scan on "PersonasDireccionesSchema".codciudadania codciudada2_ (cost=0.00..1.04 rows=4 width=52) (actual time=0.016..0.016 rows=4 loops=1)

  • Output: codciudada2_.cciudalpha1, codciudada2_.cciudvalor, codciudada2_.cciuddesc, codciudada2_.fchbaja
  • Buffers: shared read=1
11. 0.090 0.090 ↑ 1.0 1 1

Index Scan using idx_convertorpersona on "PersonasDireccionesSchema".convertorpersona convertorp3_ (cost=0.43..8.45 rows=1 width=50) (actual time=0.089..0.090 rows=1 loops=1)

  • Output: convertorp3_.conperid, convertorp3_.conperfchnac, convertorp3_.conperfchfall, convertorp3_.fchultact, convertorp3_.fchbaja, convertorp3_.trxid, convertorp3_.conperfall
  • Index Cond: (convertorp3_.conperid = 1,789,097)
  • Buffers: shared read=4
12. 0.003 0.003 ↑ 1.0 6 1

Seq Scan on "PersonasDireccionesSchema".codetnia codetnia4_ (cost=0.00..1.06 rows=6 width=19) (actual time=0.002..0.003 rows=6 loops=1)

  • Output: codetnia4_.cetniaid, codetnia4_.cetniavalor, codetnia4_.fchbaja
  • Buffers: shared hit=1
13. 0.001 0.001 ↑ 1.0 4 1

Seq Scan on "PersonasDireccionesSchema".codgenero codgenero5_ (cost=0.00..1.04 rows=4 width=20) (actual time=0.001..0.001 rows=4 loops=1)

  • Output: codgenero5_.cgenid, codgenero5_.cgenvalor, codgenero5_.fchbaja
  • Buffers: shared hit=1
14. 0.002 0.002 ↑ 1.0 5 1

Seq Scan on "PersonasDireccionesSchema".codsexo codsexo7_ (cost=0.00..1.05 rows=5 width=23) (actual time=0.001..0.002 rows=5 loops=1)

  • Output: codsexo7_.csexoid, codsexo7_.csexovalor, codsexo7_.fchbaja
  • Buffers: shared hit=1
Planning time : 315.058 ms
Execution time : 11.944 ms