explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YeYf

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 711.558 ↑ 1.0 38 1

Limit (cost=0.84..1,200.46 rows=38 width=589) (actual time=691.655..711.558 rows=38 loops=1)

  • Buffers: shared hit=91,873 read=2
2. 60.365 711.550 ↑ 32,771.5 38 1

Nested Loop Left Join (cost=0.84..39,313,035.62 rows=1,245,317 width=589) (actual time=691.654..711.550 rows=38 loops=1)

  • Buffers: shared hit=91,873 read=2
3. 0.019 10.738 ↑ 32,771.5 38 1

Nested Loop (cost=0.43..1,002,875.99 rows=1,245,317 width=499) (actual time=0.151..10.738 rows=38 loops=1)

  • Buffers: shared hit=160 read=1
4. 0.117 0.117 ↑ 32,771.5 38 1

Seq Scan on _document369 t439 (cost=0.00..323,096.46 rows=1,245,317 width=423) (actual time=0.046..0.117 rows=38 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=9
5. 10.602 10.602 ↑ 1.0 1 38

Index Scan using _inforg18872_bydims_r on _inforg18872 t440 (cost=0.43..0.54 rows=1 width=93) (actual time=0.279..0.279 rows=1 loops=38)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld18873rref = t439._idrref))
  • Buffers: shared hit=151 read=1
6. 9.310 9.310 ↓ 0.0 0 38

Index Scan using _inforg20333_bydims_r on _inforg20333 t441 (cost=0.42..0.44 rows=1 width=42) (actual time=0.245..0.245 rows=0 loops=38)

  • Index Cond: ((_fld717 = '0'::numeric) AND (t439._idrref = _fld20334rref))
  • Buffers: shared hit=113 read=1
7.          

SubPlan (for Nested Loop Left Join)

8. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg18529_bydims20274_rrss on _inforg18529 t442 (cost=0.55..7.58 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld18532rref = '\\277\\252;\\356tw;,@\\0059!G\\257\\225{'::bytea) AND (_fld18531_type = '\\010'::bytea) AND (_fld18531_rtref = '\\000\\000\\001q'::bytea) AND (_fld18531_rrref = t439._idrref))
  • Filter: ((_fld19313rref = '\\310\\2070Z:wN\\241\\021\\350e\\006\\034;\\347z'::bytea) AND (_fld18535rref = '\\207\\250\\034O8\\316\\032\\303J""q3\\311Bv:'::bytea))
9. 302.787 302.787 ↓ 0.0 0 1

