explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2KMd

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3,145.901 ↓ 0.0 0 1

Append (cost=0.00..14,892.78 rows=2 width=62) (actual time=3,145.901..3,145.901 rows=0 loops=1)

2. 0.000 0.008 ↓ 0.0 0 1

Unique (cost=0.00..0.01 rows=1 width=96) (actual time=0.008..0.008 rows=0 loops=1)

3. 0.008 0.008 ↓ 0.0 0 1

Sort (cost=0.00..0.01 rows=0 width=96) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: (CASE WHEN ((_fld9264_type = '\\x08'::bytea) AND (_fld9264_rtref = '\\x00000030'::bytea)) THEN _fld3142_type ELSE NULL::bytea END), (CASE WHEN ((_fld9264_type = '\\x08'::bytea) AND (_fld9264_rtref = '\\x00000030'::bytea)) THEN _fld3142_rtref ELSE NULL::bytea END), (CASE WHEN ((_fld9264_type = '\\x08'::bytea) AND (_fld9264_rtref = '\\x00000030'::bytea)) THEN _fld3142_rrref ELSE NULL::bytea END)
  • Sort Method: quicksort Memory: 25kB
4. 0.000 0.000 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=96) (actual time=0.000..0.000 rows=0 loops=1)

  • One-Time Filter: false
5. 0.002 3,145.893 ↓ 0.0 0 1

Nested Loop Anti Join (cost=4,503.53..14,892.76 rows=1 width=27) (actual time=3,145.893..3,145.893 rows=0 loops=1)

6. 25.503 3,145.891 ↓ 0.0 0 1

Nested Loop (cost=4,503.36..14,891.32 rows=1 width=44) (actual time=3,145.891..3,145.891 rows=0 loops=1)

  • Join Filter: (t7._idrref = t6._fld2987_rrref)
7. 109.327 1,053.956 ↓ 129,152.0 129,152 1

Nested Loop (cost=4,503.14..14,890.11 rows=1 width=68) (actual time=62.670..1,053.956 rows=129,152 loops=1)

8. 206.046 298.869 ↓ 43,050.7 129,152 1

Hash Join (cost=4,502.92..14,887.26 rows=3 width=65) (actual time=62.639..298.869 rows=129,152 loops=1)

  • Hash Cond: ((t8._fld5893_type = CASE WHEN (t7._idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t8._fld5893_rtref = CASE WHEN (t7._idrref IS NOT NULL) THEN '\\x000022bb'::bytea ELSE NULL::bytea END) AND (t8._fld5893_rrref = t7._idrref))
9. 30.366 30.366 ↓ 1.0 256,973 1

Seq Scan on _inforg5890 t8 (cost=0.00..7,006.61 rows=256,861 width=48) (actual time=0.006..30.366 rows=256,973 loops=1)

10. 38.646 62.457 ↓ 1.0 129,278 1

Hash (cost=2,822.97..2,822.97 rows=129,227 width=17) (actual time=62.457..62.457 rows=129,278 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 7211kB
11. 23.811 23.811 ↓ 1.0 129,278 1

Index Only Scan using _document8891_byfieldfld9241 on _document8891 t7 (cost=0.17..2,822.97 rows=129,227 width=17) (actual time=0.023..23.811 rows=129,278 loops=1)

  • Heap Fetches: 3405
12. 645.760 645.760 ↑ 1.0 1 129,152

Index Scan using _reference157_byfield3189 on _reference157 t9 (cost=0.22..0.94 rows=1 width=45) (actual time=0.005..0.005 rows=1 loops=129,152)

  • Index Cond: ((_fld3154rref = t8._fld5891_rrref) AND (_idrref IS NOT NULL))
  • Filter: ((t8._fld5891_type = CASE WHEN (_fld3154rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t8._fld5891_rtref = CASE WHEN (_fld3154rref IS NOT NULL) THEN '\\x00000030'::bytea ELSE NULL::bytea END))
13. 2,066.432 2,066.432 ↓ 0.0 0 129,152

Index Scan using _reference139_byfield3012 on _reference139 t6 (cost=0.22..1.20 rows=1 width=41) (actual time=0.016..0.016 rows=0 loops=129,152)

  • Index Cond: ((_fld2987_type = t8._fld5893_type) AND (_fld2987_rtref = t8._fld5893_rtref) AND (_fld2987_rrref = t8._fld5893_rrref))
  • Filter: (_fld3008 = 'a2ed497e-6243-11e8-80e7-00155d655e12'::mvarchar)
  • Rows Removed by Filter: 4
14. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference139_pkey on _reference139 t10 (cost=0.17..1.42 rows=1 width=17) (never executed)

  • Index Cond: (_idrref = t6._fld10209rref)
  • Heap Fetches: 0
Planning time : 3.130 ms
Execution time : 3,146.108 ms