Seq Scan on _inforg18529 t442_1 (cost=0.00..42,471.03 rows=1 width=17) (actual time=302.787..302.787 rows=0 loops=1)

  • Filter: ((_fld717 = '0'::numeric) AND (_fld18532rref = '\\277\\252;\\356tw;,@\\0059!G\\257\\225{'::bytea) AND (_fld19313rref = '\\310\\2070Z:wN\\241\\021\\350e\\006\\034;\\347z'::bytea) AND (_fld18535rref = '\\207\\250\\034O8\\316\\032\\303 (...)
  • Rows Removed by Filter: 523,161
  • Buffers: shared hit=29,392
10. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg18529_bydims20274_rrss on _inforg18529 t443 (cost=0.55..7.58 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld18532rref = '\\277\\252;\\356tw;,@\\0059!G\\257\\225{'::bytea) AND (_fld18531_type = '\\010'::bytea) AND (_fld18531_rtref = '\\000\\000\\001q'::bytea) AND (_fld18531_rrref = t439._idrref))
  • Filter: (_fld19313rref = '\\310\\2070Z:wN\\241\\021\\350e\\006\\034;\\347z'::bytea)
11. 234.512 234.512 ↓ 1.2 140,839 1

Seq Scan on _inforg18529 t443_1 (cost=0.00..41,163.12 rows=119,228 width=17) (actual time=5.796..234.512 rows=140,839 loops=1)

  • Filter: ((_fld717 = '0'::numeric) AND (_fld18532rref = '\\277\\252;\\356tw;,@\\0059!G\\257\\225{'::bytea) AND (_fld19313rref = '\\310\\2070Z:wN\\241\\021\\350e\\006\\034;\\347z'::bytea) AND (_fld18531_type = '\\010'::bytea) AND (_fld18531_r (...)
  • Rows Removed by Filter: 382,322
  • Buffers: shared hit=29,392
12. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg18529_bydims20274_rrss on _inforg18529 t444 (cost=0.55..7.58 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld18532rref = '\\230\\320\\3608\\313\\264\\241\\330FP>]\\026\\343aA'::bytea) AND (_fld18531_type = '\\010'::bytea) AND (_fld18531_rtref = '\\000\\000\\001q'::bytea) AND (_fld18531_rrref = t439._i (...)
  • Filter: (_fld18535rref = '\\276\\203\\321x\\271\\330H\\217I\\255\\035EX\\240T\\233'::bytea)
13. 33.124 50.381 ↓ 6.2 449 1

Bitmap Heap Scan on _inforg18529 t444_1 (cost=4,679.06..35,880.80 rows=72 width=17) (actual time=19.289..50.381 rows=449 loops=1)

  • Recheck Cond: ((_fld717 = '0'::numeric) AND (_fld18532rref = '\\230\\320\\3608\\313\\264\\241\\330FP>]\\026\\343aA'::bytea) AND (_fld18531_type = '\\010'::bytea) AND (_fld18531_rtref = '\\000\\000\\001q'::bytea))
  • Filter: (_fld18535rref = '\\276\\203\\321x\\271\\330H\\217I\\255\\035EX\\240T\\233'::bytea)
  • Rows Removed by Filter: 80,018
  • Heap Blocks: exact=14,656
  • Buffers: shared hit=16,408
14. 17.257 17.257 ↓ 1.0 80,467 1

Bitmap Index Scan on _inforg18529_bydims20274_rrss (cost=0.00..4,679.04 rows=80,433 width=0) (actual time=17.257..17.257 rows=80,467 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld18532rref = '\\230\\320\\3608\\313\\264\\241\\330FP>]\\026\\343aA'::bytea) AND (_fld18531_type = '\\010'::bytea) AND (_fld18531_rtref = '\\000\\000\\001q'::bytea))
  • Buffers: shared hit=1,752
15. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg18529_bydims20274_rrss on _inforg18529 t445 (cost=0.55..7.58 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld18532rref = '\\230\\320\\3608\\313\\264\\241\\330FP>]\\026\\343aA'::bytea) AND (_fld18531_type = '\\010'::bytea) AND (_fld18531_rtref = '\\000\\000\\001q'::bytea) AND (_fld18531_rrref = t439._i (...)
  • Heap Fetches: 0
16. 27.019 43.457 ↓ 1.0 80,467 1

Bitmap Heap Scan on _inforg18529 t445_1 (cost=4,699.15..35,699.81 rows=80,433 width=17) (actual time=18.509..43.457 rows=80,467 loops=1)

  • Recheck Cond: ((_fld717 = '0'::numeric) AND (_fld18532rref = '\\230\\320\\3608\\313\\264\\241\\330FP>]\\026\\343aA'::bytea) AND (_fld18531_type = '\\010'::bytea) AND (_fld18531_rtref = '\\000\\000\\001q'::bytea))
  • Heap Blocks: exact=14,656
  • Buffers: shared hit=16,408
17. 16.438 16.438 ↓ 1.0 80,467 1

Bitmap Index Scan on _inforg18529_bydims20274_rrss (cost=0.00..4,679.04 rows=80,433 width=0) (actual time=16.438..16.438 rows=80,467 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld18532rref = '\\230\\320\\3608\\313\\264\\241\\330FP>]\\026\\343aA'::bytea) AND (_fld18531_type = '\\010'::bytea) AND (_fld18531_rtref = '\\000\\000\\001q'::bytea))
  • Buffers: shared hit=1,752
Planning time : 7.884 ms
Execution time : 713.504 ms